Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Warehouse ETL Engineer

AceStack LLC

Data Warehouse Etl Engineer Location: Midvale UT (onsite) Full Time Only Must Have Technical/Functional Skills:

  • 8+ years of experience supporting, designing and developing applications using IBM DataStage ETL jobs to load into the Greenplum EDW Database to meet the business requirements.
  • Knowledge on Oracle, DB2, SQL Server, Teradata.
  • Knowledge on Pyspark.
  • Sound understanding of data modeling, data quality and data profiling.
  • Familiar with IBM InfoSphere DataStage.
  • Experience in writing script using SQL and Python.
  • Knowledge on Cloudera data lake.
  • Ability and desire to learn new technologies quickly.
  • Ability to work independently and collaborate with others at all levels of technical understanding.
Roles & Responsibilities:
  • Analyze environment and data designs to assess impacts to requested changes by managing code base and environment usage for development, staging and testing and applying branch and code versioning to support different data sets [10%].
  • Ensure processes are consistent with business requirements from Information Analysts (IAs) on how to process the upstream data [10%].
  • Source data from Oracle, DB2, SQL Server, Teradata, and profile the data to understand the requirements [10%].
  • Designing the IBM DataStage ETL jobs to load into the Greenplum EDW Database to meet the business requirements within the SLAs [10%].
  • Perform unit tests on code [5%].
  • Setup Control-M Schedules and order them per the business needs [5%].
  • Keep track of the reported defects, and support other teams to resolve defects [5%].
  • Monitor DataStage jobs, identify bugs, and resolve issues by fixing the data or rewriting the code [10%].
  • Work and mentor team on use of IBM InfoSphere DataStage [5%].
  • Design, build and maintenance of transform rules and processes to derive the correct data from the extracted data and to transform it into the required format [10%].
  • Design code and write SQL, Python scripts, and Unix Shell Scripts based on ETL requirements [5%].
  • Create mappings to assist Information analysts on the team [5%].
  • Design and develop data pipeline to load into Cloudera data lake [10%]. AceStack LLC

Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Data Warehouse ETL Engineer in Midvale, UT vacancy
  • $132.23k - $176.31k

     ...the trusted network for the AI‑powered world, connecting people, data, and applications through our expansive fiber network and...  ...driven decision-making. The role requires close partnership with engineering, analytics, Adobe, Salesforce, and business stakeholders to ensure... 
    Suggested
    Full time
    Temporary work

    Lumen

    West Jordan, UT
    3 days ago
  • Job-ID29220521Reference26-01840 Data Architect Job Summary The Data Architect owns the shape of the data itself. This role defines...  ...+ years in data modeling, data architecture, or analytics engineering Strong command of dimensional modeling, Data Vault, or third normal... 
    Suggested
    Contract work

    ConsultNet

    South Jordan, UT
    16 hours ago
  •  ...Description Job Description Job Title: Data Architect Location: New York City, NY,...  ...Databricks on AWS, PySpark, Python, SQL, and ETL tools such as Informatica. This is a...  ...years of experience as a Data Architect, Data Engineer, Data Analyst, or related data-focused... 
    Suggested
    Local area

    AMroute LLC

    Riverton, UT
    26 days ago
  • $116k - $159k

     ...and build better tomorrows for all.Job Title: Data Architect Who You'll Work WithOur Data Architecture & Engineering teams helps organizations modernize their data...  ...architectures, including data lakes, lakehouses, data warehouses, and real-time data platforms.* Translate... 
    Suggested
    Temporary work
    Work at office
    Local area

    Slalom

    Salt Lake City, UT
    1 day ago
  • The University of Texas at Austin is seeking a Segmentation Manager to establish governance, define audience segments, and ensure data quality across UT Development programs. You will partner with campus units to implement consistent segmentation and monitoring practices... 
    Suggested

    The University of Texas at Austin

    Salt Lake City, UT
    3 days ago
  • $169.8k - $355.4k

     ..., networks etc. Responsibilities As a member of the software engineering division, you will take an active role in the definition and evolution...  ...assessment. About Us Only Oracle brings together the data, infrastructure, applications, and expertise to power everything... 
    Temporary work
    Flexible hours

    Oracle

    Salt Lake City, UT
    3 days ago
  • $124k - $280k

     ...SummaryThe Opportunity As a Applied AI Health Data Architect you will shape data...  ...provider clients, bringing together data engineering, analytics, and AI to improve how information...  ...and Snowflake - Developing data models, warehouse structures, and transformation logic... 
    Full time
    H1b

    PwC

    Salt Lake City, UT
    16 hours ago
  • $55 - $85 per hour

     ...Job Description Job Description Data Architect Salt Lake City, UT (Onsite 2-3...  ...-defined datasets. Partner with data engineering teams on data models, ingestion patterns...  ...marts, analytical data models, or data warehouse structures in a relational database environment... 
    Contract work
    2 days per week
    3 days per week

    ConsultNet

    Salt Lake City, UT
    26 days ago
  •  ...Salesforce, ServiceNow, Adobe, Anaplan, Workday, Contentful, Boomi, Workato and more—to build scalable, end-to-end solutions that unify data, streamline operations, and unlock actionable insights. Our work powers everything from smarter CRM experiences and next-gen... 
    Temporary work
    Work experience placement
    Local area

    Slalom

    Salt Lake City, UT
    4 days ago
  • $155k - $410k

     ...LevelDirectorJob Description & SummaryThe OpportunityAs a Director, AI & Data Solution Architect you will lead the design of AI and data...  ...direction to business goals within our Data and Analytics Engineering practice. As a Director you will set strategic direction, drive... 
    Full time
    H1b

    PwC

    Salt Lake City, UT
    2 days ago
  • $124k - $280k

     ...ManagerJob Description & SummaryThe OpportunityAs a Google AI & Data Solutions Architect you will lead client-focused solution...  ...architecture and delivery approaches within our Data and Analytics Engineering practice. As a Senior Manager you will lead large projects, apply... 
    Full time
    H1b

    PwC

    Salt Lake City, UT
    2 days ago
  •  ...** no C2C with 3 rd parties - W2 candidates only *** Must be able to work on site 5 days a week - no remote work Data Center Network Engineer / Data Center Network Architect - Design and support secure, resilient, and highly available enterprise network architecture... 
    Work at office
    Local area
    Immediate start
    Remote work

    System One

    Salt Lake City, UT
    17 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse ETL Engineer. Be the first to apply!