SUMMARY

• Having 6 years of relevant experience on using ETL tool Informatica Power Center 8.X & 9.X, Oracle SQL and as well as good Experience on UNIX commands and Perl, Shell scripting.
• Conversant with all phases of Software Development Life Cycle (SDLC) in requirement gathering, Analysis, Design, Development, Implementation, Testing, Methods like Waterfall and Agile/Scrum.
• Expertise in building Enterprise Data Warehouse (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake Schema) Concepts.
• Significant Multi - dimensional and Relational data modeling experience, Data flow diagrams, Process Models, ER diagram with modeling tools like ERWIN and VISIO.
• Strong experience in MS SQL Server with Business Intelligence in SQL Server Integration Services (SSIS).
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Good exposure in Data Cleansing, Transformation, Data import, Data export, and use of Oracle Database.
• Experience in creatingUNIXshellscripts andPerlscripts.
• Involved in initial & incremental Extraction and Loading of data into Data warehouse using Informatica.
• Hands on experience with mappings from various transformation logics like Unconnected and Connected lookups, Filter, Router, Aggregator, Joiner, Stored procedure, Normalizer and reusable transformations.
• Good Understanding of relational database management systems like Oracle, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction, Transformation and Loading of data from various database source systems.
• Experienced in working with various Scheduling tools like Autosys, Control-M, Informatica Scheduler and Cronjob
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow Manager.
• Extensive knowledge in developing Teradata, Fast Export, Fast Load, Multi Load and BTEQ scripts.
• Experience in working on Informatica Data Quality - IDQ to attain data profiling, worked on reference data.
• Profound knowledge about the architecture of Teradata database
• Extensively worked on composing and execution of Test plans, Test cases and Test scripts.
• Diverse background with fast learning skills and creative analytical skills.
• Demonstrated ability to work and communicate effectively with both business and technical audiences.
• Good knowledge in Data Warehouse architecture.

TECHNICAL SKILLS

Operating System: Windows 7/XP, UNIX

Languages: SQL, PL/SQL, Transact SQL, HTML, XML, Perl,and Python.

Database: Oracle 10g/11g, MS-SQL Server, Teradata

ETL Tools: Informatica Power Center 8.6/9.1/9.5, Informatica Data Quality (IDQ)

Tools: /Utilities: TOAD, SQL Developer, Putty

Data Modeling: Dimensional Modeling, Star Schema, Snowflake Schema, Fact Tables, Dimension Tables, Erwin and Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Informatica Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Applied Slowly Changing Dimensions like Type 1 and 2 effectively to handle the delta loads
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup and Update Strategy.
• Worked on dimensional modeling to design and develop Star Schemas by identifying the Facts and Dimensions. Designed logical models as per business requirements using Erwin.
• Used ETL (SSIS) to develop jobs for extracting, cleansing, transforming and loading data into final database.
• Created automated process to monitor the space in data directory using Perl and Korn Shell.
• Developed Workflows using Task developer, Worklet designer and Workflow designer in Workflow manager and monitored the results using Workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following informatica best practices and also applied several methods to get best performance by decreasing the runtime of workflows.
• Worked with mLoad and fLoad utilities of Teradata and created partitions for tables with huge data.
• Prepared SQL Queries to validate the data in both source and target databases.
• Used debugger to test the mappings and fixed the bugs.
• Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
• Worked on Toad and oracle SQL Developer to develop queries and create procedures in Oracle.
• Performed Data Analysis to summarize data with the intent to extract useful information and Develop conclusion using the IDQ tool.
• Utilized of IDQ to complete initial data profiling and matching/removing duplicate data.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.

Environment: Informatica Power Center 9.5.1, Oracle 10g, Flat files, Teradata, SQL Server Integration Services (SSIS), Toad, Jira, Windows 7 and MS Office Suite.

Confidential, Nashville TN

Informatica Developer

Responsibilities:

• Gathering requirements and implement them into source to target mappings in Landing, Staging and ODS.
• Interacting with Business Analysts in understanding the Database requirements whenever debugging is required without changing the code.
• Focused on new system and tools with minimal supervision and trained Project Architecture to team members.
• Involved in populating data from Flat files, oracle into SQL Server 2008 R2 database from landing to ODS (Staging) and into EDW using the common code.
• Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions in Transformations.
• Effectively worked on Mapping Designer, Workflow Manager and Workflow Monitor.
• Extensively used Sequence Generator in all mappings and fixed bugs / tickets raised in production for existing mappings in common folder for new files through versioning (Check in and Check out) on an urgency through support for QA in component unit testing and validation.
• Applied Slowly Changing Dimensions Type I and Type II on business requirements.
• Parameterized all mapping, session parameters, DB connections wherever necessary in sandbox and common folder and tested links in DEV, QA and PROD for populating data into SQL and updated whenever necessary for migrations in different environments at root directory.
• Extensively worked on Performance Tuning and also in isolating header and footer in single file.
• Performed code migration of mappings and workflows from Development to Test and Production Servers through deployment groups for DEV, TEST and PROD repositories in retaining shortcuts, dependencies and versioning.
• Effectively understood session error logs and used debugger to test mapping and fixed bugs in DEV in following change procedures and validation.
• Tuned and optimized mappings to reduce ETL run time and ensuring they ran within designated load window.
• Raised change requests, analyzed and coordinated resolution of program flaws and fixed them in DEV and Pre-Production environments, during the subsequent runs and PROD.
• Perform analysis profiling on existing data and identify root causes for data in accuracies, Impact Analysis and recommendation of Data Quality.
• Precisely documented mappings to ETL Technical Specification document for all stages for future reference.
• Scheduled jobs for running daily, weekly, and monthly loads through informatica for each workflow in a sequence with command and event tasks.

Environment: Informatica 9.1.0, Oracle 10g, Windows 7, UNIX, Excel, SQL Server 2008, Visio.

Confidential, Woonsocket RI.

ETL Consultant

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively used Teradata utilities like Fast load, Multi load to load data into target database.
• Extensively worked on Power Center Client Tools like Power Center Designer, Workflow Manager and Workflow Monitor.
• Experience with using Informatica cloud for data packages from Salesforce.
• Extensively worked on Power Center 9.x Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Worked with Informatica Power Exchange and Informatica cloud to integrate Salesforce and load the data from Salesforce to Oracle db.
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings.
• Created ETL mappings for PII and PHI data tables with additional security for loading in to target database.
• Created Parameter files and validation scripts.
• Created used custom load Scripts from command task.
• Created Process Control and Metadata for Informatica jobs.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Involved in providing 24/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Assisted with peer code reviews and testing of development team’s T-SQL code.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, UNIX, Win XP, SQL*Plus, Transact-SQL, Control-M, Putty, BTEQ.

Confidential

ETL/Oracle Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using into the database. Involved in logical and physical modeling of the drugs database.
• Based on the requirements, created Functional design documents and Technical design documents for ETL.
• Created tables, views, indexes, sequences, constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures and functions to implement business rules.
• Used legacy systems, Oracle and SQL server sources to extract the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with oracle programmers and wrote reports for sales data.

Environment: Informatica Power Center 8.6/9.1, Oracle 10g, Flat files, UNIX, Win XP