> Markdown version of [/jobs/ext/458145-etl-informatica-lead-architect](https://www.wearedevelopers.com/jobs/ext/458145-etl-informatica-lead-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # ETL (Informatica) Lead/Architect - **Company:** Tata Consultancy Services Limited - **Location:** Phoenix, AZ, United States - **Experience:** Expert - **Salary:** $100,000.0 - $120,000.0 - **Contract:** Permanent contract - **Skills:** Application Integration Architecture, BigQuery, Code Review, Databases, Continuous Integration, Extract Transform Load (ETL), Data Mapping, Data Migration, Data Warehousing, IBM DB2, Database Development, DevOps, Oracle Databases, Standard Sql, Shell Script, Google Cloud, Informatica Powercenter, Star Schema, Enterprise Integration, Software Version Control - **Published:** June 7, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=17ffa7e611d68ce5 ## About the Role 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 ## 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 ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)