ETL Developer

Posted on May 18, 2024 by Allied Consultants, Inc.
Austin, TX
Other
Immediate Start
Annual Salary
Full-Time
Overview:

Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced ETL Developer to be a key resource on a technical services team.

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.

Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law.  Offers of Employment are contingent on a successful background check

Allied Consultants is an equal opportunities employer.

Responsibilities:

The Developer position will be an Information Technology (IT) resource that will assist in the development of data transformations, particularly targeting master data management solutions, in support of the client's Center for Analytics and Decision Support's, Enterprise Information Management (EIM) team. As a secondary requirement, the candidate should be familiar with technical and business metadata management and the related acquisition and administration requirements for Informatica Enterprise Data Catalog (EDC) and Informatica Axon. 

The Developer’s responsibilities may include: 

Working with subject matter experts (SMEs) across agencies to collect and update technical and business metadata. 

Load collected technical business metadata into EDC and Axon. 

Administer EDC and Axon 

Develop ETL in Informatica Power Center and Informatica data quality. 

Develop data quality processes and scorecards.  

Perform outreach and communication with source systems to support change management automation adopted by source systems. 

Review and assessment of the design, implementation and management of security access roles and privileges for all types of metadata consumers. 

Identification and documentation of business processes. 

Other duties as assigned. 

Essential Job Functions: 

Contribute the development of ETL processes, particularly those targeting client’s Master Data Management (MDM) solution. Coordinate and communicate with cross-agency SMEs to review and confirm technical metadata gaps. Participation and knowledge in the development of processes and guidelines for Metadata Management - change management, metadata access and sharing. Communicate successfully with technical and non-technical groups to facilitate the coordination of project activities. Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. (10%) 

Knowledge Skills Abilities:  

Experience with using and administering Informatica Enterprise Data Catalog and Axon.  

Experience Developing ETL with informatica Power Center and Informatica Data Quality. 

Experience with Oracle DDL and DML. 

Experience with SQL and data analysis.  

Experience with security and data quality metadata.  

Skill in communicating effectively - orally and in writing.  

Ability to assess and utilize metadata information.  

Ability to manage competing priorities, work under pressure, negotiate among multiple parties, resolve conflicts. 

Ability to establish and maintain effective working relationships – internally and externally.  

Ability to work cooperatively and effectively in a team environment.  

Ability to exercise judgment and work independently with limited direction. Ability to work on multiple projects or project assignments. 

Registration or Licensure Requirements: 

N/A 

Initial Selection Criteria: 

Required: Graduation from an accredited four-year college or university. Strong Informatica Metadata Manager experience. Strong EDC and Axon experience. Strong ETL development skills in Informatica Power Center and Data Quality. Strong SQL Experience. Experience with Oracle Databases. Experience with the Healthcare business domain. Experience working with Texas Medicaid Management Information System (MMIS) data and Texas Integrated Eligibility Redesign System (TIERS). Familiarity with agile software development lifecycle.  

Position is expected to extend into FY25, Sept 1st.

Qualifications:

Minimum Requirements:

Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

10

Required

Enterprise data analytics, integration, and management, working with data warehouse and data governance technologies

Preferred

Informatica administration experience including installation, configuration, upgrades, problem handling, and business continuity support

Preferred

Proven ability to implement data integration best practices and conventions

Preferred

Understanding of IT data security

Preferred

Excellent communication, presentation, interpersonal, and organizational skills

Preferred

Comfortable working both independently and within cross-functional, collaborative teams

Preferred

Scripting knowledge (Java, Python, Perl, PowerShell, Bash, SQL)

Preferred

Hands on experience configuring EDC and Axon, including but not limited to business glossaries, dashboards, policies, search, process maps, and advanced scanners

Preferred

Experience creating scripts to automate system administration tasks, schedules, and deployment activities

Preferred

Knowledge of source-to-target data lineage mapping and automated harvest methods

Preferred

Experience administering Informatica Axon or similar data governance portal solutions

Preferred

Experience administering Informatica Enterprise Data Catalog or similar automated metadata harvest and enrichment solutions

Preferred

Experience administering Informatica Data Quality or similar data profiling, cleansing, scorecard, and identity resolution solutions

Preferred

Linux administration experience

Preferred

Proficiency in reading data payloads in JSON and XML format

Preferred

Informatica vendor certification on EDC, Axon, and/or IDQ administration within the past 3 years

Preferred

Understanding of DAMA DMBOK data management framework

Preferred

Experienced in Scaled Agile Framework (SAFe) methods of software delivery lifecycle (SDLC)

Preferred

Knowledge of cloud infrastructure solutions (Azure, AWS, OCI)

Preferred

Experience with Git version control system

Preferred

Experience with large-scale data Infrastructure as a Service (IaaS) environments

Preferred

Informatica Master Data Management experience

Preferred

Informatica PowerCenter experience (mappings, workflows)

Preferred

Informatica Data Quality ETL experience (mappings, workflows)

Reference: 161243843

https://jobs.careeraddict.com/post/91091939

This Job Vacancy has Expired!

ETL Developer

Posted on May 18, 2024 by Allied Consultants, Inc.

Austin, TX
Other
Immediate Start
Annual Salary
Full-Time
Overview:

Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced ETL Developer to be a key resource on a technical services team.

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.

Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law.  Offers of Employment are contingent on a successful background check

Allied Consultants is an equal opportunities employer.

Responsibilities:

The Developer position will be an Information Technology (IT) resource that will assist in the development of data transformations, particularly targeting master data management solutions, in support of the client's Center for Analytics and Decision Support's, Enterprise Information Management (EIM) team. As a secondary requirement, the candidate should be familiar with technical and business metadata management and the related acquisition and administration requirements for Informatica Enterprise Data Catalog (EDC) and Informatica Axon. 

The Developer’s responsibilities may include: 

Working with subject matter experts (SMEs) across agencies to collect and update technical and business metadata. 

Load collected technical business metadata into EDC and Axon. 

Administer EDC and Axon 

Develop ETL in Informatica Power Center and Informatica data quality. 

Develop data quality processes and scorecards.  

Perform outreach and communication with source systems to support change management automation adopted by source systems. 

Review and assessment of the design, implementation and management of security access roles and privileges for all types of metadata consumers. 

Identification and documentation of business processes. 

Other duties as assigned. 

Essential Job Functions: 

Contribute the development of ETL processes, particularly those targeting client’s Master Data Management (MDM) solution. Coordinate and communicate with cross-agency SMEs to review and confirm technical metadata gaps. Participation and knowledge in the development of processes and guidelines for Metadata Management - change management, metadata access and sharing. Communicate successfully with technical and non-technical groups to facilitate the coordination of project activities. Attends work on a regular and predictable schedule in accordance with agency leave policy and performs other duties as assigned. (10%) 

Knowledge Skills Abilities:  

Experience with using and administering Informatica Enterprise Data Catalog and Axon.  

Experience Developing ETL with informatica Power Center and Informatica Data Quality. 

Experience with Oracle DDL and DML. 

Experience with SQL and data analysis.  

Experience with security and data quality metadata.  

Skill in communicating effectively - orally and in writing.  

Ability to assess and utilize metadata information.  

Ability to manage competing priorities, work under pressure, negotiate among multiple parties, resolve conflicts. 

Ability to establish and maintain effective working relationships – internally and externally.  

Ability to work cooperatively and effectively in a team environment.  

Ability to exercise judgment and work independently with limited direction. Ability to work on multiple projects or project assignments. 

Registration or Licensure Requirements: 

N/A 

Initial Selection Criteria: 

Required: Graduation from an accredited four-year college or university. Strong Informatica Metadata Manager experience. Strong EDC and Axon experience. Strong ETL development skills in Informatica Power Center and Data Quality. Strong SQL Experience. Experience with Oracle Databases. Experience with the Healthcare business domain. Experience working with Texas Medicaid Management Information System (MMIS) data and Texas Integrated Eligibility Redesign System (TIERS). Familiarity with agile software development lifecycle.  

Position is expected to extend into FY25, Sept 1st.

Qualifications:

Minimum Requirements:

Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

10

Required

Enterprise data analytics, integration, and management, working with data warehouse and data governance technologies

Preferred

Informatica administration experience including installation, configuration, upgrades, problem handling, and business continuity support

Preferred

Proven ability to implement data integration best practices and conventions

Preferred

Understanding of IT data security

Preferred

Excellent communication, presentation, interpersonal, and organizational skills

Preferred

Comfortable working both independently and within cross-functional, collaborative teams

Preferred

Scripting knowledge (Java, Python, Perl, PowerShell, Bash, SQL)

Preferred

Hands on experience configuring EDC and Axon, including but not limited to business glossaries, dashboards, policies, search, process maps, and advanced scanners

Preferred

Experience creating scripts to automate system administration tasks, schedules, and deployment activities

Preferred

Knowledge of source-to-target data lineage mapping and automated harvest methods

Preferred

Experience administering Informatica Axon or similar data governance portal solutions

Preferred

Experience administering Informatica Enterprise Data Catalog or similar automated metadata harvest and enrichment solutions

Preferred

Experience administering Informatica Data Quality or similar data profiling, cleansing, scorecard, and identity resolution solutions

Preferred

Linux administration experience

Preferred

Proficiency in reading data payloads in JSON and XML format

Preferred

Informatica vendor certification on EDC, Axon, and/or IDQ administration within the past 3 years

Preferred

Understanding of DAMA DMBOK data management framework

Preferred

Experienced in Scaled Agile Framework (SAFe) methods of software delivery lifecycle (SDLC)

Preferred

Knowledge of cloud infrastructure solutions (Azure, AWS, OCI)

Preferred

Experience with Git version control system

Preferred

Experience with large-scale data Infrastructure as a Service (IaaS) environments

Preferred

Informatica Master Data Management experience

Preferred

Informatica PowerCenter experience (mappings, workflows)

Preferred

Informatica Data Quality ETL experience (mappings, workflows)

Reference: 161243843

CareerAddict

Alert me to jobs like this:

Amplify your job search:

CV/résumé help

Increase interview chances with our downloads and specialist services.

CV Help

Expert career advice

Increase interview chances with our downloads and specialist services.

Visit Blog

Job compatibility

Increase interview chances with our downloads and specialist services.

Start Test