ETL Developer with over 3+ years of IT experience in analysis, design, development, and implementation of software applications in data warehousing using various Relational Databases like Oracle, SQL Server. Proficient in developing and designing ETL methodology for supporting data transformations using Informatica Power Center for conversion/data integration modules to support large-scale system migrations and implementations.
Extensively worked on understanding the business requirements, data modeling, and ETL structure.
Developing ETL scripts to extract and cleansing data from SQL databases.
Generating the required metadata at the source side, in the Informatica mappings.
Involving in performance tuning by collecting statistics and observing explain plan.
Carrying out performance tuning both on Informatica side and database side.
Analyzed the business requirements and designed ETL solution and developed the code using Informatica power center.