> Markdown version of [/jobs/ext/233070-etl-_-informatica-lead](https://www.wearedevelopers.com/jobs/ext/233070-etl-_-informatica-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL _ Informatica Lead

- **Company:** Tata Consultancy Services Limited
- **Location:** Charlotte, NC, United States
- **Experience:** Expert
- **Salary:** $115,000.0 - $125,000.0
- **Contract:** Permanent contract
- **Skills:** CA Workload Automation Ae, Unix, Cloud Computing, Databases, Data Integration, Extract Transform Load (ETL), Job Scheduling, Unix Shell, Oracle Databases, Oracle (Applications), Performance Tuning, SQL Databases, Data Logging, Informatica Powercenter, Information Technology, Sql Tuning
- **Published:** May 30, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=60c9b6f84c27b583

## About the Role

Do you have experience in UNIX?, Do you have a Master's degree?, Primary Skill: ETL Informatica Powercentre/IDMC
Secondary: Unix, Autosys, Oracle
Experience: Minimum 15 years
Roles & Responsibilities
Bachelor's or master's degree in computer science or related field.
ETL Informatica Lead to lead the design, development, and deployment of enterprise-scale data integration solutions. The ideal candidate will have strong hands-on expertise with Informatica PowerCenter, Informatica Intelligent Data Management Cloud (IDMC), Unix, Autosys, and Oracle, and will play a key role in requirements analysis, technical design, development, testing, deployment, and production support., Qualifications : BACHELOR OF COMPUTER SCIENCE

## Description

Leadership & Delivery

 * Lead end-to-end ETL solution delivery, including requirement analysis, design, development, deployment, and support.

 * Serve as the technical lead for Informatica initiatives and mentor ETL developers.

 * Coordinate with business analysts, architects, DBAs, and cross-functional teams.

 * Perform design and code reviews to ensure best practices and standards are followed.

Requirements & Design

 * Collaborate with business and analytics teams to understand data requirements and source-to-target mappings.

 * Design scalable, high-performance ETL architectures and workflows.

 * Define error handling, logging, reconciliation, and audit mechanisms.

 * Prepare and review technical design documents and mapping specifications.

Development

 * Develop and optimize ETL mappings, workflows, and sessions using Informatica PowerCenter and IDMC.

 * Implement complex transformations, lookups, aggregations, and incremental loads.

 * Tune ETL processes for performance and scalability.

 * Develop Unix shell scripts for automation, monitoring, and file handling.

Scheduling & Automation

 * Manage and support job scheduling using Autosys.

 * Design restartable, dependency-driven workflows.

 * Ensure SLA adherence and proactive failure handling.

Database & Performance

 * Strong interaction with Oracle databases for data modeling, SQL tuning, and performance optimization.

 * Analyze execution plans and improve SQL and ETL efficiency.

Deployment & Support

 * Support ETL deployments across DEV, QA, UAT, and PROD environments.

 * Participate in release planning, production cutovers, and post-deployment validation.


## Related Videos

- [Old tools, new tricks](https://www.wearedevelopers.com/videos/1916-old-tools-new-tricks)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security)
- [Coffee with Developers - Robby Russell](https://www.wearedevelopers.com/videos/917-coffee-with-developers-robby-russell)
- [Diagnostic Tooling: How to get insights from your .NET services hosted in Kubernetes containers?](https://www.wearedevelopers.com/videos/100188-diagnostic-tooling-how-to-get-insights-from-your-net-services-hosted-in-kubernetes-containers)

## Related Articles

- [How should you format your IT resume?](https://www.wearedevelopers.com/magazine/68-how-should-you-format-your-it-resume)
- [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)