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..