What are the responsibilities and job description for the Lead Data Architect (Informatica ETL) position at Tranzeal, Inc.?
Title- Lead Data Architect
Location- West Los Angeles, CA (hybrid 3 days a week)
Key Responsibilities
- 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.
Required Qualifications
- 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.
Salary : $70 - $80