Sr Data Warehouse Engineer

Home / Arizona / Scottsdale / Et cetera / Sr Data Warehouse Engineer

Sr Data Warehouse Engineer

22 Jun 2024
Arizona, Scottsdale, 85250 Scottsdale USA
Report job

Sr Data Warehouse Engineer

Vacancy expired!

Send your responses to Radhika @ or call

Job Title: Sr Data Warehouse Engineer

Job Type: Contractor

Duration: 6+ months

Hours & Location: M-F, 40 hours/week US-AZ Time. This role will be remote while COVID restrictions are in place.

Work Authorization: Must be authorized to work for any employer in the US.

Education: Bachelor’s or Master’s Degree in Statistics, Math, Computer Science, Management
Information Systems, Data Analytics or another quantitative discipline, or equivalent work experience

Requirements:
  • 10+ years of proven experience in multiple database platforms, including Oracle, SQL Server, Teradata and Postgres.
  • 10+ years of experience in design, development, deployment and support activities using ETL tools Informatica, Pentaho, Talend or SSIS.
  • 5+ years of experience in DW production support, troubleshooting and resolving data load errors.
  • Minimum 2 years of experience in consuming data from REST API’s and Kafka events.
  • Minimum 2 years of experience with JSON, XML and CSV sources
  • Strong Analytical and dimensional modeling background is required.
  • Demonstrated ability to take initiative, solve complex data problems and make sound decisions.
  • Advanced experience with Data visualization tools (Tableau, Power BI)
  • Experience in designing highly available Data Warehouse architecture, including identifying and deploying appropriate replication and monitoring capabilities for operational effectiveness.
  • Demonstrated experience in all phases of software development including requirements analysis, design, coding, testing, debugging, implementation, and support
  • Demonstrated expertise in designing and implementing ETL/ELT processes using established industry best practices
  • Strong experience in Relational Data Modelling and Dimensional Data modeling (starschema) and slowly changing dimensions.
  • Advanced experience in writing ad-hoc complex SQL Queries (Oracle and Postgres). Query optimizations and performance improvements.
  • Minimum 5 years of experience with Database procedural languages(PL/SQL, PG/SQL)
  • 5+ years’ experience with the analysis of business processes, workflow, data mapping and cross-data integration in a complex data warehouse environment.
  • In depth understanding of data cleansing, data auditing, data profiling, data modeling, entity-relationship modeling and dimensions modeling.
  • Experience in Java, python programming.
Thanks and Regards,

Radhika
Omega Solutions, Inc.


www.omegasolutioninc.com

Related jobs

Job Details

  • ID
    JC15722739
  • State
    Arizona
  • City
    Scottsdale
  • Job type
    Contract
  • Salary
    Depends on Experience
  • Hiring Company
    Omega Solutions Inc
  • Date
    2021-05-26
  • Deadline
    2021-07-25
  • Category
    Et cetera
  • Print

Jocancy Online Job Portal by jobSearchi.

Navigation
Vacancies
© Copyright 2024 jocancy.com. Developed by MicroPHP