Experienced ODI developer with a strong background in data integration and ETL processes , seeking challenging opportunities to leverage my skills and contribute to data-driven projects.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Staff Consultant
Apps Associates
Hyderabad
04.2022 - Current
Developed and maintained data warehouse solution using Oracle data integrator tool.
Designed and implemented data models to support reporting and analytics needs.
Collaborated with cross-functional teams to gather requirements and ensure data accuracy and integrity.
Conducted performance tuning and optimization to enhance data processing efficiency.
Troubleshoot and resolved data integration issues and provided technical support to project teams.
Worked on monthly maintenance on ODI objects.
Application Development Analyst
Accenture
Bengaluru
01.2019 - 04.2022
Setup the topology including physical architecture, logical architecture, and context
Created new Models for the different types of sources
Created load plans for the execution of scenarios in multiple ways
Expertise in creating mappings, reusable mapping, procedure, variables, and sequence in ODI
Developed interfaces to load data from multiple sources like Relational databases, flat file, complex file (JSON), xml
Used various component like filters, joins, expression, split, lookup, distinct etc
Smart importing and exporting of mapping, packages, and scenarios
Developed specification (Documents) based on the requirements, such as Business Requirement Documents, and Low-Level Document
Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates) by defining appropriate joins, calculations, dimensions, and measures in the repository in ODI
Tested application performance against user requirements to ensure quality assurance standards were met.
Education
Bachelor of Technology (Electrical and Electronics) -
Gandhi institute of Engineering & technology, Gunupur.
Secondary Education -
Grizzly Vidyalaya, Jhumri telaiya
Higher Secondary Education -
Sacred Heart School, Jhumri telaiya
Skills
Oracle Data Integrator (ODI)
ETL Development
Data Warehousing
Data Integration
Data Modelling
SQL
PL/SQL
SOA
Certification
Azure 900 Fundamentals [AZ-900]
Oracle cloud infrastructure
Accomplishments
Awarded Pinnacle Award from Accenture.
Received recognition from DU Lead and several client appreciations.
Appreciated by SIT team for the code quality.
Languages
Hindi
First Language
English
Advanced
C1
Timeline
Staff Consultant
Apps Associates
04.2022 - Current
Application Development Analyst
Accenture
01.2019 - 04.2022
Bachelor of Technology (Electrical and Electronics) -
Gandhi institute of Engineering & technology, Gunupur.