Description

You will manage data quality, collection, and reporting within a CCWIS environment, owning the design, modeling, and construction of the enterprise Data Warehouse.

This role is hybrid.

Responsibilities

• Design, model, construct, load, and validate data tables within the enterprise Data Warehouse architecture.
• Reverse engineer Oracle Warehouse Builder (OWB) ETL processes and replace them with Oracle Data Integrator (ODI).
• Write complex PL/SQL stored procedures and triggers, and build database schemas, views, and indexes in Oracle.
• Collaborate with Business Analysts and customers on logical design and ETL source-to-target mappings.
• Perform unit testing, debug code, and resolve load issues and inquiries in UNIX or LINUX environments.

Required Skills

• 7 years of experience reverse engineering OWB ETL processes and migrating to ODI.
• 7 years of experience in Dimensional and Relational Data Modeling, including normalization and de-normalization.
• 7 years of experience performing development in an Oracle Data Warehouse using PL/SQL.
• 7 years of experience with advanced ETL techniques including bulk select, bulk insert, arrays, and dynamic SQL.
• 7 years of experience developing and testing maps and source-to-target mappings in ODI.
• 7 years of experience in the full SDLC, including requirement gathering, deployment, and production support.
• 7 years of experience in UNIX or LINUX environments using Shell Scripting and SFTP protocols.
• Bachelor’s Degree.

Key Skills

Education

Any Graduate