Senior ETL Architect - Informatica, GCP & Data Warehousing

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

Benefits offered by this job

Discretionary Incentive

Medical Coverage

Family Leaves

Insurance Options

Training Reimbursement

Vacation & Holidays

401K & Bonus

Commuter Benefits

Job summary

Tata Consultancy Services is seeking an ETL (Informatica) Lead/Architect to design, develop, and optimize enterprise data integration solutions. You will lead scalable ETL implementations, drive data migration strategies, and ensure data quality across multiple databases and cloud platforms.

Ideal candidates bring 8+ years of experience, strong SQL skills, and expertise in Informatica PowerCenter, IDMC, and Google Cloud Platform.

Qualifications

• 8+ years of experience in ETL/architect roles with Informatica.
• Strong background in enterprise data integration and DW concepts.
• Proficient in SQL and database development across multiple RDBMS.
• Experience with cloud data platforms and data pipelines.

Responsibilities

• Design and implement scalable ETL solutions using Informatica PowerCenter.
• Develop enterprise data integration architecture and migration strategies.
• Analyze source systems and create efficient data mappings and transformations.
• Build and maintain data pipelines for data warehouses and analytics.
• Optimize ETL performance, scalability, and reliability.
• Collaborate with Product Teams, DBA, and application teams.
• Implement data quality, governance, and security standards.
• Troubleshoot ETL failures and production issues.
• Create technical design documents and architecture diagrams.
• Lead code reviews, deployment planning, and framework improvements.

Skills

SQL

ETL/ELT architecture

Data warehousing concepts

Unix/Linux shell scripting

DevOps / CI/CD

Data governance & security

Tools

Informatica PowerCenter

Informatica IDMC

Google Cloud Platform

BigQuery

Oracle Database

Microsoft SQL Server

DB2

Yellowbrick

Scheduling tools

CI/CD tooling

Job description

Tata Consultancy Services is seeking an ETL (Informatica) Lead/Architect to design, develop, and optimize enterprise data integration solutions. You will lead scalable ETL implementations, drive data migration strategies, and ensure data quality across multiple databases and cloud platforms.

Ideal candidates bring 8+ years of experience, strong SQL skills, and expertise in Informatica PowerCenter, IDMC, and Google Cloud Platform.