RAHEEM SHAIK Email: firstname.lastname@example.org
ETL Developer Phn.No: +91-701*******
Informatica Developer with 2.2 years of experience in ETL, Expericence in development/maintenance of software Applications using Informatica 9.5 & 10.1.
Having good knowledge of ETL process using Informatica tool.
Hands on experience on ETL tool Informatica 9.1, 9.5, 10.1.
Good command on Power Center Designer, Workflow Manager and Workflow Monitor.
Extensively worked on Informatica Power Center Designer which also include:-Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
Experience in tuning of Source system / Target system, Mapping & Session.
Good knowledge in UNIX Environment.
Created mappings using Joiner, Sorter, Union, Filter, Router, Aggregator and Lookup.
Implemented Performance Tuning techniques on Mappings.
Implemented and Tested Slowly Changing Dimensions SCD Type1 & SCD Type2.
To be Constant pursuit of Excellence and to work with new and challenging technologies.
Team player with good communication and problem solving skills. PROFESSIONAL EXPERICENCE:
Working in “THE INNOVATIVE MINDS” as a Software Engineer, Bangalore. EDUCATION:
B.Tech(ECE) ; 2013 - 2017 ; Acharya Nagarjuna University ; CIET College ; 88% Intermediate from AP Board, 2011 to 2013 with 85%
SSC from AP Board, 2010 to 2011 with 84%
ETL Tool: Informatica Power center
OS : Windows, UNIX.
Databases: Oracle 11g, MS SQL Server.
Project Title : Pharma
Client Name : GSK
Environment : Informatica 10.1, Oracle 11g, Flat Files, UNIX, Windows XP. Role : Informatica Developer
Roles & Responsibilities:
Extracting, Transforming and Loading the data from source to Staging and Staging to Target according to the Business requirements.
Developed different mappings by using different Transformations like Aggregator, Lookup, Expression, Update Strategy, Joiner, Router etc to load the data into staging tables and then to target.
Scheduling, Monitoring and Debugging of Informatica Sessions and Workflows.
Involved the Performance Tuning by optimizing the sources, targets, mappings.
Preparation of Low Level Design for the mappings created.
Prepared Unit test cases.
Worked with multiple sources such as Relational Databases, Flat Files for Extraction using Source Qualifier and Joiner.
Creating Informatica mappings, sessions and workflows using different transformation to implement in business logic.
Exponentially worked with SCD Type2 with effective date approach to update dimensional tables.
Designing, Scheduling & Monitoring of Workflows.
Creating Sessions and Workflows using Workflow Manager.
Performed various Performance Tuning techniques to improve the mapping performance. Assignment #2
Project Title : Logistics
Client Name : Braid Logistics
Environment : Informatica 9.6.1, Oracle 10g, Flat Files, UNIX, Windows 7. Role : Informatica Developer
Roles & Responsibilities:
Involved in Technologies spec walk through calls, study and understanding the functionalities.
Used heterogeneous data sources like flat files and Oracle.
Created Mappings using the transformations such as the Source Qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
Created and Monitored the Informatica Sessions.
Checked and tuned the Performance of Informatica Mappings.
Identified and created different source definations to Extract data from input sources and load into relational tables using Informatica Power Center.
Analyzed Mappings and Sessions for better Performance.