Hello Sir,
I'm Vinay Pugalia, Head BI & Data Analysis at Inkey having an overall 16 yrs. of exp. in the IT industry. As your data source & the destination database, both are in Azure, I highly suggest Azure Data Factory to get this job done. We have done this many times in the past. We have being doing these ETL operations for 12+yrs now using SSIS & ADF.
Below is the snapshot of our technical skills related to this job -
· SQL
I've been working with SQL for the last 16 yrs. now and have completed numerous projects for SQL involving DB Designing, Performance Optimization, DB Restructuring, and TSQL creation/optimization.
. SSIS/ADF
I have a very strong experience in SSIS and have been developing SSIS packages for our clients for 13+years now. I've developed many different Load, extract, and purge types of packages with very complex logic and conditions requiring expertise in designing Parallel jobs using various stages like Join, Merge, Lookup, remove duplicates, Filter.
For the last 3yrs, I have also started orchestrating ADF Pipelines for ETL/ELT purposes performing almost all the operations done in SSIS using the different Activities.
We can schedule a discussion anytime this week based on your availability where we will study your requirements in more detail and then can plan for the next action items accordingly.
Thanks & Regards,
Vinay Pugalia