Lead Data Architect (Informatica ETL)

Tranzeal, Inc.

Los Angeles, CA, United States

21 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

3 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

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

+8 more

Data Streaming Scripting Azure Data Factory Informatica Powercenter Data Lakes Semi-structured Data Data Lineage Amazon Redshift

Job 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.

Requirements

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.