Vibhor Mathur Email & Phone Number

Working experience of 3 Years as an ETL Developer at Accenture in Azure Data Factory, Azure Databricks, Azure Synapse analytics using python, SQL, Apache Spark, Pyspark, Shell scripting etc main role is to develop ETL solutions including CI/CD deployment and detailed monitoring and testing including unit testing, functional testing, link testing, regression testing.Played a pivotal role in a critical Risk-related project for a prestigious banking client, devising and implementing advanced ETL processes to address intricate data challenges.Directed in-depth requirement gathering sessions involving designers and business analysts to secure alignment and clarity for the development of an ETL solution.Utilized High-Level Design (HLD) analysis to gain insights into source system architectures within ETL solutions.Executed sophisticated data preparation jobs implementing strategic approaches to ensure the accuracy, completeness, and relevance of critical datasets across diverse projects with defect rate less than 2%.Implemented Azure Data Factory as the core element in constructing resilient ETL pipelines, orchestrating data seamlessly within Azure architecture. Leveraged advanced PySpark functionalities for intricate data transformations, guaranteeing high performance and scalability across diverse datasets and analytical workflows. Crafted Transact-SQL views in Azure Synapse Analytics to optimize data accessibility and query efficiency, thereby streamlining analytical processes.Led the design and implementation of ETL solutions using SAP Business Objects Data Services (BODS) on-premises. Optimized data integration workflows, ensuring seamless extraction, transformation, and loading processes. Specialized in processing Implemented comprehensive testing strategies for databases, including unit,link,regression,integration testing which improved data quality by 5%. Responded promptly to maintenance requests, troubleshooting and resolving issues to minimize downtime by 2.5%. Excelled in performing root cause analysis for data-related issues, identifying factors impacting data processing workflows. Engineered Test Pack automation, streamlining the execution of 500+ queries within 10 minutes. This reduced testing time by 40% but also decreased the likelihood of human errors, elevating overall testing efficiency.Designed and implemented automation solutions to streamline data movement and processing across mainframe and Unix scripting environments.

• 

  Srm University

  Computer Engineering