Amrita Sinha

OnPrem:

• Implemented multiple shell jobs on Unix using shell/batch and Oozie workflow scripting which helped to meet business requirement
• Developed, tested and supported star schema on Hadoop/Hive using Teradata SQL and HQL.

Cloud:

• Helped Migrating the entire Data product/Use case from On-prem legacy system to Azure Cloud.
• Built pipeline to process business' files on ADF using Azure Blob storage containers.
• Enabled Logic App to generate automated mail on completion of pipeline and also alert mails to business users in case of their file failures.
• Made a Power Bi dashboard for business users that visualizes Chart of accounts data fallouts. This helps in fixing the mapping on daily basis and improving the revenue insights on daily basis.
• Hands on experience in implementing data quality checks and data processing.
• Implemented pipelines using various sources like on-prem sql servers, oracle databases, csv files, BLOBs and Azure Synapse.
• Worked on CI/CD feature to deploy changes on synapse.