Summary:

• Over 7.5 years of IT experience in Data Warehouse development and Business Intelligence projects.
• 6.5 years of experience as an ETL Developer analyst using Informatica Power Center 9.1/8.x/7.1 as ETL tool.
• 7.5 years of hands on experience in various databases like Oracle, SQL Server, Teradata, DB2
• 3.5 years of experience on real-time Data Warehouse development using CDC tool Informatica PowerExchange 9.1/8.6.
• Experience in Change Data Capture CDC Methodology using Power Exchange.
• Experience in analyzing the Dimensional data modeling, Star/snowflake Schema modeling.
• Extensive experience in Extraction, Transformation and Loading of dimension tables and Fact tables from relational database source Oracle and flat files.
• Experienced in integration of various data sources like Oracle11g/10g/9i, IBM DB2, MS SQL Server 2005/2000, XML, flat files into staging area.
• Worked on non-relational sources like flatfiles and used secure FTP.
• Worked on Oracle PL/SQL programming, stored procedures, creating triggers, sequence generator on the target tables.
• Experience in UNIX shell scripting.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Working knowledge of Oracle SQL and PL/SQL Packages, Procedures etc.
• Experience in preparing ETL design documentations, user test case documentation and standard operating procedures SOP documentation.
• Excellent communication skills, technically competent and result oriented with strong problem solving skills.
• Worked on Teradata query, utilities like FLOAD, FEXPORT, MLOAD and TPump, created procedures, Macro and Tuning.
• Worked in a team environment consisting of technology and business professionals.
• Very good team player and can integrate into any functional, technical environment and deliver quality results applying best practices in the industry.
• Excellent verbal and communication skills clear understanding of business procedures and ability to work as an individual as well as part of a team.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications.
• Involved in multiple data warehouse projects where I acted as the Informatica lead.

Technical Skills:

• ETL Tools: Informatica PowerCenter 9.5/9.1/8.6/8.1/7.1, PowerExchange 9.1/8.6/8.1, Informatica cloud.
• BI Tools: BO XI R2
• Operating systems: AIX, Sun Solaris, Linux, Windows 2007/XP/98.
• Programming Languages: SQL, PL/SQL, UNIX Shell scripting, C, C , Visual Basic 6.0, .Net
• Databases: Oracle 11g/10g/9i, SQL Server 2008/2000, DB2, Teradata 13/V2R5
• Database tools: SQL Loader, Toad, SQL Developer
• Data modeling tool: MS Visio, Erwin 8.5/7.1
• Scheduler Tool: Autosys, ESP
• Applications: MS Office, MS Project, Lotus Notes, TFS and Salesforce

PROFFESSIONAL EXPRERIENCE:

Confidential

Sr. INFORMATICA DEVELOPER

Confidential involved consolidating the data from various data sources involving Policy, Billing, Agents and HR related information. This data came from different sources, which included databases such as Oracle, MS SQL Server, flat files and BDW. The Project mainly involved working with data quality, data analysis, building data warehouse and production support of the ODS system

Responsibilities:

• Interacted with functional analysts to understand requirements and involved in preparing high-level design documents.
• Working with the team for process improvement and release planning.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Extensively used ETL to transfer data from source files and load the data into the target database.
• Extracted the data from the flat files into staging area and populated onto Data Warehouse.
• Prepared Low Level Design LLD documents as per the business requirements.
• Developed Mappings Workflows as per Business logic, quality and coding standards prescribed for the module.
• Data Quality Analysis to determine cleansing requirements. Responsible for populating the business rules using mappings. Understand the business needs and implement the same into a functional database design.
• Developed number of complex mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally
• Handled slowly changing dimensions of Type1, Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Various kinds of the transformations were used to implement simple and complex business logic.
• Documented Mappings, sessions and workflows for further maintenance and support.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
• Prepared Unit Test Plan UTP documents for all the test cases for the developed mappings.
• Working with release management team to move the mapping from lower environment to upper environment.
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Analyzed application data using the SQL to identify the ETL processes
• Worked with data analysts to implement Informatica mappings and workflows, shellscripts, SQL Queries and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Responsible for creating complete test cases, test plans, test data and reporting status ensuring accurate coverage of requirements and business processes.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting.
• Extensively used Quality Center for documenting, organizing and tracking requirements.

Environment: Informatica Power Center 9.5, Informatica cloud, Salesforce, Unix Shell scripting, Oracle 10g, SQL, PLSQL, flat files, WinSCP, CITRIX, HP Quality Center, Putty, TFS.

Confidential

Sr. INFORMATICA DEVELOPER

Description: The main goal of the project is to build Data Warehouse and Data Marts. Customer datamart is one of their major data warehousing applications that extracts data from various operational systems and loads into data warehouse.

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the business community.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Designed and developed many simple as well as Complex Mappings, various transformation logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Designed the ETL processes using Informatica tool to load data from File system and Oracle into the target Oracle Database.
• Involved in identifying the sources for various dimensions and facts for different data marts according to star schema design pattern.
• Developed various reusable Informatica components like reusable transformation, mapplets, sessions.
• Responsible for Performance Tuning at the Source, Target, Mapping and Session Level.
• Extensively used both Connected and Unconnected Lookup Transformations. Developed slowly changing dimension, according to the data mart schemas.
• Developed multiple Workflows using workflow manager for initial loading, historical data loading using sessions, worklets, commands, decisions, events and timers.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter.
• Extracted and loaded data from heterogeneous sources and targets like XMLs, Flat file, .csv and Relational targets.
• Extensively worked on XML sources, targets and JMS queue.
• Used Informatica user defined functions to reduce the code dependency.
• Used debugger to track the path of the source data and also to check the errors in the mapping.
• Performing ETL database code migrations across environments.
• Provided production support by running the jobs and fixing the bugs.
• Aided in migrating the code across various environments.
• Worked on test cases and test plans.
• Documented the process for further maintenance and production support.

Environment: Informatica Power Center 9.1, Power Exchange 9.1, Unix Shell scripting, Oracle 11g, SQL, PLSQL, flat files, WinSCP, DB2 Mainframe, SCM, SQL Server 2008, XML.

Confidential

Sr. INFORMATICA DEVELOPER

Description: The Project mainly involved working with data quality, data analysis, building data warehouse and production support of the various client systems.

Responsibilities:

• Prepared the ETL design documentations and Unit test case.
• Developed mappings to extract data from flat files into staging tables and from the staging area to the dimension tables and fact table.
• Implemented Slowly Changing Dimensions - Type I II in different mappings as per the requirements.
• Error handling is done by validating the records and bifurcating the data into valid/invalid records and loading the erroneous records into the error table. Used SQLT to update the status of the records in the error log table when valid records are received from the source system.
• Designed and developed process for Audit table, which is used in the mappings to capture the run statistics.
• Worked on the UNIX shell scripts to create job to run the workflows by scheduler.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Expert in tune code using partitioning like round robin, hash auto key, key range partitioning and caching at mapping and session level.
• Extensively used Power Exchange to create datamaps, registration to connect to Mainframe.
• Created restart token, Warm and cold start wrapper, recovery process and configured real-time Informatica workflows.
• Maintain Development, Test and Production mapping, migration using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Review Informatica code, PL/SQL code and UTC docs.
• Performed Unit testing and validated the data.
• Worked on the System integrated testing and supported the IST and UAT phases of the project.
• Interacted with upstream and business partners in providing feedback and recommendations for system testing and additional requirements.
• Supported clients through testing, troubleshooting and deployment of the solution.
• Involved in production support and resolving environment and report issues proactively.
• Tracing heat tickets and maintain knowledge database for that to resolve issues quickly in future.

Environment: Informatica Power center 8.6, Informatica PowerExchange 8.6, Oracle 11g, PL/SQL Toad, Flat file, DB2,Linux, Autosys.

Confidential

INFORMATICA DEVELOPER

Confidential is the central repository of transactions, position and balances of PB clients. ADP is the books and records keeper and the settlement system of BNP domestic clients, and Calypso for the international settlements. ADP sends all related feeds back to Prime Services, which is extracted and loaded into staging area and then transformed in a way useful for internal and client reporting and for historical storage acting as a data warehouse.

Responsibilities:

• Extensively used ETL to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Created complex mappings using advanced transformations like Normalizer, Stored Procedure, Dynamic Lookup transformations etc.
• Used Informatica to extract data from VSAM and flat files to load the data into DB2 database for downstream system.
• Resolved user requests and on-line problems in production.
• Prepared test plans test cases for unit, system and integration testing.
• Implemented Floor Factor update for underwriting department.
• Designed and developed complex Informatica mappings using transformations like Normalizer, Router, Lookup connected and Unconnected and Update strategy transformation for various data loads.
• Designed and developed various Pl/SQL stored procedures to perform various calculations related to fact measures.
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Tuning Informatica Mappings and Sessions for better performance.
• Created Sessions, Workflows, Post Session email task and also performed various workflow monitoring and scheduling tasks.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Involved in creating the runbook and migration document from Development to Production .
• Documented the process for further maintenance and support.

Environment: Informatica Power center 8.1, Informatica PowerExchange 8.1, BO XI, PL/SQL, Oracle 10g, AIX, DB2, Mainframe, SQL Server, UNIX Shell Scripting, Autosys.

Confidential

INFORMATICA DEVELOPER

The objective of the project is to extract data from different source files like CMS, TRR, Enrollment, Part D, Recon Discrepancy and databases and load into oracle system to capture report maintenance/distribution, CMS readiness changes, system design and the analysis of complex business problems within the department and feed the data warehouse.

Responsibilities:

• Worked with business analyst for requirement gathering, business analysis, and testing and project- coordination.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Implemented Slowly Changing Dimensions - Type I II in different mappings as per the requirements.
• Performing ETL database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test supported the UAT for the client.

Environment: Informatica Power Center 7.1, Toad, UNIX Shell Scripting, Oracle 9g, SQL Server 2000, Mercury Quality Center, MS Project, LINUX.