PROFESSIONAL SUMMARY:

• 11+ years of progressive IT experience in development and design of ETL methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica PowerCenter, Confidential and Confidential Studio.
• Worked on all phases of data warehouse - ETL lifecycle, from gathering requirements to implementation, testing and support.
• As a member of Corporate Data Management Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Continually research the information technology marketplace for new and innovative technologies and application development practices. Proactively propose these new technologies as solutions to business problems.
• Extensive experience in designing and development of mappings, transformation standards and processes using Informatica Power Center and Informatica Developer.
• Extracted data from various sources like Oracle, Sybase, API’ Confidential, Flat files and XML files with knowledge of Data Warehouse concepts.
• Experience in working on Unix Shell Scripts.
• Good understanding between OLTP and OLAP systems.
• Knowledge in Oracle - SQL, PL/SQL and Sybase and with knowledge in capital markets and insurance domain.
• Documentation as per the client requirement.
• Ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Extensive experience in software development lifecycle and adept in software coding standards.
• Excellent interpersonal, analytical and communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 6.x/7.x/8.x/9.x,Informatica Data Quality ( Confidential ) Tool, Informatica Confidential Studio Tool.

Programming Languages: UNIX Scripting

RDBMS: Oracle, Sybase, MS -Access

Scheduling Tools: Crontab, Autosys

Languages: SQL, PL/SQL, XML

Tools: Toad, Rapid SQL, HP ALM Quality Central

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

• Analyzed the business requirement gathered from the client.
• Understanding the architecture of the project and the data model.
• Involved in creating the mappings for applying the business rules and loading them into the respective tables.
• Involved in creating mapplets for YoY calculations and derived calculations.
• Working on calling the web service API’ Confidential using web service transformation and HTTPS transformation and loading the data into stage tables.
• Involved in Unit Testing the Code.
• Bug Fixing of the associated mapping (if any).
• Extensively used mapping parameters, workflow parameters and parameter files.
• Working on calling the web service API’ Confidential using web service consumer, HTTPS transformation and loading the data into stage tables.
• Day to day coordinating between onsite and offshore from offshore.
• Ensure quality of deliverables by following predefined standards.

Environment: Informatica 9.6/10.1, Oracle 11, UNIX Shell Programming

Confidential

Lead Developer

Responsibilities:

• Analyzed the business requirement gathered from the client.
• Understood the requirements and designed the ETL process.
• Created mapping specifications and Designed the mappings
• Sending weekly status report and MSR.
• Discussion with client to clarify issues

Confidential

Responsibilities:

• Tested sample parsers in Windows and compare both versions output for Windows
• Tested sample parsers in Windows and compare both versions output for UNIX
• Tested by using cm console and compare both versions output in UNIX
• Used Informatica UDO transformation to test and compare both versions output in UNIX.
• Changed CRISIL application to use the new UNIX server and setup the Production Environment.
• Migrated old parsers history to the new environment.

Environment: Informatica 9.0.1/9.1.0 , UNIX, Oracle 10g, Informatica B2B Data Exchange, Informatica Data Quality ( Confidential ) Tool

Confidential

Senior Developer

Responsibilities:

• Understanding the architecture of the project and the data model.
• Involved in creating the mappings for loading the Static and performance data from the Staging tables, applying the business rules and loading them into the respective tables.
• Involved in creating the mappings for performing the validations on the data based on the severity and rising exceptions.
• Involved in creating common mapplets for loading the Static data for different source systems.
• Involved in Unit Testing the Code.
• Bug Fixing of the associated mapping (if any).
• Extensively used mapping parameters, workflow parameters and parameter files.
• Day to day coordinating between onsite and offshore from offshore.
• Ensure quality of deliverables by following predefined standards.

Environment: Informatica 9.1, Oracle 9i, UNIX Shell Programming

Confidential

Senior Developer

Responsibilities:

• Understanding the architecture of the project and the data model.
• Involved in creating the mappings for loading the translation tables (Asset Sub Asset Translation, BEGIN END PERIOD Translation etc.)
• Involved in bringing the ratings data from the Fact and the different Dimensional tables in RRDW (Ratings Reporting Data Ware House) into the Staging Table.
• Involved in creating the mappings for generating the Statistics Reports.
• Used transformations like Source Qualifier, Router, Normalizer, Connected and Unconnected lookups, Filter, Sorter and Sequence to handle situations depending upon the requirement.
• Involved in Unit Testing the Code.
• Bug Fixing of the associated mapping (if any).
• Involved in tuning the mappings and testing the same.
• Worked on creating the UNIX scripts for running the process, generating the parameter file and for different email notifications.
• Involved in creating High Level Design Document.

Environment: Informatica 9.1, Oracle 9i, Erwin, UNIX Shell Programming

Confidential

Senior Developer

Responsibilities:

• Analyzed the business requirement gathered from the client.
• Understood the requirements and designed the ETL process.
• Created mapping specifications and designed the mappings
• Creating Source Definitions, Target Definitions, Transformations and Mappings by using Informatica 8.6 Power Center Designer
• Worked on XSD, XML Target, XML Parser, XML Generator and SQL Transformations
• Generate the XML target files based on number of issuers
• Tuned mappings for better performance
• Creating the UNIX shell scripts to run the workflows
• Creating unit test cases, executing the same
• Sending weekly status report
• Held discussions with client to clarify issues

Environment: Informatica 8.6.1, Windows XP, Oracle 10g, XBRL.

Confidential

Senior Developer

Responsibilities:

• As a Senior Developer, responsible for analyzing the data and discussing with Onsite Business Analyst concerns if any.
• Day to day coordinating between onsite and offshore from offshore.
• Involved in Developing mappings and workflows for different Dimensions and Fact Table loading.
• Used transformations like Source Qualifier, Router and Connected and Unconnected lookups, Filter, Sorter & Sequence to handle situations depending upon the requirement.
• Ensure quality of deliverables by following predefined standards and templates.
• Code review of Power Centre mapping/Workflow.
• Involved in Unit Testing the Code.
• Bug Fixing of the associated mapping (if any).
• Extensively used mapping parameters, workflow parameters and parameter files.
• Worked on UNIX scripts and able to write basic scripts.

Environment: Informatica 9.1, Oracle 10g, Erwin, UNIX Shell Programming.

Confidential

Senior Developer

Responsibilities:

• Involved in implementation of the elevation logic as per the Business requirement.
• Created, updated and maintained ETL technical documentation.
• Review on-going and proposed projects to identify opportunities for reuse, process improvement.
• Involved in Open Enrollment or Annual Enrollment (It’ Confidential that phase of business where in lot of change requests and updates roll on in Insurance benefits for the Employees).
• Creating of mappings, workflows.
• Used transformations like Source Qualifier, joiner and Connected and Unconnected lookups, Filter, Sorter & Sequence to develop mappings based upon the requirement.
• Written SQL overrides in source Qualifier according to business requirements.
• Ensure quality of deliverables by following predefined standards and templates.
• Day to day coordinating between onsite and offshore from offshore.
• Code review of Power Centre mapping/Workflow.
• Bug Fixing of the associated mapping (if any).
• Extensively used mapping parameters, workflow parameters for common mapping.
• Involved in migration of the approved code to UAT and Production environments.
• Involved on preparing mainframe jobs and schedule chart.
• Scheduling the process to run weekly.
• Prepare process documents to stream line the process.

Environment: Informatica 7.1/8.1, Sybase, Mainframe, UNIX Shell Programming.