Rahul Dalvi

Rahul Dalvi

Business Intelligence and ETL Developer
India
Marathi, Hindi, English

About Me

•Results-oriented professional with 5 years of hands-on experience specializing in the implementation of Data Warehousing applications utilizing ETL tools. •Proficient in executing ETL operations leveraging Informatica P…

Experience

ETL Informatica Developer

VIAVI Solutions · Pune, India
Mar 2022 - Present · 4 years 4 months

Results-oriented professional with 4 years of hands-on experience specializing in the implementation of Data Warehousing applications utilizing ETL tools., Proficient in executing ETL operations leveraging Informatica PowerCenter 9.5.1/10.5.1 and adept at utilizing Informatica client tools., Extensively skilled in Informatica Designer Components and developing Informatica Mappings for data extraction., Proven track record in crafting mappings incorporating various transformations using Informatica PowerCenter Designer., Experienced in creating session, scheduling and configuring workflow using Informatica Workflow Manager., Skilled in creating parameter files for source connections, target connections, filenames, session log names, mapping parameters, and variables., Demonstrated proficiency in repository object migration and ensuring smooth transitions from development to other environments., Monitored and resolved any failures in daily running production jobs by analyzing session logs., Developed various mappings encompassing all Sources, Targets, and Transformations using Informatica Designer., Responsible for designing and customizing existing workflows and mapping logics., Developed ETL solutions for reporting purposes and provided ongoing support and maintenance for ETL jobs.

ETL Informatica Developer

VIAVI Solutions
Mar 2022 - Present · 4 years 4 months

Results-oriented professional with 4 years of hands-on experience specializing in the implementation of Data Warehousing applications utilizing ETL tools.
Proficient in executing ETL operations leveraging Informatica PowerCenter 9.5.1/10.5.1 and adept at utilizing Informatica client tools including Repository Manager, Designer, Workflow Manager and Workflow Monitor.
Extensively skilled in Informatica Designer Components such as Source Analyzer, Target Designer, Transformation Developer, and Mapping Designer.
Demonstrated expertise in developing Informatica Mappings for data extraction from diverse sources, transformation, and loading into Operational Data Store (staging area) and Data Warehouse.
Proven track record in crafting mappings incorporating various transformations including Aggregator, Expression, Joiner, Filter, Sequence Generator, Connected & Unconnected Lookup, Router, Union, and Update Strategy transformations using Informatica PowerCenter Designer.
Proficient in creating reusable transformations embedded with business logic.
Experienced in creating session, scheduling and configuring workflow using Informatica Workflow Manager.
Skilled in creating parameter files for source connections, target connections, filenames, session log names, mapping parameters and variables.
Familiar with Versioning Concepts in Informatica PowerCenter.
Successfully extracted data from diverse database sources including Oracle, SQL Server, and Flat files.
Demonstrated proficiency in repository object migration, ensuring smooth transitions from development to QA and production environments.
Monitored and resolved any failures in daily running production jobs by analysing session logs.
Developed various mappings encompassing all Sources, Targets, and Transformations using Informatica Designer.
Responsible for designing and customizing existing workflows and mapping logics to enhance performance and reduce complexity.
Developed ETL solutions for reporting purposes to effectively meet business outcome requirements.
Provided ongoing support and maintenance for ETL jobs, including addressing production issues, troubleshooting failures, and implementing enhancements or bug fixes as necessary.

PROJECTS

Inhouse Project Enhancement

viavi
Duration : 06-Mar-2022 - 31-Dec-2025

The project aims to enhance existing projects in accordance with business requirements. This involves modifying and designing mappings using Informatica PowerCenter and implementing database changes using Oracle SQL Developer.Roles and responsibilities:•Designed, developed, tested, and implemented ETL (Extract, Transform, Load) processes using Informatica PowerCenter to migrate data from various source systems to target databases/data warehouses.•Monitored and resolved any failures in daily running production jobs by analysing session logs.•Developed various mappings encompassing all Sources, Targets, and Transformations using Informatica Designer.•Responsible for designing and customizing existing workflows and mapping logics to enhance performance and reduce complexity.•Developed ETL solutions for reporting purposes to effectively meet business outcome requirements.•Delivered timely, validated, and well-tested work products.

Skills

OBIEE Structured Query Language (SQL) PL/SQL Power BI Oracle 19c MS SQL Server SQL Developer SSMS Informatica PowerCenter 9.5.1/10.5.2 Informatica Intelligent Cloud Services (IICS) Oracle Analytics Server (OAS) Informatica PowerCenter 9.5.1 Informatica PowerCenter 10.5.2 Dimensional Modeling Star Schema Snowflake Schema Data Warehousing Distributed Database Concepts Windows Linux Data Transformation Data Cleaning Performance Tuning Production Support ETL Job Scheduling Repository Manager Designer Workflow Manager Workflow Monitor Source Analyzer Target Designer Transformation Developer Mapping Designer Aggregator Expression Joiner Filter Sequence Generator Lookup Router Union Update Strategy Versioning Parameter Files Workflow Scheduling Repository Object Migration Troubleshooting
Report this Profile?