With over 3 years of ETL development experience within a Data Warehouse and a strong background in Informatica and SQL, I am eager to contribute to development projects that enable data to serve as a strategic asset. I have played a key role in large-scale data migration and have led efforts to optimize data handling, ultimately achieving significant improvements in data processing efficiency.
Informatica PowerCenter
● Analyzed the source system and involved in designing the ETL data load.
● Developed/designed Informatica mappings by translating the business requirements.
● Responsible for building Mappings, Workflows & Sessions using Informatica Power Center and IICS.
● Experience in Tools like Informatica, TOAD
● Responsible for Client communication and regular updates to clients
● Worked on large projects using Agile methodologies.
● Understanding of Business and IT processes with excellent communication skills.
● Good understanding of MYSQL, Database Integration and Database Management.
● Good knowledge on SQL Queries.
● Having strong hands on experience in extraction of the data from various source systems ranging from Mainframes like DB2, Flat Files, VSAM files, etc. to RDBMS like Oracle, SQL Server, Teradata etc.
● Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
● Performed data cleaning and transformation during ETL processes to ensure data accuracy and integrity.
● Resourceful, goal oriented, possess strong Business Intelligence skills with the ability to work under pressure and multitask in a fast-paced environment.
● Possess strong Analytical Skills.
● Good knowledge of Unix.
● Led a team of 4 members and trained 3 team members in Informatica.