EDW Informatica ETL Developer (3 positions)
EDW Informatica ETL Developer (3 positions)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Location: Telecommute (with occasional travel to Springfield IL)
Rate: depending on experience
Job Summary:
We are seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our Enterprise Data Warehouse (EDW) team. This role is responsible for designing developing and maintaining robust ETL processes using Informatica PowerCenter and Teradata. The ideal candidate will have a deep understanding of data integration performance tuning and data warehousing best practices with a focus on supporting healthcare-related data systems.
Required Qualifications:
7 years of experience with Informatica PowerCenter and ETL development.
5 years of experience writing complex SQL and performance tuning.
5 years of experience with Enterprise Relational Database Management systems (Teradata DB2 Oracle or SQL Server)
5 years of Informatica PowerCenter administration experience.
Strong communication collaboration and mentoring skills.
Bachelors or advanced degree in IT Computer Science Mathematics or a related field.
Strong organizational and time management skills
Preferred Qualifications:
Residing in or near Springfield IL.
5 years of data warehouse development experience.
5 years of data modeling experience using ERWIN or similar tools.
2 years of Unix Shell (Bash/Korn) scripting experience.
2 years of experience with Azure Data Factory and Snowflake.
Experience with scripting languages such as Python R or JavaScript (React).
Familiarity with Informatica Data Quality (IDQ) Address Doctor and Metadata Manager.
Experience with Medicaid Medicare or healthcare data systems.
Experience working in Agile environments.
Knowledge of BI and data integration technologies across relational and multidimensional systems.
Key Responsibilities:
Design and implement ETL solutions using Informatica PowerCenter to extract transform and load data from various agency sources.
Automate data staging processes and optimize ETL job scheduling for performance and efficiency.
Administer and support ETL environments including development and production systems.
Perform repository backups recovery operations and system maintenance.
Develop mappings mapplets sessions and workflows using a wide range of Informatica transformations.
Monitor and troubleshoot ETL jobs across development testing and production environments.
Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata.
Collaborate with stakeholders to define requirements document technical solutions and support project planning.
Participate in unit integration and system testing.
Provide technical support mentoring and guidance to team members.
Communicate project status and deliverables to leadership and clients.
Continuously learn and apply new technologies to enhance system performance and capabilities.
Employment Type
Contract
