Estimated Length: 24 months Full-Time 8 am – 4:30 pm   All work to be on-site, no telecommuting.

Mandatory Requirements

Senior 60-84 months

Desired Requirements

• Minimum 60 months experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects.
• Minimum 48 months experience in procedures, functions, triggers, packages, and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages.
• Minimum 48 months experience working with Oracle 10G or later and MYSQL.
• Minimum 48 months experience writing technical specifications including ETL source to target mapping documents
• Minimum 48 months experience developing ETL/E-LT objects including Interfaces, Packages, Scenarios and Procedures and load strategies for relational, Type 1, 2, and 3 slowly changing dimensions using Oracle Data Integrator and MYSQL.
• Minimum 24 months experience as a technical team lead responsible for data warehouse ETL components architecture.
• Minimum 24 months experience using ETL tools like Oracle Data Integrator or Oracle Warehouse Builder or MYSQL and migrating data from various sources and targets including databases, flat files, and XML files.

Responsibilities

• Extract, Transform, and Load (ETL) application analysis, design, development and implementation, including: data analysis, data access, data structures, data manipulation, data reporting solutions, database, and technical and user documentation.
• Act as the primary Extract, Transform, and Load (ETL) technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
• Plan and execute activities such as performance test planning and execution failure failover planning and execution, endurance testing and deployment planning and testing.
• Provide the analysis, design development, and code review using common ETLscripting languages (ex. Python, Perl and Bash) and SQL
• Develop common data-source formats including relational databases, XML, JSON and flat files (ex. XSLT). 
• Perform development activities which may include data analysis, data access, data structures, data manipulation, preparing logical database models, testing and implementation.
• Prepare, and/or review technical documentation such as designs, schemas, etc., as appropriate.  

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