SUMMARY

• 7+ years of experience in software analysis, design and development on Data warehouse projects using Informatica Power Center Server and Oracle on Windows and UNIX platforms. Experience in Financial, Banking, Healthcare, Retailand Telecommunications industries using ETL.
• Experience in development using ETL/Informatica9.X/8.X / 7.X and Performance tuning
• Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor).
• Experience in data extraction from heterogeneous sources like Flat Files, Oracle, Sybase, SQL Server, SalesForceand UDB DB2 using Informatica Power center.
• Experience in UNIX shell programming.
• Expertise in working with Oracle Stored Procedures, Packages, Cursors, Triggers, Tables, Constraints, Views, Indexes, Sequence and Synonyms.
• Good exposure to development, testing, debugging, implementation, documentation.
• Proficient in using Informatica workflow manager, workflow monitor, schedule and control workflows, tasksand sessions
• Strong noledge in Dimensional Data Modeling Technique, E - R modeling, Multi Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables and Dimension Tables) and experience in SCD’s.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings and sessions.
• Knowledge in Hadoop, Big Data, NoSQL, HDFS and Map Reduce.
• Knowledge in Hadoop eco system technologies such as in Pig, Hive and Sqoop.
• Experience in informaticascheduler.
• Unit and system testing the mappings and workflows.
• Used Push down optimization to improve the performance
• Experienced in SDLC (Gathering requirements from BA,Creating specification documents, Development and Testing)
• Experience in Agile Methodology and Waterfall methodology
• Experience in Informatica Power Exchange for Salesforce
• Knowledge in Informatica Data Quality (IDQ)

TECHNICAL SKILLS

ETL: Informatica 9.x/8.X/7.X (Integration Service / Power Center/ PowerExchange)

Big Data: Hadoop, HDFS, Map Reduce, Hive, Oozie, Sqoop, Pig and Java

Reporting Tools: Crystal Reports 2008

Databases: Oracle10g/9i/8i/7.x,MS SQLServer 2008/2005/2000 , UDBDB2, Netezza, SalesForce and Sybase.

GUI: TSL (Test script language)

Languages: SQL, PL/SQL, SOQL and C

DB Tools: SQL* plus, Oracle Developer, TOAD, Management Studio, IBM DB2 Control Center, Hive and Aginity Workbench

Web Tools: HTML and XML.

OS: MS-DOS 6.1, MS-Windows XP/2000/98/95 andUnix.

Scheduling Tools: CTRL M, Tidal

Testing Tools: Win runner, Test Directory

Office Suite: MS Word, MS Power Point, MS Excel and MS Access

Other Tools: WinSCP, Ultra Edit, SSH.

PROFESSIONAL EXPERIENCE

Confidential

ETL Consultant

Responsibilities:

• Extensively used Informatica client tools like Source Analyzer, Target Designer,Mapping designer, Mapplet Designer and Transformation Developer, Workflow manager, workflow monitor.
• Interacted with the Business Analysts to get the business requirements and involved in preparation of the design documents and Mapping documents.
• Developed mappings, workflows to extract data from various sources like flat files, RDBMS load them into different targets like flat files and RDBMS tables.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Application Source Qualifier, Expressions, Filters, Joiners, Routers, Unconnected/ Connected Lookups, Sequence generator, Aggregators, Unionand Normalizer transformations.
• Tuned and monitored in Informatica workflows using Informatica workflow manager and workflow monitor tools.
• Developed unit test case documents and tested +ve and - ve scenarios.
• Extensively used Debugger on a valid mapping to figure out the problems in mappings before loading the data into data warehouse.
• Used parameters and variables at mapping and session levels to tune the performance of Mappings.
• Extensively used Version control to Check In and Check Out the objects
• Developed pre and post session commands based on the requirement.
• Extensively used workflow monitor to monitor the logs that generates for each session runs.
• Migrated workflows in higher environments like QA, UAT and PROD.
• Scheduled the workflows in Tidal tool.
• Implemented Pushdown optimization to improve performance.
• Involved in Agile Methodology.

Environment: s: Power Center 9.5, Netezza, Flat files, DM, Tidal, SQL, Win SQL,WinSCP, Aginity Workbench.

Confidential

ETL Consultant

Responsibilities:

• Extensively used Informatica client tools like Source Analyzer, Target Designer,Mapping designer, Mapplet Designer and Transformation Developer, Workflow manager, workflow monitor.
• Interacted with the Business Analysts to get the business requirements and involved in preparation of the design documents and Mapping documents.
• Worked with various salesforce.com objects like Accounts, Contacts, Opportunities.
• Created Technical Specification Layer7 Document and Run Book Document.
• Developed mappings, workflows to extract data from various sources like flat files, SalesForce Objects load them into different targets like flat files, Salesforce Objects and RDBMS tables.
• Developed complex mappings and SCD type-I and Type-II mappings in Informatica to load the data Incrementally from various sources
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Application Source Qualifier, Expressions, Filters, Joiners, Routers, Unconnected/ Connected Lookups, Sequence generator, Aggregators and Normalizer transformations.
• Tuned and monitored in Informatica workflows using Informatica workflow manager and workflow monitor tools.
• Used Informatica Power Exchange for Salesforce to replicate, synchronize data from one Salesforce to another salesforce and RDBMS tables.
• Developed unit test case documents and tested +ve and - ve scenarios.
• Extensively used Debugger on a valid mapping to figure out the problems in mappings before loading the data into data warehouse.
• Used parameters and variables at mapping and session levels to tune the performance of Mappings.
• Created mappings to load Dimension tables and Fact tables.
• Involved in Creating Star scheme mapping.
• Extensively used Version control to Check In and Check Out the objects
• UsedTeradatautilities(BTEQ, FASTLOAD, MULTILOAD, SQL Assistant) to load and export the data.
• Developed pre and post session commands based on the requirement.
• Extensively used workflow monitor to monitor the logs that generates for each session runs.
• Working as an offshore Team Coordinator.
• Involved in Agile Methodology.

Environment: s: Power Center 9.5, Salesforce.com, Flat files, Autosys, SOQL, KM (Knowledge Management),SQL, Teradata, TeradataSQL Assistant.

Confidential, New York, NY

ETL Developer

Responsibilities:

• Extensively used Informatica client tools like Source Analyzer, Target Designer, Mapping designer, Mapplet Designer and Transformation Developer, Workflow manager, workflow monitor.
• Interacted withtheBusinessAnalysts to get the business requirements and involved in preparation of the design documents and Mapping documents.
• Developed Mapplets and reusable Transformations
• Developed mappings, workflows to extract data from various sources like flat filesload them into different targets like data base and flat files.
• Developed complex mappings andSCDtype-I and Type-II mappings in Informaticato load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and Union transformations
• Tuned and monitored in Informatica workflows using Informatica workflow manager and workflow monitor tools.
• Used MD5 function To do inserts and updates instead of dynamic look up to improve performance
• Created the informatica partitions like round robin, pass through and key range partitions to improve the session performance.
• Unit tested the mapping by running SQL queries on source and target.
• Developed unit test case documents and tested +ve and - ve scenarios.
• Extensively used Debugger on a valid mapping to figure out the problems in mappings before loading the data into data warehouse.
• Used parameters and variables at mapping and session levels to tune the performance of Mappings.
• Calculated values in a single row by specifying input/output ports before writing to the target using Expression Transformation.
• Used push down optimization to improve the performance.
• Developed UNIX shell scripts for pre and post session commands based on the requirement.
• Extensively worked with the Informatica server that runs on UNIX platform and used workflow monitor to monitor the Informatica server and reviewed error logs that it generates for each session it runs.
• WinSCP/SSH tools used to securely copy/Edit files between a local computer system and a UNIX server.
• Involved in Agile Methodology

Environment: s: Power Center 9.0.1/9.1, UNIX, Shell Script, ORACLE 11g, TOAD, Flat files, Spread Sheets, winSCP 4.0, SSH, Putty, SQL and PL/SQL, Rally, Clear Case .

Confidential, Bloomington, IL

ETL Developer

Responsibilities:

• Extensively used Informatica client tools like Source Analyzer, Target Designer, Mapping designer, Mapplet Designer and Transformation Developer, Workflow manager, workflow monitor.
• Developed Mapplets and reusable Transformations
• Developed mappings, workflows to extract data from various sources like DB2, flat files, Spread Sheets andload them into different targets like Sql Server, UDBDB2 and flat files.
• Developed complex mappings andSCDtype-I and Type-II mappings in Informaticato load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
• Tuned and monitored in Informatica workflows using Informatica workflow manager and workflow monitor tools.
• Unit tested the mapping by running SQL queries on source and target.
• Extensively used Debugger on a valid mapping to figure out the problems in mappings before loading the data into data warehouse.
• Involved in preparing Design document and Mapping documents using MS-Visio.
• Extracting data from Flat files, DB2 and SQL server sources and transforming it in accordance with the Business logic.
• Used Pmcmd command in the UNIX shell scripts
• Used parameters and variables at mapping and session levels to tune the performance of Mappings.
• Calculated values in a single row by specifying input/output ports before writing to the target using Expression Transformation.
• Involved in extensive Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Extensively worked with the Informatica server that runs on UNIX platform and used workflow monitor to monitor the Informatica server and reviewed error logs that it generates for each session it runs.
• WinSCP/Ultra Edit tools used to securely copy/Edit files between a local computer system and a UNIX server.
• Involved in Agile Methodology

Environment: s: Power Center 8.6.1,Unix,SQL Server, IBM DB2 Control Center, Flat files, Spread Sheets, Control-M, WinSCP 4.0, Ultra edit, SQL, PL/SQL, Mainframe.

Confidential, New York, NY

ETL Developer

Responsibilities:

• Co-ordinatewith the Analysts and team lead to work on the business requirements.
• ETL Development using Informatica, and Unit testing.
• Involved in preparing Design document and Mapping documents.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Filter, Sequence Generator, Sorter, Stored Procedure, Update Strategy, Joiner and Rank transformations
• Extensively used Informatica client tools like Source Analyzer, Target Designer, Mapping designer, Mapplet Designer and Transformation Developer, Workflow manager, workflow monitor.
• Developed Mapplets and reusable Transformations
• Created sessions, configured workflows to extract data from various sources to loading into data warehouse.
• Developed mappings, workflows to extract data from various sources like oracle,flat files andload them into database.
• Extensively used Informatica debugger to figure out the problems in mappings
• Developed complex mappings andSCDtype-I and Type-II mappings in Informaticato load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
• Creating Mapping Parameters and Variables, useddis parameter files to load data for specific data loads e.g. between dates
• Tuned the Mappings to perform better using different logics to provide maximum efficiency and performance
• Involved in Agile Methodology
• Created email tasks for reporting the status to entire group.
• Developed Crystal Reports using Crystal Reports 2008.
• Developed UNIX shell scripts to generate trigger files.

Environment: Informatica Power Center 8.6, Oracle 11i, TOAD 9.5, Serena PVCS, SQL, PL/SQL, Crystal Reports 2008,Secure CRT 6.5, UNIX and Control M.

Confidential, NJ

ETL Developer

Responsibilities:

• Coordinated with Business Userstounderstand business needs and implement the same into a functional Data warehouse design.
• Developed various Mappings &Mapplets to load data from ODS using different transformations.
• Developed UNIX shell scripts.
• Developed reusable Mapplets and Transformations.
• Created and Monitored Batches and SessionsusingInformatica Work flow Manager.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter and Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Developed UNIX shell scripts to format the session log files and to extract the information from error logs.

Environment: Informatica Power Center 8.1, Business Objects xi, Oracle 9i, DB2, PL/SQL, SQL*Plus, UNIX, SecureCRT 6.2 and Control M.

Confidential, Plano, TX

ETL Developer

Responsibilities:

• Gatheird the system requirements and created mapping document which gives detail information about source to target mapping and business rules implementation.
• Designed, developed and debugged ETL mappings using Informaticadesigner tool.
• Created complex mappings using Aggregator, Expression, Joiner, Filter, Sequence, Procedure, Connected & Unconnected Lookup, Filter and Update Strategy transformations using Informatica Power center designer.
• Extensively used ETL to load data from different sources such as flat files to Oracle.
• Worked on mapping parameters and variables for the calculations done in aggregator transformation.
• Implemented slowly changing dimension for accessing the full history of accounts and transaction information.
• Tuned and monitored in Informatica workflows using Informatica workflow manager and workflow monitor tools.
• Created and configured workflows, worklets and sessions using Informatica workflow manager.

Environment: Informatica Power Exchange /Power Center 7.1, Business Objects 5.1, Windows 2000, Oracle 8i/7.6, DB2, Control-M, Puttyand TOAD.

Confidential, Dallas, TX

Informatica Developer

Responsibilities:

• Coordinated with the Analysts and team lead to work on the business requirements.
• Worked on compiling the Business Requirements document, Mapping Documents, Unit test cases.
• Created many ETLs as part of development and worked on various transformations like SourceQualifier, Expression, Aggregator, Lookups, Router, Filter, Update Strategy and many others.
• Used Task developer in the Workflow manager to define sessions
• Written design documentation for the ETL maps.
• Unit tested the maps by running SQL queries on source and target.
• Used heterogeneous files, flat files, Spreadsheets, Oracle views as sources
• Developed Interfaces using UNIX Shell Script to automate the bulk load&update Processes.
• Used different Data Warehouse techniques like Star-Schema.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Created and Scheduled Sessions based on demand, run on time, run only once using Informatica workflow Manager.

Environment: InformaticaPower Center 7.1.1, SQL, PL/SQL, SQL*Loader, Oracle 9i, Control-M, UNIXand Windows NT 4.0