PROFESSIONAL SUMMARY:

• 10 years of experience in ETL / Data Warehousing technology tools like Informatica Power Center, Informatica Data Quality IDQ, Informatica analyst, Informatica Developer, SAP Business Objects and Databases like Oracle, SQL Server, DB2, Netezza and Teradata.
• Designed ETL Mapping Specifications, Design Documents in coordination with the functional team members.
• Extensively worked on Designer, Workflow Manager and Workflow Monitor, Informatica Analyst and Informatica Developer.
• Experience working in Informatica Data Quality (IDQ) using Analyst and Developer tools to perform data cleansing and data profiling activities.
• Extensively Used Address Validator Transformation, Parser Transformation, Standardizer, Join Analysis Transformation to perform the Informatica IDQ activities.
• Used Informatica Data Quality IDQ to perform Unit testing and create Mapplets that are imported and used in Power center Designer.
• Good knowledge in Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ), used tools like Informatica analyst and Informatica developer.
• Experience in working with Informatica Data Quality (IDQ) for creating Rules, Score carding, Reference Data Tables, Mappings, Mapplets etc.
• Experience working with IDQ Exception Handling and Code Migration.
• Extensively worked on Teradata tools and utilities (FastLoad, MultiLoad, TPump, BTEQ)
• Have good Knowledge of Data warehousing concepts and Informatica performance tuning.
• Have good Knowledge in SQL and UNIX Shell Scripting.
• Hands - on experience in creation of various transformation objects like the Source Qualifier, Expression, Filter, Aggregator, Lookup, Update, and joiner, Sequence Generator, Sorter, Rank, Router and Java Transformations etc.
• Proficient in the integration of various data sources involving multiple relational databases like Oracle, MS SQL Server, DB2, Netezza, Teradata, XML and Flat Files (fixed width, delimited)
• Experience in identifying performance bottlenecks and tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Involved in tuning the Oracle PL/SQL queries by using Indexing techniques, Hints and Parallel execution process.
• Experienced in Partitioning of the sessions and workflows
• Experience in working with Teradata parallelism Architecture.
• Experienced in working with Agile, Waterfall methodologies
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Experience in Scheduling Informatica sessions for automation of loads in Autosys.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.

TECHNICAL SKILLS:

ETL TOOL: Informatica Power Center 9.5.1, 9.1, 8.6 (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Informatica Data Quality (IDQ), Informatica Analyst, IDE, Data Director

Reporting Tool: Cognos BI, Cognos Data Manager, SAP Business Objects

Databases: Oracle11G/10G/9i/8i, MS SQL Server, DB2, Netezza, Teradata

Languages/Web: SQL, PL/SQL, SQL *Loader, HTML, C++, Java, Unix Shell Scripting and MS-Excel, XML.

Data Base Tools: TOAD, SQL Plus, Sql developer, Sql Server Management Studio, Teradata SQL Assistant

Environment: MS Windows, Windows NT, Unix Putty 0.67, Sun Solaris

WORK EXPERIENCE:

Confidential, East Windsor, New Jersey

ETL Lead Developer / IDQ Lead Analyst

Responsibilities:

• Responsible for Requirements Analysis and HLD, LLD Documents preparation.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Worked on complex Mappings, Mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Informatica PIM.
• Experience working in Informatica Data Quality IDQ (Informatica Analyst and Developer Tools) to perform data cleansing and profiling.
• Experience in creating Rules, Mapplets, Mappings and Scorecarding, developing the Reference data tables and standardizing the data.
• Used Address validator, Parse Transformation, Join Analysis Transformation to perform the Informatica IDQ activities.
• Used IDQ to perform Unit testing and create Mapplets that are imported and used in Power center Designer.
• Responsibilities include creating the sessions and scheduling the sessions
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created Mapplets to use them in different mappings.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 2 SCD mappings for CDC (Change Data Capture).
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica PowerCenter 9.5.1, Informatica IDQ 9.0.1, Sqlserver Management Studio 2012, flat files, Netezza, SQL Developer, UNIX putty 0.66, Teradata 15, Quality Center, BMC Remedy ITSM and Autosys.

Confidential, Dover, NH

IDQ Data Quality Analyst / ETL Lead Developer

Responsibilities:

• Involved in ETL projects requirements gathering, HLD and Technical Specs.
• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from Oracle to Teradata target database
• Review existing code, lead efforts to tweak and tune the performance of existing Informatica
• Worked on Teradata BTEQs and Teradata Load Utilities like FLoad, MLoad and Tpump.
• Preparation of Analysis document and mapping document.
• Experience working with Informatica Analyst to Analyze the Data and perform Data Profiling, Scorecarding and standardizing the data.
• Performed Profiling, Scorecarding, Creating Rules, Reference data tables, Mapplets and Mappings as part of the development process.
• Used Labeller, Match, Address validator, Parse Transformation, Join Analysis Transformation to perform the Informatica IDQ development activities.
• Used IDQ to perform Unit testing and create Mapplets that are imported and used in Power center Designer.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Leading a team of four members and updating project status to client.
• Involving in production move activities like label the workflows and creating RFC.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica Power Center 9.1, Informatica Data Quality IDQ, Informatica Analyst, Informatica Developer, Teradata, Sql server management studio, Oracle 11g, DB2, Quality Center, UNIX putty 0.66 and Autosys.

Confidential, Sacramento, CA

ETL Developer / IDQ Developer

Responsibilities:

• Developed mappings using Source qualifier, Aggregators, Connected & unconnected Lookups, Stored Procedures, Filters, Sorter & Update strategy Transformations using Power Center.
• Worked with power exchange connectors to retrieve the from SAP and Mainframe systems
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used connected Lookup to improve performance.
• Responsible for testing the mappings and ensure that the mappings do the transformations as proposed
• Involved in Creating tasks, worklets, workflows to load various dimensions that include Products, Product Categories.
• Expertise in Informatica Data Quality (IDQ) and Performed Profiling, Scorecarding, Creating Rules, Reference data tables, Mapplets and Mappings as part of the development process.
• Used Labeller, Match, Address validator, Parse Transformation, Join Analysis Transformation to perform the Informatica IDQ development activities.
• Scheduled, Run and Monitored sessions using workflow manager and workflow monitor to update data on claims, drug, physician and customer data.
• Applied slowly changing techniques and Dynamic lookup techniques.
• Defined Target Load order Plan for loading data into Target Tables.
• Involved in dealing with performance issues at various levels such as target, sessions, mappings and sources.

Environment: Informatica PowerCenter 9.1, Informatica Data Quality (IDQ), Sql server 2005, Oracle 10g, DB2, SQL Developer, Toad, Webservices (SOAP) and flat files, HP Quality Center, UNIX and Autosys.

Confidential

ETL Developer

Responsibilities:

• Involved in ETL projects requirements gathering, HLD and Technical Specs.
• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from Oracle to Teradata target database
• Worked on Teradata BTEQs.
• Developed reusable Mapplets and Transformations.
• Preparation of Analysis document and mapping document.
• Used Shell scripting for automation of ETL work.
• Performed the testing as per unit test cases.

Environment: Informatica 8.6, Oracle10g, SQL Server2005, Sql developer, Toad, flat files, HP Quality Center, NSI and UNIX

Confidential

Informatica Developer

Responsibilities:

• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from File system and Oracle staging and SQL server target database
• Used Informatica Power Center tools - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor extensively
• Developed sessions using Workflow Manager for data loading with ODBC
• Created various transformations such as Lookup, aggregate, expression, router and update strategy
• Tested applications as per unit test cases.
• Defined and documented requirements for data, workflow, logical processes and operating system environment
• Developed programs, applications and enhancements based on agreed SLAs
• Reviewed and edited requirements, business processes and recommendations related to proposed solutions

Environment: Informatica PowerCenter 8.6, Oracle 10g, SQL server 2005, Teradata Utilities, Sql Developer, Flat Files, Unix and ControlM

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Center tools - Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor extensively
• Created various transformations such as Lookup, aggregate, expression, router, filer and update strategy
• Developed programs, applications and enhancements based on agreed SLAs
• Reviewed and edited requirements, business processes and recommendations related to proposed solutions
• Created various transformations such as Lookup, aggregate, expression, filter and update strategy
• Used workflow manager to create tasks, monitor and analyze loading statistics
• Performed UTC (Unit Test Cases)

Environment: Informatica PowerCenter 8.6, Oracle 9i, SQL Server 2000, Flat Files, Sql Developer, Quality Center, UNIX and ControlM