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?