Responsibilities: • Developed and maintaining data architecture and data models. Controlling data model changes through active involvement throughout the project lifecycle, as well as reviewing and approving data designs.• Moved Oracle source using ADF to Azure Cloud in parquet format.• Fetch data from Kafka/Event hub and stored in datalake and then used in further layers and also processed xml files to move data into cloud.• Build Delta Lake house and different delta lake zones… Show more Responsibilities: • Developed and maintaining data architecture and data models. Controlling data model changes through active involvement throughout the project lifecycle, as well as reviewing and approving data designs.• Moved Oracle source using ADF to Azure Cloud in parquet format.• Fetch data from Kafka/Event hub and stored in datalake and then used in further layers and also processed xml files to move data into cloud.• Build Delta Lake house and different delta lake zones bronze, silver and gold layers.• Designed what and where data will be stored in cloud. Ex. Folder hierarchy and Year, Month and Day folders.• Moved Oracle source using ADF to Azure Cloud in the form of parquet file.• Created SCD Type I and Type II jobs using data bricks and moved the data into Cloud.• Created delta lake house and used data bricks SQL to hookup data into power BI.• Used CI/CD pipelines for check in and check out of code.• Convert Store procedures into Pyspark Databricks code and make it runnable.• Improved performance of queries using right partitioning of delta lake and applying zorder.• Created python scripts to scale up and down analysis services.• The project was delivered in 2 weeks sprint. Show less

Responsibilities: • Developed and maintaining data architecture and data models. Controlling data model changes through active involvement throughout the project lifecycle, as well as reviewing and approving data designs.• Moved Oracle source using ADF to Azure Cloud in parquet format.• Fetch data from Kafka/Event hub and stored in datalake and then used in further layers and also processed xml files to move data into cloud.• Build Delta Lake house and different delta lake zones… Show more Responsibilities: • Developed and maintaining data architecture and data models. Controlling data model changes through active involvement throughout the project lifecycle, as well as reviewing and approving data designs.• Moved Oracle source using ADF to Azure Cloud in parquet format.• Fetch data from Kafka/Event hub and stored in datalake and then used in further layers and also processed xml files to move data into cloud.• Build Delta Lake house and different delta lake zones bronze, silver and gold layers.• Designed what and where data will be stored in cloud. Ex. Folder hierarchy and Year, Month and Day folders.• Moved Oracle source using ADF to Azure Cloud in the form of parquet file.• Created SCD Type I and Type II jobs using data bricks and moved the data into Cloud.• Created delta lake house and used data bricks SQL to hookup data into power BI.• Used CI/CD pipelines for check in and check out of code.• Convert Store procedures into Pyspark Databricks code and make it runnable.• Improved performance of queries using right partitioning of delta lake and applying zorder.• Created python scripts to scale up and down analysis services.• The project was delivered in 2 weeks sprint. Show less

Responsibilities: • Developed and maintaining data architecture and data models. Controlling data model changes through active involvement throughout the project lifecycle, as well as reviewing and approving data designs.• Moved Oracle source using ADF to Azure Cloud in parquet format.• Fetch data from Kafka and stored in datalake and then used in further layers.• Build Delta Lake house and different delta lake zones bronze, silver and gold layers.• Designed what and where data… Show more Responsibilities: • Developed and maintaining data architecture and data models. Controlling data model changes through active involvement throughout the project lifecycle, as well as reviewing and approving data designs.• Moved Oracle source using ADF to Azure Cloud in parquet format.• Fetch data from Kafka and stored in datalake and then used in further layers.• Build Delta Lake house and different delta lake zones bronze, silver and gold layers.• Designed what and where data will be stored in cloud. Ex. Folder hierarchy and Year, Month and Day folders.• Moved Oracle source using ADF to Azure Cloud in the form of parquet file.• Created SCD Type I and Type II jobs using data bricks and moved the data into Cloud.• Created delta lake house and used data bricks SQL to hookup data into power BI.• Used CI/CD pipelines for check in and check out of code.• Convert Store procedures into Pyspark Databricks code and make it runnable.• Improved performance of queries using right partitioning of delta lake and applying zorder.• Created python scripts to scale up and down analysis services.• The project was delivered in 2 weeks sprint. Show less

• Analysis of business requirement and its functional and technical implementation to facilitate stakeholders in making logical / efficient decision-making to implement business intelligence (BI) solutions for Sales, product, and customer KPIs across the company.• Developed and maintaining data architecture and data models. Controlling data model changes through active involvement throughout the project lifecycle, as well as reviewing and approving data designs.• Moved Oracle source… Show more • Analysis of business requirement and its functional and technical implementation to facilitate stakeholders in making logical / efficient decision-making to implement business intelligence (BI) solutions for Sales, product, and customer KPIs across the company.• Developed and maintaining data architecture and data models. Controlling data model changes through active involvement throughout the project lifecycle, as well as reviewing and approving data designs.• Moved Oracle source using ADF to Azure Cloud in parquet format.• Created SCD mappings using data bricks using Delta Lake and moved the data into Cloud.• Created Synapse tables and hooked into Power BI• Supported existing application process which were developed on Informatica power center.• Created alerts using and email notification at ADF.• The project was delivered in 2 weeks sprint• Developed Mapping level design documents and took client’s sign off.• Identified sources map to the business requirements.• Coordinated with team members to resolve design/development issues.• Developed BI process using Informatica to load data to data mart and created SCD Type I and SCD Type II mappings.• Worked on creating transformations and mappings using designer tools of Informatica and scheduling workflow using Control M or Tidal tools.• Involved in Performance tuning of Informatica Mappings to reduce the runtime.• Expertise in tuning Oracle Queries.• Created documents like CRC (Code Review Checklist) document to ensure a good practice should be followed while ETL Development. Show less

ETL developer. Informatica, oracle, unix