Contractor Informatica ETL Developer

• We are seeking an experienced Informatica ETL Developer to join our Enterprise Data Warehouse (EDW) team.
• This role involves 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.

• Design and implement ETL solutions using Informatica PowerCenter.
• Automate data staging processes and optimize ETL job scheduling.
• Administer and support ETL environments, including development and production systems.
• Develop mappings, mapplets, sessions, and workflows using Informatica transformations.
• Monitor and troubleshoot ETL jobs.
• Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata.
• Collaborate with stakeholders to define requirements and document technical solutions.
• Provide technical support, mentoring, and guidance to team members.

• 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.

• Experience with Azure Data Factory and Snowflake.
• Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager.
• Experience with Medicaid, Medicare, or healthcare data systems.

What is the last date for applying to the job?

Which countries are accepted for this remote job?