Revanth V S
Chennai
Summary
Data Engineer with 3.7 years of experience in data skills such as SQL, Python, PySpark, Databricks, and Power BI. Skilled in data modeling and ETL processes. Worked on automating the scripts in Python to extract the data from different data sources. By using PySpark, I built ETL jobs that ingest raw data, clean and transform it, and load it into data warehouses for the analytics team.
Overview
1
1
year of professional experience
Work History
Data Engineer
Tata Consultancy Services
11.2021 - 02.2023
- I am responsible for building and optimizing scalable ETL pipelines using PySpark and SQL in Databricks to process high-volume daily insurance claims data for a U.S. insurance company.
- Automated end-to-end data workflows in Databricks reduce manual processing time and enable the timely availability of clean claim data for downstream analytics.
- Built monitoring dashboards and logging mechanisms to track pipeline health, data freshness, and record-level issues across multiple data sources.
- Developed Python and Pandas-based transformation scripts to cleanse and standardize over a million auto and property insurance claim records, reducing downstream data errors by 25%.
- Developed dynamic DAGs in Airflow to automate PySpark jobs on Databricks for cleansing, joining, and enriching insurance claims data from auto and property lines.
- Designed and implemented data quality validation frameworks in Python to ensure the accuracy and completeness of incoming claims data.
- Worked on creating reports and dashboards in Power BI based on requirements from clients.
Developer
Tata Consultancy Services
11.2021 - 02.2023
- Experienced in analyzing QPP files to investigate and resolve efficiently.
- Wrote SPUFI queries (SQL) for fetching the data from DB2 tables based on client requirements.
- Worked on minor code changes in Java files for defect fixing.
- Proficient in Jira and ServiceNow for tracking and managing tasks.
- Successfully handled P&A (Preventive and Adaptive) inject tasks, ensuring timely completion based on business priorities.
Education
B.Tech/B.E. -
St Joseph's College of Engineering
Chennai, INDIA07.2025
XIIth - English
Sri Ragavendra Matric. Hr. Sec. School
Salem04-2017
Xth - English
Dhanalakshmi Srinivasan Matric. Hr. Sec. School
Perambalur04-2015
Skills
- PySpark
- SQL
- Python
- Power BI
- ETL processes
- Data pipeline design
- Data cleansing
- Data modeling
Languages
- English
- Tamil
Total Work Experience
3 Years 8 Months
Timeline
Data Engineer
Tata Consultancy Services
11.2021 - 02.2023
Developer
Tata Consultancy Services
11.2021 - 02.2023
B.Tech/B.E. -
St Joseph's College of Engineering
XIIth - English
Sri Ragavendra Matric. Hr. Sec. School
Xth - English
Dhanalakshmi Srinivasan Matric. Hr. Sec. School
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
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Vedavalli SVedavalli S
Senior Technical Lead at Alten Calsoft LabsSenior Technical Lead at Alten Calsoft Labs