Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL. Used tools are:
Azure Data Factory (expert knowledge) to maintain pipeline from Oracle to Azure Data Lake
Azure Synapse to build stored procedures and read data from data lake
Review the requirements, database tables, and database relationships - Identify gaps and inefficiencies in current production reporting environment and provide recommendations address them in the new platform.