Job Details

ID #44829950
State New York
City Albany
Job type Contract
Salary USD TBD TBD
Source V Group Inc
Showed 2022-08-13
Date 2022-08-12
Deadline 2022-10-11
Category Et cetera
Create resume

ETL Developer

New York, Albany, 12243 Albany USA

Vacancy expired!

Direct End Client: State of New York

Job Title:

ETL DeveloperDuration: 24 MonthsNo. of Hours Per Week: 40 Hours Per WeekStart Date: 06/13/2022Location: Albany, NYPosition Type: ContractInterview Type: Phone Followed with In-Person/ Webcam

Exelare ID: SNYETL027RK

Short Description: This position is for an IT Specialist to support the OTDA Child Support Data Mart. The purpose of this project is to capture and load source system data into a data mart and develop, test and implement ETL program logic to support OTDA analytical reporting requirements.

Detailed description: 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.

Required/Desired Skills:
  • 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.

Vacancy expired!

Subscribe Report job