SAURABH PATHAK
Nallasopara west
Summary
Results-driven Azure Data Engineer with TATA Consultancy Services, skilled in ETL development and data warehousing. Expert in optimizing SQL queries and designing scalable data pipelines. Proven ability to collaborate effectively with cross-functional teams, ensuring project success and data integrity. Committed to delivering high-quality solutions that meet business needs.
Overview
6
6
years of professional experience
Work History
Azure Data Engineer
TATA Consultancy Services Limited
Mumbai
08.2022 - Current
- Company Overview: Client: GlaxoSmithKline. Project: CMC R&D Technology and Tools: Azure, SSMS, ADF, Data Warehouse, ADO, CI/CD, dot net, PLSQL, SQL Developer, Visual Studio, Agile, MS Excel, Citrix, Jira, TFS, GitHub.
- Developed and implemented data models, database designs, data access and table maintenance codes.
- Analyzed user requirements, designed and developed ETL processes to load enterprise data into the Data Warehouse.
- Managed version control and deployment of data applications using Git, Docker, and Jenkins.
- Designed data warehousing solutions, applying dimensional modeling techniques for optimized data retrieval.
- Conducted rigorous testing and validation of data pipelines to ensure accuracy and completeness of data.
- Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
- Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications for data solutions.
- Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
- Automated data quality checks and error handling processes to ensure the integrity and reliability of datasets.
- Collected, outlined and refined requirements, led design processes and oversaw project progress.
- Wrote and coded logical and physical database descriptions, specifying identifiers of database to management systems.
- Created stored procedures for automating periodic tasks in SQL Server.
- Developed Python scripts for extracting data from web services API's and loading into databases.
- Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.
- Documented data architecture designs and changes, ensuring knowledge transfer and system maintainability.
- Provided technical mentorship to junior data engineers, guiding them on best practices and project execution.
- Streamlined data flow from diverse sources using ETL tools such as Talend, Informatica, and Airflow.
- Configured and maintained cloud-based data infrastructure on platforms like AWS, Azure, and Google Cloud to enhance data storage and computation capabilities.
- Implemented and optimized big data storage solutions, including Hadoop and NoSQL databases, to improve data accessibility and efficiency.
Associate Engineer
CMS IT Services
Mumbai
01.2020 - 05.2022
- Company Overview: Client: ICICILOMBARD. Project: FastTrack. Technology and Tools: dot net, PLSQL, SQL Developer, Visual Studio, MS Excel, Citrix, Jira, GitHub.
- Collaborated with other teams to implement new features in existing systems.
- Analyzed customer requirements to develop detailed designs for new systems.
- Developed, tested and implemented software applications for client's needs.
- Provided technical support to customers regarding software and hardware issues.
- Documented processes related to system development life cycle.
- Client: ICICILOMBARD. Project: FastTrack. Tools: SQL Developer, Visual Studio, MS Excel, Citrix, Jira.
- Coded programs using object-oriented programming languages like Java, C++.
- Investigated system failures and identified root causes to resolve complex technical issues.
PHP Trainee
TEKNIKFORCE VENTURES LLC
Noida
09.2019 - 11.2019
- Utilized object-oriented programming techniques in development tasks.
- Collaborated with other developers to design solutions for complex problems.
- Ensured that all coding practices followed industry best practices.
- Created and maintained webpages utilizing HTML, CSS, JavaScript, and PHP.
- Developed and maintained web applications using PHP, JavaScript, HTML, and CSS.
Education
Bachelor Of Science - Computer Science
Thakur College of Science And Commerce
Mumbai05.2019
Skills
- Python programming
- Data pipeline control
- Big data processing
- ETL development
- Data pipeline design
- SQL programming
- Data warehousing
- SQL optimization
- ETL processes
- Data modeling
- PLSQL
- Dot Net
- Database Programming
- PHP
Hobbies and Interests
- Artificial intelligence
- Machine Learning
- Data Science
- Deep Learning
- Travelling
- Cricket
- Workout
Personal Information
Date of Birth: 08/19/98
Timeline
Azure Data Engineer
TATA Consultancy Services Limited
08.2022 - Current
Associate Engineer
CMS IT Services
01.2020 - 05.2022
PHP Trainee
TEKNIKFORCE VENTURES LLC
09.2019 - 11.2019
Bachelor Of Science - Computer Science
Thakur College of Science And Commerce
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Aparajita GhoshAparajita Ghosh
SENIOR DATA & BI ANALYST at Tata Consultancy Services LimitedSENIOR DATA & BI ANALYST at Tata Consultancy Services Limited
Sandeep NanjundappaSandeep Nanjundappa
Scrum Master at Tata Consultancy Services LimitedScrum Master at Tata Consultancy Services Limited
Akash ShuklaAkash Shukla
Senior Bartender (Freelancer) at Various Luxury Events & 5-Star HotelsSenior Bartender (Freelancer) at Various Luxury Events & 5-Star Hotels
Linet LopesLinet Lopes
Manager at KOTAK MAHINDRA Bank LtdManager at KOTAK MAHINDRA Bank Ltd