Senior Informatica ETL Developer - IDMC, Hadoop & Oracle

Tata Consultancy Services

Charlotte (NC)

On-site

USD 100,000 - 125,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Tata Consultancy Services is seeking an experienced Informatica Developer to lead ETL development and data integration efforts for complex environments in North Carolina. You will design robust mappings and workflows using Informatica PowerCenter and Informatica Cloud, optimize SQL/PLSQL queries, and ensure high-volume data ingestion with performance tuning.

Responsibilities include production monitoring, incident resolution, deployments across environments, and maintaining procedures.

Qualifications

Minimum 10 years of experience in ETL development and data integration.

Responsibilities

ETL Pipeline Development: Design, build, and deploy robust mappings and workflows using Informatica PowerCenter and Informatica Cloud.
Data Integration & Modeling: Develop and optimize SQL/PLSQL; work with Oracle, Teradata, or SQL Server.
Performance Tuning: Troubleshoot bottlenecks; tune queries and mappings for high-volume ingestion.
Monitor production environments, respond to alerts, and resolve issues; track incidents against SLAs.
Debug Informatica, Spark, Oracle and Shell scripts; analyze logs and resolve issues.
Maintain and update operating procedures; provide performance reports.
Assist with deployments and migrations across Dev/SIT/UAT/Prod environments.