Data Engineer-Application Support-IDMC - 25th Aug (Tues) - Video

Tata Consultancy Services; Hyderabad, Pune District, New Delhi; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Tata Consultancy Services is seeking a Data Engineer for Application Support specializing in Informatica IDMC to maintain cloud data pipelines and resolve system failures. The role involves optimizing data workflows and ensuring smooth data movement across cloud environments.

You will troubleshoot data integration issues, monitor ETL jobs, and perform root-cause analysis while collaborating with cross-functional teams to test fixes and update technical documentation.

Qualifications

• Hands-on experience with Informatica IDMC components (CDI/CDQ/IDMC).
• Advanced SQL for profiling, validation, and defect analysis.
• Experience with cloud platforms and cloud data warehouses/data lakes.

Responsibilities

• Provide L2/L3 Production Support for IDMC data integrations and performance issues.
• Monitor scheduled jobs and ETL taskflows to ensure system availability.
• Investigate recurring data pipeline failures and data quality discrepancies.
• Collaborate with development and infrastructure teams to deploy fixes and maintain docs.

Skills

Advanced SQL

Data Pipeline Troubleshooting

Production Support

Tools

Informatica IDMC CDI/CDQ

Secure Agents

Cloud Platforms

Snowflake / ADLS

Job description

A Data Engineer for Application Support specializing in Informatica IDMC (Intelligent Data Management Cloud) maintains cloud data pipelines, resolves system failures, and optimizes data workflows.

Key Responsibilities

• Production Support: Provide L2/L3 support to troubleshoot data integration, connectivity, and performance issues in IDMC.
• Monitoring & Maintenance: Monitor scheduled jobs, data loads, and ETL taskflows to ensure system availability and stability.
• Root-Cause Analysis: Investigate recurring data pipeline failures, data quality discrepancies, and system exceptions.
• Collaboration: Work with development and infrastructure teams to deploy fixes, test enhancements, and maintain technical documentation.

Required Skills & Qualifications

• Core Technology: Hands-on experience with Informatica IDMC components, including Cloud Data Integration (CDI), Cloud Data Quality (CDQ), and Secure Agents.
• Database & SQL: Advanced SQL skills for data profiling, validation, query optimization, and defect analysis.
• Cloud & Warehousing: Familiarity with cloud platforms (AWS, Azure, or GCP) and cloud data warehouses/lakes like Snowflake or Azure Data Lake Storage.
• Process Knowledge: Understanding of ETL/ELT concepts, data governance standards, and Agile methodologies