Sonali Ogra
Data Engineer
Pune
Summary
Results-driven Data Engineer with 3+ years of experience in ETL pipeline development, data warehousing, and cloud technologies. Skilled in Python, SQL, AWS, PostgreSQL, Redshift, and actively upskilling in Azure Data Engineering (ADF, PySpark, Synapse). Seeking to build scalable, reliable, and business-driven data solutions.
Overview
2
2
Languages
3
3
years of professional experience
Work History
Data Engineer
Bajaj Finserv Direct Ltd
06.2023 - Current
- Developed Data Warehouse solutions with PostgreSQL & Redshift.
- Built YAML-driven ETL frameworks to enhance scalability and enable parallel execution.
- Built YAML-driven ETL frameworks improving scalability & parallel execution.
- Automated data retention and purge processes across AWS S3, MongoDB, and Oracle, ensuring efficient data lifecycle management.
- Conducted production monitoring, root cause analysis, and issue resolution to maintain system reliability.
- Led key project focused on developing enterprise data warehouse solutions.
- Conducted production monitoring, root cause analysis, and issue resolution.
- Delivered analytical datasets & ad-hoc reports for strategic decision-making.
- Key Project – Enterprise Data Warehouse
Education
PG-DBDA - Big Data Analytics
CDAC ACTS
Pune01-2023
M.Tech - Computer Science
RGPV
Bhopal01-2018
B.Tech - Information Technology
RGPV
Bhopal01-2014
Skills
ETL development
Data warehousing
Data modeling
Programming: Python, SQL, Shell Scripting, Pandas, PyMongo, SQLAlchemy, Boto3
Databases: PostgreSQL, Redshift, MongoDB, Oracle, MS SQL Server
Cloud & Tools: AWS, Git, Jira, Linux
Learning: PySpark, AI Integration
Learning: PySpark, AI Integration
Timeline
Data Engineer
Bajaj Finserv Direct Ltd
06.2023 - Current
B.Tech - Information Technology
RGPV
M.Tech - Computer Science
RGPV
PG-DBDA - Big Data Analytics
CDAC ACTS
Core Competencies
- ETL Development
- Data Warehousing
- SQL Optimization
- Workflow Automation
- Production Support
- Data Validation
- Stakeholder Collaboration
- Business Intelligence