Senior Informatica Developer
- Mchoovers
- 6 - 10 years
- Hyderabad
- 24 days ago
- Email to a friend
- Report this job
Job Description
Job Title: Senior Data Engineer (IDMC-CDI)
Primary Skills: SQL, IDMC (CDI), ETL Concepts Base
Location: Gurugram (Delhi/NCR)
Mode of Work: Hybrid Office
Work from Home option available for ideal candidates
Experience: 5-8 Years
About Us
We are PDI (Pacific Data Integrators), a leading provider of Data Management, Analytics, and Cloud solutions. As an Informatica Platinum Partner and a reseller of various market-leading products, we help enterprises implement scalable and secure data solutions using tools like Informatica, AWS, Azure, Snowflake, and GCP. We continue to grow as a leader in data integration, data quality, and data security across industries, supporting customers in their digital transformation journeys.
Job Overview
We are seeking a highly skilled and experienced Informatica IDMC ETL Developer (Lead-Level) with a deep understanding of ETL design, data pipeline development, and Informatica Cloud Data Integration (CDI). The ideal candidate will have a strong background in developing, documenting, testing, and maintaining ETL applications and will take ownership in delivering scalable solutions that meet business and technical requirements.
Key Responsibilities
- Lead the design, development, and deployment of complex ETL solutions using Informatica IDMC.
- Collaborate with business stakeholders, analysts, and data architects to define technical requirements and translate them into efficient ETL workflows.
- Develop, document, unit test, and maintain high-quality data pipelines that support both batch and incremental (CDC-based) data processing.
- Configure and manage:
- Mappings, Mapping Tasks, and Taskflows.
- Secure Agents, runtime environments, and connection parameters
- Design and implement robust data transformation logic, including:
- Cleansing, enrichment, joins, lookups, aggregations
- Handling hierarchical (JSON, XML) and semi-structured data (REST APIs, Kafka)
- Use of parameterized mappings and reusable components
- Build and manage Taskflows with conditional logic, error handling, branching, and scheduling mechanisms.
- Optimize mapping performance through pushdown optimization, partitioning, and data minimization techniques.
- Provide leadership and guidance to junior developers, conduct code reviews, and ensure adherence to best practices.
- Troubleshoot and resolve complex data integration issues promptly.
- Stay updated on new features and industry trends in data integration and cloud technologies.
Required Skills
- 5+ years of IT experience in data integration and management roles.
- 4+ years of hands-on experience with Informatica products.
- 2+ years specifically working with Informatica IDMC/CDI.
- Experience in leading large projects and mentoring junior developers.
- Proficiency with Secure Agents, runtime configuration, parameterization, and environment management.
- Experience integrating external applications with IDMC via batch, APIs, and message queues.
- Strong experience with relational databases such as Oracle, SQL Server, or MySQL.
- Solid understanding of data warehousing concepts (e.g., Kimball, Inmon).
- Excellent problem-solving skills and ability to handle complex data integration scenarios.
- Strong verbal and written communication skills.
- Experience working in Agile/Scrum environments.
Preferred/Bonus Skills
- Experience with cloud platforms: AWS, Azure, or GCP.
- Exposure to data quality tools and governance frameworks.
- Familiarity with scripting languages like Python or Shell for automation.
Why Join?
- Work with cutting-edge data integration tools as part of a fast-growing, elite consulting firm.
- Collaborate with top-tier clients and deliver impactful data management solutions.
- Access to ongoing training and opportunities to work with the latest in cloud, AI, and big data technologies.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: IT & Information SecurityRole Category: IT & Information Security - OtherRole: IT & Information Security - OtherEmployement Type: Full timeContact Details:
Company: Mchoovers ConsultingLocation(s): Hyderabad
Similar positions
Mchoovers
Mchoovers Consulting / Serigor Inc is Maryland based, CMMI L3, Woman Owned Small Business (WOSB) specializing in IT Services, IT Staff Augmentation, Government Solutions and Global Delivery. Founded in 2009, we are a leading IT services firm that delivers deep expertise, objective insights, a tailor...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in