Demo

Data Warehouse Engineer with ETL

SYSTEM EDGE (USA) L.L.C.
Albany, NY Full Time
POSTED ON 2/19/2025
AVAILABLE BEFORE 5/17/2025

Hello,

We are urgently hiring for the below role with our Direct client State of New York (NYS) :

Note :

We are the direct and prime vendors with the State Of New York.

JOB TITLE : Data Warehouse Engineer with ETL

Job ID : HBITS-06-13849

Location : 40 North Pearl Street, Albany, NY 12243 (Hybrid)

Duration : 24 months

Client / Dept. : New York State Office of Temporary & Disability Assistance (OTDA)

Rate : $68 / hr on C2C (All incl.)

Required Documents :

Stamped VISA Copy, Passport COPY, DL Copy / State ID, Bachelor Degree copy & 3 Prof. References - MUST FOR SUBMISSION – All Visa HoldersOnly DL – For USC

Job Description :

  • 84 Months experience developing and testing query solutions using Oracle PL / SQL query.
  • 84 Months experience with UNIX Shell Scripting.
  • 84 Months experience with ETL design for Data Warehouse / Data Mart development using SQL and PL / SQL programming / IBM Data Stage.
  • 72 Months experience with performance tuning and optimization of sessions, mappings, sources and targets, production support, trouble shooting and solving migration issues, and identifying errors during data loads and transformations for Cognos or OBIEE 10 / 11g environment.
  • 72 Months experience using ER Studio for dimensional data modeling for Cognos or OBIEE 10 / 11g environment.
  • 84 Months experience mentoring and assisting other developers
  • 72 Months ETL development experience in Oracle environment with IBM Datastage.
  • 60 Months ETL development experience working with PPI, SSA, or HIPPA data security requirements.
  • Bachelor’s Degree in computer science, information science, engineering, or mathematics.

The responsibilities of the IT Specialist include, but are not limited to, participating in a team approach to :

  • Capture and load source system data via ETL processes into the data mart.
  • Develop, test and implement program logic for ETL development.
  • Efficiently implement team developed ETL technical specifications.
  • Optimize ETL data load jobs to improve performance and automate them and identify and create solutions to improve system performance and availability.
  • Develop and maintain logical and physical dimensional data models for Data Mart.
  • Following agency standards to ensure the accuracy and integrity of data and applications through analysis and coding as performed by the ETL process.
  • Writing clear ETL process and data modeling documentation and clear documentation of all associated tasks and processes.
  • Ongoing design, development, maintenance, and support of ETL workflows.
  • Investigating and resolving data loading and / or data integrity issues.
  • Salary : $68

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Warehouse Engineer with ETL?

    Sign up to receive alerts about other jobs on the Data Warehouse Engineer with ETL career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $71,122 - $96,652
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at SYSTEM EDGE (USA) L.L.C.

    SYSTEM EDGE (USA) L.L.C.
    Hired Organization Address Seattle, WA Full Time
    Job Details Lead/ Architect Java Developer Seattle based Client Hybrid working is needed -3 days office in Seattle-WA. W...
    SYSTEM EDGE (USA) L.L.C.
    Hired Organization Address Seattle, WA Full Time
    Job Details Lead/ Architect Java Developer Seattle based Client Hybrid working is needed -3 days office in Seattle-WA Wo...
    SYSTEM EDGE (USA) L.L.C.
    Hired Organization Address Plainfield, NJ Full Time
    Job Details Title: Automation Tester (API, Java Scripting, Tosca, Cypress and Selenium ) Location: Berkeley Heights, NJ ...
    SYSTEM EDGE (USA) L.L.C.
    Hired Organization Address Tempe, AZ Full Time
    Job Details Title: Oracle Financial Services Analytical Applications (OFSAA) Developer Duration: 12 Months Location: Tem...

    Not the job you're looking for? Here are some other Data Warehouse Engineer with ETL jobs in the Albany, NY area that may be a better fit.

    ETL and Data Warehouse Developer

    Lams Technology LLC, Albany, NY

    AI Assistant is available now!

    Feel free to start your new journey!