Project #2 Company : IBM . Project Title : ATCO Duration : June‘21 to July’22 Designation : Software Developer Roles and Responsibilities

⮚ Gathered elt requirements from business team and designed its high level and low level technical documents.

⮚ Involved with the odi integrator development and understood source systems attributes and come up with gap analysis and target systemattributes mapping

⮚ Extensive dw experience using oracle data integrator (odi), configured and setup odi, master repository, work repository, projects, models,sources, targets, packages, knowledge modules, interfaces, scenarios, filters, condition, metadata.

⮚ Used oracle data integrator designer (odi) to develop processes for extracting, cleansing, transforming, integrating, and loading data intodata warehouse database.

⮚ Created master/work repositories, physical/logical schemas, agents, and context into odi topology manager tool.

⮚ Configured odi agents on windows server and tested them to execute and schedule odi scenarios.

⮚ Setup security for accessing odi s/w by creating groups and users into security manager.

⮚ Reverse engineered source and target data stores using reverse engineering knowledge modules.

⮚ Involved in planning of upgrading odi s/w from 10g to 11g versions.

⮚ Installed and configured odi 12c on windows environments.

⮚ Created and configured odi 12c agent and installed it as a window services.

⮚ Implemented mappings in odi 12c using aggregate, expression, filter, dataset, join, lookup and split components and implemented odi 12cmapping to load multiple target tables.

⮚ Created and implemented physical databases from relational and dimensional logical data models

⮚ Debug the mappings using debugger to resolve code issue.

⮚ Designed interfaces to load data from flat files, csv files in to staging area (oracle) and load in to oracle data warehouse.

⮚ Export/import interfaces, packages and its scenarios across different environments.

⮚ Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.

⮚ Performed unit and system testing of elt packages.

⮚ Analyzed session log files in operator navigator to resolve errors

⮚ mapping and managed session configuration..