Professional Summary

• Over 10 years of total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling and Data Quality, Data Profiling, Development, testing and documentation.
• 8 years of extensive experience in Information Technology with special emphasis on Design and Development of Data Warehousing using Informatica Power Center 9.1/9.0.1/8.6 / 8.5 / 8.1.1 / 7.1.1 / 7.1.2 / 7.0 / 6.1.2 / 5.1.1
• Over 5 years of Extensive experience in developing ETL solutions using Informatica Power Center
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, DB2
• Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data and load to Oracle database.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and worked on integrating data from flat files like fixed width and delimited
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center
• Performed various kinds of testing like Integration, Unit and User Acceptance testing.
• In-depth understanding of Star Schema, Snow Flake Schema, Normalization, 1st NF, 2nd NF, 3rd NF, Fact tables, Dimension tables.
• Experience in SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• Extensively used SQL statements while performing ETL process and applied Query.
• Experience in working with scheduling tools like Autosys.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations
• Strong Experience in developing Sessions/Tasks, Worklets, Workflows using Workflow Manager tools - Task Developer, Workflow Worklet Designer
• Experience in using the Informatica command line utilities like pmcmd to execute Workflows in non-windows environment
• Extensively used Informatica Repository Manager and Workflow Monitor
• Experience in debugging mappings Identified bugs in existing mappings by analyzing the data flow and evaluating transformations
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow
• Strong knowledge in optimizing database performance
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments
• Exposure to OBIEE Concepts.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member with excellent Verbal and Communication Skills and clear understanding of Business procedures

Technical Skills

Professional Experience

Responsibilities:

• Liaising with Users and Technical team to convert business requirements into Technical Specifications.
• Analyze the requirements and create the High-level, detailed design document.
• Participate in creating application architecture document.
• Working with business to get the requirements and prepare requirements documents as per VMware standards.
• Developed and implemented data migration and upgrade procedures.
• Created design documents, mappings specification and unit test cases as per the requirements.
• Extracted data from excel files ,high volume of data sets from data files, Oracle, SalesForce.com SFDC using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area
• Closely work with Insight Analytics team to provide strategic data through Informatica for business reports.
• Worked with delimited and fixed with flat files and load data into Salesforce.com using direct and indirect methods.
• Extracted data from Salesforce.com SFDC ,Oracle,excel ,data files using Informatica ETL mappings/SQL PLSQL scripts
• Extensively used Salesforce Bulk API to load 10 million of customers in less than 6 hours.
• Used pass through partitioning to improve the job runtime during data normalization.
• Extensively worked with different transformations such as Aggregator, Expression, Router, Filter, Lookup, and Sorter.
• Extensively used Normalizer transformation with 140 occurrences.
• Created reusable mapplets and transformation.
• Created user defined function and called them in multiple mappings.
• Used mapping variables to remove the duplicates based on certain fields.
• Experienced in handling data migration and code deployment using Data loader and Eclipse respectively in SFDC environments.
• Created command tasks to invoke Unix scripts from Informatica.
• Worked with Workflow variables to pass the values to the command task rather passing hard coded value.
• Used Upsert operation in Informatica to load data into salesforce.com using unique external id.
• Created Unix scripts to invoke the jobs using pmcmd and automated them with scheduling tool AUTOSYS.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Maintaining all Informatica servers and performing all Informatica Administration tasks such as taking back up of Repository, Domain and user privileges activities.
• Deploys the code from DEV to UAT and then to PROD using Informatica deployment groups.

Environment: Informatica PowerCenter 9.0.1, Oracle10g, Toad10, PowerExchange for Salesforce.com with Bulk API, Oracle

Responsibilities:

• Worked with heterogeneous sources including relational sources and flat files.
• Work with Data Modeler and Data Architect to understand the Architecture of Data warehouse and the mapping Documents.
• Design mappings based upon the complex business logic provided by data modeler, which includes Dimensions and Fact Tables.
• Designed complex mapping logic to implement SCD1 and SCD2 dimensions.
• Interacting with the Front end users to present the proof of concept and to gather the deliverables of the team.
• Doing research work to resolve production issues and data discard during workflow runs.
• Extract the data from relational source VCMG Oracle , flat files and perform mappings based on company
• requirements and load into Oracle tables.
• Used lookup transformation Static as well as Dynamic , aggregator transformations, Update Strategy, Filter and Router Transformations.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE inTransformations.
• Also used Used-defined Function, which declared once globally and used in various mappings.
• Working extensively on Informatica Designer, workflow manager to create, sessions, workflows and monitor the results and validate them according to the requirement.
• Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance.
• Used Informatica Workflow to create, schedule, monitor and send the messages in case of process failures.
• Involved in Performance Tuning of sources, targets, mappings, sessions and data loads by increasing data cache size, sequence buffer length and target based commit interval.
• Tested the target data against the source system tables by writing the SQL queries and documented the results In the excel sheet.

• Create Mapping that Generate Parameter file and load log.
• Migrate mappings and workflows from development to QA, QA to UAT and from UAT to production.
• Unit tested Informatica Objects to check the errors and made appropriate changes in the objects to generate therequired results.
• Prepared ETL low level and high level design documents.
• Documenting the ETL mapping strategies and transformations involved in the extraction, transformation and loading process
• Interact with various business users of VCMG in order to understand concept and Business Logic.

Environment: Informatica Power Center 9.1, Oracle 10g, Toad 10, SQL/PLSQL, WinSCP, Putty, UNIX, Windows NT.

Responsibilities:

• Interacted with Business Analyst to understand requirements and translated them into the appropriate technical solution.
• Designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Extensively used ETL to load data from wide range of sources such as flat files and legacy systems.
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Version 8.6.
• Performance tuning has been done to increase the through put for both mapping and session level.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data
• Created various shell scripting using UNIX.
• Provide off-hours on-call support every 3 weeks, or on as needed basis.
• Developed various mappings using Lookup, Normalizer, Router, Expression, update strategy etc to load the required data
• Created Technical design specification documents based on the functional design documents and the physical data model
• Developed mappings to extract data from Oracle, Flat files and load into Data warehouse using the Mapping Designer
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse
• Involved in design and development of data warehouse environment, liaison to business users and/or technical
• teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation
• Involved in the Migration process from Development, Test and Production Environments
• Used SQL tools like TOAD to run SQL queries and validate the data
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data
• Developed shell scripts, for creating/dropping of table and indexes of performance for pre and post session management
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows
• Identified sources, targets, mappings and sessions and tuned them to improve performance

Environment: Informatica PowerCenter 8.6.1/9.1, Oracle 10g, Flat Files, Erwin, SQL, PL/SQL, Oracle Linux 5, Windows XP, SQL Loader.

Responsibilities:

• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets Parameter files in Mapping Designer.
• Developing workflows with Worklets, event waits, conditional flows, email, and command tasks using Workflow manager and monitored them in Workflow monitor.
• Reusing the single workflow for loading data from various regions' files with similar file structure using indirect loading as source type in session properties.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, PowerCenter transformations and sessions using techniques like Explain plans, Oracle hints re-designing the mappings. Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Creating and scheduling the PL/SQL Reconciliation Scripts of Oracle for checking validity of the data in the DWH.
• Used Mapplets, Reusable transformations, Parameters and Variables to facilitate the reusability of Code.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed processes for automation of loading data using parameter driven sessions for various workflows, verification and re-conciliation of data stored in several different source systems.
• Configured and scheduled Pre and Post Session commands with Shell Scripts and called them using command task.
• Used TOAD to run SQL queries and validate the data in warehouse.
• Extensively used command, event-wait, event-raise and control tasks for keeping track of events in the ETL process.
• Created UNIX shell script to FTP flat files from different ordering systems to the ETL server.
• Fine tuned the performance of ETL processes.
• Involved in the upgrade from Informatica Power center 8.6.1 to Informatica Power center 9.1.
• Wrote stored procedures for generating the data warehouse cycle dates and to drop, re-create the indexes.
• Developed Test Cases according to Business and Technical Requirements and prepared SQL scripts to test data.
• Performed unit test for Informatica mappings and workflows in both development and test environments.
• Used Incremental aggregation to capture new source data and in scenarios where the incremental changes do not significantly change the target so that the PowerCenter server updates the target incrementally.

Environment: Informatica PowerCenter 8.6.1/9.1, Oracle 10g, Flat Files, Erwin, SQL, PL/SQL, Oracle Linux 5, Windows XP, SQL Loader.