PROFESSIONAL SUMMARY:

• 7+ years of experience on Informatica Power center in all phases of Design, Development, Implementation and support of Data warehousing applications using Informatica power center 10.x,9.x, SQL, PL/SQL, Oracle and Unix.
• Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica.
• Extensively worked on Power Center Mapping Designer, Mapplet Designer, Transformation developer Warehouse Designer, Workflow Manager, Repository Manager and Workflow Monitor
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
• Sound Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema)
• Strong analytical and conceptual skills in database design and implementation of RDBMS concepts.
• Full life - cycle project delivery experience from product definition to implementation including: requirements and specification writing, design documentation, unit and system testing, optimization and performance analysis, quality assurance, and release into a production environment.
• Extensively used Informatica version tasks like Decision, Command, Event Wait, Event Raise, and Email.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Worked with various transformations like Normalizer, expression, rank, filter, group, aggregator, lookup, joiner, sequence generator, sorter, SQL, Update strategy, Source Qualifier.
• Designing and developing Informatica mappings including Type-I, Type- II, Type-III slowly changing dimensions (SCD).
• Very strong knowledge in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling, Data Warehouse, Data marts using Star Schema for faster and effective Querying for the Metadata Management solutions.
• Created Functional, Technical Design and Data mapping documents by Interacting with Customers subject matter expert (SME). In Addition, participating in requirement gathering, Analyzed the requirements.
• Data Processing experience in designing and implementing Data Mart applications, transformation processes using ETL tools Informatica Power Center.
• Coordinating with Business Users, BI teams, functional Design team and testing team during the different phases of project development and resolving the issues.
• Ability to interface and communicate effectively with team members and provide the guidance in the development activity

SKILL:

Strong analytic, problem solving and decision: making skills.

Good team player with both oral and written communication skills.

Ability to identify and appropriately escalate issues/risks to management.

Quickly adapting to the new environment and ability to learn new technologies

Strong time management and task prioritization.

Selfmotivated, with ability to multi: task and work well under pressure

Team player, with experience working in a global team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.2.0/9.6/8.6

Operating Environment: Unix 9.0,Linux, AIX 5.2, MS Windows 95/98/NT/2000/XP

Databases: Oracle 10g/9i/8i, DB2, SQL server 2014,Hive,Nateeza

Languages: SQL, PL/SQL

Scripting: Unix shell scripting

Microsoft Offices: MS Excel, Access, Word, Power Point

MS: Visio 2007.

PROFESSIONAL EXPERIENCE:

Confidential, NC

ETL Informatica Developer Lead

Responsibilities:

• Involved in building the ETL architecture and design for the ETL.
• Very good knowledge in Analyzing the Logical and Physical data model.
• Extensively working with BSA’s and source system teams to understand the new structure and creating the mapping document by transforming the data into the existing system.
• Converted the Object and class model source data in to the Fact and dimension model data by applying many joins conditions.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Actively coordinating with testing team in the testing phase and helped the team to understand the dependency of the whole project.
• Analyzing, designing, developing, implementing moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Responsible for creating complete test cases, test plans, test Data, and reporting status ensuring accurate coverage of requirements and business process.
• Created Audit and Error tables for capturing the errors from key columns and load it into a Error table.
• Scheduled batch and session with in informatica using Scheduler
• Created FSD & TSD for ETL process for the project.
• Prepared Data flow diagrams to assist in problem analysis and submit recommendation for solution.
• Migrated the code from Dev to SIT.
• Working with 5 of the offshore resources for this project and reviewing the code that is being developed by offshore.
• Closely worked with Informatica admin team to create a complete set up fof creating a folder, Source and target connections for this new project

Confidential, NC

ETL / Informatica Power Center Developer

Responsibilities:

• Developed Technology Documentation to support deployments and maintenance of reporting and data management.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Used Informatica designer for designing mappings and mapplets to extract data from various sources like Oracle and flat files.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project. Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Extracted the data from RDBMS Oracle11g/10g, XML, Flat files load the data in to Oracle data warehouse
• Developed database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Created reports using RDBMS Oracle PL/SQL and word on DDL’s and DML’s.
• Created unix shell scripts to automate the business processes and scheduled them using Autosys.
• Responsible for creating complete test cases, test plans, test Data, and reporting status ensuring accurate coverage of requirements and business process.
• Extensively used ETL to load data from wide range of sources and Targets
• Developed, documented and executed test plans.
• Performed pipeline partitioning to speed up mapping execution time.
• Scheduled batch and session with in informatica using Scheduler also scrips for job scheduling.
• Implement the SCD type1 &2 & 3 to keep track of historical data in dimensions.
• Created FSD & TSD for ETL process for the project.
• Prepared Data flow diagrams to assist in problem analysis and submit recommendation for solution.
• Used Informatica designer for designing mappings and mapplets to extract data from RDBMS Oracle sources.
• Good working experience in RDBMS PL/SQL,Oracle Databases and RDBMS Concept.
• Migrated the code from Dev to SIT and Production.
• Worked closely with On-shore and Off-shore application leads.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.

Confidential

ETL \ Informatica Developer Lead

Responsibilities:

• Extensively developed various Mappings, which perform Extraction, Transformation and Loading of Source data into the Target DataBase and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, and Joiner etc.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Developed an interface to transmit data on a daily basis from the mainstream application to downstream applications.
• Involved in Unit Testing and Integration Testing of the application. Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others.
• Gathered business requirements and created mapping documents based on the data and source system analysis and involved in initial design meetings.
• Integrated data from heterogeneous source systems extract and transform data with business rules and built re-usable Mapplets using Informatica Designer.
• Created complex mappings and transformations using expressions, aggregators, filters, and sorter, and sequence generator, lookups. Fine-tuned transformations and mappings for better performance.
• Used Informatica Power Center workflow manager to create sessions, workflow to run with the logic embedded in the mappings.
• Efficient documentation was done for all phases like analysis, design, development, testing and maintenance.
• Implement the SCD type1 &2 & 3 to keep track of historical data in dimensions.
• Involved in Unit testing of each mapping developed along with preparing test cases with expected and actual data examples.
• Creation of Sessions and Workflows to schedule these mappings. Developed reusable Mapplets / Transformations embedding business logic.
• Increased the performance of the mappings and workflows and performed performance test.
• Build reports according to user requirements
• Participated in weekly status meetings, conducting internal and external reviews as well as formal walkthrough among various teams and documenting the proceedings.
• Creating Functional Specification & technical specification documents for the projects.
• Developed database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Worked with source system owners to identify data source based on business requirements. Responsible for designing and developing mapping and ETL logic to integrate data into the data warehouse.
• Extracted the data from RDBMS Oracle11g/10g, XML, Flat files load the data in to Oracle data warehouse