[Skip to main content](#main-content) [OpenNash Jobs](https://jobs.opennash.com/) [Hiring report](/reports/hiring/) · [All Tata Consultancy Services jobs](https://jobs.opennash.com/companies/tata-consultancy-services/) · [Search jobs](/search/) Tata Consultancy Services · Addison, TX # ETL _ Informatica Lead Addison, TX Manager or lead $100,000 - $120,000 Last seen on Tata Consultancy Services’s official careers site on August 1, 2026; it may have closed since. [Apply on Tata Consultancy Services’s careers site →](https://ibegin.tcsapps.com/candidate/jobs/419742J) [OpenNash Jobs](https://jobs.opennash.com/) / [Tata Consultancy Services](https://jobs.opennash.com/companies/tata-consultancy-services/) / ETL _ Informatica Lead ## Job description ### Must Have Technical/Functional Skills 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. ### Key Responsibilities 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. Provide L2/L3 production support, including root cause analysis and issue resolution. ### TCS Employee Benefits Summary Discretionary Annual Incentive. ### Comprehensive Medical Coverage Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. ### Family Support Maternal & Parental Leaves. ### Insurance Options Auto & Home Insurance, Identity Theft Protection. ### Convenience & Professional Growth Commuter Benefits & Certification & Training Reimbursement. ### Time Off Vacation, Time Off, Sick Lea ve & Holidays. ### Legal & Financial Assistance Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing. ### Salary Range $100,000 - $120,000 a year