SUMMARY

• 7 years of IT experience with strong background in Application development, Maintenance, Analysis, Design, Enhancement, Implementation of Data warehouse Technologies.
• Experience in integration of various data sources likeOracle, MS excel andnon - relational sources likeflat filesinto staging area.
• Experience in creatingReusable Transformations andMappings usingInformatica Designerand creatingReusable TasksandNon-Reusable Tasksand processing tasks usingWorkflow Manager.
• Extensively worked on developing and debugging Informatica mappings, sessions and workflows and tuned mappings using Power Center Designer and used different logic to provide maximum efficiency and performance.
• Experience in direct and indirect file loading and designing, implementing and reviewing Informatica work products like mapplets, worklets, schedulers and experience in using mapping parameters, mapping variables and session parameter files.
• Strong understanding of Dimensional Modeling, Star, Snow flake Schema, Fact and Dimensional tables and DW concepts.
• Experience in writing, testing and implementation of the PL/SQL code like triggers, stored procedures, functions, packages and Materialized views.
• Experienced in Informatica admin activities like creating domain, node and those properties and start/stop informatica services, creating and managing users and groups using admin console or using Unix environment.
• Experienced inUNIX shell scripting, job schedulingand error handling, FTP and file management in variousUNIXwork environment.
• Experienced inPerl scripts to run the orchestration of different environments as tasks in informatica workflow.
• Using informatica, Transfer or deploy the developed code from development environment to different environments like test and production.
• Experienced in different types of test cycles like Unit testing, Integration testing, Regression testing, User Acceptance Testing (UAT)and implementing the respective modifications and fixing the issues.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase
• Extensive functional and technical exposure. Experience working on high-visibility projects
• Excellent analytical/ communication skills and good team player

TECHNICAL SKILLS

Databases: Oracle 11g/10g

ETL Tools: Informatica 9.x/8.x/7.x (Power Center), Siperian MDM

OLAP Tools: Business objects

Languages: SQL, PL/SQL, Perl, Unix Shell Script

Data Modeling: Erwin 4.1, Star-Schema Modeling, Fact & Dimensions

Tools: Toad, SQL* Plus, Putty

Operating Systems: Windows 7, Unix

Job Monitoring Tools: TWS (Tivoli workflow scheduler), Power center Monitor

Ticketing Tools (IM & CM): Service Manager 9 (HP)

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

ETL Senior Specialist

Responsibilities:

• Defining the specifications and designing the data models, based on business requirements.
• Designing the ETL code using Informatica, modifying the data using different transformations to modify the data into a specific format in designer and load extracted CVSdata into Database.
• Developed various mappings using the transformations such as the expression, Lookup, Filter, Sorter, Router, Aggregator, Normalizer, Joiner, Update strategyetc. And perform performance tuning.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Extensively used Toad for SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Designed the custom error control logic with in the pipeline to capture and load the bad records to a control table.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created deployment groups, migrated the code into different informatica environments (Test, staging, production).
• Written documentation to describe program development, logic, coding, testing, changes and corrections and enhancements.
• Followed Informatica recommendations, methodologies and best practices.
• Validation of developed code with data using unit testing and integration testing and non-regression testing independently.
• Implementing the code for new countries of existing clients and maintenance of respective jobs.
• Scheduling the workflows by weekly/monthly loads using orchestration process, which is developed in Perl code.
• Writing SQL, PL/SQL codes, stored procedures, functions, triggers, packages.
• Involved in the Defect analysis call for UAT environment along with users to understand the data and to make any modifications if suggested by the user.
• Prepared Perl scripts to email the Job failure notice with error message and count of records that do not satisfy the business rules (Error Records).
• Supported the applications in QA Phase and provided solutions for failed jobs.
• Involved in production activities to make sure all issues are fixed in the respective turn-around times.

Environment: Informatica Power Center 9.5, Oracle 10/11g, Toad, PL/SQL, Perl, UNIX, Windows, Putty.

Confidential, Cambridge, MA

Senior ETL Developer

Responsibilities:

• Involved in requirement gathering and analysis of source data as data comes in from different Source systems.
• Designing the landing and staging data models, based on business requirements.
• Designing the ETL code using Informatica, Cleansing the data using different transformations in designer to load extracted customer data into landing tables.
• Data integrity between the various source tables and relationships.
• Check for missing data, negatives and consistency. Field-by-Field data verification can be done to check the consistency of source and target data.
• Development of ETL code using Informatica 8.6 power center designer tools.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Prepared the error handling document to maintain the Error handling process (Error code and error table information).
• Validation of developed code with data using unit testing.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Worked Oracle SQL Developer to develop PL/SQL codes, stored procedures, functions, triggers, packages in Oracle.
• Developed the mappings in Siperian using cleanse functions.

Environment: Informatica Power Center 8.6, Oracle 10/11g, PL/SQL, SQL navigator, Windows XP, Siperian.

Confidential, Philadelphia, PA

Senior Developer

Responsibilities:

• Developed ETL procedures to translate business rules and functionality requirements into business logic, ensuring lack of redundancy and compliance with standards.
• Used transformations such as the source qualifier, aggregators, connected & unconnected lookups, filters, sorter, stored procedures, router & sequence generator.
• Developed Reusable Mapplets and Transformations for standard business calculations.
• Extensively used various Performance tuning Techniques to improve the session performance.
• Improved workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Created events, decision and tasks in the work flows using workflow manager.
• Implemented performance tuning by using lookup caches, using tables with fewer rows as the master table in joiner transformations, dropped indexes and re-created them after loading data to targets and increased the commit interval.
• Executed sessions, sequential and concurrent batches for proper execution of mappings.
• Executed Pre and Post session commands on Source and Target database using Shell Scripting.
• Scheduled Sessions to update the target data using workflow Manager of Informatica and Involved in test case preparation.

Environment: Informatica Power Center 8.6, Oracle 9i, SQL Server 2000/2008, benthic SQL plus, Windows XP/NT, Putty.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Analyze the specification provided by the client
• Performed Data Cleansing operations on the jobs using data cleansing functions.
• Data loading using INFORMARICA Power center Designer
• Worked on several transformations such as Filter Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations, Expression Transformations in mapping Designer & creating the reusable transformations, designing the reusable mappings in Informatica.
• Performed Unit Testing for developed code.
• Handled the change request and the coding related issues in Oracle 9i in various modules.
• As a part of analysis team involved in various critical analysis of sales data of Confidential Sales.

Environment: Oracle 9i, Business objects XI, Informatica Power Center 7.1 client tools, Windows NT.