SUMMARY

• 7+ years of extensive working experience in Data Warehousing applications wif prime focus on development, testing and deployment using Informatica Power Center, UNIX and Windows based platform.
• Having experience in implementation of ETL Applications for Sales and Pharma verticals.
• Extensive data integration builds and deployment experience using MSBI (SQL Server Integration Service) and Informatica Power Center 9.6.1/9.1/8.6/8.1. x, IDQ on both UNIX and Windows based platforms.
• Expertise in designing and implementing data integration platform using traditional ETL strategies (SQL /PL/SQL) as well as tools like SSIS and Informatica Power Center.
• Extensively worked on various Active and Passive transformations wifin the Power Center. Experienced in implementing business rules by creating transformations such as Expression, Aggregator, Unconnected and Connected lookup, Filter, Router, Joiner, Union and Update Strategy.
• Good understanding of Data Warehousing concepts and Dimensional modelling (star schema and snowflake schema design); Fact and Dimensional tables, Physical and Logical data modeling. Good understanding of Ralph - Kimball and Inmon approaches to Data Warehousing
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Proficient in coding SQL’s, PL/SQL (Procedures, Functions, Triggers and Packages) using SQL * Plus and TOAD. Have used SQL* Loader utility to import data on UNIX and Windows platforms.
• Well-versed wif debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Proficient in implementing data validation rules and exception handling mechanism while loading dimension and facts.
• Expertise in developing and running Mappings, Sessions/Tasks, Workflows, Worklets, and Batch processes on Informatica Integration Service.
• Having extensive hands-on technical proficiencies in developments using databases like Oracle, SQL Server.
• Experience in shell scripts to execute pre and post session operations in UNIX environment. Self-training in writing python scripts to download the files and move them into designated folder from the FTP servers.
• Good exposure to design, development, testing, debugging, implementation, documentation, production support and responsible for Weekly and Monthly loads.
• Excellent analytical, problem solving skills and a motivated team player wif excellent inter-personal skills and ability to work independently and as well as part of the team.

TECHNICAL SKILLS

ETL TOOLS: Informatica Power Center 9.6.1/9.1/8.6/8.1/7 x, Informatica Power Exchange 8.x/7.x, Talend 5.x

DATA MIGRATION: SQL * Loader, Teradata BTEQ

DATABASE: MySQL, Oracle 11g/10g/9i/8i, SQL Server 2008/2005, Teradata v14/v13

DATA MODELLING TOOLS / SCHEMAS: ERWin, Star schema, Snow-Flake schema

DATABASE UTILITIES: SQL* Loader, SQL, Transact SQL, TOAD, SQL Developer, SQL Navigator, Query Analyzer

OTHER UTILS: Putty, Notepad++, SharePoint

JOB SCHEDULERS: Maestro, Informatica Scheduler, Autosys

OPERATING SYSTEM: Windows 10/7/2008/NT/XP, HP UNIX, RHEL LinuxWindows (2000/NT/2003), SUSE Linux, UNIX, MS-DOS

LANGUAGES: Shell Scripting, Python 2.7, SQL, HTML, XML, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Norwalk, Connecticut

Informatica Developer

Responsibilities:

• Involvement in business requirements gathering and design sessions to translate requirements to technical specs.
• Created low level ETL document dat contains technical specifications for ETL mappings. Developed moderate to complex Informatica mappings in conjunction wif Unix scripts to load source data into Warehouse by applying series of business rules.
• Used various Informatica transformations such as Expression, Aggregator, Sorter, Joiner, Source Qualifier, Stored Procedure, Normalizer, Look Up, Router to munge the data along wif the strength of Database to design complex mappings.
• Developed processes involving Unix scripts and database objects to report on all source files received from various vendors.
• Designed and built restart ability into the workflows to run from the point it failed earlier. Processed inconsistent data from flat files into separate entities. Developed regular expressions in Informatica to validate email id.
• Worked extensively on mapplets, reusable transformations and worklets to enable the reusability of required code.
• Tuned various poor performing lookup queries.
• Participated in automating the file processing using UNIX shell scripting starting from file FTP to Informatica server to running the Informatica workflow to load data into landing and then in to Data warehouse.
• Configured existing sessions to use loaders to load data into Oracle.
• Scheduled the batches and sessions in the Informatica scheduler for daily loads.
• Interacted wif business users and stake holders on requirement clarifications and critical enhancements. Worked closely wif brand teams, campaign teams and data partners to address the data issues.
• Created QA test plans and participated in end-to-end testing.
• Involved in documenting various processes at a very high level by providing the process flow charts through MS Visio (graphical representation of process flows) and also worked on documenting the processes at a low level, i.e., table/mapping.
• Well versed in using SharePoint site for process management & document-management.

Environment: Informatica Power Center 10.x/9.6.1, PowerExchange 9.1.0/8.6.1, SQL Server, Oracle 11g, WinSQL Professional, Heidi.

Confidential, Rockville, Maryland

Informatica Developer

Responsibilities:

• Interacted wif reporting team and gathered requirements for new enhancement and changes to the existing system based on changing business needs to build Data Marts.
• Worked extensively on different types of Transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Lookup, Stored Procedures, Sequence Generator, Normalizer and Joiner to design new mappings.
• Developed complex mappings to replace Oracle proprietary PL/SQL APIs.
• Customized SQL Override queries where ever possible, to minimize the use of joiner, Aggregator and Lookup transformations.
• Extensively used Informatica Scheduler for scheduling jobs.
• Involved in writing korn shell scripts to automate the whole process for incremental load by using the pre-and-post session command options.
• Extensively worked on designing work flows and creating dependencies by using Unix and Informatica interfaces.
• Involved in replacing SQL Loader wif Teradata utilities for inserting bulk data into targets. Used Teradata bulk loading utilities such as Fast Load, Multi-Load and TPT.
• Worked extensively in finding out the bottle necks in mappings and tuned to optimize the performance and response times.
• Redesigned / Tuned the existing applications to achieve maximum performance.
• Involved in workflow documentation, which gives extensive information about the control flow and the dependencies.
• Created effective Test data and developed thorough Unit test cases to ensure successful execution of the data loading processes.
• Involved in running jobs and SQL scripts on the Database as a part of UAT.

Environment: Informatica Power Center 9.6.1, PowerExchange 9.1.0/8.6.1, Microstrategy 9.2.0, DB2, Teradata 15 / 14, Oracle10g/11g, AIX, WinSQL Professional, Netezza.

Confidential, Westlake Village, CA

Informatica Consultant

Responsibilities:

• Extensively worked wif business teams to understand, analyze and document the requirements.
• Solution Design Specifications (SDS) documents for new facts and measurements have been developed; modified existing Solution Design specifications (SDS) documents in case of enhancements or new requirements.
• Worked wif variety of sources such as Oracle, SQL Server, XML and flat files. Used XML parser to generate the XML files.
• Designed and developed various Informatica mappings to populate the stage, dimension and fact tables.
• Designed reusable code like database stored procedures, functions and mapplets using Oracle and Informatica technologies respectively. Re-designed and coded legacy Oracle store procedures to execute the DDL/DML statements.
• Rationalize various performance related issues in both database and ETL objects.
• Performed tuning of database objects like procedure and functions.
• Tuned the Informatica ETL processes for optimum performance by integrating ETL processes based on common sources and optimizing the source SQL to use right indexes.
• Extensively worked wif Informatica and Tidal scheduler to schedule the Informatica jobs.
• Extensive usage of TOAD in performing most of database operations like forming SQL’s, creating tables, building indexes and establishing the constraints.
• Performed Unit, Integration and System testing of all processes. Worked closely wif business users for the User Acceptance Tests & sign-off's.
• Exclusive responsibility includes assigning tasks to the off-shore teams and also for a high-level review of their development activity.

Environment: Informatica PowerCenter 9.1/8.x, ORACLE 11g/10.2.0.3, SQL Server 2005/2000, Micro Strategy 9.3, Toad 9.5, Tidal 5.3, SQL, PL/SQL, UNIX Shell Script, Windows 7/XP, LINUX and MS Office, Teradata.

Environment: Informatica Power Center 7.1.3/7.1.4, Oracle 9i, SQL Server, Teradata, Microsoft Office, Windows NT, UNIX.

Confidential, Los Angeles, CA

ETL Tester

Responsibilities:

• Understanding of Business Logic and data flow. Participated in reporting summary documents reviews.
• Worked closely wif developers and report planners/analysts to ensure dat an acceptance criterion is complete and accurate for desired report capability.
• Involved in preparing Test plans based on user requirement documents. Worked extensively on preparing unit test cases for user reports. Involved in preparation of test plans, test cases and test scripts using Quality Center.
• Worked extensively in preparing of test data based on test cases.
• Involved in Peer review of the test scripts and executing the test scripts.
• Ran all the UNIX scripts, ETL Workflows and PL/SQL Packages as part of Regression testing.
• Raising defects in Quality Center and assigning to appropriate developer.
• Validation & Communication of test results.
• Providing Defect Reports to the team on regular basis.
• Follow up on bug fixes wif the developers.
• Created test scenarios and test cases for the functionality, integration testing of the ETL, DDL, SQL and Unix scripts for User Acceptance.

Environment: SQL, Oracle 9i, Informatica Power Center 7, Windows NT, UNIX.