PROFESSIONAL SUMMARY

• About Seven plus years of experience in Data Integration and Data Warehousing using ETL tool Informatica Power Center 9.x/8.x/7.x/6.x. with a good knowledge of Informatica tools such as Power Exchange, Power Analyzer, Power Connect, Master Data Management (MDM), Data Mart.
• Having experience in all the phases ofData warehouse life cyclewhich mainly involves Requirement Analysis, Design, Coding, Testing, and Deployment.
• Worked extensively on Informatica power center9.x/8.x/7.x. (Repository Manager, Designer, Workflow Manager, Workflow Monitor and Administrator console)
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor.
• Experience in creatingReusable Transformationssuch as Update Strategy, Lookup, Expression, Joiner, Aggregator, Sorter, Sequence Generator, Router, Filter, Rank and Normalizer andMappings usingInformatica Designerand processing the tasks usingWorkflow Managerto move data from multiple sources into the targets.
• Thorough and detailed knowledge on Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions,Dimensional Modeling (Star Schema and Snow Flake Schema) and other OLAP concepts.
• Extensively worked on Code Migration from Development to UAT and Production.
• Experience inworking on Data Integration projects using Informatica Master Data Management (MDM).
• Worked on Advanced Scheduling tool known asAutosys.
• Extensively worked on Informatica Web services transformations.
• Hands on experience on Informatica Web services (WSDL/XSLT/XML).
• Complete knowledge of data warehouse methodologies (Ralph Kimball, INMON), ODS, EDW and Metadata repository.
• Developed all types of slowly changing dimensions such as Type-I, Type-II, and Type-III.
• Hands on experience inUNIX& LINUXwork environment,including transfer of files,scheduling of jobsand error handling.
• Equipped with strong Dataware Housing and Business Intelligence concepts.
• Expertise in OLAP and Reporting tools like Business objects and Cognos.
• Expert-level mastery in creating UNIX Shell Scripts and also worked on integrating data from flat files, CSV files and XML files into a common reporting and analytical Data Model.
• Strong Data warehousing experience specializing in RDBMS, ETL concepts especially in writing ETL procedures to load data from different sources into data warehouse using Informatica Power Center.
• Worked with Informatica Data Quality for Data Profiling.
• Strong experience in coding using SQL, PL/SQL -Procedures/Functions, Triggers and Packages.
• Highly used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Expert developer skills in TeradataRDBMS, initial TeradataDBMS environment setup, development and production support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities.
• Strong expertise in Relational database systems like Oracle, SQL Server, Teradata, Sybase, DB2 design and database development using SQL *PLUS, TOAD, SQL LOADER, PL/SQL developer.
• Highly proficient in writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Self-Starter who can adapt and learn fast with excellent communication &interpersonal skills.
• Recognized team player with the ability to perform well in a group or individually and can cope well in a high intensity work environment.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Power Mart, Power Channel 6.2, Power Exchange 5. Power Analyzer Data Profiling, Power Connect, and Data cleaning, Flat file system (Fixed width, Delimiter), OLAP,IDQ

ETL data Integration Tools: Informatica Power Center / Power Mart 6.x/7.x/8.x/9.x(Designer, Workflow Manager, Work flow Monitor, Repository Manager, Repository Server Administration Console), Power Connect for ERP and Mainframes, Power Exchange, Data stage, Master Data Management (MDM) .

Data Modeling: Erwin 4.0, Star-Schema Modeling, FACT and Dimension Tables

DBMS: Oracle 12c/11g/10g/9i, Microsoft Access, SQL Server 2008/2005, MS Excel, Flat Files, Teradata, Sybase

Languages: C, C++, Java, SQL, PL/SQL, HTML, DHTML, XML, UNIX, Shell Scripting,Visual basic, ASP, JSP, XML, Macromedia Software, JCL.

Scripting Languages: Java Script, VB Script and UNIX Shell Scripting.

Operating Systems: HP-Unix, Linux, Windows 2008/2003/NT/X

Design Skills: Object Oriented Analysis Design using UML.

Others: MS Project, MS Office Suite, Toad

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Informatica Integration Consultant

Responsibilities:

• Worked closely with Business Analysts to gather Business Requirement Specific (BRS) and Prepared Technical Specification Document.
• Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Worked closely with Salesforce Developer Team, as our source systems is Salesforce Application (SFDC).
• Worked with SOQL statements in Salesforce force explorer, workbench etc.
• Worked closely with Database Administratorsteamand Oracle JDE teamas our target systems is Oracle JDE.
• Worked with third party Vendors, Oracle JDE team this is maintained by them, so got a chance to closely work with them while performing UAT1, UAT2 and UAT3.
• Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager
• Developed Parameter files for passing values to the mappings.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Unit test the Data Mappings and Workflows and validate the data loaded into database.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings.
• Performed UAT for different projects internally.
• Worked on several modules of the company business project internally like B2B, ATG, SALESFORCE MIGRATION, JDE INTEGRATION etc.
• Used Pmcmd command to run the workflows, like creating a master worklow and calling all relevantworkflows and running.
• Scheduled the workflows using windows task scheduler and also created batch files, log files.
• Extensively worked on Salesforce Interface while performing UAT.
• Loaded bulk data into Oracle, handled lot of performance issues while loading, done data partitioning and used several concepts and resolved the performance issue.
• Worked almost on the tasks at workflow level email, link, session, cmd etc.
• Worked on DDL, DML, TCL etc at sql level, worked on advanced concepts at PL/SQL level.
• Worked with Winscp SFTP server, to get the order files from remote server and after processing at our side(Oracle JDE), generated Files like Invoice and ASN and sent back these files to the same server using CMD task at workflow level.

Environment: -Informatica Power Center 9.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Oracle 11g, SQL, PL/SQL, Flat Files, Win7, Winscp, SFDC Workbench, Force Explorer, Test Salesforce, SQL * Plus, Sql Developer, Toad, Windows Server.

Confidential, Romulus, MI

Sr. ETL Developer

Responsibilities:

• Worked closely with Business Analysts to gather Business Requirement Specific (BRS) and Prepared Technical Specifications
• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager
• Analyze, design, and modify the existing Data Warehouse’s data structures in Oracle Database
• Developed generic mappings and workflows for loading different types of client data by passing the parameters and variables for incremental loads.
• Developed Parameter files for passing values to the mappings for each type of client
• Worked with Connected look up and unconnected lookup and configured the same for implementing complex logic
• Developed mappings and workflows by reading the data from one database and loading the data to another database
• Modify and develop new ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon redesign activities.
• Created Parameter files and validation scripts. Worked on developing Change Data Capture (CDC) mechanism using Informatica Power Exchange for some of the interfaces based on the requirements and limitations of the Project.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the data according to the business logic.
• Equipped with strong Dataware Housing and Business Intelligence concepts.
• Performed Unit testing and Data validation testing using Validation scripts.
• Migrated data from staging to ODS and from ODS to RPT.
• Moved the mappings, sessions, workflows, and mapplets from one environment to other.
• Worked with numerous flat files, loaded data from flat files to Oracle.
• Performed UAT for different projects internally.
• Involved in working with Informatica Master Data Management (MDM) to improve business operations in providing efficient BI, reporting and Analytics.
• Handled multiple tasks at a time and successful in completion on time, without any loss of quality.
• Trouble shooting and problem solving applications with Informatica Debugger. Used debugger to test the data flow and fix the mappings.
• Extensively worked on Informatica transformations, Web services transformations.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Worked with Informatica Data Quality for Data Profiling.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Expertise in OLAP and Reporting tools like Business objects and Cognos.
• Writing UNIX scripts for unit testing the ETLCode (Sessions, Workflows, and Log Files).
• Unit test the Data Mappings and Workflows and validate the data loaded into database.
• Identified the errors by analyzing the session logs.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), Informatica Master Data Management (MDM), Oracle 12c, SQL, PL/SQL, Flat Files, Win7, SQL * Plus, Toad, LINUX, HP-UX.

Confidential, Washington

Sr. Informatica Developer

Responsibilities:

• Worked with business analysts and DBA’s for requirements gathering, business analysis and to design the data marts.
• Created the data model structure and E-R modeling with all related entities and relationship with each entities based on the rules provided by the business manager using Erwin
• Designed, developed Informatica v9.1 mappings to extract, transform and load the data into Oracle 11g target tables from Legacy systems.
• Designed and developed source to stage mappings/sessions/workflows.
• Experience in using Informatica Application ILM to control data growth and improve the performance of applications as part of effective application information lifecycle management.
• Designed and developed stage to ODS mappings/sessions/workflowsand also designed and developed ODS to data mart mappings/sessions/workflows.
• Extensively worked with heterogeneous sources from various channels like Oracle, DB2, SQL Server and Flat Files.
• Extensively worked on Informatica tools like source analyzer, warehouse designer, mapping designer, workflow manager, and workflow monitor and repository manager.
• Used Informatica repository manager to create repositories, users, permissions and privileges.
• Used SCD type1, Type2, Type 3 to load the present and historical data into EDW
• Developed UNIX shell scripts and PL/SQL procedures.
• Extensively worked on performance tuning of ETL mappings and sessions.
• Used TOAD to run SQL queries and to validate the data.
• Documented all mappings, crested effective test cases by performing unit testing and Integration testing to ensure the successful execution of data loading process.
• Analyzed session log files if the session failed and resolved the errors.
• Provided technical assistance by responding to inquiries regarding errors or questions with programs/interface.
• Tested the data quality and data integrity among various sources and targets.
• Associated with production support team in various performances related issues.
• Designed and maintained Complex Universes, resolved loops by creating aliases and contexts.
• Wrote Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Created views and altered some of the dimensional tables to satisfy their reporting needs.
• Worked with the Release Management Team for the approvals of the Change requests, Incidents using BMC Remedy Incident tool.

Environment: Informatica Power Exchange 9.x/ Power Center 8.1, Informatica Application ILM, Oracle 10g, AS/400 DB2, Microsoft SQL Server 2005, MS Access, TOAD, SQL Plus, PL/SQL, UNIX Shell Scripting, Sun Solaris 5.8, Windows NT 4.0, Erwin 4.0, BMC Remedy.

Confidential, Wilmington, DE

Data Integration Developer

Responsibilities:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Worked on dimensional modeling to Design and develop Star Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Design ETL processes using Informatica tool to load data from Oracle source systems and Flat files into Oracle Target database
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i/10g.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Used Informatica Repository Manager to create Repositories and users and to give permissions to users.
• Imported metadata from different sources such as Relational Databases, XML Sources and Impromptu Catalogs into Frame Work Manager
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Wrote Shell Scripts for Informatica Pre-session, Post session Scripts.
• Written PL/SQL stored Procedures andFunctions for Stored Procedure Transformation.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Performed Unit testing and verified the data.
• Involved Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Environment: Informatica Power Center 8.6, Flat files, XML files, Oracle10g, SQL Server, UNIX, PL/SQL, Windows 2005/08.

Confidential

ETL Developer

Responsibilities:

• Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations
• Used Transformation Developer to create the reusable Transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Wrote SQL Scripts for the reporting requirements and to meet the Unit Test Requirements.
• Developed UNIX shell scripts to move source files to archive directory.
• Performance tuned the mappings using different techniques to provide maximum efficiency.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Monitored batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.
• Optimized the Performance of the mappings to load the data quicker.
• Utilized several transformations in OWB such as Sequence, Splitter, De-duplicator, Constant

Environment: Informatica Power Center 7.2, OWB, SQL, PL/SQL, Oracle 8i, Windows NT, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Identified business rules for data migration and analyzed the business requirements.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplets Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Used PL/SQL to write stored procedures to increase the performance.
• Extensively used Debugger Process to test Data and applied Breakpoints.
• Loaded data from various sources (Flat files, Oracle, Sql Server, XML) using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Expression, Sequence Generator, XML Source Qualifier, Union and Update Strategy to load the data into the target.
• Worked on Data cleansing, data conversion & process implementation.
• UNIX Shell scripting for backup and monitoring of databases.
• Responsible for the development, implementation and support of the database of the server.
• Provided daily support to clients including data research and test environment data refreshes
• Monitored the processes to identify potential issues and apply preventative and corrective actions.
• Designed the slowly changing dimension strategy for the warehouse.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Provided production support.
• Coordinated between Development, QA and production migration teams.

Environment: Informatica Power Center 7.2, Oracle 9i, Clear Case, Clear quest, XML, PL/SQL, Toad, Unix Korn-shell scripts, Perl scripts, SQL Server Query Analyzer, Erwin, Linux.