ETL _ Informatica Lead

Tata Consultancy Services Limited
Charlotte, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 125K

Job location

Charlotte, United States of America

Tech stack

CA Workload Automation Ae
Unix
Cloud Computing
Databases
Data Integration
ETL
Job Scheduling
Shell
Oracle
Oracle Applications
Performance Tuning
SQL Databases
Data Logging
Informatica Powercenter
Information Technology
Sql Tuning

Job 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.

Requirements

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

Benefits & conditions

Pulled from the full job description

  • Pet insurance
  • Health insurance
  • Vision insurance
  • Dental insurance
  • Commuter assistance, 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: $115,000 - $125,000 a year

Apply for this position