SUMMARY:

• Over 7+ years of IT experience in Data warehousing, Data Analysis, Data Migration, Development, ETL, Maintenance, Unit Testing and Documentation in diversified industries like Electronics, Retail, Healthcare and Investment Banking.
• Proficient in integration of various Operational Data Sources (ODS) to Multiple Relational Database Management Systems (RDBMS) like Oracle, SQL Server, Teradata, DB2, Sybase etc.
• Experience in Application Design, Data Extraction, Data Acquisition, and Data Mining Development, Implementations and Testing of Data warehousing and Database business systems.
• Experience with Software Development Life Cycle (SDLC) and Agile methodology.
• Expertise in using Informatica 9.6.1/9.5.1/8.6.1/8.1.1/7.1 (Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer).
• Strong experience on Workflow Manager Tools - Task Developer, workflow and Worklet Designer.
• Proficiency in data warehousing techniques for Staging area design, data cleansing, error handling, audit login, surrogate key assignment and real-time change data capture (CDC).
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.
• Conducted Unit tests, Integration tests and Customer Acceptance tests.
• Good working knowledge of OLTP systems, Analysis E-R Modeling, Data Modeling using data modelers, Star schema, Snowflake schema, Fact and dimensions table using ERWIN.
• Experience in integration of various data sources like Oracle, DB2, Tera data, SQL Server, Fixed width, Delimited Flat Files, XML Files and Main frames.
• Worked on Informatica Developer Tool 9.5.1 for profiling purpose and worked efficiently on transformations like Address Doctor.
• Extensively used Source Qualifier, Connected and Unconnected Lookup, Normalizer, Router, Filter, Expression, Aggregator, Stored Procedure, Sequence Generator, Sorter, Joiner, Rank, Update Strategy, Stored Procedure Transformation, Union Transformations, and Mapplets.
• Experience in Mappings, Mapplets, Worklets, Reusable Transformations, Sessions/Tasks, Workflows and Batch Processes in Informatica Server.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCD’s (Type 1/Type 2/ Type 3) loads.
• Involved in PL/SQL Programming (Stored Procedures, Triggers, Functions and Packages) Using Oracle.
• Proficient in Functionality Testing, Regression testing, Performance testing process and have good experience in writing Use Case documents, Detailed Design Documents, Test Plans, Test Cases, Use Cases and User Manuals.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, MVS, COBOL files & XML Files.
• Also have good knowledge in Performance Tuning at both Database Level and Informatica.
• Good experience in UNIX Shell Scripting and ETL Process Automation Using Shell Programming.
• Automated the jobs using the Scheduling tools like AutoSys and Control-M.
• Experience in Business Intelligence in generating various reports using Micro Strategy, COGNOS , Business Objects.
• Strong logical and Analytical Reasoning Skills, Excellent Communication with Good Listening Presentation and Intrapersonal Skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1/9.5.1/8.6.1/8.1/7.1.4 , Informatica Developer 9.5.1, Informatica Analyst, PMPC 3.0

Data modeling: ERWIN 7.0/4.0/3.0, Dimensional modeling, Snowflake, Star schema

Programming: C /C++/ HTML / UNIX Shell Scripting, PL/SQL, Perl.

GUI: TOAD 8.5/10.5.1.3 , SQL * LOADER, SQL Developer, Toad SQL Server

Databases/RDBMS: ORACLE 8i/9i/10g/11i, SQL Server 2000/2005/2008 , PL/SQL, Teradata V2R4/V2R5, SQL* PLUS, DB2 9.0

Operating Systems: Windows 98/2000/XP/ 7/8, MSDOS, UNIX, LINUX

Version Control: SCM, Dimensions

Scheduling: TIVOLI, Autosys, Control-m

PROFESSIONAL EXPERIENCE:

Senior Informatica Developer

Confidential, Dublin, OH

Responsibilities:

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Worked on Informatica Power Center tool using Source Analyzer, Mapping Designer, Transformation Developer, Informatica Repository Manager.
• Developed Data Mappings between source systems and warehouse components using mapping designer.
• Extensively used Designer to manipulate source definitions, create Mappings, Mapplets.
• Converted procedures into mappings using various transformations like Source Qualifier, Expression, sorter, Update Strategy, Filter, Lookup, Aggregator, etc.
• Created extract mappings and load mappings.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Created mapping documents to outline data flow from sources to targets.
• Created workflows using Session, Command, and Email tasks.
• Modified existing mappings for enhancements of new business requirements.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, command, worklets, Assignment, Timer and scheduling of the workflow.
• Use Incremental Loading concept by pulling transactional data that has a Source Update Date greater than the workflow’s last run date. Workflow’s last run date is captured in a custom table and updated in Post SQL of the workflow. Parameter files are created dynamically at the start of the workflow.
• Create complex mappings which involved Slowly Changing Dimensions (SCD Type 2 with date range), lookups on multiple tables, mapping and workflow parameters, User defined functions, mapplets and dynamic lookups
• Developed PL SQL procedure to enable a workflow to trigger only after certain fields are set in an external table
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with reporting team to help understand them the user requirements on the reports build using COGNOS and the measures on them.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.1/9.5, Oracle 11g, PL/SQL, SQL Loader, SQL Navigator 4.0, TOAD 8.5, Cognos 8, Erwin, Autosys.

Senior Informatica Developer

Confidential, Gaithersburg, MD

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, Db2 UDB, SQL Server and XML Files.
• Used Data conversion to merge data from various sources and to load into the target.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Worked on Migration of mappings from Data Stage to Informatica.
• Worked on Power Exchange bulk data movement processes by using Power Exchange Change Data Capture (CDC) method.
• Used workflow application which modifies the JDF ticket to describe what it has done and to examine the JDF ticket.
• Good knowledge in Unix Shell scripting.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD).
• Used Visual Basic 6.0 to create data bases and to develop fast and easy tools for simple utilities.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management.
• Used OBIEE for scorecard and strategy management and business process invocation.
• Worked with Power Center parameter file, which is a list of parameters and variables and their associated values, includes information for multiple services, service processes, workflows, worklets, and sessions in a single parameter file.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Used SQL Service Integration Services (SSIS) for workflow functions such as FTP operations, application programming interfaces (API’s) for programming the Integration Services object model, aggregating, merging and copying data.
• Extensive knowledge on Analyzing the Software Requirement Specifications and Software Development Life Cycle (SDLC) like waterfall and agile methodologies .
• Developed a UNIX Shell scripts, which will send the reports to client over the network by using file transfer protocol (FTP & SFTP) and generating the log file, which will keep the history for the FTP reports.
• Used T SQL which is an extension of the basic SQL to date processing, local variables, various support functions for string processing and changes to delete and update statements.
• Generated ABAP code to pull the data from SAP.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Executed Informatica workflows using PMCMD utility through UNIX scripts.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.
• Wrote SQL Queries as part of Data validation in the Target tables.

Environment: Informatica Power Center 9.5.1, Oracle 10g, Oracle SQL* LOADER, Flat Files, UNIX Shell Scripting, TOAD, Crontab, Teradata 13.10, Teradata SQL Assistant, SSIS, VSS, Outlook, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT .

Informatica Developer

Confidential, Irvine, CA

Responsibilities:

• Worked closely with Business Analysts and Developers to gather Application Requirements and Business Processes and formulated the test plan.
• Prepare a Low-level Design Document based on the BR.
• Developed ETL mappings, transformations using Informatica Power Center.
• Implemented source and target definitions in Power Center -Designer.
• Used most of the transformations like Source Qualifier, Expression, Aggregator, Lookup, Filter, Router, Sequence Generator, Sorter, Joiner, Union, Update Strategy, etc.
• Mappings were designed to cater the slowly changing dimensions.
• Used SCD Type I and Type II for storing historical data.
• Created the Informatica mappings as per the new business requirement.
• Developed several reusable transformations and Mapplets that were used in other mappings.
• Worked on the Workflow manager to run several sessions and workflows.
• Migrate the UNIX jobs and Informatica mapping into production.
• Involved in performing Unit test cases.
• Analysis of existing system with objective of improving & optimizing the system performance.
• Involved in Performance Tuning of developed mappings.
• Took full responsibility of job failures and open the bridge with DBA and Production control to solve the errors within provided timelines.
• Preparing install guide and other release documentation.
• Responsible to track, log all support issues to significantly reduce the amount of time needed for support issues.
• Created detailed periodic Status Reports for senior management to keep them on the progress of implementation.
• Performed tests to check whether there is any loss of data during data loads.
• Responsible for analyzing and preparing dependencies and sequence in which processes should be scheduled in Control-M scheduler.

Environment: Informatica Power Center 9.1, Oracle 10g, UNIX, Sql Developer, Control-M.

Informatica Developer

Confidential, MN

Responsibilities:

• Interacted with Business Users and understood the design requirements of the users.
• Used different kinds of transformations like Router, Sorter, Source Qualifier, Joiner, Aggregator, Stored Procedure, Lookups both Connected and Unconnected Lookups, Expression, Expression, XML Sequence Generator, Union, Update Strategy to load data into target tables.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Worked on Incremental Aggregations for improving performance in Mappings and Sessions.
• Created Mappings for Populating data to dimensions and fact tables.
• Extensively used Power exchange to import source files from Mainframe systems
• Extensively used ETL to load data from wide range of source such as flat files, Mainframes to DB2.
• Used Debugger in troubleshooting the existing mappings.
• Extensively used Toad for DB2 for executing the queries.
• Used IBM Rational Clear Quest to track the Incidents.
• Implemented both SCD’s (Slowly Changing Dimensions) TYPE-1 and TYPE-2.
• Used Mapping Parameters and Variables, Dynamic parameter files, Shortcuts, Reusable Transformations.
• Immediately assisted in Troubleshooting of our application performance issue.
• Involved in migrating folders from Development to Testing and from Testing to Production Environments, creating Connect Strings and synchronizing the Connect Strings and Connection Objects in Dev, Test and Prod environments.
• Involved in Unit Testing and created Test Cases for those mappings.
• Worked with QA Team and helped in Testing at Integration Level.
• Extensively used various tasks like Session task, Event Wait task, Decision task, Email task, Command task.
• Developed Stored Procedures, Functions, Triggers, Indexes and Views.
• Created UNIX shell scripts to run session workflows for Informatica mappings.

Environment: Informatica Power Center 8.6.1, IBM Db2 V9.5, SSH Secure Shell 3.2.9, Putty, Scheduler CA7 for Mainframes, Erwin, Clear CaseQuick 3270 V2.5 Mainframes, IBM Rational Clear Quest, Microsoft Visio, Toad 9.0, Power Exchange, windows XP, PVCS

SQL/ETL Developer

Confidential

Responsibilities:

• Studied and understood the warehouses, sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Worked on creating mapping/Imported Sources/Targets etc. using Informatica Power center 7.1
• Developed and tested all the Informatica mappings involved complex lookups and update strategies.
• Created Stored Procedures, Views and Packages in Oracle.
• Designed and documented the validation rules, error handling and test strategy of the mappings.
• Implemented Slowly Changing Dimensions (SCDs, Type 2).
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Configured sessions with email when failure and decision task.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema using Erwin 4.0.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Analyzed the session, event and error log for troubleshooting mappings and sessions.
• Responsible for submitting DBA requests using LOTUS NOTES, following up with data base DBA’s and Informatica administrators, creating remedy ticket, handling all the signoffs for the production, updating all changes with new versions using START team, creating test cases using Quality Center.
• Involved in Data Profiling using Data Explorer.
• Expert knowledge in SQL Queries, Triggers, PL/SQL Procedures, Packages to apply and maintain the Business Rules.
• Using Toad to increase User productivity and application code quality while providing an interactive community to support the user experience.
• Involved in Performance Testing created test cases and captured test results.
• Used PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Did the Performance tuning in Oracle to run the queries faster in the application Dashboard.
• Worked with mapping variables, Mapping parameters and variable functions like Set Variable, SetCountVariable, SetMinVariable and SetMaxVariable.
• Worked on Batch Processing or Scheduling and Shell Scripting.

Environment: Informatica Power Center 8.6.1, Teradata V2R5, Erwin 4.0, Oracle10g, PL/SQL, Shell Scripting, Toad, UNIX

ETL Developer

Confidential

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica Power Center tool.
• Extracted data from Oracle, Flat file, Excel files and performed complex joiner, Expression, Aggregate, and Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions, heterogeneous sources and determining the hierarchies in dimensions.
• Used Workflow Manager for Workflow and Session Management, database connection management and   scheduling of jobs to be run in the batch process.
• Developed complex Informatica Mappings, Mapplets and reusable Transformations for different types of tests in pharmaceutical research studies on daily and monthly basis.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Created pre and post SQL scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static, Dynamic and Persistent.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Experience in Performance tuning using Pushdown Optimization, Partitioning etc.

Environment: Informatica Power Center 9.0/8.6, Informatica Power Exchange, Oracle 11g/10g, UNIX, Unix Shell Script, DB2, TOAD, WinScp.