Job descriptionMarvelous Technologies seeking ODI Consultant, who will be responsible for design, development and maintenance of ETL/ELT code for enterprise data warehouse.
TechnologiesTools 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.