ETL with career spanning 3 years’ experience in Azure Data Factory, informatica power centre, data warehouse SectorDeveloped and optimized ETL pipelines using Azure Data Factory and Informatica Power Centre and good knowledge in Azure databricksExpert in Monitoring the flows, Fixing the Failure jobs, Backtracking the Failure jobs, manually analysing the production systemExcellent problem-solving skills in SQL & Python with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure.Business requires HR analytics data to be loaded into DWH which involves automation of data load to data warehouse through success factor. The data like job requisition and job applications for particular requirement in the organization.Monitoring and Managing the Informatica, Unix TasksMeeting the SLA, Delivering the data extracts on timeBacktracking and Fixing the bugsProficient in developing and debugging ADF pipeline failures, and resolving data issuesCreating ADF pipelines, Linked services, Datasets and scheduling triggers.Worked on developing and Implemented SCD Type1 and SCD Type2 in informatica and ADFWorked on various azure services such as Azure DataBricks, Azure Synapse, Azure Blob Storage, Azure FunctionsResponsible for gathering, analysing and understanding the data to satisfy business requirementResponsible for job creation, auto scheduling of jobs, error handling and finding the causeDeveloped and optimized ETL pipelines using Azure Data Factory, Informatica Power Center resulting in a 30% increase in workflow efficiencyExperienced in creating Pyspark Databricks Notebooks for data extraction and transformations and handled various file formats like JSON, CSV, AVRO, PARQUET extensively. Possess strong SQL query writing skills and understanding of Stored Procedures.