PROFESSIONAL SUMMARY:

• Over 7 years of experience in Data warehousing & Business intelligence Domain .
• Highly Proficient in Design, Development, Implementation, Administration and Support of ETL processes for Data Marts and large - scale Data Warehouses using Informatica Power Center 10.1/9.6/9.1/ 8.6 Client tools - Mapping Designer, Repository Manager and Workflow Manager/Monitor.
• 5+ Years’ of experience in data profiling concepts and tools like Informatica Data Analyst and Confidential developer tool.
• Worked on Archival life cycle management tools like ILM - Informatica life cycle management.
• Worked on Informatica product like TDM - Test data management tool. & IMM - Informatica Metadata manager tool.
• Worked on Informatica Cloud tool - Data integration hub 10.1.1
• Expertise in database like oracle 10G & 11G, SQL server 2005 & 2008 R2 and Teradata.
• Experience in programming languages like C/C++, SQL & PL/SQL .
• Expert on scripting language like Unix Shell Scripting.
• Experience in scheduling tool like Autosys .
• Adept in end-end development of ETL jobs from requirement analysis to system study, designing, coding, testing, de-bugging, performance tuning, documentation, implementation and post production support.
• Knowledge in Agile Methodology.
• Knowledge of Sales force Application, Sales force Data Base, SQL and Informatica Integration with Sales force application.
• Good experience with development, testing, debugging, implementation, documentation and Production Support.
• Experience in working with oracle using SQL, PL/SQL , TOAD and also Expertise in using Stored Procedures, Functions, Triggers, Views, Materialized views and Synonyms in Different databases.
• Excellent communication and interpersonal skills with abilities in resolving complex software issues.
• Knowledge in OLAP, OLTP processes, UNIX Shell scripting integrate and synchronize third party data with corporate IT environment.
• Thorough knowledge of Database Modeling, Management concepts like conceptual, logical and physical data modeling in Data Warehousing applications.
• Experienced in analyzing large data and get the business requirement/process, converting the business specification to technical document, developing and integrating solutions to meet the requirement as per Industry standards.
• Domain knowledge in Life Science (Pharmaceutical) and Healthcare (Claims, provider and members area).
• Trained on BI tools Cognos, MSTR and programming languages like SAS.

TECHNICAL SKILLS:

Domain Knowledge: Data Warehousing and BI Practices.

RDBMS: Oracle 9i,10g & 11g, Oracle Exadata, SQL Server 2005 & 2008R2, Teradata, Netezza 4.6.5.

ETL Tools: Informatica 8.6, Powercenter 9.1, 9.6 & 10.1, DIH, ILM,IMM &TDM

Data Quality Tools: Informatica Developer ( Confidential ), Informatica Analyst.

Scripting Languages: Unix Shell Scripting, PL/SQL

Scheduling Tools: Autosys, Tidal and Tivoli scheduling

Programming: PL/SQL, C/C++ & HTML

Methodologies: Agile and SDLC

DB models: Star schema and snowflake schema

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Environment: Informatica 9.1 & 10.1, Informatica Analyst and Confidential Developer, DIH, ILM, IMM, TDM, Oracle 11g, SQL Server 2008 R2, Teradata, IBM DB2 and UNIX.

System Analyst / ETL Developer

Responsibilities:

• Prepared Technical/Design Specification documents on client request for Enhancement.
• Impact analysis document will be prepared first to assess the changes and its impacts in existing code.
• After the client review and approval code will be developed.
• Will prepare test scripts and test load data in Development for client review.
• Unit Test cases and Scripts documents will be prepared.
• Code migration Documents from DEV->TEST->PROD will be prepared.
• End to End support will be given until code moved into Production.
• Worked on SCD type 1 and 2 mappings.
• Worked in UPSERT type of mappings.
• Worked on Unix Shell scripting.
• Worked on automation of entire load from file to stage DB then to Detailed DB.
• Worked on PL/SQL procedures and functions to be used to call the Informatica SP transformation.
• Worked on Parallelism & Partitioning in Informatica on processing large data.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Implemented the data quality rules on data as re-usable mapplets in Informatica Developer ( Confidential ) which can be used in any mappings.
• Worked in Teradata TPT utility in Informatica.
• Analyzed and created FACT tables and Dimension table for storing the historical data.
• Worked on performance tuning of long running sessions.
• Worked on Transaction control to dynamically create multiples files during run time.
• Worked on Teradata bugs were still no solution found from Teradata vendor team.
• Worked with Informatica Data Quality ( Confidential ) Analyst tool for Analysis and Confidential developer tool for data cleansing, data matching, data conversion, exception handling and monitoring capabilities.
• Extensively worked on Informatica Confidential .
• Involved in data profiling using Confidential (Analyst Tool) prior to data staging.
• Used Confidential ’s standardized plans for addresses and names clean ups.
• Used Confidential to complete initial data profiling and removing duplicate data.
• Created references tables, applications and workflows and deployed that to Data integration service for further execution of workflow.
• Worked on Unix Shell Scripting to schedule Confidential jobs.
• Played a very important role in team in development of mappings, workflows and troubleshooting the issues.
• Very familiar about Sorter, Filter, Expression, Labeler, Standardizer, Consolidation, Match, Case Converter, Classifier and Address validator transformations.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Design reference data and data quality rules using Confidential and involved in cleaning the data using Confidential in Informatica Data Quality 9.1/9.6/10.1 environment
• Used Confidential to profile the project source data, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Used Address doctor transformation to correct the invalid address.
• Analyzing the source data coming from different sources and working with business users and developers to design the Data Model.
• Worked on integrating two different data models in oracle 11g.
• Translated requirements into business rules & made recommendations for innovative IT solution.
• We use Tivoli and DAC scheduling tool for each subject area wise which is will be easy to run more than 300 workflows in execution order.

Confidential

Environment: Informatica 8.6&9.1, Oracle 10g, Oracle 11g, Oracle Exadata, Netezza4.6.5

Systems Analyst / ETL Developer

Responsibilities:

• Interacted with Business to understand the business requirements.
• Prepared Design specification, ETL mapping and Unit test plan documents.
• Played a role of team member in Development.
• In Development Roles played by me
• Source files validation to meet business requirements.
• Development of mappings.
• Creation of batch scripts for archival and purging of files.
• Coordinated with multiple teams including the business team for End to End ST to understand and resolve the issues.
• Performance tuning of jobs to improve the quality of data time load.
• Post production/ Warranty support.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Worked with big volume data (TBs/Billions) using Netezza features - Distribution, Organize, nz migrate, Groom and Statistics.
• Migrate Informatica objects, Database objects to Integration Environment.