SUMMARY:

• 8+ years of extensive working experience in Data Warehousing applications with 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. Good knowledge in interacting with Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ ).
• 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 within 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 Teradata SQL Assistant and data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, and Exposure to TPump on UNIX/Windows environments and running the batch process in Teradata.
• Developed Scripts to use TPT, MLoad, BTEQ, FastExport & FastLoad Teradata utilities and very good hands on these utilities.
• 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 with 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 server.
• Having extensive hands-on technical proficiencies in developments using databases like Oracle, SQL Server.
• Good experience in shell scripts for Informatica pre and post session operations, in UNIX Shell Scripting, CRON, FTP and file management in various UNIX environments.
• 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 with 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, Pentaho 5.x/6.x, SSRS

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

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 (self-learning), SQL, HTML, XML, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, Norwalk, Connecticut 

Data Integration Consultant

Responsibilities:

• Involvement in business requirements gathering and design sessions to translate requirements to technical specs.
• Created low level ETL document that contains technical specifications for ETL mappings. Developed moderate to complex Informatica mappings in conjunction with 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 with 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 MySQL.
• Scheduled the batches and sessions in the Informatica scheduler for daily loads.
• Interacted with business users and stake holders on requirement clarifications and critical enhancements. Worked closely with 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 9.6.1, PowerExchange 9.1.0/8.6.1 , SQL Server, MySQL 5.7, AIX, WinSQL Professional, Squirrel, Heidi

Confidential, Rockville, Maryland 

Informatica Senior Consultant

Responsibilities:

• Interacted with 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 with 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, Squirrel.

Confidential, Westlake Village, CA

Informatica Consultant

Responsibilities:

• Extensively worked with 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 with 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 with 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 with 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.

Confidential, Los Angeles, CA 

Informatica Developer

Responsibilities:

• Maintained source and target mappings, transformation logic and processes to reflect the business environment over time.
• Used Version mapping to update the slowly changing dimensions to keep full history to the target database.
• Used transformations like Aggregator, Filter, Router, Stored Procedure, Sequence Generator, lookup, Expression and update strategy to meet business the logic in the mappings.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations using Designer.
• Created workflows to run sessions sequentially one after the other and concurrent worklets to start all the sessions in the workflow at once.
• Worked on Informatica Power Center tool - Source analyzer, Warehouse Designer, mapping Designer and Transformation Developer.
• Created sessions and batches for incremental load and schedule them to run daily.
• Used Update Strategy to effectively migrate data from source system to target Database.
• Create, monitor, and troubleshoot batches and sessions for daily extracts.
• Extensively worked on Informatica to extract data from SQL Server, Teradata, Flat files, and to load the data into the target database.
• Used Informatica job scheduler to schedule the Informatica jobs along with other operational processes.
• Designed data transformation to Staging, Fact and Dimension Tables in the Warehouse.
• Create and maintain shell scripts for pre/post session operations and various day-to-day operations.

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 with developers and report planners/analysts to ensure that an acceptance criterion is complete and accurate for desired report capability.
• Involved in preparing Test plans based on user requirement documents.
• Extensively involved in preparation of 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 with the developers.
• Created test scenarios and test cases for the functionality, integration testing of the ETL, DDL, SQL and Unix scripts for User Acceptance.
• Involved in the Informatica version upgrade regression testing (from 6 to 7)
• Involved in updating process flow diagrams in Visio.

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