Dynamic ODI Technical Architect with extensive experience at Capgemini, specializing in Oracle Data Integrator (ODI) and SQL. Proven track record in optimizing ETL processes and resolving complex data integration issues. Adept at collaborating with cross-functional teams, demonstrating strong problem-solving skills to enhance operational efficiency and drive successful project outcomes.
Overview
12
12
years of professional experience
1
1
Certification
Work History
ODI Technical Architect
Hexaware India Pvt.
Bangalore
09.2021 - Current
Company Overview: Hexaware is a global provider of IT, BPO, and consulting services.
Monitoring the ODI jobs and workflows to ensure timely execution and completion of load processes as per scheduled.
Responding to alerts, notifications and incidents related to ODI jobs errors and failures.
Proactively monitoring on long running session, taking the appropriate action, and involving DB team to kill these sessions.
Investigating and diagnosing data integration issues, identifying root causes, and implementing resolutions and fixing the issues.
Troubleshoot errors, analyze log files, and implement solutions to prevent reoccurrence.
Documenting production support processes, troubleshooting procedures, and resolutions for future reference.
Involved in ODI upgradation version from 12.2.1.3.2 to 12.2.1.4.0 version.
Collaborating with data architects and business analysts to understand business requirements and based on ETL mapping sheets provided by data analysist designing the ODI code solutions.
Experience and working on exception handling at load plan level.
Creating and maintaining ODI mappings, interfaces, packages, and procedures to extract, transform, and load (ETL) data.
Participating in all phases of code development, testing and production deployments.
Working knowledge on LKM,IKM,CKM and JKM knowledge modules.
Good hands-on experience in performance tuning at ODI and DB level.
Performing wellness checks on the Oracle Data Integrator (ODI) environment during the maintenance activity and patches essential to ensure its smooth operation and optimal performance.
Hexaware is a global provider of IT, BPO, and consulting services.
ODI Consultant
Capgemini Technology Services India Pvt Ltd.
Hyderabad
05.2019 - 09.2021
Company Overview: Capgemini is a global leader in consulting, digital transformation, technology, and engineering services.
Understanding functional document and design flow based on that I have prepared Technical Design Documentations.
Monitoring Full and incremental load from ODI Console and Operator.
Debug the sessions by utilizing ODI session logs & web services logs files to diagnostic infrastructure level issues.
Responsible in monitoring the jobs and providing immediate analysis on root cause of failures.
Coordinating with team members in business requirement Analysis, system analysis, and development of the application.
Running and monitor the load plan by using designer and operator.
Involved in export the generated scenarios and deploy the code in different Testing cycle repository.
Utilized the PL/SQL packages, procedures, triggers cursors and various database objects.
Experience on ODI Knowledge Modules like LKM, IKM and JKM, CKM.
Experienced in Working with Load Plans and Scenarios.
Created Data servers, Physical and Logical schemas for multiple technologies like (XML, UCM, Hyperion Servers and Files) in Topology.
Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
Good Hands-on experience on creating ODI failures alerts mechanism.
Debug, troubleshoot, and resolve ODI-related issues and errors.
Provide documentation and training to users and team members as necessary.
Capgemini is a global leader in consulting, digital transformation, technology, and engineering services.
Senior ODI Developer
Capgemini Technology Services India Pvt Ltd.
Hyderabad
10.2017 - 05.2019
Company Overview: Capgemini is a global leader in consulting, digital transformation, technology, and engineering services.
Involved in Extraction, Loading (Implement business logic) and Transformation of data into RMS application base Tables using ODI.
Modified and maintained rms, rpm application databases in order to accomplish the business requirement.
Developed and employed automation scripts.
Utilized the plsql packages, procedures, triggers cursors and various database objects.
Performed the analysis necessary to design and architect solutions that meet identified client requirements.
Development of integration which integrate with oracle soa for a near real time response.
Development of interfaces to read data from complex files such as , xml.
Created Data servers, Physical and Logical schemas for multiple technologies like (XML, UCM, Hyperion Servers And Files) in Topology.
Good knowledge in creating File to Database, and Database to Database related interfaces.
Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
Experienced in Working with Load Plans and Scenarios.
Experience in implementing end to end flow which connects various sources and targets.
Experienced in Working with Exception Handling in load plans.
Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.
Capgemini is a global leader in consulting, digital transformation, technology, and engineering services.
Senior ODI Developer
Birlasoft India Pvt Ltd.
Hyderabad
10.2017 - 05.2019
Company Overview: Birlasoft is a global technology services company that provides IT services and solutions.
Involved in Extraction, Loading (Implement business logic) and Transformation data into EPMI Tables using ODI.
Modified and maintained Hyperion Essbase applications and databases to incorporate new business requirements.
Developed and employed calculation scripts.
Utilized Excel Spreadsheet Add-in and SQL server reporting tools to help meet the reporting needs of business and management.
Performed the analysis necessary to design and architect solutions that meet identified client requirements.
Created Data servers, Physical and Logical schemas for multiple technologies like (Hyperion Servers And Files) in Topology.
Good knowledge in creating File to Database, and Database to Database related interfaces.
Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
Experienced in Working with Load Plans and Scenarios.
Experience in resolving the tickets (RITM Tickets & Change Request Tickets).
Experienced in Working with Exception Handling in load plans.
Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.
Created multiple Interfaces for full load and incremental loads and executed them accordingly.
Birlasoft is a global technology services company that provides IT services and solutions.
Senior ODI Developer
TechMahindra
Pune
10.2016 - 10.2017
Company Overview: Tech-Mahindra is a provider of IT services and solutions.
Involved in Extraction, Loading (Implement business logic) and Transformation data into Flat files using ODI.
Created Data servers, Physical and Logical schemas for multiple technologies like (File, Oracle SQL Server and Excel files) in Topology.
Developed several Interfaces with Transformation Logics like Filters, Joins and Lookups.
Good knowledge in creating File to Database, and Database to Database related interfaces.
Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
Experienced in Working with Load Plans and Scenarios.
Experienced in Working with Exception Handling in load plans.
Participated in all phases of project development, testing, in deployment and support activities.
Used ODI commands like ODI-files move, ODI-files append, ODI-files copy etc.
Worked in SCD and CDC implementation and Used CDC features for Incremental data loads.
Hands on experience in configuration of agent such as standalone agent, collocated agent.
Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.
Created multiple Interfaces for full load and incremental loads and executed them accordingly.
Harjai Computers is a provider of IT services and solutions.
ODI Developer
Tata Consultancy services
Pune
09.2013 - 10.2016
Company Overview: Tata consultant Pvt Ltd
Involved in Extraction, Loading, and Transformation data to warehouse using ODI.
Developed several Interfaces with Transformation Logics like Filters, Joins and Lookups.
Created Data servers, Physical and Logical schemas for multiple technologies like (File, Oracle SQL Server and Excel files) in Topology.
Good knowledge in creating File to Database, and Database to Database related interfaces.
Extensively used ODI (Oracle Data Integrator) ELT tool to create Data ware Housing OLAP.
Experienced in Working with Load Plans and Scenarios.
Participated in all phases of project development, testing, in deployment and support activities.
Used ODI commands like Odi-files move, odi-files append, odi-file copy etc.
Very much involved in understanding the source system and target systems.
Strong Experience on creating workflow using package and objects like procedure, Interface, Variables, User Functions and Development of procedures, models and packages.
Experience on ODI Knowledge Modules like, LKM, IKM and JKM, CKM.
Worked in SCD and CDC implementation and Used CDC features for Incremental data loads.
Created multiple Interfaces for full load and incremental loads and executed them accordingly.
Enhancement of ELT code/design, defect fixing- code fixes and data fixes.