EXPERIENCE SUMMARY:

• Over 10 + years of professional IT experience in Development, Confidential, Enhancement, Testing and Production Support Projects of Data warehousing projects.
• Experience in Banking, Manufacturing and Pharmaceutical industry business processes.
• Experience in creating complex mappings, sessions, workflows, reusable components in Designer, Workflow Manager using various transformations.
• 6+ years of experience in Informatica Power Center (9.x) in creating complex mappings, sessions, workflows, reusable components in Designer, Workflow Manager using various transformations like Source Qualifier, Unconnected and Connected Lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.,
• 3+ years of experience in Informatica Data Quality 9.6/9.1 Data Profiling standards and best practices on Process Sequence, Data Quality Lifecycles, Naming Convention and Version Control.
• Designed and developed Physical Data Objects , Mappings , Mapplets , C omplex quality rules, Profiles and Scorecards using Informatica Developer and Informatica Analyst with cleanse, parse, match, standardization validation etc.
• Worked on Web Services, SAP Data Services, XML and SOAP UI.
• Involved in the full development lifecycle from requirements gathering, low level design, requirements analysis, coding and/or testing through development and support using Informatica Power Center, Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Fixing Informatica code to resolve Business critical errors and deploying the code in production
• Worked on the source systems like Oracle, SQL Server, Flat Files, XML and COBOL files.
• Managing project deliverables in line with the project plan and recording and managing project issues and escalating where necessary.
• Resolving cross - functional issues at project level and managing project scope and change control and escalating issues wherever necessary.
• Monitoring project progress and performance
• Experienced in coding SQL Queries
• Experienced in working Scrum methodology.
• Extensive experience in Production support which does not limit not only to monitoring the Batch jobs, tracking and resolving the incidents and provided solutions on time to the application users but also quick turnaround fixes
• Experienced in finding the root cause for Batch Job failures, reviewing Logs, Health Checks by coordinating with the respective teams.
• Experience in scheduling the batch jobs using Workflow Monitor, Appwrox & other third party tools.
• Monitoring the performance of production data loads and initiating action plans to tune the long running data loads.

TECHNICAL SKILL SUMMARY:

ETL Tools: Informatica Power center 9.x/8.x

Databases: Oracle 9i/10g/11g, Microsoft SQL Server 2012 Management Studio

Operating System: Windows NT/2003/XP/7, UNIX/LINUX

Languages: HTML, XML

Products/Tools: TOAD, Appworx Batch Remediation, SQL Server, Serena Change Manager (PVCS), SQL Developer, Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Environment: Informatica Power Center, MS SQL Server, Power Shell, UNIX, Service NOW

Responsibilities:

• Responsible for leading day to day ETL discussions.
• Lead all design decisions on technical implementation and concepts (i.e. templates, standards, KPI).
• Decide on ETL implementation issues.
• Maintain ETL coding standards document and has the responsibility to keep ETL team members informed.
• Review ongoing development/technical documentation and maintain an inventory of improvements.
• Ensure customer satisfaction
• Ensure implementation and maintenance of quality systems within the group.
• Train and retain members of the technology group as a part of knowledge management activity.
• Estimation
• Ensure peer reviews of software work products
• Understanding the Requirements from customer(Business user)
• Translating the Requirements into Design.
• Prepared technical design documents.
• Created source to target mapping sheet as part a design
• Prepared the db script (DDL) for creating the tables in warehouse staging database.
• Created a mappings, sessions, workflows as per the requirements.
• Unit Testing of all the ETL components, submitting the results.
• Prepared the Confidential template
• Coordinated with the testing team for fixing the defects.
• Perform the sanity check after the QA Confidential .

Confidential

Informatica Data Quality Lead

Environment: Informatica Data Quality, Oracle, UNIX, Service NOW

Responsibilities:

• Requirements Analysis, Design, Development and Testing.
• Participating in the project report meetings and provide Functional and Technical support.
• Prepare high and low level design documents before starting the development phase.
• Designing, developing and unit testing.
• Presenting profiling/audit results in summary or in detail, to the business analyst, the project manager, the data steward or business management to define or modify the project plan based on the results of a data quality assessment.
• Involved in Data analysis, data cleansing using various transformations like Standardizer, Labeller, Keygen, Parser transformations etc.,, data matching, data conversion, address standardization using Address Doctor Transformation, exception handling, reporting and monitoring capabilities of IDQ.
• Worked on Web Services, SAP Data Services, XML, SOAP UI.
• Designing, developing and unit testing of Power Centre Workflows, Sessions, Mappings, IDQ mappings and running the Sessions to achieve the Data Integration for near Real Time.
• Participating in the Release management, deployment checklist review and Defect management of each release.
• Worked on Release management, deployment checklist review and Defect management of each release.
• Ensuring that all deliverables will be done with high quality on time by following all the processes/standards set by the customer and providing weekly status to the customer.
• Manage day to day operational calls and client issues.
• Performance tuning for long running queries.
• Confidential of code to various environments

Confidential

Informatica Developer

Environment: Informatica Power Center, MS SQL Server, Oracle, UNIX, Service NOW

Responsibilities:

• Responsible for leading day to day ETL discussions.
• Lead all design decisions on technical implementation and concepts (i.e. templates, standards, KPI).
• Decide on ETL implementation issues.
• Maintain ETL coding standards document and has the responsibility to keep ETL team members informed.
• Review ongoing development/technical documentation and maintain an inventory of improvements.
• Ensure customer satisfaction
• Ensure implementation and maintenance of quality systems within the group.
• Train and retain members of the technology group as a part of knowledge management activity.
• Estimation
• Ensure peer reviews of software work products
• Understanding the Requirements from customer(Business user)
• Translating the Requirements into Design.
• Prepared technical design documents.
• Created source to target mapping sheet as part a design
• Prepared the db script (DDL) for creating the tables in warehouse staging database.
• Created a mappings, sessions, workflows as per the requirements.
• Unit Testing of all the ETL components, submitting the results.
• Prepared the Confidential template
• Coordinated with the testing team for fixing the defects.
• Perform the sanity check after the QA Confidential .

Confidential

 Informatica Developer

Environment: Informatica Power Center, MS SQL Server, Oracle, UNIX, Service NOW

Responsibilities:

• Requirements Analysis, Design, Development and Testing.
• Participating in the project report meetings and provide feedback to the Technical coordinator for further decisions.
• Functional and Technical support.
• Prepare high and low level design documents before starting the development phase.
• Designing, developing and unit testing
• Participating in the Peer review related to Design, Code and Unit test cases and monitoring the performance.
• Experience in the Release management, deployment checklist review and Defect management of each release.
• Facilitating weekly and monthly status review meeting with the client.
• Manage day to day operational calls and client issues.
• Performance tuning for long running queries.

Confidential

Sr. Informatica ETL

Environment: Informatica Power Center (9.5/9.6.1), Oracle SQL Developer, UNIX Shell Scripts, Scheduling Tool - Appworx, Ticketing Tool -- Remedy

Responsibilities:

• Doing Impact Analysis and preparing High Level and Low Level design documents based on the Business Requirement documents and providing proper estimates for the whole life cycle of the Data Warehousing project.
• Presenting profiling/audit results in summary or in detail, to the business analyst, the project manager, the data steward or business management to define or modify the project plan based on the results of a data quality assessment.
• Designing, developing and unit
• Preparing Test cases and test data for Unit testing.
• Reviewing the Code and resolving any technical issues of project.
• Ensuring all the Performance Optimization techniques were incorporated while developing the Mappings.
• Expertise in performing optimization analysis. Improved the performance of long running jobs by tuning the SQL queries and creating necessary indexes.
• Ensuring that all deliverables will be done with high quality on time by following all the processes/standards set by the customer and providing weekly status to the customer.
• Participating in the Release management, deployment checklist review and Defect management of each release.
• Confidential of code to various environments
• Mentored/Trained team members in creating different Design documents and other required documentation.