Sr. Software Engineer

Job Summary

Role: Oracle Data Integrator Developer Location: ATC Gurgaon Office Shift Timing: 12 PM to 9 PM Required by: ASAP New/Replacement Replacement Updated Date 31 Mar 2025 SUMMARY: Oracle Data Integrator is responsible for developing medium to complex ODI interfaces by using various transformation packages and knowledge modules. Should be able to diagnose and debug data reconciliation issues and identify the fixes. The incumbent should be able to deploy code to multiple environments. Working knowledge of ODI packages/interfaces and KMs is a must. ESSENTIAL FUNCTIONS ON BELOW ODI TASKS: ¿ 5 to 8 years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development and system Integration projects. ¿ Minimum 4 years of strong experience in Oracle Data Integrator (ODI) 12c with knowledge of data modeling and ETL design. ¿ In depth knowledge of Oracle Data Integrator (ODI) 12c concepts. ¿ Must have done the Development of topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, Scheduling Jobs and ODI tools. ¿ Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure. ¿ Experience in performance tuning and optimization of ETL processes. ¿ Ability to design ETL unit test cases and debug ETL Mappings. ¿ Managing Files, Oracle DB, XML's through ODI. ¿ Must be well versed and hands on in using and customizing Knowledge Modules (KM) IKM, LKM, CKM and RKM. ¿ Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD2, Aggregates, keys, indexes. ¿ Work closely with cross functional teams, including data architects, database administrators, and business analysts, to deliver high quality data integration solutions. ¿ Strong follow up skills: ability to organize applicable department timelines and follow up with internal and external customer needs. ¿ Excellent problem solving and analytical skills. ¿ Effective communication and collaboration abilities. ¿ Strong organizational skills, ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast paced environment. ¿ Experience with Salesforce integration using ODI is preferable. ¿ Experience with Production support along with development. EDUCATION AND EXPERIENCE: ¿ BE/BTech, MBA, BCA, MCA (Graduate/Post Graduate) with 5 to 8 years of relevant experience.