SUMMARY

• IT professional with 8+ years of diverse experience in Design, Development and Maintain ETL process using Informatica 9.5 and lower versions across Healthcare, Automotive, Financial and Insurance sectors.
• Extensively used Informatica Repository manager, Power center Designer, Workflow manager, Workflow Monitor and Repository Admin Console.
• Proficient in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.
• Extensive Experience in designing and developing complex mappings applying various transformations such as Expression, Aggregator, Lookup, Source qualifier, Update strategy, Filter, Router, Sequence generator, Rank, Stored procedure, Joiner and Sorter.
• Extensive experience in performance tuning and resolving performance bottlenecks of sources, transformation, targets, mappings and sessions.
• Excellent knowledge in creating source to target mapping, edit rules and validation, transformations based on business rules.
• Created UNIX shell scripts to automate daily and monthly loads.
• Experience in all phases of the Software development lifecycle (SDLC) using Agile and Waterfall methodologies.
• Involved in all stages ETL - requirement gathering, designing and developing various mappings, unit testing, integration testing and regression testing.
• Data Validation and Profiling based on the business and functional requirements.
• Used various database client tools like TOAD, SQL developer, SQL server, Teradata SQL Assistant to access/create/change database objects and create scripts.
• Extensively worked with Teradata, Oracle and SQL Server.
• Automation and scheduling of Informatica jobs using AutoSys.
• Excellent written and verbal communication skills, good analytical reasoning and ability to learn quick and high adaptability to new tools and technologies.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica PowerCenter 9.5/9.1/8.6.1/7.1 , Informatica Power Exchange, B2B,IDQ

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling, Entities, Attributes, ER Diagrams, Erwin 7.2

Databases: Oracle 11g, 10g/9i/8i, MS SQL Server 2005/2000, Teradata, MS Access, IBM DB2

Programming: SQL, PL/SQL, SQL*Loader, Unix Shell Scripting

Reporting Tools: Crystal Reports, Business Objects, Oracle Business Intelligence

Other Tools: SQL Plus, TOAD, SQL developer, SQL server, Teradata SQL Assistant, Autosys

Environment: UNIX, Windows (XP, NT/ 95/98/2000/2007 ).

PROFESSIONAL EXPERIENCE

Confidential, Danville, PA

Sr ETL Developer

Responsibilities:

• Involved in requirement gathering with business users and converted them into mapping documentation.
• Extensively word on Informatica Power Centers tools like Designer, Workflow Manager and Repository Manager.
• Worked with transformations like Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update strategy, Union, Rank and more.
• Developed complex mappings and involved in tuning for better performance.
• Designed and executed error handling process using Informatica Debugger.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Identified the Bottlenecks, removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Developed number of Complex Informatica Mappings and Reusable Transformations based on the business rule.
• Involved in creating SQL overrides in source qualifiers for extracting only the required rows for optimal performance.
• Created complex transformations using connected/unconnected Lookups.
• Created Reusable Transformations and Mapplets based on the business rules.
• Involved in Performing Unit Testing of the mappings developed and ETL process to check if the transformations are executing as expected.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Developed UNIX shell scripts to implement ETL process on daily/monthly jobs.
• Involved in creating best practice documents for ETL Process.
• Involved in coordinating with DBA to increase performance of ETL process by creating indexed on target tables as required.
• Collaborated with development and testing team to support end to end testing.

Environment: Informatica Power Center 9.5.1/9.1.0 , Oracle 11g, Teradata, Erwin, SQL Developer, TOAD, PL/SQL, Tidal, Unix, WindowsXP/7, SQL Server.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Created data maps using Informatica Power Center to populate the data from main frames to the staging area.
• Extensively worked on performance tuning at various levels like mapping level, session level, and database level.
• Involved in requirement gathering meeting and prepared technical and mapping documentation.
• Involved in design layouts, analysis and other documentation along with the business analysts and team.
• Developed UNIX scripts for modifying, parsing validating data.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the best possible usage of sources, transformations and target loads.
• Generated parameter files dynamically with the data from database table.
• Created Mappings using different transformations like Expression, update strategy, Joiner, Router, Lookup, Filter, Update Strategy, XML Generator to perform the process of Extract, Load and Transform effectively in the Mapping Designer as per the business requirement.
• Created objects like Mapplets, reusable transformations, shortcuts for ease of enhancement by facilitating reusability.
• Involved to set up sessions to extract data through FTP from remote mainframe data source files
• Developed mapping parameters and variables to support SQL override.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented.

Environment: Informatica Power Center 8.6.1, Informatica Power Center 9.1, Informatica Power Exchange 8.6.1, Informatica Power Exchange 9.1, Oracle 10g, Mainframe, SQL developer, Auto sys, JIRA

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Involved with Business users to identify the process metrics and various key dimensions and measures.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Created Mapplets, reusable transformations and used them in different mappings.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for clean up and update purposes.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, XML files, SQL Server into the Staging table and then to the target database Oracle.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Performed incremental aggregation to load incremental data into aggregate tables.
• Involved in redesigning ETL mappings to improve data quality.
• Unix Validation of Informatica mappings for source compatibility due to version changes at the source.
• Involving in trouble shooting of long running sessions and fixing bugs.
• Developed UNIX shell scripts using PMCMD and PMREP utilities and scheduled ETL load using Maestro.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.
• Migrated repository objects, services and scripts from development environment to production environment.
• Extensive experience in troubleshooting and solving migration issues and production issues.
• Involved in creating multi dimensional universe and reports in Business Objects Environment.

Environment: Informatica Power Center 8.6.1, Oracle 11g/10g,SQL Server 2008, SQL,PL/SQL, TOAD, Unix, Unix Shell Script, Business objects.

Confidential

Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Created Repository using Repository Manager.
• Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Tuned the mappings to increase its efficiency and performance.
• Used Informatica Workflow Manager to create workflows
• Workflow Monitor was used to monitor and run workflows
• Involved in production support which also includes trouble shooting of connectivity issues.

Environment: Informatica PowerCenter 7.1, Oracle 8i, UNIX, TOAD, SQL * Loader, Windows.

Confidential

Informatica Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of data warehousing efforts.
• Involved in Designing the Data warehouse using Informatica ETL tool by using Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Joiner, Update Strategy and Rank.
• Extensively involved in Performance Tuning issues.
• Involved in Creating tasks, Worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Migrated Mappings, Sessions and Workflows from Development to Test and then to Production environment.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Involved in developing ad-hoc and business reports according to the requirement.

Environment: Informatica Power Center 7.1, Oracle, SQL loader, UNIX, Windows 2000.