ODI Consultant

Job description

Marvelous Technologies seeking ODI Consultant, who will be responsible for design, development and maintenance of ETL/ELT code for enterprise data warehouse.

Technologies

Tools and technologies: Oracle Data Integrator (ODI), Oracle DB, MS SQL Server DB, unix.

Key Responsibilities

• Requirements analysis, design, development and maintenance of data warehouse.

• Works on data analysis, data profiling.

• Create technical design documentation for data warehouses.

• Design, development and maintenance of ETL/ELT code using Oracle Data Integrator (ODI) to integrate various sources data into data marts, and data warehouses.

• Works on different databases coding like Oracle, Microsoft SQL Server.

• Administration of Data Warehousing applications.

• Perform source to target data reconciliation, data issues analysis and fix.

• Works on jobs scheduling, job failures root cause analysis and fix.

• Performance tuning of Data Warehouse and data load.

• Analysis of existing system, impact analysis, defects analysis and fix.

• Verify the structure, accuracy, or quality of warehouse data.

• Report assigned tasks status to supervisor on an as needed basis.

• Provide high-quality and timely deliverables; provide references and documentation for users; provide and deploy best practices in methodology.

• Ensure that the right product is developed to meet or exceed Company's quality standard and is delivered at the right time.

• Recommend new processes where needed to improve quality or on-time delivery.

• Provide unparalleled client service.

Minimum Qualification

Bachelor's degree in Computer Science or Information Technology or closely related field.

Job Location

South Deerfield, MA.