ODI Developer

Job Title : ODI Developer

Location: Kolkata

Experience : 2-9 Years

Skills : ODI, Data warehousing, SQL

Job Description :

• 3 to 8 years IT experience in development and implementation of Business Intelligence and Data warehousing solutions using ODI Knowledge of Analysis Design, Development, Customization, Implementation & Maintenance of Oracle Data Integrator (ODI)
• Experience in Designing, implementing, and maintaining ODI load plan and process Working knowledge of ODI, PL/SQL, TOAD Data Modelling logical / Physical, Star/Snowflake, Schema, FACT & Dimensions tables, ELT,OLAP Experience with SQL, UNIX, complex queries, Stored Procedures and Data Warehouse best practices.
• Ensure correctness and completeness of Data loading (Full load & Incremental load) Excellent communication skills, organized and effective in delivering high-quality solutions using ODI
• Experience in design and development of Data Warehouse solutions, Software Development projects.
• Rich experience in Oracle Data Integrator (ODI) with the knowledge of ETL design and OBIEE (Business Intelligence)
• Ability to solve production issues at the earliest.
• Must have knowledge on end to end implementation of DW and BI projects.
• Ample know how on knowledge modules and customization.
• Good querying skills on Oracle database
• Good to have prior experience in installation and configuration of ODI
• Design and develop mappings, Process Flows
• Good experience on testing the data loads/other ODI objects
• Ability to design ETL/ELT unit test cases and debug ETL/ELT Mappings.
• Provide application development including enhancements and maintenance to business specific applications
• Must have done the Development of topology setup, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs.
• Knowledge on any of the following technologies is a plus - OBIEE, OAC, Python, ADW, OBIA