Vidyavathi B M

Energetic, composed, and motivated ETL Developer driven by a passion for innovation, learning, and technology. Possessing 5.8 years of strong experience in ETL methodology, with a focus on data transformation using Informatica PowerCenter and IICS. Skilled in the data warehouse and system development life cycle, enabling effective contributions to project success.

• Developed ETL mappings, transformations using Informatica Power Center.
• Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, Joiner, Filter, Sorter, Union and Router etc. to load the data into staging tables and then to Dimension tables.
• Prepared deployment document and assisted to deployment team while migration.
• Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
• Tested the Informatica mappings with manual testing and assisted QA team.
• Experience in analyzing data from various source systems and based on business requirements build the transformation rules to extract, transform and load the data in the target system.
• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Implemented SCD Type-1 and SCD type-2 Mapping Logic to load to the dimension tables.
• Testing of the existing Informatica workflows/mappings, Fix the bugs.

• Databricks Certified Data Engineer Associate
• SQL SkillForge Program
• Certified Teradata Vantage 2.4