Tata Consultancy Services

ETL (Informatica) Lead/Architect

Tata Consultancy Services • $100K — $125K *
Phoenix, AZ 85032In-Person
Information Technology
8 - 10 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 8+ years of experience in ETL architecture and Informatica
  • Proficiency in Informatica PowerCenter and IDMC
  • Strong knowledge of ETL/ELT architecture and data warehousing
  • Advanced SQL and database development capabilities
  • Experience with a variety of databases including Oracle, SQL Server, DB2, Yellowbrick, and BigQuery
  • Familiarity with cloud platforms, particularly Google Cloud
  • Understanding of DevOps principles and shell scripting

Responsibilities

  • Design and implement ETL solutions using Informatica PowerCenter
  • Develop enterprise data integration architecture and migration strategies
  • Create data mapping and transformation logic based on source systems
  • Build and maintain data pipelines for analytics platforms
  • Optimize ETL performance and reliability
  • Collaborate with cross-functional teams including DBAs and product teams
  • Lead technical documentation, code reviews, and deployment planning

Benefits

  • Discretionary Annual Incentive
  • Comprehensive Medical Coverage including dental and vision
  • Maternal and parental leave support
  • Auto, home, and identity theft insurance options
  • Commuter benefits and certification training reimbursement
  • Generous time off policy including vacation and sick leave
  • Legal assistance and financial support programs including 401K and student loan refinancing
Full Job Description
Role - ETL (Informatica) Lead/Architect

Experience Required -8+ Years

Must Have Technical/Functional Skills

ETL Architect with Informatica expertise to design, develop, and optimize enterprise data integration solutions..
• Strong experience with Informatica PowerCenter
• Experience with Informatica IDMC and Google Cloud Platform (GCP)
• Expertise in ETL/ELT architecture and data warehousing concepts
• Strong SQL and database development skills
• Experience with databases such as:

Oracle Database

Microsoft SQL Server

DB2

Yellowbrick

BigQuery
• Knowledge of data modeling techniques (Star Schema, Snowflake Schema)
• Experience with cloud platforms:

Google Cloud

Informatica IDMC
• Familiarity with Unix/Linux shell scripting
• Knowledge of scheduling tools
• Understanding of DevOps, CI/CD, and version control

Roles & Responsibilities
• Design and implement scalable ETL solutions using Informatica PowerCenter
• Develop enterprise data integration architecture and data migration strategies
• Analyze source systems and create efficient data mapping and transformation logic
• Build and maintain data pipelines for data warehouses and analytics platforms
• Optimize ETL performance, scalability, and reliability
• Collaborate with Product Teams, DBAs, and application teams
• Implement data quality, governance, and security standards
• Troubleshoot ETL failures, data discrepancies, and production issues
• Create technical design documents, architecture diagrams, and best practices
• Lead code reviews, deployment planning, and ETL framework improvements
• Support cloud migration and modernization initiatives

Base Salary Range : $100,000 to $125,000 Per Annum

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 Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

About Tata Consultancy Services

Tata Consultancy Services (TCS) is an Indian multinational information technology (IT) services and consulting company, headquartered in Mumbai, Maharashtra, India. It is a subsidiary of Tata Group and operates in 149 locations across 46 countries. TCS is the largest Indian company by market capitalization and is ranked 11th on the Forbes Global 2000 list of the world's biggest public companies. TCS is also the second-largest IT services company in the world by revenue and the largest employer of women in India. The company provides services in areas including IT, consulting, and business solutions.
Learn more about Tata Consultancy Services
Size
469,261 employees
Industry
Information Technology
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Tata Consultancy Services

More Information Technology Jobs

Find similar ETL (Informatica) Lead/Architect jobs:

NationwidePhoenix, AZ