SUMMARY

• 9 years of IT industry experience as ETL Informatica Developer and data engineer with experience in domains Insurance, Telecom, banking 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.
• Experience in change data capture (CDC)
• 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 informatica 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 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.5/8.6

Databases & Tools: Oracle, DB2, Teradata, Ms sql server, Teradata SQL Assistant, DB Visualizer, SQL developer, Toad, Ms sql server management studio, Cache 2012, Putty

Scheduling tool: ESP workload Automation,Control M

Deployment and FTP Tools: Eclipse,winscp,Filezilla

Other tools: Quality Center, Test Track,Team Track,Team foundation server

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

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

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Senior 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.
• Developed mappings for Audit reconsolidation of daily loads.
• Worked with Informatica power centre 9.5 to extract the data from IBM Mainframes DB2 sources into Teradata.
• Created mappings by using Joiner, Expression, Aggregator, Router, Lookup, SQL transformation, Update Strategy and Sequence Generator.
• Worked with various lookups-Connected lookup, un connected lookup, Static cache, and 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, IBM Mainframes DB2, Teradata SQL Assistant, DB Visualizer, Putty, Esp workload Automation, Eclipse,winscp,Filezilla,Windows 7,UNIX.

Confidential, Indianapolis, IN

Senior Informatica ETL Developer

Responsibilities:

• Prepared mapping design documents from requirements.
• Created mappings to load the Teradata stage tables and base tables.
• 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, sorter, Update Strategy and Sequence Generator.
• 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.

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

Confidential

Informatica 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, SQL Server 2008 R2, Ms sql server management studio, Windows 7, Putty, UNIX.

Confidential

Informatica 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.
• Worked with the testing team in resolving the issues during system integration testing and UAT

Environment: Informatica Power Center 8.6, Oracle 10g, SQL, PL/SQL, Toad, Windows XP, Putty, UNIX.

Confidential

ETL Developer

Responsibilities:

• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used Informatica Designer to create complex mappings using different transformations to move data from the source to the Data Warehouse.
• Developed the transformation/business logic to load data into data warehouse..
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Developed reusable mappings using Mapplets, parameters and Variables. used different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner.
• Created sessions, batches and scheduled them. Scheduling the sessions to extract, transform and load data in to warehouse database as per Business requirements.
• Scheduled the Sessions and Mapplets using Workflow Manager to load the data into Target Oracle database.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL developer, Windows XP, UNIX.

Confidential

Data Engineer

Responsibilities:

• Client Interaction on regular basis for requirement collation
• Extensively involved in reviewing and analyzing the business and functional Requirements
• Performed data cleaning by eliminating null values
• Collect data from different sources like oracle, sql server, flatfiles
• Form the final data in common format with the business rules
• Create the pivot reports from the source.

Environment: Oracle, sql server,SQL, TOAD, sql server management studio