ETL Information Power center Developer | Health care is a plus

[Rajesh C2C Requirements]

Reply to kris...@codebaseinc.com

Only H1B Genuine

ETL Information Power center Developer | Remote

 

Design, rebuild, and optimize enterprise ETL pipelines currently implemented in Informatica PowerCenter into modular, tested DBT models running on Snowflake, with a focus on healthcare data domains and high-volume fact tables.

Key responsibilities:

• Analyze existing Informatica workflows, mappings, and worklets, reverse-engineer business logic, and document current-state data flows.
• Re-implement transformation logic (lookups, expressions, SCDs, ICD-10 recodes, readmission rules, incremental loads) as performant Snowflake SQL wrapped in DBT models.
• Design and maintain star & snowflake schemas and healthcare fact & dimension models (e.g., encounters, diagnoses, readmissions) optimized for analytics.
• Implement DBT tests, documentation, and CI/CD to ensure data quality, lineage visibility, and reliable deployments across environments.
• Validate migrated pipelines by reconciling Snowflake outputs with legacy EDW Informatica results and addressing data quality or performance gaps.
• Collaborate with analytics, clinical, and platform teams to gather requirements, prioritize migration waves, and support cutover to the new Snowflake platform.

Required skills:

• 8+ years of experience in data engineering
• Strong SQL and data modeling experience, with hands-on Snowflake and DBT.
• Prior experience building or supporting Informatica ETL (PowerCenter or IICS) for large-scale data warehouses.
• Solid understanding of ETL/ELT patterns, incremental loads, and performance tuning on cloud data warehouses.
• Experience with Git-based workflows, code review, and automated testing in modern data stacks.
• Healthcare data experience (encounters, diagnoses, readmissions, ICD-10) is a strong plus.