ETL Engineer
Aanchal ..United StatesMIDPosted 11h ago
Informatica PowerCenterETLSQLPythonDB2PostgreSQLFlat FilesData Warehousing
About the Role
We are looking for an experienced Informatica ETL Developer to work on converting data from legacy applications to a modernized, single-tenant healthcare application.
Key Responsibilities
• Develop complex ETL mappings and workflows using Informatica PowerCenter
• Create reusable transformations, Mapplets, Workflows, and Worklets
• Extract and transform data from Flat Files, DB2, and PostgreSQL
• Support ETL repository versioning and code management
• Utilize AI tools to generate and optimize ETL mappings
• Perform ETL performance tuning and troubleshoot data-related issues
• Support legacy-to-modern application data conversion
Requirements
• Strong hands-on experience with Informatica PowerCenter
• Extensive ETL development and data transformation experience
• Strong knowledge of Mappings, Mapplets, Workflows, and Worklets
• Experience with SQL, Python, DB2, PostgreSQL, and Flat Files
• MANDATORY: Medicaid healthcare domain experience
• Experience in healthcare data migration/conversion is highly preferred
• Knowledge of Data Warehousing concepts: MOLAP, ROLAP, ODS, DM, and EDW