Lead Data Architect (Informatica ETL)

Hybrid in Los Angeles, CA, US • Posted 8 hours ago • Updated 8 hours ago
Contract W2
Contract Corp To Corp
6 Months
50% Travel Required
Hybrid
$70 - $80/hr
Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

  • Informatica
  • Redshift
  • AWS Redshift
  • Red Shift
  • ETL
  • Enterprise Data Warehouse
  • Data warehousing
  • OLAP
  • OLTP

Summary

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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10439527
  • Position Id: 9033403
  • Posted 8 hours ago
Contact the job poster
AK

Aditya Kumar

Sr. Talent Acquisition @ Tranzeal, Inc.
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Los Angeles, California

Today

Easy Apply

Contract

$60 - $75

Hybrid in Los Angeles, California

Today

Easy Apply

Third Party, Contract

$60 - $70

Los Angeles, California

Today

Easy Apply

Contract, Third Party

$90 - $105

Hybrid in Los Angeles, California

26d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs