Experienced ETL Developer with over 5 years of expertise in designing, developing, and deploying robust ETL pipelines and data warehousing solutions utilizing Snowflake, SQL, Informatica Power Center, and Oracle. Currently managing data effectively across various technologies like Snowflake and SQL in current role. Confident in tackling new projects and dedicated to ensuring customer satisfaction. Consistently applying meticulous attention to detail in every aspect of work.
Overview
5
5
years of professional experience
2019
2019
years of post-secondary education
3
3
Languages
Work History
Senior System Engineer / Technology Analyst
Infosys Pvt. Ltd.
04.2022 - 01.2025
Project: Paccar financial corporation (April 2022- June 2024)
Client: Paccar.
Designation: Worked as a senior systems engineer and technology analyst.
Achievement: Honored with a Insta Rise award from the client for outstanding performance, unwavering dedication, and exemplary commitment in successfully delivering the assigned tasks for Paccar Finance with punctuality and excellence
Project: Exxon Mobil (July 2024 – present)
Client: Exxon.
Designation: Worked as a technology analyst.
Achievement: I received appreciation from the client for exceptional work on the Exxon project for timely delivery. Implementing new things with ease has made me more confident in my work. Great learning experience for future projects.
Roles and Responsibilities:
Client data is used to design data marts and define transformation logic.
Wrote SQL queries and stored procedures for data extraction, validation, and transformation across RAW, STG, and Target layers.
Created reporting views for analysis and visualization.
Loaded data into Snowflake using structured ETL processes, with a focus on quality and integrity.
Automated data workflows, including job scheduling, monitoring, and error handling.
Performed unit testing, data validation, and resolved pipeline issues.
Documented ETL steps, workflows, and methodologies for knowledge sharing.
Collaborated with stakeholders to gather requirements, and deliver reliable solutions.
Ensured compliance with organizational policies and data governance standards.
Strong grasp of business logic; worked independently and in cross-functional teams.
Communicated effectively with both technical and non-technical stakeholders.
ETL DEVELOPER
BDigitaU Digital Solutions Pvt. Ltd.
04.2021 - 04.2022
Project: Healthcare Services Data Collection.
Role: ETL Developer.
Milestone Achievement: Earned significant appreciation from the client and team for quickly learning and implementing new concepts.
Roles and Responsibilities:
Built scalable ETL pipelines in Informatica PowerCenter to extract data from Oracle, and load it into Snowflake.
Developed complex SQL scripts, stored procedures, UDFs, views, and tasks for data transformation and validation.
Designed a multi-stage Snowflake architecture (RAW → STG → Target), ensuring data integrity and lineage.
Automated data ingestion using Snowpipe, external/internal stages, and custom file formats.
Utilized Informatica transformations (Joiner, Lookup, Expression, Filter, Aggregator) for data processing.
Created reusable sessions, workflows in Informatica, and integrated with Snowflake pipelines.
Optimized Snowflake performance using clustering keys, result caching, and Query Profile analysis.
Developed and scheduled parameterized workflows, with robust error handling and logging.
Worked with analysts, QA, and business teams to deliver accurate, high-quality data solutions.
Managed schema evolution via DDL scripting in Oracle and Snowflake.
Enforced RBAC policies and ensured compliance with Snowflake security standards.
Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
Software Trainee Engineer
BDigitaU Digital Solutions Pvt. Ltd.
01.2020 - 03.2021
Designation: Worked as a Software trainee Engineer.
Assisted in data flow development and QA support during the early career phase.
Maintained detailed documentation of all completed tasks for easy reference during maintenance or future updates as needed by other developers down the line.
Assisted in the development of client-specific solutions, resulting in increased customer satisfaction levels.
Education
Bachelor of Engineering - E&TC
PES Collage of Engineering
Aurangabad, India
05.2016 - 08.2019
Diploma - E&TC Engineering
CSMSS Collage of Polytechnique
Aurangabad, India
01.2013 - 01.2016
SSC - General Education
Baliram Patil Vidyalaya
Aurangabad, India
03-2012
Skills
Snowflake
Sql Programming
Data warehousing
Informatica Power Center 104
Python
Extract, Transform, Load Techniques
Oracle 11g
SQL Server
Git, Jira, AWS(S3)
Talend
Interests
Playing Cricket, Playing Chess, Reading News Paper
Service Project ManagerNational Technical and Magnet Specialist, Remote Technical Support Engineer and Magnet Specialist at Philips HealthcareService Project ManagerNational Technical and Magnet Specialist, Remote Technical Support Engineer and Magnet Specialist at Philips Healthcare