OnBenchMark Logo

PRATEEK

Senior Data Engineer
placeholder
Location Delhi
view-icon
Total Views167
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 4.3 Year
  • Cost
    Hourly Rate$10
  • availability
    AvailabilityImmediate
  • work from
    Work FromAny
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnMay 07, 2024
Key Skills
Azure StorageAWS or AzureSSISSSASSQLAzure Data FactoryAzure SynapseETLDataware houseData ModelingSnowflakeMatillionPythonAzure SQL DB
Education
2013-2017

B.tech(IT)
Maharaja Surajmal Institute of Technology

Summary

Have 4.4 years of full-time experience in Business Intelligence as BI Developer in developing BI applications using Microsoft Business Intelligence (MSBI) Tools- SQL Server Integration Services (SSIS), SQL Server Analysis Service (SSAS), SQL Server Management Studio (SSMS), Power BI and Azure Data Factory, Azure Synapse, Key Vault, Logic App, Spark SQL, Data Vault 2. O, AWS, Matillion, and Snowflake.


Projects: -

Senior System Engineer at GlobalLogic Pvt. Ltd. (Feb 2021 – Current)

CONA: - 1. Design the whole warehouse in Data Vault Model from the beginning.

2. Built Error Notification to capture error at run time and send it through Amazon SNS

service.

3. Design an Email with the help of Python and Amazon SES service.

4. Working for a US client as an individual member.

5. Won Monthly award from GL side.


Data Engineer at Neal Analytics. (Apr 2020 – Feb 2021)

EBC/MTC: - 1. Build the pipeline for EBC and MTC Project using Azure Data Factory.

2. Built Data Model for EBC Report and developed multiple power bi reports.

3. Analyze requirements and develop ETL/BI report.

4. Worked on the triggered, automatically send notification for pipeline using the logic app.

5. Recognize for Q2, Q3- Reward in Neal India Company.

Senior System Engineer at INFOSYS LTD. (Nov 2017- Mar 2020)

Forecasting: - 1. Proficient in writing SQL queries for reporting and data analysis.

2. Data modeling and implementation of ETL Procedures, data cleansing functions, load

automation.

3. Daily work involves creating or updating jobs and implementing them for scheduling SSIS

packages with the environment variables.

4. Analyze requirements and develop ETL/BI reports and dashboards.

5. Works with Data Scientists to Infer tends from a variety of data sources and confidently

delivers their interpretation and makes recommendations to executives.

6. Created dashboards and various types of reports using Power BI.

7. Worked on tabular model using SQL Server Analysis Services 2012 (SSAS). Development

of packages according to the ETL specifications for the staging area & Warehouse data

loading using SQL Server Integration Services (SSIS) & SQL Server 2015.

Project Details
Title :CONA
Duration :1.3
role and responsibileties :

Data warehouse Design.

Build a warehouse as a single source of truth.

Built automated notification email for any data issue in any table.

Building a mechanism to evaluate goals and target for Client Sales


Description :

CONA: - 1. Design the whole warehouse in Data Vault Model from the beginning.

2. Built Error Notification to capture error at run time and send it through Amazon SNS service.

3. Design an Email with the help of Python and Amazon SES service.

4. Working for a US client as an individual member.

5. Won Monthly award from GL side.


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