ETL IDQ 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

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.

At Mitratech, we are a team of technocrats focused on building world-class products that simplify operations in the Legal, Risk, Compliance, and HR functions. We are a close-knit, globally dispersed team that thrives in an ecosystem that supports individual excellence and takes pride in its diverse and inclusive work culture centered around great people practices, learning opportunities, and having fun! Our culture is the ideal blend of entrepreneurial spirit and enterprise investment, enabling the chance to move at a rapid pace with some of the most complex, leading-edge technologies available.

For over 35 years, the experts at Mitratech have been focused on solving the complex needs. Today, we serve 20,000 client companies of all sizes globally, representing 30% of the Fortune 500 and over 500,000 users in over 160 countries.

As we continue to grow, we’re always looking for resourceful, enthusiastic, and fresh perspectives. Join our global team and see what makes Mitratech a truly exceptional place to work!

Job Overview 

Principal Data Engineer

About Engineering at Mitratech Legal Solutions 

Mitratech's engineering organization is a collaborative and dynamic environment where engineers are empowered to drive technical direction and innovation. Our engineers are passionate about delivering high-quality products and solutions that meet the evolving needs of our customers, and we're committed to fostering a culture of continuous learning and growth. 

About the Role 

Mitratech is a fast-paced and dynamic environment, and this role requires someone who is adaptable, resilient, and able to thrive in a rapidly changing landscape. If you’re a seasoned engineer with a passion for technical leadership, innovation, and collaboration — including building the data foundations that power trusted reporting and agentic AI-driven products — we’d love to hear from you. 

What You Will Do

•  Drive technical direction for a significant product domain or platform capability, ensuring alignment with business objectives and customer needs 

•  Design and maintain data pipelines and reporting models that power trusted business metrics and increasingly feed agentic AI systems (e.g., RAG ingestion, embeddings, vector stores, AI agent workflows) 

•  Use AI-assisted and agentic engineering tools (e.g., Claude Code, Copilot, Cursor, AI agents) as part of your own workflow, and help other engineers adopt agentic development practices effectively 

•  Reduce systemic complexity by identifying and leading architectural debt remediation, and developing strategies for ongoing technical debt management 

•  Partner with Product and Engineering leadership to inform multi-quarter roadmap feasibility, and provide technical guidance and oversight to ensure successful implementation 

•  Elevate engineering craft across multiple teams through RFCs, mentorship, and knowledge sharing, and develop training programs to improve engineering skills and knowledge 

•  Represent Mitratech’s technical capabilities externally, including speaking at conferences, contributing to open-source projects, and engaging with industry peers and thought leaders 

What We Are Looking For 

To be successful in this role, you will need: 

•  10+ years of experience in software engineering, with a focus on technical leadership and architecture 

•  Deep understanding of data engineering principles, including data modeling, data warehousing, reporting, and data governance 

•  Strong technical expertise in SQL, PostgreSQL, ETL/ELT pipelines, BI tools, and analytics platforms 

•  Practical experience with AI/LLM-adjacent and agentic AI data work — e.g., RAG ingestion pipelines, embedding generation, vector store management, or building/operating AI agent workflows over data — using AI coding assistants (Claude Code, Copilot, Cursor, or similar) as a regular part of the engineering workflow 

•  Working knowledge of modern cloud platforms such as AWS 

•  Experience with BI, reporting, dashboards, and customer-facing analytics 

•  Experience leading cross-functional initiatives with product, engineering, analytics, and business teams 

Nice to Have 

•  Working knowledge of Ruby on Rails and React 

•  Experience with a semantic or metrics layer (e.g., dbt Semantic Layer, headless BI) 

•  Understanding of CI/CD, Git-based workflows, and infrastructure-as-code 

The Stack Context 

•  Modern data stack: Fivetran, Airbyte, dbt, Snowflake, GitHub, Terraform, or similar tools 

•  Application context (nice to have): Ruby on Rails, React, or similar backend/frontend frameworks 

•  Data modeling: SQL, analytics models, documentation, testing, naming standards, and version control 

•  Infrastructure: cloud-based data infrastructure, infrastructure-as-code, CI/CD, monitoring, and cloud storage 

•  Data workflows: ingestion, transformation, orchestration, reporting, deployment, and change management 

•  Reporting focus: trusted metrics, scalable reporting models, dashboards, exports, and data quality 

•  AI surface: data pipelines and quality practices supporting AI/LLM and agentic AI use cases (RAG, embeddings, vector stores, AI agents) alongside traditional BI 

Why This Role 

This role offers a unique opportunity to drive technical direction and innovation at a rapidly growing company, while also mentoring and coaching engineers to improve their craft. As a Principal Data Engineer at Mitratech, you will have the chance to work on complex and challenging problems spanning trusted reporting and agentic AI systems, collaborate with cross-functional teams, and represent the company's technical capabilities externally. If you're looking for a role that offers a mix of technical leadership, data and reporting depth, agentic AI innovation, and collaboration, this could be the perfect fit for you. 

We are an equal-opportunity employer that values diversity at all levels. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity, disability, or veteran status.

Data Engineer

Location: Bengaluru, India (Hybrid)

Employment Type: Full-time

Experience: 3-5 years

Role Overview  

What We’re Looking For:

• Bachelor’s degree in Computer Science/Engineering or equivalent experience required.
• Experience designing and shipping cloud services products.
• Experience driving and managing technical and architectural dependencies on AWS Cloud.
• A firm understanding of system architecture, cloud computing, PaaS/SaaS design principles, S3, DynamoDB, RDS mandatory.
• Experience in building or maintaining ETL processes and tools, i.e., AWS Glue or any open-source tool.
• Proven system-level design contribution to a current “Live” (in production / under daily high load) multi-region SaaS or PaaS offering.
• Proven experience with S3, DynamoDB, SQL, and AWS RDS services.
• Proficiency in programming languages such as Python.
• Strong analytical and problem-solving skills.
• 
  

Required Skills & Experience

• Experience with Python, SQL, and data visualization/exploration tools.
• Familiarity with the AWS ecosystem, specifically S3, DynamoDB, and RDS.
• Communication skills, especially for explaining technical concepts to nontechnical business leaders.
• Ability to work on a dynamic, research-oriented team that has concurrent projects.
• Experience in AWS cost optimization (Savings Plans, Reserved Instances, Spot Instances) and governance frameworks.
• Experience developing solutions using infrastructure orchestration tools (SSM, automation account, Ansible, etc.).
• Excellent leadership, stakeholder management, and communication skills.

What We Offer

• Work with some of the brightest minds in the emerging EV industry.
• Make a tangible impact in reducing carbon emissions and enabling sustainable energy.
• Freedom to suggest, implement, and innovate on systems, processes, and technologies.
• Daily ownership in a high-growth, challenging environment.
• Flexible work environment with hybrid schedules and virtualization options.
• Competitive pay and benefits including health coverage, innovative PTO program, and performance bonuses.

Responsibilities

Design and execute ETL test scenarios, test cases and test scripts based on business and technical requirements.

Validate source-to-target data mapping, transformation rules, business rules and data flows.

Perform ETL, Data Warehouse and Database Testing across multiple data sources and target systems.

Validate data extraction, transformation, loading and reconciliation processes.

Perform data validation, data completeness, data accuracy and data integrity testing.

Write complex SQL queries for backend data validation, reconciliation and defect analysis.

Validate source-to-target mappings and identify data discrepancies. Perform database testing involving joins, stored procedures, views, functions, indexes and constraints.

Test incremental loads, full loads, CDC and batch processing where applicable.

Validate ETL workflows, schedules, dependencies and error-handling mechanisms.

Perform data reconciliation between source and target systems and investigate mismatches.

Validate duplicate records, missing records, null values, data truncation and transformation errors.

Execute regression, integration, system and end-to-end testing for ETL/data pipelines.

Validate large-volume datasets and perform data quality and consistency checks.

Work with developers, data engineers, business analysts and product teams to resolve data-related issues.

Analyze ETL job failures and assist development teams with root-cause analysis (RCA). Log, track and manage defects using tools such as Jira, Azure DevOps or similar.

Prepare test execution reports, defect reports and testing status updates.

Participate in requirement analysis, test planning, estimation and defect triage meetings.

Support UAT, production validation and post-release data verification.

Ensure testing complies with enterprise data governance, security, privacy and quality standards.

Work in an Agile/Scrum environment and participate in sprint planning, daily stand-ups, reviews and retrospectives.

Collaborate with globally distributed teams and stakeholders across business and technology functions.

Understand insurance-domain data such as policy, customer, claims, billing, premium and financial data is an advantage.

Requirements

4–6 years of hands-on experience in ETL Testing / Data Warehouse Testing / Database Testing.

Strong understanding of ETL concepts, data warehousing and data integration processes.

Strong hands-on SQL skills including complex joins, subqueries, CTEs, aggregations and data reconciliation queries.

Experience with ETL tools such as Informatica, IBM DataStage, SSIS, Talend, Azure Data Factory or similar.

Experience testing large-volume data and enterprise data pipelines. Good understanding of Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact and Dimension tables.

Strong knowledge of source-to-target mapping and transformation validation.

Experience with Oracle, SQL Server, DB2, PostgreSQL or other relational databases.

Knowledge of batch processing, scheduling, incremental/full loads and data migration testing.

Experience with API, web service or downstream application data validation is preferred.

Good understanding of SDLC, STLC, defect lifecycle and Agile methodologies.

Experience with Jira, Azure DevOps, ALM or similar test/defect management tools.

Exposure to cloud data platforms such as Azure/AWS is an added advantage.

Exposure to Python or scripting for test-data validation/automation is desirable.

Knowledge of data quality, reconciliation, data lineage and data governance.

Strong analytical and problem-solving skills with the ability to investigate complex data issues.

Excellent communication and stakeholder-management skills.

Prior experience in Insurance, BFSI or other regulated enterprise environments will be highly preferred.

Job Summary

We are seeking a skilled Data Engineer to design, build, and maintain scalable data pipelines and infrastructure. The ideal candidate should have strong expertise in SQL, Python, Linux, and modern data engineering practices to support data integration, transformation, and analytics.

Key Responsibilities

• Design, develop, and maintain ETL/ELT data pipelines.
• Write efficient and optimized SQL queries for data extraction, transformation, and reporting.
• Develop automation scripts using Python for data processing and workflow optimization.
• Work with Linux environments for deployment, monitoring, and troubleshooting.
• Ensure data quality, integrity, and reliability across data platforms.
• Collaborate with data analysts, software engineers, and business stakeholders to deliver data solutions.
• Monitor, troubleshoot, and optimize data pipelines for performance and scalability.
• Implement best practices for data security, governance, and documentation.

Required Skills

• Strong experience in Data Engineering concepts and ETL/ELT processes.
• Proficiency in SQL, including query optimization and database design.
• Strong programming skills in Python.
• Hands-on experience with Linux commands, shell scripting, and system administration basics.
• Experience with relational databases such as PostgreSQL, MySQL, SQL Server, or Oracle.
• Familiarity with Git/version control.
• Strong analytical and problem-solving skills.

Preferred Skills

• Experience with cloud platforms (AWS, Azure, or GCP).
• Knowledge of Apache Spark, Airflow, Kafka, or similar data engineering tools.
• Experience with data warehousing solutions and big data technologies.
• Understanding of CI/CD pipelines and containerization (Docker/Kubernetes).

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• Relevant certifications in cloud or data engineering are an added advantage.

Must have experience in Java

Must have experience in Spark

Must have experience in ETL coding

Strong expertise in coding