> Markdown version of [/jobs/ext/1789552-lead-data-architect-informatica-etl](https://www.wearedevelopers.com/jobs/ext/1789552-lead-data-architect-informatica-etl). 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).

---

# Lead Data Architect (Informatica ETL)

- **Company:** Tranzeal, Inc.
- **Location:** Los Angeles, CA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Cloud Database, Data Architecture, Data Governance, Extract Transform Load (ETL), Data Mart, Data Warehousing, Data Intelligence, Metadata Repositories, Online Analytical Processing, Operational Data Store, Software Engineering, SQL Databases, Data Streaming, Scripting, Azure Data Factory, Informatica Powercenter, Data Lakes, Semi-structured Data, Data Lineage, Amazon Redshift
- **Published:** July 22, 2026
- **Apply:** https://www.dice.com/job-detail/0fd4a6de-368a-4ecb-a779-1764230f6679

## About the Role

* 8+ years of overall software development experience is required primarily with Data warehouse applications, with 3+ years in a technical leadership role.
 * 3+ years of hands-on development experience in Cloud-based data warehouse platform (AWS Redshift preferred) and experience with ETL tools.
 * 3+ years of development experience with Python scripting experience.
 * Strong knowledge and experience in OLAP data modeling & design.

## Description

* Architecting and maintaining Operational data stores (ODS), Enterprise Data Warehouse (EDW) and associated data intelligence environments including data lakes, data marts, and metadata repositories.
 * Designing and implementing high performance data movement pipelines using multiple ETL tools (Informatica, Azure Data Factory, SQL Packages, etc) with batch and real-time event data streams.
 * Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks.
 * Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models.
 * Ensures data warehouse features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability.
 * Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders.
 * Leading and coordinating the design and operationalization of Data Governance capabilities like data lineage, data catalog, data quality, etc.


## Related Videos

- [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java)
- [The Data Mesh as the end of the Datalake as we know it](https://www.wearedevelopers.com/videos/156-the-data-mesh-as-the-end-of-the-datalake-as-we-know-it)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Intermediate Bitcoin Script](https://www.wearedevelopers.com/videos/25-intermediate-bitcoin-script)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)