Informatica developer with Teradata Bengaluru, Karnataka, India
Over 3+ years of industry experience in IT with a strong background in Database development and Data Warehousing and ETL process using Informatica Power Center 9.6.1. Proficient in understanding Business processes requirements and translating them into technical requirements. Experience in database design, entity-relationship modeling, and dimensional modeling . Expert in designing various mappings for extracting data from various sources and loading into targets. Having experience in Informatica PowerCenter Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, Star Schema, OLTP, OLAP, Data Reports. Extensive Knowledge on Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases like Oracle, SQL Server, Teradata, and Worked on integrating data from flat files, CSV files into a common reporting and analytical Data Model using Informatica. Extensively worked on database Triggers, Stored Procedure, Functions and Packages. Extensively worked in the performance tuning of the programs, ETL Procedures and processes Expertise in Toad (Tool for Oracle Application Developers). Strong experience with UNIX Shell Scripting . Excellent understanding of Client/Server architecture makes a valuable asset to any project, with Excellent Logical , Analytical , Communication and Organizational Skills. Excellent team player and can work on both development and maintenance phases of the project. Highly skilled in providing instantaneous and workable solutions to business problems . Efficient team player with excellent communication skills and good interaction with users.