SUMMARY

• Seven Plus (7+) years of Total IT experience which includes Business Requirements Analysis, Data Modeling, Development, Implementations and Testing of Data Warehousing in various industries.
• Five Plus (5+) years of Data Warehousing experience using Informatica Power Center 9.0/8.6/8.1, Informatica Power Exchange 9.5, Informatica PowerMart Warehouse Designer, PowerConnect, PowerAnalyzer, Data Analyzer, ETL, Datamart, OLAP, OLTP,
• Experience in Real time processing using Power Exchange
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Proficiency in using Informatica PowerCenter tool to design data conversions from wide variety of 3sources
• Strong in Data warehousing concepts, Star Schema and Snowflakes Schema methodologies
• Extensively worked with large Databases in Development / Production environments.
• Proficient in using Informatica workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
• Performance tuning of the Informatica and Databases
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Proficient in understanding business processes / requirements and translating them into technical requirements.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Seven Plus (7+) years of database experience using Oracle 11g/10g/9i, SQL Server 2010
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Extensively worked with SQL Loader for bulk loading into the oracle database.
• Experience in complete life- cycle of Test case design, Test plans, Test execution, Defect Management.
• Experience in UNIX Operating System and Shell scripting
• Outstanding skills in analyzing business process and end-user needs, detail oriented and committed to delivering superior quality work.
• Excellent problem solving, communication, leadership, analytical and interpersonal skills working independently or as part of a team

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.2/9.0/8.6/8.1 , Informatica Power Mart Warehouse Designer, Power Connect, Power Analyzer, Data Analyzer, ETL, Datamart, OLAP, OLTP, Maestro, Control-M

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 7.2/6.1

Databases: Oracle 11g/10g/9i / PL/SQL Developer 10.2

Programming: TOAD, SQL, PL/SQL, Unix Shell Scripting

Environment: Sun Solaris, HP-UX, IBM AIX, Unix HP

PROFESSIONAL EXPERIENCE

Confidential

Sr. Informatica Developer

RESPONSIBILITIES:

• UAT high priority defects analysis and fixation.
• Analysis the existing code to come up with solution on existing issue.
• Find out the cause of defect and fix.
• Worked in development,Uat and Production environment.
• Create detail design document for all the defects.
• Create Unit Test Template.
• Worked from source to downstream extract.
• Used various Informatica Error handling techniques to debug failed session.
• Performance tuning for optimum performance.
• Handled Users, Data Security issues and automation of schedules and sessions.
• Worked on different types of products like: Shares, Equity, Bonds, Options etc.
• Worked closely with DBA team to tune the performance of the Database.
• Designed, Developed, Deployed and implemented ETL mappings using Informatica
• Migrated code one environment to another through SVN Process.
• Worked on data validation.
• Did design and code reviews for the EDW Production Support project
• Interacting with client to understand the requirement and explain them to downstream impact of fix the issue
• Tune SQL Query using explain plans, hints, indexes, and partitions.
• Extensively worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank, Union, Joiner, Source Qualifier, etc.,
• Assisted in handling production support issues.

Confidential

INFORMATICA DEVELOPER

RESPONSIBILITIES:

• Experience in Real time processing using Power Exchange.
• UAT high priority defects analysis and fixation
• Designed and developed Oracle PL/SQL Procedures and wrote SQL, PL/SQL scripts code for extracting data to system.
• Used various Informatica Error handling techniques to debug failed session.
• Used Informatica scheduler for scheduling the jobs.
• Performance tuning for optimum performance.
• Handled Users, Data Security issues and automation of schedules and sessions.
• Worked with staging area to perform data cleansing, data filtering and data standardization process.
• Worked closely with DBA team to tune the performance of the Database.
• Designed, Developed, Deployed and implemented ETL mappings using Informatica
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Worked with Informatica PowerCenter -Source Analyzer, Warehousing designer, Mapping Designer & Mapplet and Transformation Developer for creating Mappings.
• Used Informatica Workflow Manager for creating, running the Workflows and Sessions and scheduling them to run at specified time.
• Write stored procedures, functions, and packages.
• Designed the Mapping Design documents and the Deployment Documents.
• Used various partitioning schemes in order to improve the overall session performances.
• Worked on the performance tuning of databases (dropping & re-building indexes, partitioning on tables)
• Involved in developing UNIX shell script to invoke the workflows and Informatica batches including the pre and post analysis.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy
• Used transformation Logic to cleanse the data.
• Extensively worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank, Union, Joiner, Source Qualifier, etc.,
• Developed slowly changing dimensions mapping to accommodate the passive mode phase.
• Developing number of Complex Informatica Mappings, Mapplets and Reusable Transformations for weekly Loading of Data.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Worked with Informatica PowerCenter -Source Analyzer, Warehousing designer, Mapping Designer & Mapplet and Transformation Developer for creating Mappings.
• Used Informatica Workflow Manager for creating, running the Workflows and Sessions and scheduling them to run at specified time.
• Write automated script for DATA VALIDAION in plsql
• Created UNIX scripts to automate the activities like start, stop, and abort the informatica workflows by using PMCMD command in it.

Confidential

INFORMATICA DEVELOPER

RESPONSIBILITIES:

• Understand the overall functional architecture of pending orders process & Coordinated with IM Business group to gather functional & business requirements.
• Developed Logical and Physical Data Model using Erwin followed Star Schema to build the Datamart.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Extracting the data from different sources that involved flat files, XML, Oracle, MS SQL Server relational tables.
• Used different transformations for Extraction/Transformation, data cleansing and loading data into staging areas and Presentation Tables.
• Worked with workflow Manager and workflow monitor to schedule batches and run the workflow and monitor session logs.
• Effectively tuned the performance of Informatica Transformations, mappings, sessions and workflows.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Extensively designed Data mapping using filters, Expression, Update Strategy Transformations in Power Center Designer.
• Created target load order group mappings and scheduled them for Daily Loads.
• Preparation of Unit Test Plans and verification of functional specifications and review of deliverables.
• Migrated Mappings, Sessions, Workflows and Common Objects from Development to Test and to Production.
• Wrote Unix Scripts and SQL Commands to test and analyze the data
• Extensively used UNIX commands within Informatica for Pre Session and Post Session Data Loading Process.
• Used Informatica scheduler for scheduling the jobs.
• Assisted in handling production support issues.
• Did design and code reviews for the EDW Production Support project
• Developed QA/QC processes using shell scripts to help identify data quality issues prior to production load and provide pre-processed data source
• Extensive use of Informatica metadata manager for data lineage and where-used analysis, metadata browsing, metadata reporting & metadata document.
• Performed various testing processes unit testing, end to end test, and regression testing
• Prepared Production stage, Production install turnover documents describing program development, logic, testing, changes & corrections.
• Extensively worked with production support and end user team in migrating, promoting and data validation in production servers.

Environment: Informatica Power Center 9.0 (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Oracle 11g, SQL Server 2010 (Enterprise Manager, Query Analyzer), Maestro, SQL, Visio, Erwin, UNIX, Maestro

Confidential

INFORMATICA DEVELOPER

RESPONSIBILITIES:

• Analyzed the business systems, gathered requirements from the users and documented business needs for decision support data.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Created the (ER) Entity Relationship diagrams & maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Prepared technical documentation to map source to target.
• Designed, Developed, Deployed and implemented ETL mappings using Informatica
• Migrated Workflows, Mappings, and other repository objects from Development to QA and then to production.
• Responsible for performance tuning at all levels of the Data warehouse.
• Created Informatica sessions in workflow manager to load the data from staging to Target database.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Using Aggregator transformation calculated SUM, AVG of monthly sales for different products.
• Created different target schemas for Staging and Data Mart.
• Designed the Mapping Design documents and the Deployment Documents.
• Designed and Developed several mappings to Load the Dimensions and the fact tables.
• Created Informatica mappings to extract data from sources and staged in Oracle and populated the warehouse
• Created sessions and workflows for processing and to populate the dimensions and facts in the star schema.
• Extensively used various transformations like XML, Union, Expression, Filter, Aggregator, Lookup and Router Transformations.
• Generated XML files as target to load into the vendor customized application to generate the reports.
• Implemented Slowly Changing Dimensions Type1, Type 2.
• Worked with various look-up caches.
• Worked with connected and unconnected look-up for implementing complex logic.
• Used key range partitioning, hash partitioning for performance tuning.
• Identified the bottle necks and tuned the mappings and sessions to improve performance.
• Created sessions and workflows for processing and to populate the dimensions and facts in the star schema.
• Developed Shell Scripts for event automation and scheduling
• Worked closely with DBA team to tune the performance of the Database.
• Analyzed IMS data for Sales & Marketing analysis and reporting.
• Write stored procedures, functions, and triggers.
• Validate packages and investigate performance issues.
• Tune code packages using explain plans, hints, indexes, and partitions.
• Used Maestro for scheduling jobs.
• Designing ETL strategy for both Initial and Incremental & CDC Loads.
• Responsible for writing procedures drop and create partitions of large volume tables for the archival process.
• Developed unit test cases and ensured that the results are right before moving to QA and Production.
• Designed and developed Oracle PL/SQL Procedures and wrote SQL, PL/SQL scripts code for extracting data to system
• Performed integration testing for various mappings. Tested the data and data integrity among various sources and targets.

Environment: Informatica PowerCenter 9.0, ETL, Erwin 7.2, Flat files, Oracle 11g, FirstLogic, MS SQL Server 2008, PL/SQL, Maestro, IMS Data (Xponent, Xponent Plantrak, DDD), Shell Programming, SQL * Loader, XML, Toad, Excel and Unix scripting, Unix, Windows NT

Confidential

INFORMATICA DEVELOPER

RESPONSIBILITIES:

• Gathered requirements from the end users and Involved in analysis of source systems, business requirements and identification of business rules.
• Data Warehouse Data modeling based on the client requirement using Erwin (Conceptual, Logical and Physical Data Modeling)
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Provides strategic thinking, leadership pertaining to new ways of leveraging information to improve business processes.
• Experienced in database design, data analysis, development, SQL performance tuning, data warehousing ETL process and data conversions.
• Based on the logic, developed various mappings & mapplets to load data from various sources using different transformations like Source Qualifier, Expression, Filter, Normalizer, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner in the mapping.
• Also developed Error Processing to capture the error records and loads them into Mesg Log table.
• Worked with Stored Procedure Transformation for time zone conversions.
• Created UNIX scripts to automate the activities like start, stop, and abort the informatica workflows by using PMCMD command in it.
• Fine tuned the mappings by analyzing data flow and Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Lookup, Joiner and aggregator transformations.
• Provided production support including error handling and validation of mappings.
• Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Used various Informatica Error handling techniques to debug failed session.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data.
• Responsible for migrating the folders or mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Proactive team player with the demonstrated ability to multi-task and prioritize in a fast-paced professional environment.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Designed testing procedures and test plans. Provided Production support
• Worked with HIPAA Transactions and EDI transaction sets

Environment: Informatica PowerCenter 8.5, Oracle 10g, Flat Files, CSV files, PL/SQL, Erwin 6.1, MS Visio, SQL Developer, SQL*Plus, TOAD, Windows 2008, UNIX, HIPAA

Confidential

DW DATABASE DEVELOPER / ETL DEVELOPER

Responsibilities:

• Migrated large volumes of data from legacy systems to Oracle database.
• Extensively used SQL Loader for Data loading
• Enhancements and Functional Specifications.
• Consolidation, Cleansing, Integration, and customization of data
• Optimized Query Performance, Session Performance and Reliability.
• Created complex procedures.
• Database connectivity was done using ODBC.
• Preparation of Unit Test Plans.
• Verification of functional specifications and review of deliverables.
• Complex SQL queries were used for data retrieval.
• Involved in Data Modeling using Erwin.
• Developed Packages, Procedures and function to maintain the Business logic using PL/SQL.
• Creating Database objects including Tables, Indexes, Views, Sequences, Synonyms and granting Roles, and Privileges to the system users.
• Creating sql scripts for deployment of database objects on Production.
• Involved in fine tuning of sql query to achieve good performance.
• Formally trained in DW / BI Methodologies and formally trained in Informatica.

Environment: Oracle 10g, PL/SQL, HTML, JavaScript, Informatica 8.1, SQL