Job Title: PowerCenter to IDMC Migration Developer
Location: Remote
Experience: 5+ Years
Employment Type: Full-time
Shift Timing: 4.30 PM to 1.30 AM (IST)
Notice Period: Immediate Joiner only
Job Summary:
We are seeking an experienced ETL Developer with strong expertise in Informatica PowerCenter and hands-on experience migrating ETL jobs to Informatica Intelligent Data Management Cloud (IDMC). The ideal candidate should have deep knowledge of ETL workflows, Cloud Data Integration (CDI), and migration best practices.
Key Responsibilities:
-------------------------
Lead end-to-end migration of PowerCenter workflows, mappings, and sessions to IDMC (CDI/CDI-E).
Analyze existing ETL pipelines and redesign/optimize them for the cloud environment.
Build, configure, and deploy new pipelines in IDMC Cloud.
Perform impact analysis, feasibility checks, and migration assessments.
Validate and test migrated jobs to ensure functional equivalence.
Troubleshoot performance issues in both PowerCenter and IDMC environments.
Work closely with business, QA, and cloud data teams to ensure smooth project delivery.
Create technical documentation, mapping sheets, test cases, and migration reports.
Follow best practices for security, governance, and data quality in cloud ETL.
Required Skills & Experience:
5+ years of experience in ETL development using Informatica PowerCenter.
Strong hands-on expertise in IDMC (CDI/CDI-E, Application Integration, Runtime Environments).
Proven experience in PowerCenter to IDMC migration projects (must-have).
Strong SQL knowledge (Oracle, SQL Server, Snowflake, or similar).
Understanding of ETL/ELT concepts, data pipelines, and transformation logic.
Experience with cloud platforms (AWS / Azure / GCP) is an added advantage.
Good understanding of job scheduling/orchestration tools.
Excellent debugging, problem-solving, and performance-tuning skills.
Good to Have:
Experience with Informatica Data Quality (IDQ) or MDM.
Knowledge of REST/SOAP APIs and integration patterns.
Exposure to CI/CD pipelines and Git-based versioning.
Arumugam Veera leads the Talent Acquisition function for TechMango, driving our mission to build high-performing teams and connect top talent with exciting career opportunities.
Feel free to connect with him on LinkedIn: https://www.linkedin.com/in/arumugamv/
Follow our official TechMango LinkedIn page for the latest job updates and career opportunities: https://www.linkedin.com/company/techmango-technology-services-private-limited/
Looking forward to connecting and helping you explore your next great opportunity with us!
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.