Hemalatha N

• 2+ years of experience in ETL, Data warehousing, IICS projects.
• Experience integrating data to/from On - premise database and cloud-based database solutions using Informatica intelligent cloud services.
• Hands-on experience with cloud-based database solutions such as AWS DMS, AWS Redshift, GCP, and Snowflake.
• Worked extensively with Data migration, Data Cleansing, Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Skilled in developing SQL queries for diverse relational databases including Oracle, DB2, and SQL Server.
• Tuning of SQL Queries/Processes SCD 1, 2, 3 and Change Data Capture (CDC).

PROJECT EXPERIENCE:

ETL Developer

Project : PPM CCO Modernization
Client : Liberty Mutual Insurance (April 2024 to Till date ).

The project defines the goal of migration of on premise Data Warehouse to Cloud based Data Warehouse solution.

Key Responsibilities:

• Designed, Developed and Implemented DMS tasks using AWS.
• Managed end-to-end data migration from DB2 to Postgres, encompassing development, testing, and monitoring.
• Conducted thorough analysis of current DB-Naming Standards, file formats, and schema conversion. Developed comprehensive design specification for new target Cloud DB.
• Achieved significant reduction in load time from 11 hours to less than 1.5 hours by successfully implementing Parallel-Load in DMS in Production .
• Implemented Liquibase setup for seamless deployment of database changes from development to production.
• Created PYTHON scripts which will used to start and stop cloud Tasks.
• Performed validation of migrated data in target system.

ETL Developer

Project : Snowflake to IDMC Migration.

Client : Liberty Mutual Insurance(January 2024 - March 2024)

• Responsible for designing and developing of ETL pipeline from Snowflake to IICS.
• Created and implemented Mappings using diverse Transformations such as lookup, Update Strategy, Aggregator, Router, Sequence generator, and Expression.
• Designed, developed, and unit tested ETL process for loading STAGE, LOAD, and ACCESS schemas.
• Worked on defect management and collaborated with the Testing team to resolve issues, while also creating comprehensive mapping documents.
• Enhanced debugging efficiency by utilizing session logs, workflow logs, and debugger to identify and troubleshoot issues in mappings and generic scripts.
• Implemented enhancements and change requests.

ETL Developer

Project :WEM Data Portfolio

Client : Liberty Mutual Insurance(june 2023 - Jan 2024)

• Gained hands-on experience in requirement gathering, data analysis, and project coordination while working closely with the IT architect and program managers.
• Created mapping documents with detailed source to target transformation logic, Source data column information and target data column information.
• Designed, Developed and Implemented ETL processes using IICS Data integration.
• Designed, Developed and unit tested the ETL process for loading the records across STAGE, ODS and wem schemas.
• Extracted data from legacy systems to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
• Involved in ETL process from development to testing and production environments.
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using IICS.
• Creating effective Test data and development thorough unit test cases to ensure successful execution of the data.
• Experience of handling Slowly Changing Dimensions to maintain the complete History.
• Tuned mappings and SQL queries for better performance and efficiency.
• Created new mappings and updating old mappings according to changes in Business Logic