Praveen Prakash
Data Engineer
Bengaluru,KA
Summary
Results-driven Data Engineer with 9.6+ years of experience in
developing ETL pipelines using Informatica PowerCenter IICS , Snowflake .Experience in utilizing Snowflake as DWH solutions, ensuring optimal data storage and retrieval processes.
Proficient in SQL / Advanced SQL , PySpark and Python libraries for Data Analysis.
Overview
10
10
years of professional experience
Work History
Data Engineer Specialist
Accenture
11.2021 - Current
- Built and optimized ETL pipelines using Informatica Powercenter , IICS and Snowflake.
- Migration of legacy systems to Cloud DWH( Snowflake ).
- Experience in building scalable big data pipelines using PySpark with Airflow scheduler/executor framework .
- Good knowledge & expertise in Data processing and Data manipulation skills like DWH concepts, SCD types.
- Professional hands-on experience in SQL for Business Reporting
- Experience in Python based ETL Development and data processing libraries
Senior Software Engineer
Legato
06.2019 - 07.2021
- Integrated multiple disparate data sources into a cohesive view using Informatica PowerCenter tools for comprehensive reporting capabilities.
- Good knowledge & expertise in Data processing and Data manipulation skills like DWH concepts, SCD types.
- Experience in utilizing Teradata utilities ( BTEQ , Fastload , Multiload , Fastexport ) for ETL needs
- Professional hands-on experience in SQL ( including Advanced SQL )
Business Technology Analyst
Deloitte
01.2018 - 06.2019
- Built ETL pipelines using Informatica Powercenter
- Used Teradata as DWH . Experience in using Teradata Utilities
- Professional hands-on experience in SQL for Business Reporting/Analytics and Query Optimization
System Engineer ( Data )
IBM
12.2014 - 10.2017
- Worked as Oracle DBA . For OLTP Optimization , created/managed tablespaces, Stored procedures ,triggers and various other DB objects.
- Used Advanced SQL for BI Queries
- Created complex views for Business Reporting .
Education
Bachelor of Technology - Electronics And Communications Engineering
NIT
Patna 04.2001 -
Skills
ETL development
Data Warehousing
PySpark
Python Data Handling Libraries
SQL / Advanced SQL ( Oracle / Snowflake / Postgres / Teradata )
Snowflake
IICS Informatica
Airflow
Big Data / Distributed Computing
Timeline
Data Engineer Specialist
Accenture
11.2021 - Current
Senior Software Engineer
Legato
06.2019 - 07.2021
Business Technology Analyst
Deloitte
01.2018 - 06.2019
System Engineer ( Data )
IBM
12.2014 - 10.2017
Bachelor of Technology - Electronics And Communications Engineering
NIT
04.2001 -