Informatica ETL Developer

Dear Candidates,

Greetings from TCS!!!

TCS is looking for Informatica ETL Developer

Experience: 5-8 years

Location: PAN India

Required Technical Skill Set: Informatica ETL Developer

Must have skill:

• Experience in ETL development with Informatica PowerCenter (experience with BDM/CDI preferred).
• Strong knowledge of PL/SQL, Greenplum, and data warehousing concepts.
• Hands-on experience with Hadoop ecosystem (HDFS, Hive) and Spark for big data processing.
• Familiarity with Kafka and real-time streaming ETL.
• Experience with Unix/Linux scripting, scheduling tools, and workflow automation.
• Understanding of data governance, metadata management, and compliance (GDPR, PII masking).

Good to have:

• Exposure to cloud-native ETL architectures and containerization (Kubernetes) is a plus.

Roles and responsibilities:

The Senior Informatica ETL Developer will design, develop, and optimize ETL workflows to support enterprise data ecosystem, which includes Greenplum Data Warehouse , HDFS-based Data Lake , and real-time streaming pipelines . This role ensures efficient data integration, high performance, and compliance with governance standards while enabling analytics and BI platforms such as MicroStrategy, Power BI, and Tableau.

• Design, develop, and maintain ETL workflows using Informatica PowerCenter and Informatica BDM/CDI for batch and streaming data ingestion.
• Integrate data from structured, semi-structured, and unstructured sources into Greenplum Data Warehouse and HDFS Data Lake .
• Collaborate with data architects, BI teams, and data governance teams to ensure alignment with architecture and compliance requirements.
• Implement error handling, logging, recovery mechanisms , and data quality checks .
• Perform performance tuning of ETL processes, SQL queries, and optimize for MPP engines .
• Support metadata management and lineage using Informatica EDC .
• Provide production support , troubleshoot ETL failures, and ensure pipeline observability.

Contribute to real-time data integration leveraging Kafka and streaming frameworks.