Job ID: VA-640132 (98291228)
Local IBM Infosphere DataStage Developer with PL/SQL, DW/Data Warehousing, Oracle, Toad, SQL Plus, SQL Developer, SQL Server, TFS, Job Scheduling, Agile/Scrum and Linux Shell Scripting experience
Location: Richmond VA (VDOT)
Duration: 6 months
Positions: 1 (1/2)
*local candidates strongly preferred
*ALL candidates MUST be able to attend a personal interview, NO phone interviews, NO Skype, NO exceptions
Skill Required / Desired Amount of Experience Expertise Rating
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
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.