SUMMARY

• Over 5 years of experience as an ETL Informatica Consultant with analysis, design, development, implementation and troubleshooting of Data Mart / Data Warehouse applications using Informatica Power Center 10.x/9.x
• Complete knowledge of Data Warehouse methodologies Star and Snowflake Schemas of (Ralph Kimball, Bill Inmon), Dimensional Modeling and Slowly Changing Dimensions (SCD’s).
• Extensively worked on Informatica client tools Admin Console, Repository manager, Designer, Workflow manager, Workflow monitor.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Normalizer, Stored Procedures, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Worked on parameter files and variables to allow for reusability of the mappings.
• Created, launched & scheduled Workflows/sessions.
• Involved in the Performance tuning of mappings and sessions.
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions and Triggers and involved in Query Optimization.
• Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
• Solid experience in analyzing and fixing Production issues in the current Informatica Applications.
• Quick learner and a versatile team player with excellent analytical, programming, written and interpersonal skills with an aptitude to learn new technologies.

TECHNICAL SKILLS

Programming Languages: C, C++, Java, SQL, PL/SQL, Shell Scripting, Big Data

ETL Tools: Informatica Power Center 10.x/9.x, SAS, Hive, Tableau

Reporting Tools: Cognos, Business Objects, Microstrategy

RDBMS: Oracle 10g/9i (SQL, PL/SQL, Stored Procedures,Functions), MS - Access

Database Tools: Toad 9.1, SQL Plus

Operating Systems: Windows 2000/NT/XP, Windows Vista, Linux

Scripting: Unix Shell Scripting

Other Utilities: HTML, XML, Visio, MS-Office, AWS, MoveIt

PROFESSIONAL EXPERIENCE

Confidential

ETL Informatica Consultant

Responsibilities:

• Actively involved in Requirement Gathering from the business.
• Developed number of Complex ETL Mappings, Mapplets and Reusable Transformations in Staging, Warehouse and up to Mart layer.
• Prepared estimation, Unit test plan and Defect report documents and delivered the change requests on time.
• Involved in Peer review (Mappings/Mapplets/Workflows), Defect tracking and control.

Environment: Informatica Power Center 10.2, Oracle 11i, Shell Scripting, SQL Developer, PL/SQL, Windows, Linux.

Confidential

ETL Informatica Consultant

Responsibilities:

• Actively involved in Requirement Gathering from the business.
• Analyzed number of Complex ETL Mappings, Mapplets and Reusable Transformations in Staging, Warehouse and up to Mart layer.
• Prepared precise Estimation, Workbook and Bug Fix Documentation for the entire change request.
• Prepared Unit test plan and Defect report documents and delivered the change requests on time.
• Creating Adhoc reports to users in Tableau by connecting various data sources
• Involved in Peer review (Mappings/Mapplets/Workflows), Defect tracking and control.

Environment: Informatica Power Center 10.1, Oracle 9i, Shell Scripting, Tableau, SQL, PL/SQL, Netezza, Windows, Linux.

Confidential, Atlanta, GA

ETL Informatica Consultant

Responsibilities:

• Actively involved in Requirement Gathering from the business.
• Developed number of Complex ETL Mappings, Mapplets and Reusable Transformations in Staging, Warehouse and up to Mart layer.
• Prepared precise Estimation, Workbook and Bug Fix Documentation for the entire change request.
• Prepared Unit test plan and Defect report documents and delivered the change requests on time.
• Involved in Peer review (Mappings/Mapplets/Workflows), Defect tracking and control.

Environment: Informatica Power Center 9.6, SAS, Oracle 9i, Shell Scripting, SQL, PL/SQL, Toad, Windows, Linux.

Confidential

ETL Informatica Developer

Responsibilities:

• Actively involved in Requirement Gathering from the business.
• Analyzed the existing system and understand the logic to implement the change requests as provided by the clients.
• Prepared Precise Estimation, Workbook and Bug Fix Documentation for the entire change request.
• Developed number of Complex ETL Mappings, Mapplets and Reusable Transformations in Staging, Warehouse and up to Mart layer.
• Prepared Unit test case documents and delivered the change requests on time.
• Rectified the existing defects raised for the system by modifying/ developing the new mapping.

Environment: Informatica Power Center 8.x/ Power Exchange, Oracle 9i, Shell Scripting, SQL, PL/SQL, Toad, Windows, Linux.

Confidential

ETL Informatica Developer

Responsibilities:

• To verify all the workflows were scheduled as per the scheduler.
• Monitored the daily scheduled jobs.
• Analyzed and recovered the production failure within the SLA time limit.
• Analyzed and resolved the data quality issues reported by the business users.
• Carried out on-demand activities like loading the files as per the business requirements.
• Carried out the recovery process after the server came back online from hiccup.

Environment: Informatica Power Center 8.1.1, Oracle 9i, PL/SQL, Toad, Windows, Linux.

Confidential

Programmer Analyst

Responsibilities:

• Developed Informatica objects - Mappings, sessions, workflows based on the prepared low level design documents.
• Involved in creation of sessions, worklets and workflows and scheduled in Workflow manager.
• Involved in developing the SQLs, which are used to apply all business rules on the data before load into the target tables.
• Verified all the workflows were scheduled as per the scheduler.
• Provided detailed analysis of data issue, mapping data from source to target, design and data cleansing on Data Warehouse.
• Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.

Environment: Informatica Power center 7.1, Oracle 9i, TOAD, Windows, Linux and PL/SQL.