Summary
Overview
Work History
Education
Skills
Certification
Hobbies and Interests
Personal Information
Timeline
Generic

PRANAV NAYAK

Bangalore

Summary

Data Engineering professional with 10.6+ years of experience specializing in ETL development, data warehousing, and business intelligence. Currently serving as Lead Technical Consultant at JLL Tech with expertise in creating complex data pipelines using Informatica, SSIS, and cloud technologies. Proven track record of delivering enterprise data solutions for Fortune 500 companies across real estate, healthcare, financial services, and retail domains.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Lead Data Engineer

JLL TECH INDIA
09.2021 - Current
  • Company Overview: Combined File Implementation Project - Leading American Real Estate Firm
  • Architected and implemented Enterprise Data Warehouse solution consolidating regional data sources
  • Designed data models and developed ETL workflows using Informatica, Azure Databricks and Snowflake
  • Integrated diverse data sources including Oracle, SQL Server, DB2, and flat files
  • Created automated pipelines for data extraction, transformation and loading across multiple regions
  • Combined File Implementation Project - Leading American Real Estate Firm

ETL Developer

ERNST AND YOUNG
03.2020 - 08.2021
  • Company Overview: AICPA and CIMA Data Management and Reporting
  • Implemented standardized data quality checks for policy, customer, producer and claims data
  • Developed ETL pipelines using Informatica 9.6 and IICS to load data through ODS to CSA to ADL layers
  • Built analytics solutions using Power BI and OBIEE for business reporting
  • Utilized Azure Data Lake for data storage and analytics processing.
  • AICPA and CIMA Data Management and Reporting

Senior ETL Developer

MERCEDES BENZ - DAIMLER GROUP
02.2019 - 03.2020
  • Company Overview: PDM 2020 Data Warehouse Implementation
  • Contributed to building enterprise data warehouse from ground up for multiple Daimler subsidiaries
  • Designed and implemented ETL mappings using Informatica 10.1, SSIS and Talend
  • Created reusable components and workflows for improved development efficiency
  • Worked with multiple databases including Teradata and Oracle.
  • PDM 2020 Data Warehouse Implementation

Informatica Developer

DELOITTE CONSULTING
11.2017 - 02.2019
  • Company Overview: MongoDB Migration - Leading American Cloud Computing Firm
  • Led data migration from Oracle to MongoDB for mobile application backends
  • Designed and implemented JSON data generation using Informatica
  • Developed HTTP transformation in Informatica to trigger Java APIs for MongoDB loading
  • Integrated Salesforce and Oracle data sources into unified MongoDB collections.
  • MongoDB Migration - Leading American Cloud Computing Firm

Informatica Developer

INFOSYS LTD
01.2015 - 11.2017
  • Company Overview: Informatica Phoenix Remediation Project - Global Athletic Apparel Retailer
  • Created Sales Order Link to capture and process store-level sales data
  • Developed ETL processes for loading sales information into SAP
  • Built reusable file consumption framework for retail verticals
  • Maintained strict SLAs for production code stability
  • Informatica Phoenix Remediation Project - Global Athletic Apparel Retailer

Education

Bachelor of Engineering - Electronics

Mumbai University
01.2014

Skills

  • ETL/ELT Tools
  • Informatica PowerCenter
  • IICS
  • Azure Databricks
  • Azure Data Lake
  • Snowflake
  • Oracle
  • SQL Server
  • Teradata
  • IBM DB2
  • Power BI
  • PL/SQL
  • Unix Shell Scripting
  • Pyspark
  • Git/GitHub
  • Control-M

Certification

  • Azure AZ-900 Certification, 89%
  • Infosys Certified Informatica Professional, 70%
  • Infosys Advanced Informatica Certification, 80%
  • Infosys Oracle 10g DBA Fundamentals Certification

Hobbies and Interests

  • Traveling
  • Certified Fitness Consultant

Personal Information

Date of Birth: 06/20/92

Timeline

Lead Data Engineer

JLL TECH INDIA
09.2021 - Current

ETL Developer

ERNST AND YOUNG
03.2020 - 08.2021

Senior ETL Developer

MERCEDES BENZ - DAIMLER GROUP
02.2019 - 03.2020

Informatica Developer

DELOITTE CONSULTING
11.2017 - 02.2019

Informatica Developer

INFOSYS LTD
01.2015 - 11.2017

Bachelor of Engineering - Electronics

Mumbai University

Similar Profiles

CREATE PROFILE
PRANAV NAYAK