ETL (Informatica) Lead/Architect

Tata Consultancy Services Limited

Phoenix, AZ, United States

2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Compensation

$100,000.0 - $120,000.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Application Integration Architecture BigQuery Code Review Databases Continuous Integration Extract Transform Load (ETL) Data Mapping Data Migration Data Warehousing IBM DB2 Database Development DevOps

+8 more

Oracle Databases Standard Sql Shell Script Google Cloud Informatica Powercenter Star Schema Enterprise Integration Software Version Control

Job description

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

Requirements

Do you have experience in Version control systems?, 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

Benefits & conditions

(part of Tata group) 3.93.9 out of 5 stars Phoenix, AZ $100,000 - $120,000 a year, Pulled from the full job description

Pet insurance
Health insurance
Vision insurance
Dental insurance
Commuter assistance, Base Salary Range : $100,000 to $120,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 & Pa rental 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.