IDMC Developer
Core
Lead the migration of legacy Informatica PowerCenter/CDI-PC workflows to Informatica IDMC and develop ETL/ELT pipelines for Databricks Lakehouse.
Role type
Senior Informatica IDMC Developer / Tech Lead
Builds
IDMC data integration workflows, ETL/ELT pipelines, and migrated assets for Databricks Lakehouse
Domain
Data Engineering / ETL / Cloud Data Platforms
Required skills
Informatica PowerCenter, Informatica CDI-PC, Informatica IDMC, Oracle SQL, Unix/Linux, Databricks, Python, Data Validation, Technical Leadership
Preferred skills
B2B/EDI (835/837), Informatica DVO, Azure Data Factory, Azure Synapse Analytics, PySpark, CDI-PC to IDMC conversion
Technologies
Informatica IDMC, PowerCenter, CDI-PC, Databricks, Oracle, Python, SQL, Unix, Azure, Java, XML
Responsibilities
Analyze and assess conversion readiness of legacy PowerCenter/CDI-PC workflows; Design and build IDMC/IICS assets corresponding to legacy sessions and mappings; Lead technical validation, testing, and defect triage of converted assets; Develop and optimize ETL/ELT pipelines ingesting data into Databricks Lakehouse; Configure secure connections and orchestrate workflows between IDMC and Databricks; Mentor team members and establish conversion standards and documentation.
Seniority
Senior, hands-on IC with leadership responsibilities