SUMMARY

• Around 7 years of IT experience in Analysis, Design, Development and Testing of various business applications as an ETL developer with major contribution in Informatica Power Center.
• Extensive knowledge in Documenting, Developing and Implementing projects on various Domains.
• Experienced in Kimball Methodology - Dimensional Modeling, SCD (Slowly Changing Dimension) Types- 1, 2 and 3, Data Marts and Data Warehouses.
• Profound Knowledge in Informatica Power Center 9.1.0/9.0/8.5/8.1.2/7.1.3/6.2 Server and Client tools- Repository Manager, Designer (Source analyzer, Target designer, Transformation and Mapplet designer), Workflow Manager, Workflow Monitor.
• Experienced in analyzing Business and Functional requirements, studying the source systems, thoroughly designing the target by going through the Functional Specification Document and one- to- one interaction.
• Clear knowledge on OLTP and OLAP systems, developing Database schema - Star and Snow flake schema (Dimensions and Facts), E-R Modeling- Logical and Physical Modeling Concepts.
• Extensive usage of Reusable and Non reusable Transformations- Expression, Aggregator, Filter, Router, Normalizer, Sorter, Lookup- Unconnected and Connected, Update strategy, Sequence generator, Stored procedure, Joiner, and Java Transformations.
• Experienced in developing Complex Mappings, Mapplets (Re-usable Business Logic), Worklets, Tasks (Session, Command and Event wait), Workflows and Batch Processes.
• Implemented Pre-Session and Post-Session shell scripting to run workflows using pmcmd command.
• Extraction of data from Sources to Targets- Staging Area, Data Marts or Data Warehouses.
• Extensive use of Informatica Debugging in mappings and used Session Log File to trace the errors when loading into targets.
• Implemented Performance Tuning Techniques on Mappings, Session and Targets.
• Worked on Various RDBMS like SQL server, Oracle, DB2, Teradata, MS Access.
• Experienced in working with Tools- TOAD, SQL Developer and SQL Plus.
• Hands on experience in writing PL/SQL stored procedures, functions in Oracle 11g/10g/9i/8i and MS SQL Server 2000/2005.
• Worked closely with Architects when designing the Data Marts and Data Warehouses, with Business Analyst in understanding the business needs and interacting with other team members in completing the task as scheduled.
• Experienced in Scheduling Meetings with Business Users and Coordinating with offshore team.
• Strong Analytical skills, Excellent Presentation, Communication with Good Listening and Interpersonal Skills.

TECHNICAL SKILLS

Data Warehousing/ ETL: Informatica PowerCenter 9.1/9.0/8.6.1/ 8.5/8.1.2/ 7.1/ 6.2 , Power, Exchange/ Power Connect, SSIS, DTS, and Data Stage

Reporting Tools: Cognos, Data Reports, MS Access Reports

Databases & Tools: Oracle 11g/10g/9i/8i,DB2,SQL*Server 2008/2005,Sybase,Toad,Sql Developer

Scheduling Tools: Autosys, Tidal, Apex scheduler,Cron, Tivoli

Programming Languages: SQL, PL/SQL, TSQL, UNIX Shell Programming

Web Tools: HTML, ASP, JavaScript, .NET

Environment: UNIX, Win XP/NT 4.0

PROFESSIONAL EXPERIENCE

Confidential, NY

ETL Informatica Developer

Responsibilities:

• Gathered requirements from business analysts for designing and development of the system.
• Developed Transformation logic and designed various complex Mappings in the Designer for data load and data cleansing.
• Assessed data to understand its quality challenges using data profiler.
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Extensively used the capabilities of Power Center such as File List, pmcmd, Target Load Order, Constraint Based Loading, Concurrent Lookup Caches etc.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Data Quality Analysis to determine cleansing requirements.
• Used shortcuts (Global/Local) to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Extensively performed Change Data Capture (CDC).
• Used the Workflow manager to create workflows, worklets and sessions
• Created post-session and pre-session shell scripts and mail-notifications.
• Used debugger to test the mapping and fixed the bugs.
• Created Cron jobs to schedule sessions and workflows on UNIX.
• Scheduled various reports using Schedule Management tool/Event Studio.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Used Shell Scripts & Perl scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from the log files on Unix server.
• Documented Informatica mappings, design and validation rules.
• Used Oracle warehouse builder for loading data into Confidential inventory management system.

Environment: Informatica Power Center 9.1/ 8.6.1, Flat Files, Oracle 10g, Data Sync Utility, Toad 9.1, SQL, PL/SQL, and Shell Scripting

Confidential, TX

ETL Informatica Developer

Responsibilities:

• Gathering user requirements and source system analysis and establishing mappings between source to target attributes.
• Source data analysis, design & documentation.
• Parsed high-level design spec to simple ETL coding and mapping standards.
• Used Informatica designer for developing various mappings.
• Designed and developed ETL Mappings using Informatica to extract data from flat files and Oracle, and to load the data into target database.
• Created different source definitions to extract data from flat files and relational databases.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• Coded various complex business rules and complex queries using PL/SQL.
• Analyzed and fine-tuned PL/SQL scripts.
• Extracted data from various sources like Teradata and relational databases (Oracle).
• Created ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Developed ETL into data mart for phase-II data elements from staging.
• Worked with Informatica Power Mart client tools like Source Analyzer, Warehouse Designer and Mapping designer.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Used PMCMD/PMREP commands for running Informatica from backend.
• Migration of New and Changed Informatica objects across the environments using Folder to Folder and Deployment Group methods.
• Maintain warehouse metadata, naming standards and warehouse standards for future application development.
• Created PL/SQL procedures to populate base datamart aggregation structure.
• Used predefined shell scripts to run jobs and dataloads.
• Translated the business processes into Informatica mappings for building the datamart.
• Worked on SQL tools like TOAD to run SQL Queries to validate the data.
• Created, updated and maintained ETL technical documentation.

Environment: Informatica PowerCenter 8.5, Oracle10g, DB2, Trillium 7.6, PL/SQL, UNIX Shell Scripting, Erwin 4.5, Windows XP, AIX, Microsoft Visio, TOAD.

Confidential, NJ

DW Informatica Developer

Responsibilities:

• Requirement gathering from the end users and preparation of the BRDs.
• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse.
• Used all the Informatica client components like Designer, workflow Manger, Workflow Monitor, Repository Manger, and Repository Admin Console.
• Extensive hands-on experience working with Metadata Manager.
• Worked extensively with various Passive transformations in Informatica Power Center like Expression, Sequence Generator, and Lookup Transformation.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented.
• Extensively worked with SCDs slowly changing dimensions Type 1, Type 2, and Type 3.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs.
• Extensively used Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override.
• Developed Re usable Transformations, and Re Usable Mapplets.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject the items based on the requirement.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV environment.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Worked with third party versioning tool StarTeam for versioning.
• Worked with third party CA Autosys scheduling Team for scheduling the Informatica PowerCenter Workflows.

Environment: Informatica Power Center 8.1/7.1.4(Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Informatica Metadata Manager, Oracle 10g, SQL Server, Sybase, Access, Flat Files, Business Objects, AIX UNIX, Windows XP, CA Autosys Scheduler, StarTeam.

Confidential, Columbus, OH

DW Informatica Developer

Responsibilities:

• Design of ETL mappings for the CDC change data capture.
• Extensively used various transformations like Filter, Router, Sequence Generator, Look Ups, Update Strategy, Joiner, Source Qualifier, Expression, Sorter, and Aggregator.
• Extensively used Mapping Variables, Mapping Parameters, and Parameter Files for the capturing delta loads.
• Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Extensively worked with various re-usable tasks, workflows, Worklets, mapplets, and re-usable transformations.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency.
• Worked with slowly changing dimension Type1, Type2, and Type3.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Extensively used Mapplets for use in mappings thereby saving valuable design time and effort.
• Responsible for Production Support.
• Worked with the Business Intelligence tools like Business Objects and Crystal Reports.
• Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Worked with session logs, Informatica Debugger and Performance logs for error handling when we had workflows and session fails.
• Worked extensively with the business intelligence team to in corporate any changes that they need in the delivered files.

Environment: Informatica Power Center 7.1/6.2(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, SQL Server, CA Autosys, Teradata (T-Pump, Fast Load, Multi Load), Business Objects, UNIX, Windows XP, Autosys.

Confidential, Denver, CO

DW ETL Informatica Consultant

Responsibilities:

• Extracted data from sources like Oracle, Flat Files and XML and wrote shell scripts to add the corresponding delimiters to flat files according to the requirements.
• Designed and developed mappings using new features of Informatica 6.0 that include Sorter Transformation, Workflow Manager and Workflow Monitor.
• Created Source and Target Databases on Oracle 8i.
• Analyzed and Created Facts and Dimension Tables.
• Created Mappings between Source and Target using Power Center Designer.
• Involved in data cleansing.
• Exported and Imported sessions across Repositories with XML files.
• Implemented the Slowly Changing Dimensions as per the requirement.
• Designed and developed mappings that included Source Qualifier, Aggregator, Joiner, Lookup, Filter, Router Update Strategy, Expression and Sequence Generator transformations.
• Designed Reusable Transformations using the Transformation Developer.
• Created Mapping Parameters and Variables.
• Involved in the Debugging & Performance Tuning of the Informatica mappings.
• Developed Korn shell scripts for Informatica pre-session, post session scripts.
• Loaded data into relational target tables using External Loader utility of Informatica to increase the session performance.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Created and monitored Sessions and Batches using Informatica Server Manager.
• Used pmcmd command to schedule sessions and batches and to recover the sessions.
• Used pmrep command to create backups, copy and delete repositories.
• Assisted the BO reporting team in generating reports.

Environment: Oracle 10g, SQL, PL/SQL, PowerCenter 6.1, Import/Export utilities, XML, and Windows NT.

Confidential

Oracle Developer

Responsibilities:

• Had walk through the Project bid document for requirements, made many visits to BSNL offices (Switch centers) to understand the present process in DOTSOFT system and took additional requirements from ITPC, created use cases for mapping the requirements and involved in preparation of Provisioning SRS HLD documents, switch documents, mapping documents etc. Understood the basic end-end business process flow of LANDLINE and PCO.
• Trained on Clarity System from Clarity Sydney team and involved in customization of the tool according to project requirements. Configured the basic data and tested end to end order completion. Understood Roles and Grants of each screen and created users with roles by understanding BSNL’s workforce hierarchy.
• Developed MDD’s (Mediation Device Driver) for Network Elements like EWSD, AXE10, 5ESS,
• CDOT, OCB, E10B which enable the process activation of new subscriber and services on the communications networks.
• Developed procedures and functions as per requirements and design which are used in production.
• Has visited different BSNL switch centers to get the “line test “(Assurance) details and based on that XML’s are changed.
• Fixed code for the issues which are faced in production.
• Prepared checklists for GO-LIVE activities.
• Responsible for whole NORTH-WEST go-live activities with respect to activation module.
• Gathered requirements for each SSA from the client (BSNL).
• Updated the switches connectivity status before and after production.
• Responsible for dunning activity (North-west).
• Assigned work to team for continuous monitoring of switches and order flows.
• Provided solutions immediately to issues that rose as tickets.
• Changing the code as per new requirements.
• Designed and prepared test cases for all components involved in project.
• Performed UAT at client location of all tested modules.
• Prepared User manuals for the whole project with End to End process flow.
• Had given training sessions to Hyderabad BSNL people about front end, written Clarity Provisioning user manual by using TCS Techcom tips and template and same TEMPhas been published to client.

Environment: Clarity OSS/BSS tool, PL/SQL developer, XML, Putty