Prerit Garg

Data Engineer

Gurgaon, Haryana, India12 yrs 7 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in building data warehouses and reporting dashboards.
Strong background in ETL processes and data integration.
Proficient in using AWS and modern BI tools.

Stackforce AI infers this person is a Data Engineering expert in Fintech with strong BI and ETL capabilities.

Contact

Skills

Core Skills

Technical Project LeadershipPythonData WarehousingSqlEtlData VisualizationBusiness Intelligence

Other Skills

AWS GlueAbinitioAmazon RedshiftAmazon Web Services (AWS)AthenaAutosysBusiness Intelligence (BI)Business Objects Data IntegratorData AnalysisData IntegrationETL ToolsExtract, Transform, Load (ETL)GitHiveQLInformatica

About

Data Engineer with industry experience building data warehouse, reporting dashboards and data insights for analysis. Wide experience in business analysis and understanding business processes and data flows, ability to turn data into insights using modern technologies and best practises. I really like playing with data, I understand its role in decision-making, and I know how to make it work using visualisation and advanced technologies in order to improve company performance. Mature and responsible approach based on scientific critical vision to any undertaken task, excellent time-management skills developed through successful combining different duties, confidence in using ETL and BI tools, analytical mind and willingness for permanent self-improvement and studying new techniques and technologies help me to do my job in the most effective way and create an advantage in data related fields.

Experience

The economist

3 roles

Staff Data Engineer

Oct 2024 – Present · 1 yr 6 mos

Technical Project LeadershipPythonSQLAmazon Web Services (AWS)Team Lead

Senior Data Engineer

Promoted

Apr 2022 – Oct 2024 · 2 yrs 6 mos

SQLSnowflakeAmazon Web Services (AWS)Data Warehousing

Data Engineer III

Jun 2021 – Mar 2022 · 9 mos

Publicis sapient

Senior Associate

Jan 2021 – Jun 2021 · 5 mos

Oaknorth

2 roles

Technical Lead

Apr 2018 – Jan 2021 · 2 yrs 9 mos

Senior Technical Analyst

Jul 2017 – Mar 2018 · 8 mos

Collaboration with different business units and BI Team to understand business requirements and translate them into complete ETL solution design.
Drive and participate in the definition, design, and development of Data
warehouse platform from scratch for OakNorth Bank - facts and dimension tables, indexes,
dimension modelling, ETL routine, for ETL solutions.
ETL process development using Talend and Python(Pandas and Pyspark).
Generating automated operational monitoring and regulatory reports.
Delivering Power BI/Reporting dashboards for generating data
insights, trend analysis. Like cohort Stickiness model, app downloads, Deposit vs Rate analysis, Deposit vs Pledged Analysis, Days to fund deposit, How did you hear about us.
To generate Ad-Hoc MIS reports using Data warehouse and OLTP databases.
Fee Amortization Utility: Utility to amortize (SLM and EIR model) the fees charged at the
disbursement of a loan (arrangement fee, Introducer fee, Exit Fee).
Data Migration Reconciliation Reports using Python on loan balances,
repayment future schedule and fee income.