Informatica Senior Data Governance Technical Specialist - EDC, AXON, Python

Experience: 8 to 12 years

Location: Hyderabad, India

Skills: Informatica IDMC, Cloud Data Integration, Mappings, taskflows, parameterization, Secure Agent configuration, scheduling, SQL, data transformation, data warehousing, cloud data platforms, Snowflake, PowerCenter, CDC, incremental loading strategies, CI/CD, Git, Agile, Scrum, data governance, data quality

Job Summary
We are looking for a hands‑on Informatica IDMC CDI Developer Lead who will own design, development, migration, and delivery of cloud-based data integration solutions. The role requires strong technical leadership, architecture understanding, and the ability to mentor a small team of CDI developers while working closely with data architects and business stakeholders.

Key Responsibilities
Technical Leadership & Architecture
Own the end‑to‑end design and implementation of Informatica IDMC CDI solutions
Define cloud‑optimized ETL/ELT architecture and data integration patterns
Lead PowerCenter → IDMC migration design and execution
Establish coding standards, naming conventions, and reusable templates
Review and approve technical designs, mappings, and taskflows

Development Responsibilities
Design and develop:
• CDI mappings for complex transformations
• Mapping tasks and synchronization tasks
• Parameterized and reusable workflows
• Linear and event‑based taskflows
Implement:
• Incremental and full load strategies
• Error handling, logging, audit controls, and restartability
• Optimize performance for high‑volume and SLA‑critical loads

Cloud & Integration Scope
Integrate data from:
• RDBMS sources (Oracle, SQL Server, PostgreSQL)
• Cloud platforms such as Snowflake / Azure Synapse
• Cloud storage (ADLS Gen2 / S3)
• Flat files and application feeds
Work with cloud teams to align on:




• Secure Agent placement
• Network and security setup
• Cost‑efficient processing models

Secure Agent & Environment Management
Design and manage Hybrid Secure Agent architecture
Support Dev / QA / Prod deployments
Troubleshoot agent, runtime, and performance issues

Team Leadership & Collaboration
Lead and mentor 2–6 CDI developers
Conduct code and design reviews
Collaborate with:
• Data Architects
• Business Analysts
• QA and Cloud Platform teams
Translate business requirements into technical deliverables

Production Support & Governance
Ensure job reliability, SLAs, and monitoring
Perform root cause analysis for production issues
Drive continuous improvement and optimization

Skill Requirements
Mandatory Skills
Strong hands‑on experience with Informatica IDMC – Cloud Data Integration (CDI)
Expertise in:
• Mappings, taskflows, and parameterization
• Secure Agent configuration and scheduling
• Strong SQL and data transformation skills
• Solid understanding of data warehousing concepts
• Experience working with cloud data platforms (Snowflake preferred)

Positive to Have
• PowerCenter to IDMC migration experience
• CDC and incremental loading strategies
• CI/CD exposure (Git, automation pipelines)
• Knowledge of Agile/Scrum delivery
• Exposure to data governance or data quality concepts

Experience & Education
• 8–12 years of overall ETL/Data Integration experience
• 3–5 years of hands‑on Informatica IDMC CDI experience
• 2+ years in a Lead / Senior Developer role
• Bachelor’s degree in Engineering or Computer Science

Other Requirements
Role Expectations
• Lead from the front with hands‑on development
• Act as the technical face of the data integration stream
• Own delivery quality, timelines, and design decisions
• Mentor team members and build long‑term capability

📌 Informatica Senior Data Governance Technical Specialist EDC, AXO (Secunderabad)
🏢 HCL Technologies
📍 Secunderabad