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 noledge 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 teh source systems, thoroughly designing teh target by going through teh Functional Specification Document and one- to- one interaction.
• Clear noledge 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 teh 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 teh Data Marts and Data Warehouses, with Business Analyst in understanding teh business needs and interacting with other team members in completing teh 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:

• Gatheird requirements from business analysts for designing and development of teh system.
• Developed Transformation logic and designed various complex Mappings in teh Designer for data load and data cleansing.
• Assessed data to understand its quality challenges using data profiler.
• Created Mappings using Mapping Designer to load teh 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 teh history.
• Extensively used teh 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 teh 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 teh repository and inherit changes made to teh source automatically.
• Extensively performed Change Data Capture (CDC).
• Used teh Workflow manager to create workflows, worklets and sessions
• Created post-session and pre-session shell scripts and mail-notifications.
• Used debugger to test teh mapping and fixed teh 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 teh 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 teh 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 teh 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 teh data mart and monitored them. Teh mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator.
• Configured teh mappings to handle teh updates to preserve teh 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 teh 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 teh business processes into Informatica mappings for building teh datamart.
• Worked on SQL tools like TOAD to run SQL Queries to validate teh 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 teh end users and preparation of teh BRDs.
• Implemented ETL Informatica designs and processes for teh load of data from teh sources to teh target warehouse.
• Used all teh 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 teh scratch and also did performance tuning of teh 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 teh bottlenecks and fixing teh bottlenecks with performance tuning.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject teh items based on teh 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 teh 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 teh 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 teh 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 teh capturing delta loads.
• Worked with various tasks like Session, E-Mail, Workflows, Worklets, and Command
• Worked with teh Informatica Scheduler for scheduling teh delta loads and master loads
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in teh Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in teh Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in teh Joiner Transformation.
• Extensively worked with various re-usable tasks, workflows, Worklets, mapplets, and re-usable transformations.
• Implemented various new components like increasing teh 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 teh process at teh mapping level, session level, source level, and teh target level.
• Extensively used Mapplets for use in mappings theirby saving valuable design time and effort.
• Responsible for Production Support.
• Worked with teh 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 teh business intelligence team to in corporate any changes that they need in teh 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 teh corresponding delimiters to flat files according to teh 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 teh Slowly Changing Dimensions as per teh 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 teh Transformation Developer.
• Created Mapping Parameters and Variables.
• Involved in teh Debugging & Performance Tuning of teh 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 teh 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 teh 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 teh sessions.
• Used pmrep command to create backups, copy and delete repositories.
• Assisted teh 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 teh Project bid document for requirements, made many visits to BSNL offices (Switch centers) to understand teh present process in DOTSOFT system and took additional requirements from ITPC, created use cases for mapping teh requirements and involved in preparation of Provisioning SRS HLD documents, switch documents, mapping documents etc. Understood teh basic end-end business process flow of LANDLINE and PCO.
• Trained on Clarity System from Clarity Sydney team and involved in customization of teh tool according to project requirements. Configured teh 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 teh process activation of new subscriber and services on teh communications networks.
• Developed procedures and functions as per requirements and design which are used in production.
• Has visited different BSNL switch centers to get teh “line test “(Assurance) details and based on that XML’s are changed.
• Fixed code for teh 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.
• Gatheird requirements for each SSA from teh client (BSNL).
• Updated teh 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 teh 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 teh 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