Oracle BI to Snowflake/Power BI MigrationCurrent System:- Oracle, MS SQL Server, ODI, OBIEE, BIPTarget System:- Snowflake, Power BI, DBT, HVR

• Worked on Multiple modules of ODI.• Worked on ODI11g to 12c Migration.• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse OBAW.• Created and customized ODI interfaces, mapping, joins, filters lookups to implement business rules.• Managed ETL team for multiple modules.

▪ Managed complete ODI work in BIApps 11g environment.▪ Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse OBAW.▪ Created and customized ODI interfaces, mapping, joins, filters lookups to implement business rules.▪ Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including Essbase, Relational Database Management servers including Oracle RDBMS, SQL Server, and IBM DB2 and flat files including CSV, Excel, XML file formats.▪ Worked on Topology Manager Module to manage the data describing the information systems physical and logical architecture.▪ Responsible for Metadata Administration, managed Data models and reverse engineering.▪ Involved in designing and creating DataMart in Azure SQL DB.▪ Responsible for getting data to Azure SQL Datamart from Salesforce, Oracle, files and Sql Server using Informatica Cloud.▪ Created simple POWER BI reports on Azure SQL Datamart.

Responsibilities:-• Quick resolution of production tickets raised by business for ETL.• Interacting with business to discuss issues faced during design and development of production issues. • Attain good understanding of betting and gaming business for designing and providing effective solution for the business problem.• Performance tuning of ETL strategy used to load the data from source till the fact reporting layer.• Providing design and development walkthrough to the support team and DBA team, helping them for batch monitoring and providing quick resolution in case of any failures in production.• Interacting with technical architects for introduction of new ETL implementation and standards.• Assisting newly joined team members in estream team to understand the practices followed for ETL.

Have experience entire Data warehouse life cycle, majorly as an ETL developer, gathering requirements, data modeling and design, doing SQL performance tuning of ETL and reports. Worked on Service packs and product patches and an engineer at front to represent the product to customer after the RTM. Technologies: Talend, Oracle, SQL Server ,Oracle data Integrator , Oracle ,Flat files