PWPrachi Waikar is a data enthusiast with 6 years of experience specializing in ETL methodology. She has a proven track record of building scalable systems for collecting, storing, and analyzing data at scale. Her expertise includes working with various data warehousing tools and cloud platforms like AWS and Snowflake.
Experience
Assistant Manager
Infocepts
Involved in complete end to end lifecycle of data management right from requirement gathering, data ingestion, architecting pipelines along with ETL code development, testing and support. Working with Apache Spark for running spark jobs on AWS EMR to create data lake for BI reporting. Worked with ETL tools of Informatica suite, dbt and databases like SQL-Server, Memsql, Oracle, DB2 and Snowflake.
Lead Data Analyst
Infocepts
Worked extensively in Extraction, Transformation, Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center 9.x/10.x. Interacted with end-users and functional analysts to identify business requirements and transform it into technical solutions. Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, Update Strategy from varied transformation logics in Informatica. Worked with T-SQL procedures and functions, stored procedures within the mappings.
Education
IIIT Bangalore
PG Diploma in Data Science and Data Engineering
SRCOEM, Nagpur
Bachelors of Engineering(Electronics)
Licenses & Certifications
Big Data Streaming for Developers
Informatica
MicroStrategy 10 Certified Analyst (MCA)
MicroStrategy
MicroStrategy 10 Certified Designer (MCD)
MicroStrategy
MicroStrategy 10.11 Certified Specialist Analyst (MCSA)
MicroStrategy