Estimated Length: 6 months Full time  7:30 – 5:00 (negotiable) 

Mandatory Requirements

Specialist - 84+ Months

Desired Requirements

• 84 Months Demonstrated hands-on experience Developing and testing query solutions using Oracle PL/SQL query
• 84 Months Demonstrated hands-on experience with UNIX Shell Scripting
• 84 Months Demonstrated hands-on experience ETL design/Data Warehouse development using SQL and PL/SQL programming/ IBM DataStage
• 72 Months Demonstrated hands-on 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 Demonstrated hands-on development experience using ER Studio for dimensional data modeling for Cognos or OBIEE 10/11g environment
• 72 Months Demonstrated hands-on ETL development experience in Oracle environment with IBM DataStage 
• 60 Months Demonstrated hands-on experience as a DataStage Administrator on AIX maintaining parameter sets at the enterprise level, implementing and maintaining business and technical rules and automating ETL code migration process and standards.
• 60 Months Demonstrated ETL development experience working with PPI, SSA, or HIPPA data security requirements.
• 84 Months Demonstrated experience mentoring and assisting other developers
• Bachelor Degree in computer science, information science, health science, engineering, or mathematics

Responsibilities

• Capture and load source system data via client processes into the data warehouse; 
• Develop, test and implement program logic for client development. 
• Efficiently implement team developed client technical specifications 
• Optimize client 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 Warehouse/Data Mart 
• Following agency standards to ensure the accuracy and integrity of data and applications through analysis and coding as performed by the client process; 
• Writing clear client process and data modeling documentation and clear documentation of all associated tasks and documents. 
• Ongoing design, development, maintenance, and support of client workflows; 
• Investigating and resolving data loading and/or data integrity issues

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

Our Consultants love working for IIT

Follow us on LinkedIn or Twitter or Facebook

IIT is an Equal Opportunity Employer