| Duties & Responsibilites : | Job Description
This position will design and implement software solutions and assure current and new technologies are effectively integrated to fulfill the business needs. This individual will be expected to provide expertise and hands-on participation in the following activities:
- Manages ETL solutions for medium to large scale data warehouse projects
- IT experience in 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 ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
- Work with the Infrastructure team to 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 enterprise applications using JAVA/JEE, JSF, XML, XSLT and the IBM Portal/Websphere Application development software.
- Perform oversight of 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.
- Provide technical leadership to team of developers.
Skills Required
- Minimum 5 years experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects including: procedures, functions, triggers, packages, and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages.
- Minimum 4 years experience working with Oracle 10G or later
- Minimum 4 years experience writing technical specifications including ETL source to target mapping documents
- Minimum 4 years 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.
- Minimum 1 year experience as a technical team lead responsible for data warehouse ETL components architecture.
- Minimum 1 year experience using ETL tools like Oracle Data Integrator or Oracle Warehouse Builder and migrating data from various sources and targets including databases, flat files, and XML files. |
