Job Description :
DirectClient: Dallas Area Rapid Transit(DART)
Solicitation#2043062
Title:?? ETL/Oracle SQL Developer????
Location: Dallas, Texas 75202
Duration: Until October 31, 2018 with possible ?1 year ?extension
?Last date for submission: July 6, 2018 (2.00PM-CST)

Job Description:
Analyze and profile data from multiple strategic sources.
Help maintain the existing Oracle data warehouse
Develop SQL Queries to help ETL developers pull data from various transactional databases
Help write and optimize Oracle SQL and PL/SQL queries
Review query performance and optimizing code
Design and coding database tables to store the applications data
Data modeling to visualize database structure
Create table indexes to improve database performance
Program views, stored procedures, and functions

Note: No Skype interviews, interviews will be conducted by phone. May require travel to other locations, transportation provided.

WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
8 Information Technology experience focused on Business Intelligence solutions
7 Experience independently developing SQL script solutions from scratch working with BI Analysts and Data Modelers
7 Develop SQL Queries to help ETL developers pull data from various transactional databases
6 Writing and optimizing Oracle SQL queries and PL/SQL bodies
6 Programming views, stored procedures, and functions
6 Years of cumulative experience as a Data Modeler, Data Architect
5 Analyzing and maintaining Oracle data warehouse
4 Analyzing performance and creating table indexes to improve database performance
4 Preparing metadata documentation describing relationships on data warehouse & data mart structures

Preferences:
Years Skills/Experience
IBM InfoSphere DataStage Certified
PMP

Client : DART