Devyani Chavan

Analyzed existing ETL data warehouse process and created design specification based on new target cloud Snowflake database and Azure Data Lake Store.
Created ETL and Datawarehouse standard documents – Naming standards, ETL methodologies and strategies, standard input file formats, data cleansing and preprocessing strategies.
Created mapping documents with detailed sources to target transformation logic, source data column information and target data column information.
Designed, developed, and implemented ETL processes using IICS data integration.
Developed cloud integration parameterized mapping templates SCD Type1 and SCD Type2 for Stage, Dimension and fact load processes.
Developed Informatica cloud task flow with multiple mapping tasks and extracted data from Snowflake to push the data into Azure Datawarehouse instance to support reporting requirement.
Designed data integration audit framework in Snowflake to track the data load and extensively used pushdown optimization option to optimize processing and used limitless power of Snowflake database.
Integrated various data sources like Oracle, SQL Server, Snowflake, and Flat Files in various formats like fixed width, Csv and Excel.
Involved in Development, Unit Testing, SIT and UAT phases of project.
Worked in Sprint methodology.

Good understanding of dimensional modelling like Star Schema,
Snowflake Schemas.
➢ Experience integrating data to/from on-premises database and cloudbased database solution using Informatica Intelligent Cloud Services.
➢ Experience in developing technical design documents and mapping
specifications to build Informatica mappings.
➢ Experience in building and unit testing of deliverables with quality and
without any scheduled variation.
➢ An energetic, self-motivated with hands on experience in programming
skills, client-server infrastructure & requirements gathering.
➢ Experience in creating SCD Type 1 and SCD Type 2 methodologies to
keep historical data in data warehouse.
➢ Worked with various transformations including Router transformation,
Update Strategy, Expression transformation, lookup transformation,
Sequence Generator, Aggregator transformation, Sorter transformation
and others.
➢ Performance tuning is performed at the Mapping level as well as the
Database level to increase the data throughput.
➢ Created shell scripts for the File Validations, Job Dependencies and File
List to automate the process.
➢ Experience working in Agile/Scrum development team. Experience in
CI-CD pipeline.

Analyzed existing ETL data warehouse developed and implemented ETL process using IICS data integration.
Developed SQL queries for data analysis purposes, enhancing reporting capabilities for stakeholders.
Implemented comprehensive unit test plans and supported regression testing, achieving a defect reduction rate of 25%.
Demonstrated excellent communication, presentation, teamwork, and ability to work independently and as part of a team.

Developed ETL programs using Informatica to implement business requirements.
Communicated with business customers to discuss the issue and requirements.
Created shell scripts to fine tune the ETL flow of the Informatica workflows.
Used Informatica file watch events to pole the FTP sites for the external mainframe files.
Provided production support to resolve ongoing issues and troubleshoot the problems.
Performed performance tuning at functional level and map level and used relational SQL wherever possible to minimize the data transfer over the network.
Used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
Worked on enhancement and maintenance activities of the data warehouse including tuning and modifying stored procedures for code enhancements.
Worked in an Informatica version-based environment and used deployment groups to migrate objects.
Used debugger in identifying the bugs in existing mappings by analyzing data flow and evaluating transformations.
Used pre and post session assignment variables to pass the variable values from one session to another.
Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks and used Informatica scheduler to schedule jobs.
Performed unit testing at various levels of ETL and actively involved in team code review.

Testing of flat files load to load data in fact tables.
Created vendor wise data extract queries and data extract files.
Tested and added new vendor and new channels and activities.
Tested and added new product in MDH system.
Used connected and unconnected lookups, Router, Sequence Generator, Stored Procedure and Update Strategy transformations.
Implemented SCD Type 1 and SCD Type 2 methodologies to keep historical data in data warehouse.
Followed up with issue tickets.
Prepared test plans and performed unit testing.
Prepared documentation on requirement.