ODI Consultant

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. Apply Now