SUMMARY

• Put forth overall of 8 years of IT industry experience with 5 years as ETL informatica Developer and 3 years as QA analyst in data base testing with experience in domains Insurance, Telecom, and Health care.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Centre Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica PowerCenter.
• Extensive experience in Performance Tuning in Identifying and fixing bottlenecks also tuned the complex Informatica mappings for better Performance.
• Experience in databases Oracle, Teradata, and DB2.
• Experience in tools Teradata SQL Assistant, DB visualizer, SQL Developer, SQL*Plus.
• Experience in Test Deployment of informatica objects using deployment groups, and non informatica objects using Eclipse and UNIX deployment process.
• Experience in using Putty, Scheduling the workflows using ESP workload scheduler, Control M
• Experience in using Teradata load and unload utilities (Fast load, Fast Export in informatica sessions)
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Star schema and Snowflake schema used in relational, dimensional modelling.
• Extensively worked on Data Merging, Data Cleansing, Data Scrubbing, and Data Aggregation of operational sources using ETL.
• Self - motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.

TECHNICAL SKILLS

Data Warehousing/ ETL tool: Informatica PowerCenter 9.x/8.6

Databases & Tools: Oracle, DB2, Teradata, Teradata SQL Assistant, DB Visualizer, Putty,Cache 2012, SQL developer, SQL*Plus, Toad

Scheduling tool: ESP workload Automation,Control M

Deployment and FTP Tools: Eclipse,winscp,Filezilla

Test management & Bug reporting tools: Quality Center, Test Track,Team Track

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Environment: Windows 7/XP, Windows Server 2003/2008, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Informatica ETL Developer

Responsibilities:

• Understanding the requirements and data mapping documents.
• Prepared high level mapping design documents from requirements.
• Created mappings for Initial, Daily loads, Base table and functional table loads.
• Worked with Informatica power centre 9.5 to extract the data from DB2 sources into Teradata.
• Created mappings by using Joiner, Expression, Aggregator, Router, Lookup, SQL transformation, Filter, Rank, sorter, Update Strategy and Sequence Generator.
• Worked with various lookups-Connected lookup, Un connected lookup, Static cache, Dynamic cache lookups.
• Parameterized using mapping, session parameters, and workflow variables by defining them in parameter files.
• Analysed session logs, session run properties, Workflow run properties.
• Analysed rejected rows using bad files.
• Performed code reviews and unit testing.
• Deployment of informatica objects by deployment groups in informatica and non informatica objects by using Eclipse, Unix deployment process.
• Scheduling jobs using ESP workload Automation to run informatica workflows.
• Implemented performance tuning techniques.
• Used mapping debugger for data and error conditions to get trouble shooting information.

Environment: Informatica Power Centre 9.5, Teradata, DB2, Teradata SQL Assistant, DB Visualizer, Putty, Esp workload Automation, Eclipse,winscp,Filezilla, Windows 7,UNIX.

Confidential, Jacksonville, FL

ETL Developer

Responsibilities:

• Understanding the health care Business Requirements and map to the Technical Requirements. Developed ETL Design & process documents and mapping document.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Extensively used ETL to load data from multiple sources to Staging area and implemented transformation logics to load data to base tables.
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Analysed session logs, session run properties, Workflow run properties, rejected records.
• Involved in identifying the bottlenecks and tuning to improve the Performance.
• Parameterized using mapping and session parameters.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Performed code reviews and unit testing.

Environment: Informatica Power Center 9.1, Oracle 10g, SQL developer, Windows 7, Putty, UNIX.

Confidential

ETL Developer

Responsibilities:

• Extracted the data from Oracle, Flat files and Access into Data warehouse.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, and Joiner. Used connected unconnected, Static and Dynamic lookup transformations.
• Developed mappings by using parameters and Variables.
• Analysed session logs, session run properties, Workflow run properties, rejected records.
• Involved in identifying the bottlenecks and tuning to improve the Performance.
• Performed code reviews and unit testing.
• Scheduled informatica workflows using Control M.
• Developed Test scripts & Test Plans for testing the end user requirements. Worked with the testing team in resolving the issues during system integration testing and UAT

Environment: Informatica Power Center 8.6, Oracle10g, SQL, PL/SQL, Toad, Windows XP.

Confidential

QA Analyst

Responsibilities:

• Test Planning & Management
• Client Interaction on regular basis for requirement collation
• Extensively involved in reviewing and analyzing the business and functional Requirements
• Test Case design, writing, execution and defect reporting
• Follow up and verification of defect fixation
• Execute Backend Testing application by writing complex SQL Queries.
• Designed and executed functional test cases using Quality Center
• Reported bugs using bug reporting tool Test Track

Environment: Oracle 9i, SQL, TOAD 8.6.1, Quality Center, Test Track

Confidential

QA Analyst

Responsibilities:

• Test Planning & Management
• Client Interaction on regular basis for requirement collation
• Extensively involved in reviewing and analyzing the business and functional Requirements
• Test Case design, writing, execution and defect reporting
• Follow up and verification of defect fixation
• Execute Backend Testing application by writing complex SQL Queries.
• Designed and executed functional test cases using Quality Center
• Reported bugs using bug reporting tool Test Track

Environment: Oracle 9i, SQL, TOAD 8.6.1, Quality Center, Test Track