SUMMARY

• 9+ years of experience in Data Warehousing using tool Informatica Power Center 8.x & 9.x and Databases like Teradata & Oracle.
• Designed various mapping specifications, Design Documents in coordination with the functional team members.
• Extensively worked on Designer, Workflow Manager and Workflow Monitor.
• 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 and Router etc.
• Hands-on on reporting tools like Xcelcius.
• Good Analytical and problem solving skills with strong technical background and good interpersonal skills.
• Experience in working withInformatica Data Quality (IDQ) for data and quality analysis.
• Experience in writing VBA Scripts to enhance the report functionality and automated the Printing capabilities.
• Proficient in the integration of various data sources involving multiple relational databases like Oracle, MS SQL Server, DB2 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 SQL queries by using Indexing techniques, Hints and Parallel execution process.
• 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.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using Auto Sys scheduler and Involved in migration/conversion of ETL processes from development to production environment.

TECHNICAL SKILLS

DWH Tools(ELT/ETL): Informatica Power Center 9.0.1/8.6.1

Operating System: Windows, UNIX

Database: Oracle, Teradata

Application Tools: Toad Oracle, Teradata utilites (FastLoad, MultiLoad, TPump, BTEQ)

Scripting: Unix Shell Script

Reporting Tools: Xcelcius

PROFESSIONAL EXPERIENCE

Confidential, Hartford, Connecticut

Technical Lead

Responsibilities:

• Responsible for Business Analysis, Requirements Collection and HLD creation
• 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
• Involved in 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.
• Created reusable tools like file splitter and file format checking using Informatica.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Informatica PIM.
• 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.
• Developed mappings to load into staging tables and then to flat files
• 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 9.x,Sqlserver,flat files,Autosys

Confidential, Dover, NH

Tech. Lead

Responsibilities:

• Responsible for Business Analysis, Requirements Collection and HLD creation
• 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
• Involved in 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.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used visio to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• 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.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used SSIS to load data from excel files to tables.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, 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 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote Batch Scripts to archive the files.
• 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 9.x,Teradata,Oracle & Unix.

Confidential, Dover,NH

Sr.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
• Review existing code, lead efforts to tweak and tune the performance of existing Informatica
• Worked on Teradata BTEQs.
• Worked on Salesforce objects loading.
• Worked on Salesforce lookups.
• Preparation of Analysis document and mapping document.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Used Shell scripting for automation of ETL work.
• 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.
• Assigning work to team members.
• Updating project status to client.
• Involving in production move activities like label the workflows and creating RFC.
• Implementation of upsert using Teradata.
• 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.0.1, Teradata 13 and UNIX

Confidential, CALIFORNIA

ETL Developer

Responsibilities:

• Developed mappings using Source qualifier, Aggregators, Connected & unconnected Lookups, Stored Procedures, Filters, Sorter & Update strategy Transformations using Power Center.
• 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.
• 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 9.x,Sql server,Oracle and flat files

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.x,Oracle and Unix

Confidential

ETL Developer

Responsibilities:

• Gathered and analyzed requirements and designed ETL processes using Informatica tool to load data from SQL Server 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.
• Preparation of release notes.
• Check in the workflows into TFS.
• Preparation of Technical design documents.
• 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 and logical processes.
• Used Informatica repository manager to backup and migrate metadata in development and AT.
• Creation of Parameter file in UNIX environment.
• Performed the testing as per unit test cases.

Environment: Informatica 8.x,Teradata,flat files.