SUMMARY:

• Established track record with in - depth understanding of Business Requirements Analysis, Development, Testing, Implementation and Maintenance.
• Overall 9.7 years of IT experience in the ETL tool Informatica Power center.
• Worked in various roles including Module Lead, Designer, Analyst, and Developer.
• Expertise in project span across Insurance Industry.
• Data Warehousing ETL experience as a designer, analyst and developer in the ETL process using, Informatica and BO Report Testing
• Excellent Client Relations building potential and strong Interpersonal skill to drive the positive energy across the team under Onsite/Offshore & Global Development Model.
• Analytical and problem solving ability to find the root cause of the problem and accomplish the goals in competent fashion.
• Experience in implementing Ralph Kimball and Bill Inmon methodologies of Data Warehouse design.
• Sound knowledge in Data warehousing and ETL process for extracting data from legacy systems to stage and then to Cleanse, Process and Loading into Data Warehouse and Data marts using Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Experience in performance tuning of sources, mappings, targets and sessions. Debug the sessions by utilizing the logs of the sessions.
• Experienced in BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Experienced in integration of various data sources like Oracle, DB2, SQL server, Teradata and Netezza into staging area.
• Experience with various Online Analytical Processing tools (OLAP) like designing Data Marts and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems, fact and dimension tables modeling of data at all the three levels: view, logical and physical.
• Experience in Production support activities. Proven ability to resolve issues & provide the solution in quick time.
• Experience in writing Test plans, Test cases, Unit Testing, System Testing, Integration testing and Functional testing.

TECHNICAL SKILLS:

• ETL Solution Architecture for Enterprise Level Data Warehouse/ Data Marts.
• Informatica 10.1 Power Center, SSIS.
• Business Objects.
• Oracle 11g/10g/9i/8i, DB2, SQL Server 2010/2005, Teradata, Oracle SQL*Plus, SQL Query, PL/SQL.
• UNIX Shell Scripting.
• Control M and Autosys

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica Developer

Responsibilities:

• Understand functional requirements and develop technical requirements and solution blueprint.
• Develop effective Analysis Documents, and Implementation Plans and Review the same
• Develop technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.
• Work on Query Optimization and report testing techniques.
• Responsible for UAT, Regression testing and Performance tuning of ETL routines to make sure that they work as specified on heavy loads in different environments.
• Worked on AutoSys scheduler to schedule jobs.
• Implement DBMOD for data correction using PL/SQL.

Environment: Informatica 10.1, Oracle 9i, Netezza, AutoSys, UNIX, Jira, GIT, PL/SQL.

Confidential

ETL Informatica Developer

Responsibilities:

• Understand functional requirements and develop technical requirements and solution blueprint.
• Develop effective Analysis Documents, and Implementation Plans and Review the same
• Develop technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.
• Work on Query Optimization and report testing techniques.
• Responsible for UAT, Regression testing and Performance Tuning of ETL routines to make sure that they work as specified on heavy loads in different environments.
• Worked on Remedy tool to create Service Requests, Incidents for the changes in Database, INFA and Control-M Work scheduler.

Environment: Informatica 9.1, Oracle 9i, Control-M, Windows 2007, UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

• Understand functional requirements and develop technical requirements and solution blueprint for this Module
• Conduct data profiling and analyze results (e.g. analyze data quality, identify data gaps) for the source data.
• Develop technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.
• Created transformations and used Expression, lookup, extensively. Developed complex validation codes to validate the source data.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (facts/summary) data identified by dimensions using Informatica ETL tool.
• Following all the compliances of UBS to have the data and the project details secured.
• Write Unit Test Plan, Module Test Scripts, Module Test Plan, Failure Modes & Effective Analysis Documents, and Implementation Plans and Review the same.
• Discussing with the Client and identify new Tasks/Change Requests/Test Requests
• Coordinate the Onsite and Offshore Teams for maximum productivity by resolving the issues
• Responsible for UAT, Regression testing of ETL routines to make sure that they work as specified on heavy loads in different environments.
• Implemented Performance Tuning Techniques
• Develop ETL deployment plan and ETL operations manual to coordinate and drive ETL activities in Test and Production environment.
• Extracted data from various sources like DB2, Flat file, SQL Server, XML files and loaded into Oracle database.
• Involved in Internal KT’s and Production support transitioning.

Environment: Informatica 9.1, Oracle 9i, DB2, Windows 2007, UNIX,PL/SQL.

Confidential

ETL Informatica Developer

Responsibilities:

• Working as an ETL Developer for creating mappings, Mapplets, sessions and workflows for the proposed ETL solution in Informatica.
• Understand functional requirements and develop technical requirements and solution blueprint for this Module
• Conduct data profiling and analyze results (e.g. analyze data quality, identify data gaps) for the source data.
• Develop technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.
• Create and execute Assembly test Plan, Product test for ETL and coordinate with BA teams for the defect root cause identification and proposal of fixes for the same.
• Develop ETL deployment plan and ETL operations manual to coordinate and drive ETL activities in Test and Production environment.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Discussing with the Client and identify new Tasks/Change Requests/Test Requests
• Write Unit Test Plan, Module Test Scripts, Module Test Plan, Failure Modes & Effective Analysis.
• Involved in Internal KT’s and Production support transitioning.

Environment: Informatica 9.1, Oracle 9i, DB2, Windows 2007, UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

• Working as an ETL Developer for creating mappings, Mapplets, sessions and workflows for the proposed ETL solution in Informatica.
• Understand functional requirements and develop technical requirements and solution blueprint for this Module
• Conduct data profiling and analyze results (e.g. analyze data quality, identify data gaps) for the source data.
• Develop technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.
• Create and execute Assembly test Plan, Product test for ETL and coordinate with BA teams for the defect root cause identification and proposal of fixes for the same.
• Develop ETL deployment plan and ETL operations manual to coordinate and drive ETL activities in Test and Production environment.
• Discussing with the Client and identify new Tasks/Change Requests/Test Requests
• Write Unit Test Plan, Module Test Scripts, Module Test Plan, Failure Modes & Effective Analysis.

Environment: Informatica 9.1, Oracle 9i, DB2, Windows 2007, UNIX.

Confidential

ETL Tester

Responsibilities:

• Profile the Source data and prepare data for each source file.
• Analyze the compatibility of the current code and find the impacts of new heart system over the existing system.
• Perform data sanity checks and compare the data between Staging and Target to ensure the data is loaded correctly using the Test cases they developed.
• Develop and automate test cases and query templates before the file layouts testing starts and execute test cases quickly.
• Monitor dynamic inserts to tables. Take the new codes that are inserted dynamically and compare with Production data.

Environment: Informatica 9.1, Oracle 9i, DB2, Siebel, Windows 2007, UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in requirements gathering, project estimation and build phase.
• Handling a team of around 5 people.
• Design ETL Technical specification documents to load the data in target using various transformations as per the business requirements
• Develop complex mapping using Informatica Power Centre for loading the data by using Type-2 mechanism.
• Performed performance tuning in the existing process by modifying the mapping using the method of reducing the cache size, partitioning and using push down optimization.

Environment: Informatica 9.1, Oracle 9i, Teradata, Windows 2007, UNIX.

Confidential

ETL Informatica Developer

Responsibilities:

• Conduct data profiling and analyze results (e.g. analyze data quality, identify data gaps) for the source data.
• Working as an ETL Developer for creating mappings, Mapplets, sessions and workflows for the proposed ETL solution in Informatica.
• Understand functional requirements and develop technical requirements and solution blueprint for this Module.
• Develop technical design documents (both low level and high level), mapping specifications (source to target mapping docs) and unit testing documents.
• Create and execute Assembly test Plan, Product test for ETL and coordinate with BA teams for the defect root cause identification and proposal of fixes for the same.
• Develop ETL deployment plan and ETL operations manual to coordinate and drive ETL activities in Test and Production environment.
• Discussing with the Client and identify new Tasks/Change Requests/Test Requests
• Write Unit Test Plan, Module Test Scripts, Module Test Plan, Failure Modes & Effective Analysis.

Environment: Informatica 9.1, Oracle 9i, DB2, Windows 2007, UNIX.

Confidential

ETL Developer

Responsibilities:

• Working as an ETL Developer for creating mappings, Mapplets, sessions and workflows for the proposed ETL solution in Informatica.
• Create and execute Assembly test Plan for ETL Logic.
• Write Unit Test Plan, Module Test Scripts, Module Test Plan.

Environment: Informatica 9.1, Oracle 9i, SQL server, Windows 2007, UNIX.