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.

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

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

Job Summary

We are looking for an experienced ETL Tester / Data QA Engineer with strong SQL skills to validate data pipelines, ETL processes, data transformations, and data quality across source and target systems. The candidate should have hands-on experience in writing complex SQL queries, performing data validation, and identifying data discrepancies.

Key Responsibilities

• Perform ETL testing for data extraction, transformation, and loading processes.
• Validate data between source and target systems.
• Write and execute complex SQL queries for data validation and reconciliation.
• Verify data transformations, mappings, joins, aggregations, and business rules.
• Perform data completeness, accuracy, consistency, integrity, and duplicate checks.
• Validate incremental and full data loads.
• Test ETL workflows, batch jobs, and data pipelines.
• Identify, document, and track defects using tools such as JIRA.
• Analyze production data issues and support root-cause analysis.
• Prepare test scenarios, test cases, test data, and execution reports.
• Work closely with developers, data engineers, business analysts, and other QA teams.
• Participate in regression, integration, system, and end-to-end testing.

Required Skills

• Strong hands-on experience in ETL/Data Warehouse Testing.
• Advanced SQL skills, including:
• Joins
• Subqueries
• CTEs
• Window functions
• Aggregations
• Stored procedures
• Data reconciliation
• Knowledge of Data Warehousing concepts such as fact and dimension tables, star/snowflake schemas, and slowly changing dimensions (SCD).
• Experience with ETL tools such as Informatica, Talend, SSIS, DataStage, or similar.
• Experience with relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL.
• Good understanding of SDLC/STLC and defect life cycle.
• Experience with Agile/Scrum methodologies.

Good to Have

• Experience with cloud data platforms such as Snowflake, AWS, Azure, or GCP.
• Knowledge of tools such as Databricks, Azure Data Factory, AWS Glue, or dbt.
• Experience with API testing or data pipeline automation.
• Basic knowledge of Python for test/data validation automation.
• Experience testing large-volume datasets and complex data migrations.

Qualifications

• Bachelor's degree in Computer Science, IT, Engineering, or a related field.
• Strong analytical and problem-solving skills.
• Good communication and documentation skills.

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

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.

Role Overview

We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.

Key Responsibilities

• Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
• Build and maintain data models to support business processes, reporting needs, and integration workflows.
• Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
• Work closely with cross-functional teams to gather data requirements and understand business logic.
• Develop and execute integration test plans, including functional, data validation, and regression testing.
• Support data migration activities, including extraction, transformation, and loading (ETL).
• Monitor and troubleshoot integration issues, ensuring timely resolution.
• Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
• Ensure integration security, data integrity, and compliance with organizational standards.

Required Skills & Qualifications

• 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Hands-on experience with data mapping, data modelling, and database schema design.
• Proficiency in SQL (complex joins, stored procedures, performance tuning).
• Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
• Strong analytical and problem-solving skills.
• Experience with API-based integrations (REST/SOAP) is a plus.
• Familiarity with testing methodologies for integrations and data validation.
• Ability to work with business users, understand workflows, and translate requirements into technical solutions.

Preferred Qualifications

• Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
• Knowledge of JSON, XML, CSV transformation.
• Exposure to scripting languages (Python, Shell).
• Experience in Agile/Scrum environments.
• Prior involvement in ERP implementation or upgrade projects.

Competencies

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
• Work on impactful projects that make a difference across industries.
• Opportunities for professional growth and continuous learning.
• Competitive salary and benefits package.

Application Details

Ready to make an impact? Apply today and become part of the QX Impact team!