Professional Summary:

• 8 years of Overall work experience on Data Warehousing ETL and Database Programming.
• Over 4 years of work experience and expert level knowledge in designing/supporting databases in Netezza Environment
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.6/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/ 5.1 Power Center/ Power Mart Designer, Workflow Manager, Workflow Monitor and Server Manager Teradata and Business Objects.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005,SAS, Netezza Mako, Twin-fin Servers.
• Strong experience in Extraction, Transformation and Loading ETL data from various sources into Data Warehouses and Data Marts using Informatica Power Center Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger , Power Exchange, Power Connect as ETL tool on Oracle, Netezza, SAS and SQL Server Databases.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, Netezza, SAS and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Dollar Universe and Control-M.
• Worked extensively with slowly changing dimensions.
• Expert level knowledge in designing/supporting databases in Netezza Environment
• Extensive use of creating SQL queries, Indexes and Tables.
• Scheduling and setting up jobs using Dollar Universe job for Netezza.
• Scheduling and setting up jobs using Dollar Universe job for Informatica.
• Experience in coordinating to offshore team
• Hands-on experience across all stages of Software Development Life Cycle SDLC including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Worked extensively in agile methodology and Waterfall models.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines
• Offers proven abilities, as team player possesses strong communication, verbal and written skills and possess a track record of success in meeting the project deadlines.
• Self-motivated with exemplary analytical and problem solving skills developed through variety of projects

Technical Skills:

• Informatica Power Center 9.6/9.1/8.6/8.5/8.1/7.1 Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server
• Netezza Mako, Twin fin Servers and Oracle 11g/10g/9i/8i
• Unix Shell Scripting
• Control-M, Dollar Universe
• Rational Software Architect, Subversion

Work Experience:

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in functional and technical design document sessions with Technical team and business users team.
• Team Lead and interacting with Business Analyst to understand the business requirements Involved in analyzing requirements to refine transformations.
• Understanding existing business model and customer requirements.
• Analysis of the specifications provided by the clients.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Analysis of Data model to check table constraints and columns in Data mart
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders.
• Effectively communicate project expectations to team members and stakeholders in a timely and clear fashion.
• Conduct project post mortems and create a recommendations report in order to identify successful and unsuccessful project elements.
• Worked with various Active Passive transformations and created Reusable Transformations and Mappings using Designer Tool set of Informatica.
• Developed mappings for initial load and daily updates.
• Extensively used Mapping variables, Mapping Parameters and parameter files.
• Created Reusable transformations and Mapplets to use in multiple mappings.
• Created sessions to update the target data using Workflow Manager of Informatica.
• Involved in Unit Test case preparation and did the unit testing. Conduct project post mortems and create a recommendations report in order to identify successful and unsuccessful project elements.
• Creating Netezza DB Objects using Best practices of Netezza in order to avoid data skews on the Netezza Objects.
• Designed and Developed the Netezza SQL Scripts as per the Customer requirements.
• Performance tuning of Netezza SQL scripts.
• Provided technical guidance for re-engineering functions of Oracle warehouse operations into Netezza
• Created NZLoad Scripts to load the Flat Files into Netezza Staging tables.
• Created Scheduler jobs for Netezza SQL scripts using Dollar Universe Scheduling tool.
• Coordination of system/Integration/UAT testing with other teams involved in project and review of test strategy
• Coordinating with business and development teams for closure of UAT defects and creating adhoc reports for end users.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.
• Develop best practices and tools for project execution and management.
• Estimate the resources and participants needed to achieve project goals.

Environment: Informatica Power Center 9.6.1/9.1.1 Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Transformations , Oracle 10g, PL/SQL Procedures, functions, packages , Netezza, Unix Scripts, Dollar Universe

Confidential

Informatica/ Netezza Lead

Responsibilities:

• Involved in functional and technical design document sessions with Technical team and business users team.
• Team Lead and interacting with Business Analyst to understand the business requirements Involved in analyzing requirements to refine transformations.
• Understanding existing business model and customer requirements.
• Analysis of the specifications provided by the clients.
• Preparation of HLD, project plan based on the business functional spec.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Analysis of Data model to check table constraints and columns in Data mart
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders.
• Effectively communicate project expectations to team members and stakeholders in a timely and clear fashion.
• Set and continually manage project expectations with team members and other stakeholders.
• Worked with various Active Passive transformations and created Reusable Transformations and Mappings using Designer Tool set of Informatica.
• Developed mappings for initial load and daily updates.
• Extensively used Mapping variables, Mapping Parameters and parameter files.
• Created Reusable transformations and Mapplets to use in multiple mappings.
• Created sessions to update the target data using Workflow Manager of Informatica.
• Involved in Unit Test case preparation and did the unit testing. Conduct project post mortems and create a recommendations report in order to identify successful and unsuccessful project elements.
• Creating Netezza DB Objects using Best practices of Netezza in order to avoid data skews on the Netezza Objects.
• Designed and Developed the Netezza SQL Scripts as per the Customer requirements.
• Performance tuning of Netezza SQL scripts.
• Provided technical guidance for re-engineering functions of Oracle warehouse operations into Netezza
• Created NZLoad Scripts to load the Flat Files into Netezza Staging tables.
• Created Scheduler jobs for Netezza SQL scripts using Dollar Universe Scheduling tool.
• Coordination of system/Integration/UAT testing with other teams involved in project and review of test strategy
• Coordinating with business and development teams for closure of UAT defects and creating adhoc reports for end users.
• Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.
• Develop best practices and tools for project execution and management.
• Estimate the resources and participants needed to achieve project goals.
• Develop full-scale project plans and associated communications documents.
• Delegate tasks and responsibilities to appropriate personnel.
• Develop and deliver progress reports, proposals, requirements documentation, and presentations.
• Pro-actively manage changes in project scope, identify potential crisis, and devise contingency plans.
• Coach, mentor, motivate and manage project team members and contractors

Environment: Informatica Power Center 9.1.1 Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Transformations , Oracle 10g, PL/SQL Procedures, functions, packages , Netezza, Unix Scripts, Dollar Universe

Confidential

Sr. Informatica Developer

Responsibilities:

• Actively participated in the design phase for data conversion architecture.
• Create mapping for all the fields to be migrated from one system to another with business rule of transformation mentioned with the same.
• Involved in the preparation of High level Design HLD and Low Level Design LLD specifications.
• Involved in designing and developing the Informatica mappings and workflows for Data Conversion mechanism.
• Used various transformations like unconnected look-up, connected look-up, aggregator, joiner, sorter, Ranker, SQL Transformation, update strategy etc.
• Used Pre and Post Session Commands for renaming the file names, changing the Permissions, Removing the files etc.
• Developing Mappings and tuned them for better Performance
• Code Migration
• Customer Data Analysis.
• Running the workflows through UNIX.
• Conceptual knowledge in UNIX Scripts
• Review the mappings for code issues/functional correctness
• Review migrated data functionally for critical areas like Third Party Claims, Patient Information, Pricing data and Drug data
• Migrated Mappings, Sessions, and Workflows from Development to Test
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.

Environment: Informatica Power Center 8.6.1 Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Transformations , Oracle 10g, PL/SQL Procedures, functions, packages , Unix Scripts

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in functional and technical design document sessions with Technical team and business users team.
• Understanding existing business model and customer requirements.
• Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.
• Analysis of Data model to check table constraints and columns in Data mart
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders.
• Actively participated in the design phase for data conversion architecture.
• Effectively communicate project expectations to team members and stakeholders in a timely and clear fashion.
• Involved in the preparation of High level Design HLD and Low Level Design LLD specifications.
• Involved in designing and developing the Informatica mappings and workflows for Data Conversion mechanism.
• Worked with various Active Passive transformations and created Reusable Transformations and Mappings using Designer Tool set of Informatica.
• Developed mappings for initial load and daily updates.
• Created sessions to update the target data using Workflow Manager of Informatica.
• Involved in Unit Test case preparation and did the unit testing. Conduct project post mortems and create a recommendations report in order to identify successful and unsuccessful project elements.
• Create mapping for all the fields to be migrated from one system to another with business rule of transformation mentioned with the same.
• Used various transformations like unconnected look-up, connected look-up, aggregator, joiner, sorter, Ranker, SQL Transformation, update strategy etc.
• Used Pre and Post Session Commands for renaming the file names, changing the Permissions, Removing the files etc.
• Developing Mappings and tuned them for better Performance
• Code Migration
• Running the workflows through UNIX.
• Conceptual knowledge in UNIX Scripts
• Review the mappings for code issues/functional correctness
• Review migrated data functionally for critical areas like Third Party Claims, Patient Information, Pricing data and Drug data
• Migrated Mappings, Sessions, and Workflows from Development to Test
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Created and monitored sessions and batches to run the mappings.
• Verified the application behavior and reports on converted data and identified and resolved data issues or informed the Business if any other major issues found with the application and reports.

Environment: Informatica Power center 8.6.1 Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Transformations , Informatica Data Quality 8.6,Oracle 10g, PL/SQL Procedures, functions, packages , Unix Scripts, Control-M