GREEN DOT: Senior Data Warehouse Developer

Elevated Resources, Inc.
Pasadena, CA, United States
3 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Working hours
Regular working hours

Tech stack

Microsoft Azure Big Data Cloud Computing Databases Data Architecture Data Governance Extract Transform Load (ETL) Data Mart Data Warehousing Issue Tracking Systems Data Intelligence Metadata
+13 more
Metadata Repositories Operational Data Store Performance Tuning Cloud Services SQL Databases Data Streaming Informatica Powercenter Data Lakes Semi-structured Data Data Lineage Apache Kafka Data Management Databricks

Job description

This is an exciting opportunity for an experienced senior data warehouse developer of large-scale data solutions. You will join a team delivering a transformative next-gen cloud hosted data platform., * 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 performance data movement pipelines using multiple ETL tools with batch and real-time event data streams (Informatica, Databricks, Apache Kafka, Azure Event Hub, SQL Packages, etc.)
  • Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks
  • Establish Informatica IDMC Platform from scratch including all administration activities like provisioning servers, installing and configuring secure agents for Informatica Data Quality, Data Governance and their master data management solutions like customer 360, Reference 360
  • Gathering business and information requirements from various product owners across various functional units
  • Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models.
  • Conducting design review sessions and communicating design artifacts with stakeholders.
  • Creating source to Target data mappings including multi step transformations
  • Ensures database features and capabilities are incorporated into data model designs and ETL pipelines to optimize performance, resiliency, and scalability.
  • Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders
  • Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks
  • Leading and coordinating the design and operationalization of Master Data Management, Data Quality & Data Governance initiatives including end to end data lineage
  • Working with other members of the project team to support delivery of additional project components associated with cloud data platforms.
  • Problem-solving of Data warehouse and ODS application issues and production errors, including high level critical production issues that require immediate attention.
  • Perform other duties as assigned including major new project initiatives.

Requirements

Data Warehousing, Data Warehousing, Cloud Computing, Service Delivery, Proof of Concept, Change Management, Performance Tuning/Optimization, Database Extract Transform and Load (ETL), Data Mart, Metadata, The ideal candidate will have a proven track record in implementing next-gen cloud data solutions and transformation pipelines for large scale organizations. We are seeking someone with deep technical skills in a variety of data warehouse related technologies to play an important role in developing and delivering early proofs of concept and production implementation. The successful candidate will have hands-on experience in a multitude of data domains; including but not limited to; 24 x 7 x 365 enterprise and cloud data warehouse and reporting solutions and management, design and build data warehouse models, ETL tool installation development, performance tuning, service delivery, incident tracking, and change management.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…