• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 29th Dec 2020

Requisition Class: SADATAMGMT : DBAV2 : DBA5 : Region 1-Virginia

Region Name: Virginia Information Technology Agency

Title/Role: VDOT Senior ETL Developer - Datastage (640132)

Start Date: 01/11/2021

End Date: 06/30/2021

Worksite Address: 1221 E Broad St, Richmond, VA 23219

Agency Interview Type: Web Cam Interview Only

 

 

*local candidates strongly preferred

*interviews will be conducted via MS Teams or Google Meet.

*candidates will telework now (after coming to office to pick up laptop). Once restrictions are lifted, candidates will be required to work onsite daily M-F 8-5pm, NO exceptions

 

• VDOT is looking for a Sr Level DataStage Developer. Responsibilities include:
• ETL resource with 5+ years of experience in IBM Datastage.
• Development skills in using Oracle 11g/12c PL/SQL.

 

Design relational models for small and large scale applications.

Work with project and business analyst leads in order to develop and clarify in-depth technical requirements including logical and physical data modeling activities.

• Expertise in ETL activities like Data Extraction, Data Modeling, Loading (Full/ Delta upload), and scheduling data loads, creating process chains
• Design and implement ETL processes for data transactions related to Enterprise Data Warehouse, Operational Data Store (ODS), and other data structures to support our Business Intelligence operations.
• Help business users analyze data as well as providing data insight to upper management.
• Identify and test for bugs and bottlenecks in the ETL solution.
• Ensure the best possible performance and quality in the packages.
• Provide support and fix issues in the packages ETL/ELT Developer.
• Provide data analysis and validation.
• Identification of performance issues on production and testing systems.
• PL/SQL and SQL Tuning and Optimization of newly develop and existing applications.
• Familiar with various Datastage stages sequence activities dynamic loading of data from different file formats and Oracle and SQL Server.
• They will work with the Teams which are working on Agile Development, DevOps and TFS. We will consider, if the candidate have any working knowledge/experience in those areas.

 

Write and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production,

Required

5

Years

Strong development experience and Data Warehousing knowledge, importing and exporting large datasets from and to various sources

Highly desired

5

Years

SQL Statement Tuning and Analysis

Required

5

Years

Oracle 11g/ 12C PL/SQL, Toad, SQL PLUS , SQL Developer and any other Development Tools

Required

5

Years

SQL Server 2014 Development Skills

Desired

2

Years

Source Code and Team Management software (TFS preferred)

Desired

2

Years

IBM infosphere Datastage ETL Tool

Required

5

Years

Job Scheduling through Windows and Linux and any other ETL Job Scheduler tools

Desired

3

Years

Bachelor’s Degree in Computer Science or Information Systems

Nice to have

 

 

Software Development Life cycle - Development and implementation Practices

Desired

3

Years

Strong analytical skills to solve and model complex business requirements.

Desired

3

Years

Experience in an Agile Scrum environment

Desired

3

Years

Linux OS and Writing Shell Scripts

Desired

2

Years

 

Question 3

In what city/state does candidate reside?

Question 4

Is your candidate able to work onsite daily M-F 8-5pm once restrictions are lifted? This is REQUIRED.

Question 5

Does your candidate have five plus years of IBM Datastage ETL Experience? This is REQUIRED.

Question 6

How soon after an offer can your candidate start?