Objective:

Around 7 years of experience with full life-cycle development: requirements analysis, design, development, testing, documentation specializing in Data Warehousing with Informatica.

Summary:

• 7 years of extensive experience in Analysis, Design, Development, Implementation and Testing of ETL procedures.
• Strong experience in performing ETL procedures to load data from different sources into databases, data marts and data warehouses using Informatica PowerCenter.
• Experience in extracting data from multiple sources, applying business logic and loading into Data Warehouse, Data Marts, Data Cubes.
• Experience in building Operational Data Store in order to make reporting and analysis easier.
• Extensive experience in data Extraction, Transformation, and Loading from multiple relational databases like Oracle, Teradata, DB2, SQL Server and Flat files Fixed Width Delimited like TXT files, CSV files, XML files ,Excel Files.
• Good understanding of Data Warehousing concepts. Knowledge of Identifying Facts and Dimensions tables.
• Clear understanding of data modeling concepts such as star and snowflake schemas.
• Good understanding of OLAP and OLTP methodologies.
• Experience in writing UNIX Shell Scripts and Perl Scripts for data validation, data cleansing, automation of sessions and file transfers.
• Hands on experience in creating/executing DDL, DML, SQL, PL/SQL Procedures, Functions, Triggers, Cursors, Views, Materialized View, Indexes and Packages.
• Performed unit testing and provided support to SIT System Integration Test and UAT User Acceptance Test to check the data quality.
• Experience in Tuning the Performance of Sources, Targets, Mappings Sessions, SQL Queries, Informatica Sessions to optimize load and run times on the server.
• Hands on experience on various scheduling tools: Autosys, Control-M.
• Experience in UNIX shell scripting, job scheduling, communicating with server using pmcmd, FTP ,SFTP and file management in various UNIX environments.
• Experience in Preparing Design documents for ETL Specifications.
• Excellent Analytical, Problem Solving, Communication and Interpersonal skills, with an ability to Interact with individuals at all levels. in maintaining Star schemas.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Reverse engineered existing mappings to understand the existing business logic.
• Reliable, Highly organized, Hardworking, Flexible and a Good team player.

Technical Skills:

Confidential

ETL / Informatica Developer

Description:

This Project is aimed to Migrate 180 of Siemens Healthcare SAP BOBJ Data Integrator DI jobs to Informatica. Source system are SAP tables and oracle tables. Target : oracle. Current ETL tool Data Integrator is running on Windows 2003 servers, and since the Windows 2003 OS will not be in use in HC after April 2015, the DI servers must be replaced with infa jobs.

Responsibilities:-

• Involved in the requirements gathering and analysis for implementing the Data Warehouse.
• Designed Source to Target Mapping Design Documents, ETL specification document, Unit Test document.
• Loaded data to Flat File , Oracle staging area from SAP-R3 database then from staging tables to Oracle 11g target tables.
• Designed and developed complex mappings using various transformations to load data from Flat Files, Oracle staging DB into the target Oracle Data warehouse.
• Imported flat file sources through CoreFTP and loaded them into Oracle target tables.
• Performed FTP tasks to transfer parameter file to the Informatica Windows server.
• Analyzed performance bottlenecks, tuned various mappings and created reusable transformations and Mapplets to increase the performance.
• Imported Stored Procedures, Functions, Packages defined in Oracle database to informatica.
• Using Audit Table CDC STATUS TABLE to keep a log for each Infa jobs. Which contains the information as such Job Name, Folder, Last Run Date, SAP Table Name, DW Row Count, SAP Row Count.
• Extensively used the transformations Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP Static and Dynamic , Update Strategy, Source Qualifier, Joiner, Normalizer.
• Used SQL-Loader to load data from flat file to Oracle tables, to improve the performance.
• Performed migration of the workflows and mappings from the development folder to the integration test folder.
• Created parameter file to make workflows flexible to move from one environment to the other.
• Developed pre-session, post-session routines to drop indexes and to reassign them and batch execution routines to run Informatica sessions.
• Scheduled sessions and work flows using Informatica work flow scheduler and pmcmd.
• Created Workflows and used various tasks like Assignment, Command, Email, Event-wait and Event-raise, Timer, Decision, Session in the workflow manager.
• Implemented Type-I slowly changing dimensions..
• Have a good understanding on power connect to connect to SAP-R3 data base.
• Loaded the data from multiple source files that have the same structure and properties using Indirect Load method.
• Developed unit test cases and did unit testing for all the developed mappings.
• Analyzed with Business Analysts and client representatives and solved client specific data issues.

Environment: Oracle 11g, SAP , SQL, PL/SQL, Oracle-SQL-Developer, SQL-Plus , Informatica Power Center 9.1,SQL-Loader.

Confidential

Description:

Confidential is loaded with the wholesale inventory activity and sales activity data and the different sales force data is loaded into Dimensions. Data warehouse design is based on a Star Schema. The Source system is IBM Mainframe, Oracle and the Data Warehouse is in ORACLE 10g on UNIX. The project is based on migrating the Warehouse to new version.

Responsibilities:

• Interacting with the clients on a regular basis to discuss day-to-day issues and matters.
• Performed source data analysis. Primary data sources were from Oracle SQL server 2008.
• Provided L2/L3 application support in Production environment. Including reporting, investigating, analyzing, and coordinating resolution of issues.
• Provided detailed level analysis on workflow failure to development team.
• Identifying production issues, review errors, approve resolution, and advice of potential downstream impacts.
• Monitored running workflows and tasks, if any error occurs, analyze the issue by checking logs. Intimate about the error to the concerned person.
• Participated in all facets of the software development cycle including providing input on requirement specifications, design documents, and user's guides.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Created command tasks to run shell scripts to kick off workflows using PMCMD, organize flat files.
• Created e-mail tasks to notify the status of the Session, workflow, worklet if they completed or stopped, or failed while execution.
• Scheduling and Monitoring Informatica repository backups.
• Created and used Debugger Sessions to debug sessions and created breakpoints for better analysis of mappings.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Worked with DBA to resolve the database problems and performance tuning.
• Responsible for Trouble shooting, Production support, Performance tuning and Batch monitoring activity.
• Handled adhoc issues depending on the priority and implement the change requests in production.
• Provided production support by monitoring the Workflows running on daily basis.
• Submitted ETL support documents to trouble shoot in future production runs.
• Worked on AOTs/Remedy Tickets assigned to support group and provided resolution to the customer issues within specified SLA.
• Following Instruction from development team to complete load.
• Produce weekly status report and participate in team meetings and conference calls with other region.
• Worked closely with reporting team and helped them whenever they had any ETL issues.
• Prepared user manual and technical support manual.
• Maintained the root cause analysis issues tracker sheet.

Environment: Informatica Powercenter 8.1, WinScp, Oracle 10g, SQL Server 2008, UNIX.

Confidential

ETL Developer

Description:

Confidential handles commercial and consumer banking operations and offers financial products, services, ideas and solutions to customers and clients in 50 states. The project objective is to design and develop a single Integrated Data Warehouse for reporting the loan data for the Organization, which enables the loan servicing department to track the loans and improve the Overall performance.

Responsibilities:

• Have a good understanding on Investment Banking sector.
• Performed cleansing and scrubbing on data which came from various sources.
• Used different Cache properties, such as dynamic cache session property to perform the Update and Insert into the relational table simultaneously using Lookup transformation.
• Involved in identifying bottlenecks and performance tuning of SQL Queries, Sources, Targets and Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Performed record counts after loading the data into targets.
• Performed Unit testing, System Integration testing of mappings.
• Implemented Slowly Changing Dimensions Type II by creating Surrogate Keys in the target table to accommodate historical data
• Created Mapplets and Worklets to reuse the logic in several mappings.
• Worked with DBA to resolve the database problems and performance tuning.
• Prepared design documents, ETL Specifications and migration documents.
• Developed UNIX shell scripts to create parameter files, rename files, compress files and for scheduling periodic load processes.
• Created reports for the daily and weekly status meetings.
• Defined ETL standards for future reference purposes.
• Wrote PL/SQL stored procedures for complex data extraction logic.

Confidential

ETL developer

Description:

The primary role of the project was to build a Centralized Data Warehouse to store and maintain historical data for business analysis. The goal of the project was to support business executives in making a quick decision about their target customers and to offer additional products.

Responsibilities:

• Involved in for Evaluation, Analysis, Design, Development and Delivery of Interfaces ETL using Informatica.
• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer.
• Involved in Agile development, project planning and release planning activities.
• Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Extensively worked in the performance tuning of ETL mappings.
• Created reusable transformations.
• Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.

Environment: Informatica 7.1.3 power center, Oracle 9i, TOAD 8.6.1, SQL Plus, SQL.UNIX

Confidential

Oracle Developer

Responsibilities:

• Creation of database tables, views, triggers,etc. using SQL.
• Involved in Developing PL/SQL stored procedures.
• Created the index for increasing the performance of data conversion process.
• Involved in the database design of the application.
• Writing Shell scripts for routine Unix tasks.
• experience in Oracle Forms and Reports.
• Developed complex SQL queries including Sub queries, correlated queries, and Nested queries, Unions, Intersect and Aliases.
• Testing and providing Post live Support to the application.