Informatica ETL Developer

Job Description:

Skill Set

Informatica, IDMC, Informatica MDM

Experience

4-6 Years

Location

Faridabad, Haryana, India

Work Mode- Hybrid

Job Description

Roles & Responsibilities

• Lead project team members through all activities required to successfully deliver Informatica.
• Define technical specifications for workflows and business rules.
• Prepare detailed design documents for data migration.
• Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
• Train and mentor colleagues in Informatica implementation activities and best practices.
• Support integration, system, and user acceptance testing.
• Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
• Profile & Analyze Source Data usage using ETL tool.
• Automation, job scheduling, dependencies, monitoring.
• Configure/Script Business rules and transformation rules in ETL
• Data pipeline using IICS
• Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
• Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
• Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
• Experience in administering, supporting, and performance tuning using Informatica.

Hiring: Informatica IDMC / IICS Developer

Location: Faridabad, Haryana

Experience: 4–7 Years

Must-Have:

• Informatica IDMC / IICS

• Data Integration & Application Integration (CAI)

• ETL / Data Pipelines / Data Migration

• REST, SOAP, SFTP & API Integration

• Strong SQL, Stored Procedures & RDBMS

• Job Scheduling, Monitoring & Performance Tuning

Good to Have: Informatica MFT, DX, DT, MDM & Data Quality

Strong Senior Developer – PL/SQL, SQL & ETL (Microsoft SSIS) Profile

2

Mandatory (Experience 1) – Must have minimum 5+ years of strong hands-on experience in PL/SQL and SQL development, including complex stored procedures, functions, queries, joins, data manipulation, and query/performance optimization.

3

Mandatory (Experience 2) – Must have strong hands-on experience in ETL development using Microsoft SSIS, including building, maintaining, optimizing, and troubleshooting SSIS packages for large-volume data movement and transformation.

4

Mandatory (Experience 3) – Must have solid experience working with Data Warehousing concepts and architectures, including data models, fact/dimension structures, ETL data flows, and enterprise reporting/data warehouse environments.

5

Mandatory (Experience 4) – Must have experience managing batch jobs, scheduling, and data pipelines, ensuring timely and reliable execution of enterprise ETL workflows.

6

Mandatory (Experience 5) – Must have hands-on experience in production support for SSIS/ETL and data warehouse jobs, including monitoring job execution, troubleshooting failures, performing root cause analysis, and implementing preventive fixes.

7

Mandatory (Experience 6) – Must have experience with data quality, validation, and troubleshooting, including identifying and resolving data discrepancies/issues affecting downstream reports, dashboards, and analytics.

8

Mandatory (Experience 7) – Must have experience with unit, integration, and regression testing of SQL, PL/SQL, and ETL components, along with strong documentation of technical designs, data mappings, data flows, and deployment processes.

9

Mandatory (Location) – Must be willing to work in a hybrid model from a city where Cognizant has an office.

10

Mandatory (Notice Period) – Immediate joiners or candidates who can join within 2–4 weeks.

Job Summary

We are seeking an experienced Informatica MDM Developer to design, develop, and implement Master Data Management (MDM) solutions using Informatica IDMC (SaaS). The role focuses on establishing a Single Source of Truth by integrating multiple data sources, enforcing data quality standards, and managing master data domains such as Customer, Product, Supplier, and Employee.

The engineer will collaborate closely with data stewards, data architects, and business stakeholders to deliver high-quality, governed enterprise data. The role requires willingness to support production MDM SaaS platforms and the data warehouse feeding MDM. When capacity permits, the candidate will also support GCP Data Engineering activities

Key Roles & Responsibilities

• Design and build Master Data Management (MDM) solutions using Informatica IDMC (SaaS).
• Create and manage data models for domains like Customer, Product, Supplier, and Employee.
• Configure Business 360 including UI, entities, and business rules.
• Develop and maintain match, merge, and survivorship rules to create accurate golden records.
• Build data integrations using Cloud Data Integration (CDI) and Cloud Application Integration (CAI).
• Develop and support REST APIs for real-time data exchange.
• Implement data quality, cleansing, and standardization rules using Cloud Data Quality (CDQ).
• Support data stewards in resolving data issues, merges, and exceptions.
• Monitor, troubleshoot, and optimize MDM SaaS platform performance.
• Support production MDM systems and the data warehouse feeding MDM.
• Collaborate with business and technical teams to deliver high-quality governed data.
• Willing to support GCP Data Engineering tasks when required (training provided).

Required Skills & Qualifications:

• Hands-on experience with Informatica IDMC (SaaS) including Business 360, Customer 360, or Product 360.
• Strong expertise in CDI, CAI, and CDQ.
• Solid understanding of relational and dimensional data modeling.
• Advanced SQL skills.
• Experience with REST/SOAP APIs, JSON, and XML.
• Familiarity with cloud data platforms such as Snowflake, Databricks, AWS Redshift, or Azure Synapse.

Experience & Education

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience:
• 3+ years of experience in Master Data Management (MDM).
• 1–2 years of hands-on experience with Informatica MDM SaaS / IDMC.
• Prior experience with Informatica On-Prem Multidomain MDM is a plus (with SaaS migration exposure).

.

Job Types: Full-time, Permanent

Position: Backup Data ETL Developer

Experience: 6–9 Years

Location:Banglore

Employment Type: Full-time

Job Description:

We are looking for a Backup Data ETL Developer with 6–9 years of experience in designing, developing, and supporting data extraction, transformation, and loading (ETL) processes.

The candidate should have strong hands-on experience with Hadoop, Spark, Informatica, and Snowflake, along with expertise in large-scale data processing and data integration technologies.

Key Skills:

Hadoop

Spark

Informatica

Snowflake

ETL Development

Data Integration

Data Transformation

Large-Scale Data Processing

ETL Workflows and Data Pipelines

Troubleshooting and Problem-Solving

Strong analytical and collaboration skills

We are seeking an experienced Informatica MDM Developer to design, develop, and implement Master Data Management (MDM) solutions using Informatica IDMC (SaaS). The role focuses on establishing a Single Source of Truth by integrating multiple data sources, enforcing data quality standards, and managing master data domains such as Customer, Product, Supplier, and Employee.

The engineer will collaborate closely with data stewards, data architects, and business stakeholders to deliver high-quality, governed enterprise data. The role requires willingness to support production MDM SaaS platforms and the data warehouse feeding MDM. When capacity permits, the candidate will also support GCP Data Engineering activities

Key Roles & Responsibilities

• Design and build Master Data Management (MDM) solutions using Informatica IDMC (SaaS).
• Create and manage data models for domains like Customer, Product, Supplier, and Employee.
• Configure Business 360 including UI, entities, and business rules.
• Develop and maintain match, merge, and survivorship rules to create accurate golden records.
• Build data integrations using Cloud Data Integration (CDI) and Cloud Application Integration (CAI).
• Develop and support REST APIs for real-time data exchange.
• Implement data quality, cleansing, and standardization rules using Cloud Data Quality (CDQ).
• Support data stewards in resolving data issues, merges, and exceptions.
• Monitor, troubleshoot, and optimize MDM SaaS platform performance.
• Support production MDM systems and the data warehouse feeding MDM.
• Collaborate with business and technical teams to deliver high-quality governed data.
• Willing to support GCP Data Engineering tasks when required (training provided).

Required Skills & Qualifications:

• Hands-on experience with Informatica IDMC (SaaS) including Business 360, Customer 360, or Product 360.
• Strong expertise in CDI, CAI, and CDQ.
• Solid understanding of relational and dimensional data modeling.
• Advanced SQL skills.
• Experience with REST/SOAP APIs, JSON, and XML.
• Familiarity with cloud data platforms such as Snowflake, Databricks, AWS Redshift, or Azure Synapse.

Experience & Education

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.