Experience in implementing Azure data solutions, provisioning storage account, Azure Data Factory, SQL server, SQL Databases, SQL pool Data warehouse/Synapse DWH, Azure Data Bricks - Implementation of data movements from on-premises to cloud in Azure.Develop batch processing solutions by using Data Factory and Azure Data bricks.Implement Azure Data bricks clusters, notebooks, jobs and auto scaling.Design relational and non-relational data stores on Azure.Involve in functional testing and regression testing.Creating ETL test scenarios and test cases and plans to execute test cases.Interacting with business users and understanding their requirements. Participate in KT sessions conducted by customer/ other business teams and provide feedback on requirements. Proficient in SQL and other relational databases.Implement Azure Data Factory operations and deployment into Azure for moving data from on-premise into cloud.Monitoring end to end integration using Azure monitor.Create pipelines in ADF using linked services to extract, transform and load data from multiple sources like Azure SQL, Blob storage and Azure SQL Data warehouse.

Experience in implementing Azure data solutions, provisioning storage account, Azure Data Factory, SQL server, SQL Databases, SQL pool Data warehouse/Synapse DWH, Azure Data Bricks - Implementation of data movements from on-premises to cloud in Azure.Develop batch processing solutions by using Data Factory and Azure Data bricks.Implement Azure Data bricks clusters, notebooks, jobs and auto scaling.Design relational and non-relational data stores on Azure.Involve in functional testing and regression testing.Creating ETL test scenarios and test cases and plans to execute test cases.Interacting with business users and understanding their requirements. Participate in KT sessions conducted by customer/ other business teams and provide feedback on requirements. Proficient in SQL and other relational databases.Implement Azure Data Factory operations and deployment into Azure for moving data from on-premise into cloud.Monitoring end to end integration using Azure monitor.Create pipelines in ADF using linked services to extract, transform and load data from multiple sources like Azure SQL, Blob storage and Azure SQL Data warehouse.

Being part of retrospective discussions and scrums to determine task deliveries and planning.Supporting all 4 environments (DEV, QA,UAT and PROD) in divided groups i.e. Marketing, CRM.Analyzing Customer requirements and create mappings accordingly.Status reporting on daily basis as per cycle runs scheduled on Autosys.Finding and providing RCAs for stuck jobs or issues.Knowledge about Data Warehouse concepts and various schemas involved, Transactional database and Dimensional Database.Involved in ongoing migration activities and analysis, responsible for gathering all Informatica data and making sure of required tasks to be done from a developers end on admin level.Fine-tuning the existing codes to enhance the performance.Developed Informatica mappings for the complex business requirements.Have given technical proposals for CR's to implement the necessary changes requested from business.Prepared ETL mapping documents for Data Migration for smooth transfer of project from development to production environment.Version control using Git-Bash /SourceTree (GUI) and maintaining the code repositories on Bitbucket.

Analyzing Customer requirements and create mappings accordingly.Validating / Design Informatica mapping and testing data.Design Mapping as per Business Logic for exchanging Data with various Upstream/downstream application.Knowledge about Data Warehouse concepts and various schemas Involved, Transactional database and Dimensional Database.Create Mapping and Worked with various types of transformations like Lookup (connected and unconnected).Joiner, Expression, Filter, Router, Sorter, Aggregator, Normalizer, Sequence generator, Update Strategy, Stored procedure transformation of Informatica Power Center using mapplets as templates.Developing new Informatica mappings based on the requirement using Informatica Power Center 9.6 and 10.2.Modifying the existing mappings based on the new requirements in order to improve the performance.

Oversaw telecom operations for Business Intelligence EIS unit, handling {$5 million} annual budget.Ensured 99.9% system availability by monitoring active Datastage jobs.Mapping design on Pentaho data integration tool.Follow check list activity and ensure completion of Batch job.Ticket creation process needs to be followed in the case of job failures Implementation of the error handling in case of error.Remedy ticket tool for ticket creation Implementation of workarounds in case of problems Database queries and updates for problem solving Investigate job failures and escalation.Daily report preparation and sending with in SLA Perform any ad hoc batch runs.Scheduling of resources.Create tickets on-request that require immediate action Identification of long jobs running.Participate in Disaster Recovery processes/test as required.