Devyani Chavan

<p>Analyzed existing ETL data warehouse process and created design specification based on new target cloud Snowflake database and Azure Data Lake Store.<br>
Created ETL and Datawarehouse standard documents – Naming standards, ETL methodologies and strategies, standard input file formats, data cleansing and preprocessing strategies.<br>
Created mapping documents with detailed sources to target transformation logic, source data column information and target data column information.<br>
Designed, developed, and implemented ETL processes using IICS data integration.<br>
Developed cloud integration parameterized mapping templates SCD Type1 and SCD Type2 for Stage, Dimension and fact load processes.<br>
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.<br>
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.<br>
Integrated various data sources like Oracle, SQL Server, Snowflake, and Flat Files in various formats like fixed width, Csv and Excel.<br>
Involved in Development, Unit Testing, SIT and UAT phases of project.<br>
Worked in Sprint methodology.</p>

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.

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

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

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