Srini M.

• Having 10 years of IT experience and 7 years relevant of experience in Data warehousing and ETL such as Extraction, Cleaning, Transformation and Loading using Informatica power center and Informatica cloud data integration in Finance, Retail & Healthcare Domain.
• Had experience in data modeling using Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
• Basic knowledge on High Level Design and Data Modelling concepts.
• Good experience on Implementation and supporting the enhanced Business Information Involved in building a small Independent DataMart and developed Logical and Physical Data Model. Worked with different data sources, non-relational Databases such as Flat files, and other relational sources such as Oracle, Hive, Redshift. Hands-on experience in Oracle 11g and Informatica.
• Hands-on experience in writing and executing SQL queries. Exposure in Data Warehouse concepts like star schema, Snow-flake schema Exposure in ETL process and Data warehouse lifecycle Experience in Performance Tuning and Debugging of mappings and sessions.
• Involved in designed the mapping with multiple files loading using file repository. Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources.
• Designed various Mappings for extracting data from various sources involving relational tables and flat files.
• Ability to work as a part of a team or individually & ability to pick up new skills quickly.
• Extensively worked with Informatica cloud (IICS) and Informatica Power Center Worked on Data synchronization task, Data Replication, mapping, Mapping configuration tasks in data integration.
• Experience in full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, and maintenance.
• Good Understanding of Dimensional Modelling, Star and Snowflake Schemas.
• Created Informatica mappings to load data using transformations like source qualifier, sorter, aggregator, expression, joiner, connected and unconnected lookup, filters, sequence generator, router and Update strategy.
• Experienced in doing the process of extraction, transformation and loading data from multiple sources like flat files and OLTP systems into data marts using Informatica Power Centre.
• Hands-on Experience in Informatica BDM & Hadoop.
• Good knowledge of Redshift and Hive.

Accenture solutions pvt ltd. 

Client – Best Buy

Duration: 03/2022 - present: 

• Involved in the High-Level Design phase and able to relate a Data Model and the relationship between the entities.
• Designed the whole project and the processing logic which ensures the present ability of the data. ETL developing Creating the mappings and transformations using Informatica the data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy, and more direct interaction with the client Managers/Business users for understanding of requirements.
• Leading the development work with the team involved. Carried out Root cause analysis for any issue in order to understand the Business requirement.
• Supported code/design analysis, strategy development and project planning. Responsible for the development of Meta data transformations and establishing load schedule.
• Optimizing/Tuning mappings for better performance and efficiency. Creating validation and loading the rejected records into the relevant tables and send to the users for re-submitting.
• Creating slowly changing dimension tables and fact tables. Used the mapping parameter to make the mapping more flexible. Involved in Unit testing.

Environment: Informatica Power Center V10.5, IICS, Oracle 11g, Unix (Shell Script), Maestro scheduler, MS Office, and Delimited Flat files. 

IBM India Pvt Ltd. 

Client: Caterpillar Inc.

Duration: 09/2020 - 03/2022

• Involved in the High-Level Design phase and able to relate a Data Model and the relationship between the entities.
• Designed the whole project and the processing logic which ensures the present ability of the data.
• ETL developing Creating the mappings and transformations using Informatica the data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy, and more direct interaction with the client Managers/Business users for understanding of requirements.
• Leading the development work with the team involved. Carried out Root cause analysis for any issue in order to understand the Business requirement.
• Supported code/design analysis, strategy development and project planning. Responsible for the development of Meta data transformations and establishing load schedule. Optimizing/Tuning mappings for better performance and efficiency.
• Creating validation and loading the rejected records into the relevant tables and send to the users for re-submitting.
• Creating slowly changing dimension tables and fact tables. Used the mapping parameter to make the mapping more flexible.
• Involved in Unit testing.

Environment: Informatica Power Center V10.4, IICS, Oracle 11g, Unix (Shell Script), Control M (Scheduler), JCL, PL/SQL Developer, MS Office, and Delimited Flat files. 

Cognizant Solutions

Client: Pacific life Inc.

Duration: 07/2019 - 09/2020 

• Involved in the High-Level Design phase and able to relate a Data Model and the relationship between the entities.
• Designed the whole project and the processing logic which ensures the present ability of the data. Designed various Mappings for extracting data from various sources involving relational tables and flat files.
• Played a designer role in DDS project and able to detail the project ready for development.
• Involved in Query tuning as the project involved huge amount of data and complex logic to be incorporated. Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Development of ETL using Informatica PowerCenter. Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables. Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping. Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait. Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows. Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows. Prepared SQL Queries to validate the data in both source and target databases.
• Worked on Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process. Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports. Interaction with the offshore team daily on the development activities.

Environment: Informatica Power Center v9.6, Oracle 11g, Unix (Shell Script), CA7 (Scheduler), JCL, PL/SQL Developer, MS Office, and Delimited Flat files.

IBM India Pvt Ltd

Client: Anthem Inc.

Duration: 12/2017 - 04/2019

• ETL developing Creating the mappings and transformations using Informatica the data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy, and more direct interaction with the client Managers/Business users for understanding of requirements.
• Leading the development work with the team involved.
• Carried out Root cause analysis for any issue to understand the Business requirement.
• Developing Unix scripts and Informatica mappings.
• Supported code/design analysis, strategy development and project planning.
• Responsible for the development of Meta data transformations and establishing load schedule.
• Optimizing/Tuning mappings for better performance and efficiency.
• Creating validation and loading the rejected records into the relevant tables and send to the users for re-submitting. Creating slowly changing dimension tables and fact tables.
• Used the mapping parameter to make the mapping more flexible. Involved in Unit testing.

Environment: Oracle 11g, Informatica Power Center v9.6, Unix (Shell Script), MS Office Suite.

• SQL SKILLFORGE program