Tejas Pathak Email & Phone Number

Vadodara, Gujarat, India

Cloud and ETL Expertise: Extensive experience working with cloud technologies on the Azure stack, including Azure Data Factory (ADF), Azure Databricks, and SQL Server Integration Services (SSIS) to design and maintain ETL/ELT pipelines. Strong knowledge of Private, Hybrid, and Public Cloud environments, with a focus on Azure products.ETL Development and Data Processing: Robust skills in building, optimizing, and troubleshooting ETL pipelines, with expertise in data ingestion, transformation, and orchestration for both structured and unstructured data. Hands-on experience with SQL and Python for efficient data processing.Problem-Solving and Debugging: Adept at resolving issues related to data pipelines and application environments in cloud-based systems, applying effective problem-solving techniques to ensure smooth ETL operations.Communication and Collaboration: Demonstrated strong interpersonal and communication skills, collaborating with remote and global teams to deliver ETL projects.Organizational and Project Management Skills: Highly organized and results-oriented, able to manage multiple ETL projects simultaneously in a fast-paced, cloud-based environment.

Vadodara, Gujarat, India

-Gathered data from various sources such as databases, files, cloud environments using orchestration tools or python.-Clean, transform, and structure data to make it suitable for analysis or storage in a data warehouse.-Created and managed schemas for intermediate staging tables required for ETL and Data-warehouse development.-Designed, developed, and implemented ETL processes with the help of SQL, Python and workflows using tools like SSIS, Azure Data Factory.-Developed Stored Procedures using Microsoft SQL Server and envelop the logic and transformation required for ETL. Additionally created SPs for intermediate Staging that was required for Reporting purposes through Power BI.-Ensured data integrity, consistency, and accuracy throughout the ETL process.-Optimize T-SQL scripts for better performance and faster execution.-Created Automated Scripts for generating random data for various scenarios such as testing and for simulation of distributed sets of data.-Worked with business analysts and data-warehouse engineer to understand data requirements and implement appropriate solutions.-Maintained detailed documentation of ETL processes and workflows.

Jaipur, Rajasthan, India

Iran

Did a thorough research on Alzheimer disease and its previous proposed research solutions.Proposed a solution with a machine learning model with ANN demonstrating how the analysis of MRI scans can help diagnosing the Alzheimer disease at an early stage.

Executive Post Graduate Program, Data Science And Engineering

Modules: Analytics Problem Solving Data Toolkit - Programming in Python, Python for Data Science, Data Visualization in Python, EDA.

Bachelor Of Engineering - Be, Computer Science, First Class With Distinction

Higher Secondary Education, Science

Secondary Education