Vaibhav Powar

I am looking forward to work in an organization, which provides the environment for growth with competent and Strong leaders in Data related technologies. I am having a knowledge in ETL, SQL and Data warehousing projects. I am very good team player in Agile way of working, with strong communication skills.

Data Engineer at ScatterPie Analytics (2025-01 – Present)

Working as a Data Engineer in ScatterPie Analytics.

ETL Developer at Ultraskills IT solutions (2021-11 – 2024-12)

Data Engineer at Quess Corp (2025-01 – Present)

BI_TRANSITION project - Development and Support in Finance industry

• Involved in discussions with business users to understand the Business requirement.
• Did analyzed the Source data and validated against the business requirement. Given suggestion to source team, requested the missing data.
• Created different pipelines for the implementing the star schema to implement the different KPIS.
• Conducted comprehensive data analysis in MySQL, identifying KPIs, uncovering outliers, and providing actionable insights to influence business strategies and operational decisions.
• Used custom SQL in ETL to do data transformations such as filter, Joins etc.
• Managed data loading processes in the UAT environment, ensuring smooth transitions from development to testing
• Worked in UAT environment for validation of the data to resolve the user's query.
• Created Technical design document, and took the client sign off on the same.
• Developed and maintained schemas, creating mapping sheets as per data models in collaboration with tech architects
• Built and managed ETL pipelines, loading data into Snowflake, and creating interfaces for raw & stage layers
• Developed scalable ingestion Taskflow to extract structured data from Oracle, PostgreSQL, MS SQL, and SharePoint Lists
• Converted complex Qlik ETL scripts and Oracle SQL queries into optimized Snowflake-compatible codes
• Designed and implemented mapping for efficient data transformation, with automated daily execution to ensure timely loading into target tables.
• Building data mart and Star Schema using IICS and Snowflake.
• Scheduled ingestion and ETL pipelines using Stonebranch, monitored ETL jobs, and debugged errors
• Addressed customer concerns, provided ad-hoc mapping refinements, and ensured data quality
• Deployed code to QA and production environments using GIT and Jenkins
• Helped on Post Deployment issues, Production Maintenance issues

ETL Development at SBI (2023-08 – 2024-12)

WMP project - Development and Support in Banking industry

• Worked on development and support activities.
• Extraction of source file/database data and load the data in data warehouse.
• Development of mappings, sessions, workflow etc. as per design.
• Worked on all of the design phases (Staging, SNAP, Business and Dimensional layer)
• Worked on creation of mappings for different dimension and fact table.
• Worked on extract generation for the transaction details.
• Worked as SPOC for deployment activities
• Used different transformation for implementing SCD1, SCD2 logics.
• Coding (Implementation of business requirement through Informatica) and Unit Testing
• Developed the UNIX Scripts to transfer the Files
• Worked on all the layer of the Architecture
• Worked on Peer review.
• Doing the data load in UAT environment and data validation
• Involved in support of the Application.

ETL Development and Support at Tele2 (2021-11 – 2023-08)

EDW project - Development and Support in Telecommunication industry

• Requirement Analysis for the different work flows.
• Used various transformations like Filter, Expression, Aggregator, Joiner, Update Strategy Router and to create robust mappings in the Informatica.
• Used PDO for different logic in Informatica.
• Worked on the UNIT testing of the code.
• Worked on all the layer of the Architecture
• Worked on Peer review.
• Doing the data load in UAT environment.
• Data validation
• Involved in UNIX scripting activities as well.
• Resolve the performance issues in the Informatica mappings.
• Used GitHub CI/CD process

BSC in CS – Shivaji University Kolhapur (2021)

Class XII – Kolhapur Board (2015)

Class X – Kolhapur Board (2013)