Yogini Deshpande
Sheboygan,WI
Summary
Results-driven Data Engineer with experience at Schlumberger, specializing in ETL development and data integration. Achievements include unifying over 100 tables in GCP, resulting in a 70% improvement in query performance. Proficient in Python and Informatica, with a strong focus on mentoring junior engineers to enhance collaboration and optimize data management practices.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer
Schlumberger
Pune, Maharashtra, India
09.2020 - 08.2024
- Integrated data from 4+ diverse source types (RDBMS, SAP HANA, APIs, and CSV files) to deliver 100+ tables into a unified GCP repository using Informatica BDM, PowerCenter, and IICS, significantly enhancing overall data accessibility, and enabling efficient data processing.
- Developed and maintained custom Informatica mappings to ingest data with filters , masking of data classified as secret and implemented pushdown optimization, improving query performance efficiency by 70% of time saving.
- Developed Python and Shell scripts for API data extraction, handling pagination, and ensuring data consistency across 70+ split files, which were then consolidated and delivered into a single RDBMS table.
- Optimized SQL queries for data loading in Hub (GCP), leveraging SQL Server Management Studio (SSMS), Oracle Developer, and MySQL Workbench to access and integrate data from various applications.
- Designed and implemented batch data delivery methods that improved data processing speeds based on fiscal year requirements, optimizing data handling efficiency.
- Developed a Python automation process to extract metadata, validate data integrity, and generate data registries for ingested tables before production deployment.
- Utilized Power BI to create insightful dashboards by integrating the PostgreSQL database, which enabled us to understand the time cycle required for the data ingestion process, reducing the data ingestion time by 60%.
- Mentored junior engineers, fostering a culture of continuous improvement and knowledge sharing, while enhancing team collaboration and growth.
Education
Bachelors in Computer Engineering - Computer Engineering
Savitribai Phule Pune University
Pune India10-2020
Skills
- Tools: Informatica Power Center, BDM, IICS, Power Bi , Tableau, Snowflake (In Progress)
- Databases: SQL Server, PostgreSQL, Oracle, MYSQL DB
- Languages: Python, Shell
- ETL Development, Data Integration
- Data Management: Data Quality, Data Security and Governance
Certification
- Post Graduation Certification in Data Science and Business Analytics (University of Texas at Austin 2022)
- Azure Data Fundamentals, DP 900, 2024
- Cloud Data and Application Integration, R38, 2022
Accomplishments
- Excellency Award, 2022, Recognition of work excellency in 2022 Q4
Timeline
Data Engineer
Schlumberger
09.2020 - 08.2024
Bachelors in Computer Engineering - Computer Engineering
Savitribai Phule Pune University
Similar Profiles
Yazeed AldayelYazeed Aldayel
Products and Services Delivery Manager, Mechanical Intervention at SchlumbergerProducts and Services Delivery Manager, Mechanical Intervention at Schlumberger
MAHDI SALEH AL KHAMISMAHDI SALEH AL KHAMIS
Resource Coordinator at SchlumbergerResource Coordinator at Schlumberger
Hung DinhHung Dinh
Production Supervisor at SchlumbergerProduction Supervisor at Schlumberger
Luis RodriguezLuis Rodriguez
Machine Technician at SchlumbergerMachine Technician at Schlumberger
Diana KorkkoDiana Korkko
Educator | Project Manager in the Classroom at Sheboygan Area School DistrictEducator | Project Manager in the Classroom at Sheboygan Area School District