SUMMARY:

• 10+ yearsof IT industry experience with9yearsas ETL Developer and 1.6 years as data engineerwithexperiencein domains Insurance, Telecom,banking and Health care.
• Extensive experience in Informatica PowerCenter as ETL tool.
• Experience in using different parsing techniques in Informatica B2B Data Transformation Studio.
• Experience in using data sourcesOracle, Teradata, DB2, Ms SQL server, flat files, and XML files.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using PowerCenter Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Extensively worked on Informatica PowerCenter Transformationssuch as Source Qualifier, Lookup, Filter, Expression, SQL transformation, Data masking, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Transaction Control transformations.
• 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 bottlenecksalso tuned the complex Informatica mappings for better Performance.
• Experience in writingcomplexSQL queries, stored procedures and functions using PL/SQL programming.
• Experience in Test Deployment of Informatica objects using informatica deployment groups, and non Informatica objects using Eclipse and UNIXdeploymentprocess.
• Experience inusing Putty, Scheduling the workflows using ESP workload scheduler, Control M, Tidal scheduler.
• Experience in creating highly interactive Data Visualization Reports and Dashboards using Tableau desktop features such as Data Blending, Joining, Calculations,Filters,Actions,parameters,Maps, sets, Groups, Aggregate measures etc.
• Experience in tools Teradata SQL Assistant, DB Visualizer, SQL Developer, Toad,Ms sql server management studio
• 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:

ETL/ Reporting tools: Informatica PowerCenter, Informatica B2B Data Transformation studio,Tableau desktop

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

Schedulingtool: ESP workload Automation,Control M, Tidal scheduler, Tidal Transporter

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, Python scripting language

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

PROFESSIONAL EXPERIENCE:

Confidential, Dover, NH

Senior Informatica ETL Developer

Responsibilities:

• Understanding the requirements and data mapping documents.
• Prepared high level mapping design documents from requirements.
• Developed mappings for Audit reconsolidation of daily loads.
• Implemented changed data capture by using control tables.
• Implemented SCD type 1 for ODS table loads.
• Created mappings by using Joiner, Lookup, Expression, Aggregator, Data masking, 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.
• Performed deployment of informatica code.
• Run the informatica jobs by using Tidal scheduler.
• Implemented performance tuning techniques.
• Leading a team of ETL developers from offshore.

Environment: InformaticaPower Centre 9.5, Teradata, Unix Shell Scripting, Teradata SQL Assistant,Putty, Tidal scheduler,Tidal Transporter,winscp, Filezilla, Windows 8.

Confidential, San Francisco, CA

Senior ETL Developer

Responsibilities:

• Understanding the requirements.
• Understanding the existing logic in PL/SQL stored procedures of different packages to implement ETL code in informatica.
• Created Informatica mappings for stage tables, ODS tables and core table loads.
• Extensively worked with Informatica power centre 9.5.
• Created mappings by using Joiner, Expression, Aggregator, Router, Lookup, SQL transformation, Update Strategy and Sequence Generator.
• Parameterized ETL mappings by defining parameters and declaring 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.
• Implemented performance tuning techniques.
• Used mapping debugger for data and error conditions to get trouble shooting information.

Environment: Informatica Power Centre 9.5,Oracle 11g, SQL developer, tidal, Unix Shell Scripting, Putty, SQL, PL/SQL, Windows 8.

Confidential, Redmond, WA

Senior ETL Developer/Onsite lead

Responsibilities:

• Understanding the requirements and data mapping documents.
• Created Informatica mappings for data migration from DB2 to Oracle.
• Used Parser in Informatica B2B Data Transformation to convert the semi structured data to XML files.
• Created Informatica mappings for data integration with different Confidential applications in Ms sql server.
• Extensively worked with Informatica power centre 9.5.
• 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.
• Implemented SCD type 2in the integrations.
• Analysed session logs, session run properties, Workflow run properties.
• Analysed rejected rows using bad files.
• Performed code reviews and unit testing.
• Implemented performance tuning techniques.
• Used mapping debugger for data and error conditions to get trouble shooting information.
• Created data visualization reports and dashboards using Tableau desktop.
• Leading a team of ETL developers from offshore.

Environment: InformaticaPower Centre 9.5, Informatica B2B Data Transformation studio,DB2, Oracle 11g, Ms SQL server, SQL developer, DB Visualizer, SQL server management studio,Tableau desktop, Windows 8

Confidential, Indiana Polis, IN

SeniorInformatica ETL Developer

Responsibilities:

• Understanding the requirements and data mapping documents.
• Developed mappings for Audit reconsolidation of daily loads.
• Worked with Informatica power centre 9.5 to extract the data from DB2 sources into Teradata.
• Created mappings by using Joiner, Expression, Aggregator, Data masking, 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.
• Used unix shell scripting for informatica jobs to run from ESP workload scheduler.
• Implemented performance tuning techniques.
• Used mapping debugger for data and error conditions toget trouble shooting information.
• Leading a team of ETL developers from offshore.

Environment: Informatica Power Centre 9.5, Teradata, DB2, Unix Shell Scripting, Teradata SQL Assistant, DB Visualizer, Putty, Esp workload Automation, Eclipse, winscp, Filezilla, Windows 8.

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,SQL developer, Windows XP, 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
• Developed stored procedures and functions with PL/SQL programming.

Environment: Informatica Power Center8.6,Oracle 10g, SQL, PL/SQL, SQL developer, Windows 7, 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, Toad, SQL Server, Ms sql server management studio, Windows xp, Putty, UNIX.