ETL (Informatica) Lead/Architect

Tata Consultancy Services; Phoenix (AZ); On-site; USD 100,000 - 125,000; Full time

Benefits offered by this job

Annual Incentive

Medical Coverage

Family Leave

Insurance Options

Commuter Benefits

Training Reimbursement

Paid Time Off

401K Plan

Performance Bonus

Job summary

Tata Consultancy Services is seeking an ETL (Informatica) Lead/Architect to design, develop, and optimize enterprise data integration solutions. The role requires deep Informatica PowerCenter expertise and strong SQL skills to support data warehousing initiatives.

You will lead architectural design, collaborate with DBAs and product teams, and guide migration and modernization efforts across on-prem and cloud environments.

Qualifications

• 8+ years of ETL/architect experience.
• Expert in Informatica PowerCenter and IDMC.
• Strong SQL and database development skills.
• Experience with Oracle, SQL Server, DB2, Yellowbrick, and BigQuery.
• Familiarity with Unix/Linux shell scripting.
• Knowledge of scheduling tools and DevOps practices.
• Understanding of data warehousing concepts.

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.

Skills

ETL Architecture

Data Warehousing

SQL & DB Development

Unix/Linux scripting

DevOps / CI-CD

Version Control

Cloud platforms

Tools

Informatica PowerCenter

Informatica IDMC

Google Cloud Platform

BigQuery

Oracle Database

Microsoft SQL Server

DB2

Yellowbrick

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.