SUMMARY

• Having around 6 years of experience in Information Technology, which includes Data Integration and Analysis for Decision Support System and Data Quality in Various Sectors.
• Experienced to work in Development team, Production Support teams in handling critical situations to meet the deadlines for successful completion of task/projects with Onsite/Offshore model.
• Working closely with architectures for requirement gathering and working with teams on solutions.
• Involved in Data Analysis using Query Analyzer, Understanding the requirement and do the mapping layout document to implement in Informatica code.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected/Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow &Worklet Designer.
• Proficient in transforming data from various sources (flat files, XML, DB2, Oracle) to Oracle Data warehouse using ETL tools.
• Extensively used Informatica Workflow Monitor.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in checking data quality using IDQ.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing.
• Good Experience in Creating different Repositories, Integration Services, Users and User Groups and also giving privileges to the Users/User Groups in Informatica using Admin Console.
• Good experience in preparing migration documents from development to testing and production environments.
• Experience in online analytics, system analysis, creating technical design documents, project plans, managing Data Warehouse projects.
• Expertise in installing Informatica on Windows and Linux OS.
• Good Experience in Mentoring and Leading the teams.
• Ability to rapidly learn new concepts together with excellent interpersonal skills.
• Excellent skills in understanding business needs and converting them into technical solutions.
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows 2008R2/2003 R2/XP/7.

ETL Tools: Informatica Power Center 8.x/9.x (Repository Manager, Designer, Workflow Monitor, Workflow Manager),IDQ.

Languages: SQL, PL/SQL, Basics of JAVA.

Databases: Oracle11g/10g/9i, MS SQL server 2003/2008 and MS Access 2000.

Database utilities: SQL *plus, Stored procedures, Functions, Exception handling, Data flux.

Reporting Tools: Oracle Business Intelligence.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica 9.1 for extracting the data from PEOPLE-SOFT application and loading data into DATA-WAREHOUSE.
• Creation of jobs using different transformations and validate the mapping.
• Created various mappings and mapplets to implement the business logic using different transformations.
• Used Aggregator, Connected and Unconnected Lookups, Router, Update Strategy, Filter, Rank, Joiners, Expression, Sequence generator.
• Used debugger to test the mapping and fixed the bugs.
• Implemented Slowly Changing dimensions Type 1, slowly changing dimensions Type 2 history of dimensional data in the table.
• Implemented the integration of Data Quality Tool (DQS) with MDM Tool (MDS) to spearhead the implementation of Data governance (de-duplication, aggregation, reconciliation, archiving).
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and load into Data warehouse using the Mapping Designer.
• Designed and Developed the Informatica workflows and sessions to extract, transform and load the data into dimension and fact tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Used Workflow Monitor to monitor the progress of workflow.
• Worked with a team in IDQ environment to improve the quality of available data.
• Responsibility also involved maintain the coding standard according to the Naming convention.
• Interacted with technical team and business users to perform analysis of business requirements.
• Prepare the technical document after going through the functional specification.

Environment: Informatica 9.1, IDQ Developer, Oracle 11g, PL/SQL, UNIX.

Confidential, Salt Lake, UT

Sr. Informatica Developer

Responsibilities:

• Work with Business Users in understanding the requirements.
• Document the requirement specifications and created source to target mapping documents.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy, XML Parser and XML Generator Transformations.
• Created mapplets, reusable transformations and used them in different mappings.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target.
• Used database objects like Views and Stored Procedures for accomplishing Complex logical situations.
• Involved in Unit testing, System testing to check whether the data loading into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with DBA's in tuning SQL queries using Execution Plan and Purged the data periodically.
• Used in IDQ environment to maintain and refine the quality of the data.
• Documented the code for better understanding for production support team in the event of production failure and also for better maintenance and analyzing the process flow.
• Actively participated in Design Reviews and Code Reviews to follow Standards and Best Practices.
• Used Tidal scheduling to schedule the workflows.
• Mentored peers during the on board phase.

Environment: Datastage, Informatica 8.1.1, PL/SQL, SQL*Plus, UNIX.

Confidential

ETL Developer

Responsibilities:

• Developed mappings using Source Qualifier, Expression, Lookup, Joiner Transformations etc. Informatica 8.1.1.
• Developed New and also Modified Existing Stored Procedures, Functions, Cursors, views using SQL Server.
• Developed Test Plan, Test Cases for Unit Testing.
• Mentoring ETL Team.
• Involved in Testing Dashboards, Business Objects Reports.
• Assisting in setting up the data for Testing and Reporting teams.
• Assisting in understanding the requirements and ETLs for testing teams.
• Changes and Code Reviews done for the Junior Developers.
• Reviewed Others Unit Test Cases.

Environment: Informatica 8.1.1, SQLServer 2005, Business Objects and Dash Boards

Confidential

ETL Developer

Responsibilities:

• Used Informatica Power Center 7.1 for extraction, transformation and loading (ETL) of data in the DataMart.
• Developed mappings using Source Qualifier, Expression, Lookup, Joiner Transformations etc. Informatica 7.1.
• Developed Stored Procedures, User Defined Functions, Triggers, views in Oracle for Loading Dimension and Fact tables
• Developed Test Plan, Test Cases for Unit Testing.
• WroteComplex SQL Queries for Data Validation at the end of the Load.
• Involved in testing the reports developed in Business Objects.
• Prepared Technical Design Documents.
• Prepared Batch Script to automate the ETL Load.

Environment: ETL Informatica 7.1, Oracle 9i (SQL, PL/SQL), Business Objects 6.5.