ROSHANI KATEKAR
Data Engineer
Pune
Summary
ETL Developer designing and maintaining SQL and PySpark transformation logic for enterprise data movement. Uses Azure Data Factory and Databricks to extract, cleanse, validate, and load data into Azure SQL Database and Azure Data Lake. Delivers repeatable batch processes that improve data quality and keep downstream consumers supplied with current data.
Overview
3
3
Certifications
5
5
years of professional experience
Work History
Systems Engineer
Tata Consultancy Services
Pune
12.2024 - Current
- Main Technologies: PySpark, Azure Data Lake Storage, Azure Databricks, Azure Data factory, Bitbucket, JIRA, DataDog Application
- Orchestrated E2E data pipelines using Databricks workflows integrated in Azure Data Factory.
- Developed ETL/ELT pipelines using Pypark and Spark SQL to process structured and semi-structured data.
- Managed migration projects between tenants, successfully deploying in production environment.
- Worked on ingestion and extraction (Load data from SRZ-CZ-AZ) part on Rahona cloud framework.
- Worked on Enhancement projects and configured in Production, successfully worked on post-go-live, in that I had a minor issue but which was resolved within SLA.
- Engaged in requirement gathering, analysis, refinement sessions, sprint planning, estimation, code review, and project status meetings.
- Provided knowledge transition in internal team to understand the requirement.
Associate II
Capgemini Technology Services India Limited
Pune
08.2021 - 12.2024
- Main Technologies: PySpark, Azure Data Lake Storage, Azure Data Warehouse, Azure Data factory, GitHub
- Executed integrations, extracting and loading data from on-premise servers to cloud platforms to facilitate seamless data migration
- Identified data quality issues such as missing and duplicate values using Azure Databricks, ensuring data integrity for analysis
- Worked on Integrations, extracting and loading data from on- premise servers to cloud platforms
- Store the processed data in Azure SQL Database for efficient querying and retrieval.
- As per requirement or need KT sessions were arranged within and outside the team
Education
B.Tech - CSE
Karmaveer Bhaurao Patil College of Engineering
Satara01-2021
Skills
- Apache Spark
- Azure Databricks
- Azure Data Factory
- Python
- SQL
- ETL pipeline development
Accomplishments
- Recognized as the STAR of the Month for consistently delivering project milestones and successful critical deliveries
- Received On the Spot Award for consistent performance and reliable delivery of project deliverables
Certification
Databricks Certified Generative AI Engineer Associate
Timeline
Systems Engineer
Tata Consultancy Services
12.2024 - Current
Associate II
Capgemini Technology Services India Limited
08.2021 - 12.2024
B.Tech - CSE
Karmaveer Bhaurao Patil College of Engineering