$8.0 per Hour
Total 3+ years of IT experience in ‘Travel and Hospitality’ domain with expertise in Design, Development, Implementation and Support of MS SQL Server2008R2/2012 and Azure data factory.
Having experience in creating database objects such as Tables, Views, Stored Procedures and Functions.
Working on SQL Server for loading, transforming and cleaning of Data by creating and managing stored procedures, functions, Joins etc.
Knowledge of Azure Data Factories for creating pipelines, datasets, using different activities like Stored Procedure activity, Copy Activity and monitoring pipelines based on applied triggers.
Having expertise in Lift and Shift SSIS Packages in Azure - deploying SSIS packages in Azure SQL Server and scheduling using Azure Data Factory.
Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
Enthusiastic and Quick to learn new applications and technologies and willing to take individual responsibilities.
A good team player with strong ability to learn and adapt new skills and makes efforts to do the work at hand and manage time effectively.
Client communication over Telephone and Email.
- January 2020 - December 2022 - 3 Year
Mandrain Oriantal Migration
- September 2020 - December 2021 - 16 Months
Mandrain Oriantal Migration project involve extraction data from different sources like file share excel files,
Oracle, SQL Server database, AS400 DB2 database, FTP Server files. Loading and transforming data by using Azure data flows as per business requirement.
Created Azure Data Factory Pipelines, Data Flows, Linked Services, Datasets, Integration Runtimes – Azure SSIS Integration Runtime and Self Hosted Integration Runtime, Triggers.
Deployment of ADF and ADW code to upper environments by using CICD Deployment pipelines.
Development of Power BI report based on transformed data using ADF. Used SharePoint linked service as source in Power BI dashboard development.
Worked on creating basic Logic Apps for email notification.
Monitoring and troubleshooting ADF workflows
Involved in Code reviews for peers to enforce coding standards and code consistency. Also mentored teammates in case of functional/technical issues.
Involved in unit testing of ETL flows, Data monitoring,
Support to developed ETL flows.
Vehicle Data Integration And Clean-up
- January 2020 - September 2020 - 9 Months
Komastu Escavators project involve extraction data from different sources like excel, CSV, text files, SQL Server database, FTP Server files. Loading and transforming data by using SSIS packages as per business requirement.
Roles & Responsibilities:
Involved in cleaning and combining different format files data using database and SSIS tool.
Basic understanding of SSIS packages.
Worked on SQL Server for loading, transforming and cleaning of Data by stored procedures.
Having knowledge of data import and export wizard.