PROFILE SUMMARY:

• Over 7+years of IT industry experience, encompassing a wide range of skill set, roles and industry verticals.
• Having 7 years of experience in Data Warehousing ETL tool INFORMATICA 9.5.1/8.6 and 4 years of experience in Unit testing.
• Experience in Data Warehousing ETL using Informatica 9.5.1/8.6 PowerCenter Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center as ETL tool on Oracle, DB2,SQL and flat files.
• Designed and developed Mappings, from varied Transformations logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update strategy and more.
• Having good knowledge in BIGDATA Hadoop, HIVE, HBase, SQOOP and PIG.
• Business Knowledge in Telecom, Banking, Credit Cards, P & C insurance and Government Benefit Systems.
• Develop OLAP applications using Cognos suite of tools and extract data from the enterprise data warehouse to support the analytical and reporting for
• Hands on experience with complex SQL, Procedures, Packages
• Hands on experience on retirement policy to archive database.
• Strong understanding of data structure, analysis and design techniques.
• Ability in selecting the appropriate testing tool for projects.
• Good Project management skills in planning and monitoring small to large projects. Had been managing technical and non-technical teams through the DW & other application life-cycle phases(SDLC)
• Clear understanding of Software Development Life Cycle and Application testing Life Cycle.

TECHNICAL SKILL SET:

Operating System: UNIX, Windows 98/NT/2000/XPETL TOOL

OTHER: INFORMATICA Power Center 9.5.1/8.6 (Designer, Workflow Manager, Workflow Monitor and Repository manager) SQL, PL/SQL, Unix

DATABASE: SQLServer, DB2, Oracle

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer Lead

Responsibility:

• Gather requirements from business in the process of resolving a defect detected in production understanding the total functionality.
• Resolve defects in every monthly release.
• Requirement Gathering and Analysis of each enhancement come across for provider area.
• Worked on highly critical trade normalization project for Jefferies where all trades which were made by Jefferies needed to be consolidated.
• Followed agile methodology for development which also includes deployment, defect fixing, status matrix.
• Work closely with data analyst and data modeling team on help building new structures.
• Helped developed audit balance control mechanism for all ETL/data warehouse projects to control quality of data sent to vendors
• Enhance the codes and processes to make the code robust and time saving.
• Effectively communicate with client and business Users

Solution Environment: UNIX (IBM AIX) DB2 Tools INFORMATICA PowerCenter v8.6/9.5, WinSQL, WinSCP, Putty, Remedy

Confidential

ETL Developer /designer

Responsibility:

• Requirement Gathering and Analysis of each enhancement come across for provider area.
• Coordinate with all downstream systems/Vendors for testing to make sure no breach in app due to new data.
• Get offshore resource adequate knowledge to get them on speed to meet project deadline.
• Helped analyzing the data synchronization
• Extensive co-ordination with multiple Maintain the defect life cycle, traceability matrix.
• Prepare Project Status, Metrics report and manage onshore/offshore quarterly effort estimation.
• Manage Customer Relationship.
• Support the long running as well as newly developed applications by understanding the total functionality.
• Enhance the codes and processes to make the code robust and time saving.
• Effectively communicate with client and business Users
• Resolve and close incidents within SLA.

Solution Environment: UNIX (IBM AIX) Oracle 10g/11g Tools INFORMATICA PowerCenter v8.6/9.5, SQL Developer, WinSCP, Putty, Remedy

Confidential

ETL Developer /designer

Responsibility:

• Understand the business requirement and prepare the POC and provide the ETL solution.
• ETL Coding using Informatica Mappings.
• Requirement Gathering and Analysis of each individual application with application AD team on masking in/out of scope fields
• Discuss with application team and finalize sensitive data.
• Creating retirement strategy policy for apps to archive data.
• Coordinate with all downstream apps for testing to make sure no breach in app due to masking of upstream application
• Verify data with Informatica Data Validation Object(DVO) that data is correctly masked or not.
• Run Informatica IDQ to profile database tables and cleansing data based on requirement.
• Maintain the defect life cycle, traceability matrix.
• Participate in Reviews and Audits.
• Prepare Project Status, Test Status and Metrics report.
• Manage Customer Relationship.
• Developing unix shell scripts.
• Performance Tuning
• Unit and System Testing of Informatica mappings.
• UAT support and Defect Fixing.
• Environment preparation for SIT/UAT
• Client communication
• SIT/UAT/Pre-Prod/Prod Support of the developed code.

Solution Environment: UNIX (IBM AIX) Oracle 10g/11g Tools INFORMATICA PowerCenter v8.6/9.5, PL/SQL Developer

Confidential

ETL Developer / Production support

Responsibility:

• Understanding of the requirement.
• Proper analysis of the requirement.
• Designing according to the requirement. (High level to Low Level)
• Implementation of mapping.
• Implementation and Integration.
• Unit test Plan preparation.
• Code review and Unit Testing.
• Integration Testing.
• Environment set up.
• Execution plan preparation for ETL part.

Solution Environment: UNIX (IBM AIX) SQL Server 2000 Tools Pentaho 4.3

Confidential

ETL Developer /Production support

Responsibility:

• Understand the business requirement and prepare the POC and provide the ETL solution.
• ETL Coding using Informatica Mappings.
• Unit and System Testing of Informatica mappings.
• UAT support and Defect Fixing.
• Environment preparation for SIT/UAT
• Client communication

Solution Environment: UNIX (IBM AIX) Oracle 10g Tools INFORMATICA PowerCenter v8.6, PL/SQL Developer

Confidential

ETL Developer /Production support

Responsibility:

• Responsible for the planning and management of all technical and operational activities.
• Understand the business requirement and prepare the POC and provide the ETL solution.
• Created mock up data and inserted them into CMR and verified that to detect Duplicate Address issue.
• ETL Coding using Informatica Mappings.
• Unit and System Testing of Informatica mappings.
• UAT support and Defect Fixing.
• Environment preparation for SIT/UAT
• Helped analyzing the data synchronization
• Extensive co-ordination with multiple Teams.
• Created technical documents to understand team how data extracting happens from various sources involving flat files in future.
• Verification of all ETL mapping for error strategy, reconciliation, error processing.
• Verified mappings which extracts data from various sources involving flat files with mock up data
• Frequent communication with the business on technical and functional queries.
• Building Generic SQL for quick verifications.

Solution Environment: UNIX (IBM AIX) Oracle 10g Tools INFORMATICA PowerCenter v8.6, PL/SQL Developer