PROFESSIONAL SUMMARY:

• Having 10 years of IT experience in Analysis, Design, Development, Testing, Implementation, Migration and Support of Data Warehousing and Data Integration & Data Migration Solutions using Informatica Power Center, Informatica data quality and relational data bases Oracle, Db2, Netezza, Postgres, Redshift and SQL Server.
• Extensive experience in ETL (Extraction, Transformation and Loading) of data using Informatica Power Center from heterogeneous sources like Flat files (Fixed, delimited), XML files, Relational databases, SAP Sources, Sequelink.
• Develop project solution strategy by understanding key client objectives, diagnosing and mapping client requirements, articulating solution risks and barriers, recommending project approaches, preparing time and cost estimate & planning full project life cycle.
• Facilitate information gathering sessions to validate business cases, gather and document business and functional objectives.
• Extensive experience in Informatica Administration and good knowledge on Informatica data Quality.
• Extensive experience in Migration projects like Informatica 8.6 to 9.6.1 & 10.2 and Database migration from DB2 to Netezza and Oracle to Redshift.
• Extensive experience with Banking and Finance, Insurance and Retail & Finance Domains.
• Extensive knowledge in SDLC (Software Development Life Cycle) and executed projects in Waterfall and Agile methodologies.
• Experience in coordinating and leading onsite - offshore development model.
• Co-ordinated and lead the interactions across Portfolio Architects, EDMS, DBA and Business teams in finalizing Business requirements, ETL architecture and data modeling.
• Extensive knowledge in RDBMS concepts and Relational and Dimensional Data modeling.
• Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance.
• Expertise in analyzing the source data systems for better understanding the business requirements, designing optimal data model and ETL design.
• Developed technical specifications of the ETL process flow, High level and Low Level Design and Source to Target mapping documents.
• Designed and Developed Audit, Control and Load Balancing process.
• Strong experience in handling slowly Changing Dimensions.
• Extensively involved in creating reusable objects to standardize Informatica code and to bring down the development and testing efforts drastically.
• Expertise in developing the flexible ETL code for maintenance and future enhancement by adopting mapping parameters, Variables, Session, Workflow level parameters.
• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks at Source, Transformations, Target layers.
• Extensively involved right from Project engagement to till Production Warranty support of the project, Prepared Project support handover document and transitioned to Support team to ensure smooth execution of the project in Production.
• Extensively involved in generating automated alerts to Business users via IMR and Email notifications as per Business requirement.
• Extensively involved in migrating Informatica objects to Test and Production environments by creating RFCs, Deployment groups.
• Extensively involved in writing Unix Shell Scripting programs like Source file validations, Files upload/Download to/from remote server, Source/Target Files Archival/purge requirements and to run ETL batch jobs from Unix using PMCMD command.
• Experience in scheduling of ETL jobs using Control-M.
• Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules, possess and good communication skills.

TECHNICAL SKILLS:

ETL: Informatica PowerCenter 10.2,9.x/8.x, Informatica data Quality, Source Analyzer, Transformation developer, Mapping Designer, Mapplet designer, Workflow Monitor, Workflow Manager.

Data modeling tools: Erwin 7.x, Microsoft Visio

Operating Systems: Windows 2008/2003/2000/ XP, Linux, UNIX (AIX)

Database: Oracle, IBM DB2, Netezza, Sql Server, Postgres, Redshift.

Languages: SQL, PL/SQL, C, C++.

Tools: TOAD, SQL developer, Aginity workbench, Rally, HPQC, ServiceNow

PROFESSIONAL EXPERIENCE:

Confidential, Reston, Virginia

Sr ETL Informatica Developer

Responsibilities:

• Develop project solution strategy by understanding key client objectives, diagnosing and mapping client requirements, articulating solution risks and barriers, recommending project approaches, preparing time and cost estimate & planning full project life cycle.
• Facilitate information gathering sessions to validate business cases, gather and document business and functional objectives.
• Research, analyze & define custom solution(s) for inter departmental operations using Informatica, Oracle and MicroStrategy.
• Contribute to the overall team accomplishments and competence by planning delivery of solutions, answer technical and procedural questions for team members and customers.
• Involved in the requirements mapping from source to target, design and ETL process flow diagrams.
• Prepared test Scenarios and Test cases and involved in unit testing of mappings, system testing and user acceptance testing.
• Performed various data validations and cleansing activities before loading data into STAGE layer and standardizations and integration with confirmed dimensions at Data ware house and transformed data as per reporting requirement before loading to DATA MART layer.
• Created mappings using Source qualifier, Expression, Lookup, Router, joiner, Aggregator, Union, Update strategy transformations.
• Involved in the Historical, Daily, catch up loads once the project launched in Live environment.
• Write Batch script to transfer source files from remote server, Archive/Purge requirements and kick off ETL batch jobs from Windows environment.
• Supported in test data preparation for the SIT, UAT and fixed identified defects.
• Created CR’s, Deployment groups for the code migration to Development and Production environments.
• Monitored jobs during warranty phase and handed over to Support team with support hand over document and KT sessions.

Environment: Informatica Power Center10.2, Oracle, SQL Server, Postgres, Redshift, Windows Server.

Confidential, Phoenix

Technical Lead

Responsibilities:

• Involved in envisioning phase calls with business users, SME’s and Source teams to understand the requirements and identifying the sources.
• Involved in the requirements mapping from source to target, design and ETL process flow diagrams.
• Engaged various teams like data model, Database and the shared infrastructure, GSQO teams to kick start the development activities.
• Initiated and Lead the discussions with EDMS, DBA teams to design the data model and Database.
• Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.
• Appeared before the PRB (Project Review board) for each phase of the project to check project health checkup and to get Approvals from PFA’s and sign off from Tech Director before commencing next phase.
• Performed various data validations and cleansing activities before loading data into STAGE layer and standardizations and integration with confirmed dimensions at Data ware house and transformed data as per reporting requirement before loading to DATA MART layer.
• Created mappings using Source qualifier, Expression, Lookup, Router, joiner, Aggregator, Union, Update strategy transformations.
• Implemented and maintained slowly changing dimensions as per business requirement.
• Involved in the Historical, Daily, catch up loads once the project launched in Live environment.
• Write Shell script to transfer source files from remote server, Source files validation, Archive/Purge requirements and kick off TL batch jobs from UNIX environment.
• Participated in Daily stand up calls and Kick off meeting sessions at the begin of each release.
• Participated in Show and Tell and Retrospective session for each release.
• Supported in test data preparation for the SIT, UAT and fixed identified defects by the teams.
• Created RFC’s, Deployment groups for the code migration to Development and Production environments.
• Monitored jobs during warranty phase and handed over to Support team with support hand over document and KT sessions.

Environment: Informatica Power Center9.6, DB2, Netezza, SQL Server, HPQC, Rally, UNIX.

Confidential, Phoenix

Sr. ETL Informatica Developer

Responsibilities:

• Extensively involved in almost all the phases of Project life cycle right from Requirements Gathering to Testing etc.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development by applying Ralph Kimball methodology of dimensional modeling.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Actively involved in gathering requirements from the end users.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and Sql server tables to target tables.
• Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Did performance tuning at source, transformation, target, and workflow levels.
• Parameterized the mappings and increased the re-usability
• Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Experience in using Debugger in Informatica Designer tool to test and fix errors in the mappings
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Worked with BIDW Admin Team for Code Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.

Environment: Informatica Power Center 9.1, Netezza, UNIX, IBM DB2, Xml, flat files

Confidential, Phoenix

Sr Informatica Developer

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Actively involved in gathering requirements from the end users.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files, xml and RDBMS tables to target tables.
• Worked with various transformations to solve the Slowly Changing Dimensional Problems using Informatica Power Center
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Schedule ETl loads using Control M.
• Resolve Critical and high incidents within time frame.
• Did performance tuning at source, transformation, target, and workflow levels.
• Used PMCMD, and UNIX shell scripts for workflow automation.
• Parameterized the mappings and increased the re-usability
• Used transformations such as the source qualifier, normalizer, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Checked and tuned the performance of application.
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Created RFCs and worked with BIDW admin team on Migration between Development, Test and Production Repositories.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.
• Did unit testing and development testing at ETL level in my mappings.

Environment: Informatica 9.1, DB2, UNIX Shell Scripting, Netezza

Confidential

Informatica Developer

Responsibilities:

• Worked on PowerCenter Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Extracting the data from Mainframe DB2 tables, transforming and validating the data and loading the data into Central Data Warehouse DB2 database.
• Designed, developed mappings, enabling the extract, transport and loading of the data into target tables.
• Tuned the SQL queries used in the SQL override, Lookup Override of the Source Qualifier and Lookup transformations.
• Scheduled the Loading processes and monitored sessions using Informatica Workflow Monitor.
• Analyzing and modifying the existing PL/SQL Packages for performance tuning.
• Extensively worked in the performance tuning of mappings and sessions.
• UNIX Environment for running jobs through Control M.
• Responsible for Testing and validating the Informatica mapping against the pre-defined ETL design standards.
• Created the Unit Test Plans and did Unit Testing, Prepare the Unit Test logs.
• Successfully moved the Mappings, Sessions and workflows from the Development environment to Production environment.
• Completed documentation in relation to detailed work-plans, mapping documents and high-level data models.

Environment: Informatica 8.6, DB2, UNIX.