OnBenchMark Logo

Vibhu

Senior Data Engineer
placeholder
Location Moradabad
view-icon
Total Views65
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 6 Year
  • Cost
    Hourly Rate$10
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnJune 14, 2024
Key Skills
Data ModelingData ExtractionDatabaseSQLOracleETL
Education
2012-2016

B Tech(Electronics & Communication Engineering)
UPTU

2019-2022

(Data Science & Engineering)
BITS Pilani

2021-2022

(Data Science & Engineering)
BITS PIlani

Summary

WORK EXPERIENCE

AXTRIA Mar 2022 – Nov 2022

InsightsMAx – Senior Data Engineer

• Identified required dimensions and facts for the dimension model and used Erwin tool to develop conceptual models based on requirements

• Developed data pipelines for input datasets to be used in ML algorithms with the help of Pyspark, S3 and EMR

TATA CONSULTANCY SERVICES Aug 2016 – Mar 2022

Telecom BI DWH migration to Telecom BI Datalake – Data Engineer

• Environment migration from Oracle DWH to Hadoop Datalake

• Involved in optimized data aggregation and data ingestion jobs development using Spark-SQL

• Development of automated ETL processes across millions of rows of data, which reduced manual workload by 40% monthly

Telecom BI Datawarehouse – Data Engineer

• Developed Data Mapping, Governance, Transformation and Cleansing rules for architecture involving OLTP and OLAP

• Ingested data from disparate sources using a combination of BODS, Oracle SQL DB procedures, Python and Shell scripts to create data views to be used in BI tools

• Developed semantic layer for dashboards, visualizations, and interfaces with Oracle database to deliver meaningful and actionable insights

Telecom network Datawarehouse – Data Architect

• Performed data modeling using Oracle SQL Developer tool and developed an end-to-end database solution for network data warehouse application for a leading telecom company in India

• Worked with client to understand business needs and translate those business needs into actionable reports using SQL and Oracle DB procedures, saving 15 hours of manual work each week

• Introduction of Self-Healing data pipeline into system to ensure insertion of noise-free data into data warehouse

DIA-LUT Framework – Data Modeler/ Data Analyst

• Conduct Design discussions and meetings to come out with the appropriate data model at the lowest level of grain for each of the dimensions involved

• Reverse engineered the reports and identified the data elements, dimensions, facts, and measures required for enhancements of existing reports

• Prepared ETL technical mapping documents for each mapping for future developments to maintain SDLC

Indus Dashboards – ETL Developer

• Monitored pre-decided ETL jobs written in SAP BODS and SQL Procedures and ensure resolution of discrepancies

• Involved in different phases of SDLC to analyze, design, coding and implementing high quality scalable solutions as per business requirements

Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon