SUMMARY

• Over 8+ years of software experience in System Analysis, Application Design, Development, Implementation and ETL, Reporting for Data Warehousing. Experience in customization and implementation of client server and involved in analysis, design, and development, testing applications.
• Experienced in requirements gathering, project estimating, planning design, build, maintenance, report design, user navigation design, testing and implementation. Good knowledge on SDLC (software development life cycle) and good experience with unittesting and integration testing.
• Designed and implemented Data Mart / Data Warehouseapplications using Informatica Power Centre 9.x/ 8.x (Power Center Designer, Workflow manager, Workflow monitor and Repository Manager).
• Very strong knowledge on end to end process of Data Quality and MDM requirements and its implementation.
• Developed business rules for cleansing/validating/standardization of data
• Excellent knowledge upon RDBMS, OLAP, OLTP, Data Marts, ODS Systems. hands - on Informatica IDQ 9.5.4 Analyst IDQ Data profiling IDE Data Discovery IDS for reporting and Developer ETL Application
• Extensively worked on Informatica Designer Tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) and Workflow Manager Tools (Task Developer, Worklet and Workflow Designer).
• Created Mappings in Mapping Designer to load data from various sources using complex transformations like transaction control, Lookup (Connected and Un-connected), Joiner, sorter, Aggregator, Update Strategy, Filter and Router, java, transaction controltransformations.
• Experience in working on Entity-Relationship concepts,Operational Data Store (ODS), Facts and dimensions tables, slowly changing dimensions, Dimensional Modeling (Star Schema and Snow Flake Schema), Normalization and De Normalization Concepts.
• Experience in integration of various data sources like Oracle, Teradata, SQL Server, and Flat Files into the data warehouse.
• Proficient knowledge of Creating Feeds from OLTP to OLAP systems.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Involved in writing shell scripts to handle Squid process and Secure file transfer(FTP/SFTP) of the data files, audit and error files which includes various level of data and transfer validation.
• Comprehensive Cloud Integration and Data Management Solution for Microsoft Azure
• Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Involved in creating Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Dimensional Data Modeling
• Extensive experience in creation of ETL Mappings and Transformations using Informatica Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, ERP Source Qualifiers, Aggregators, Filters, Joiners
• Good experience in Data Cleansing, Data profiling and Data Analysis.
• Worked on Oracle e-business(EBS) support project and involved Finance Account Payables, Account Receivables
• Participate in code reviews and QA to verify and validate coded queries against requirements
• Extensively worked on integration of SAP and non-SAP data for enterprise analysis, reading Tables, writing files,
• Knowledge with Informatica DVO, IDE/IDQ tools for Data Analysis / Data Profiling and Data Governance.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages, Cursors, Snapshot, Roles, Privileges, Tables, Constraints, Views, Indexes, Sequence, Synonyms, SQL*Loader in distributed environment. Experience in UNIX shell programming.
• Work on SQL Server Management studio and Visual Studio for day to day activities.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Involved in Performance tuning of Informatica mappings and sessions.
• Explore prebuiltETLmetadata, including Informatica workflows and mappings DACmetadata.
• Having good experience in Performance tuning of SQL and PL/SQL scripts.
• Good experience in creating and review of Requirements/System Impact Specifications, Data Flow Diagrams, Effort estimation and Implementation Plan.
• Experience in data extraction from heterogeneous sources using Informatica Power center.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.

TECHNICAL SKILLS

ETL Tools: Informatica 9.6.1/9.5.1/8. x, IDQ, MDM, IDS

Data Modeling: Dimensional Data Modeling- FACT & Dimensions tables Logical and physical data modeling, Star & Snowflake schema

Databases: Oracle 11g/10g/9i, Teradata, DB2, Netezza, MS SQL Server 2005/2008, Microsoft Word, Microsoft Excel.

RDMS Load Tools: TOAD and SQL Developer (Database tool), SQL *Loader

Languages: C, C++, Java, Visual Basic, SQL, PL/SQL, Shell Scripting.

Operating System: Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Solaris, AIX).

Office Applications: MS-Office 97/2000/XP/2007, Open Office Suites.

Scheduler: Tivoli, Autosys, Control-M, Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential, MANHATTAN, NY

Sr. ETL Informatica Developer

Responsibilities:

• Prepared High-level Design and Low-Level Design based on Functional and Business requirements of the project.
• Designing & documenting the functional specs and preparing the technical design.
• As a team conducted gap analysis and Discussions with subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
• Supported the development, optimization, and maintenance of Informatica mappings with various source data including Oracle and SQL.
• Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapp lets& Parameter files.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Designed and Developed ODS to Data Mart Mappings/Sessions/Workflows.
• Developed, maintained programs for scheduling data loading and transformations using DataStage
• Developed mapping parameters and variables to support SQL override.
• Participated in the agile development process including standup, planning meetings, grooming, demonstrations and retrospectives.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Migration of code between the Environments and maintaining the code backups.
• Using the Power Exchange for Change Data capture (CDC) option to capture the data whenever the inserts, updates, and deletes underlying these events as soon as they occur and transfer in to multiple targets without intermediate queues or staging tables
• Creating Informatica Exception Handling Mapping for Data Quality, Data Cleansing and Data Validations.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, PowerCenter transformations and session’s level. Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Used Automation Scheduling tools like AutoSys and Control-M
• Created process flow diagrams for all objects using Microsoft Visio.
• Developed test cases for Unit, Integration and system testing.
• Partitioned the Sessions for better performance.
• Involved with Scheduling team in creating and scheduling jobs in Autosys Workload Scheduler.
• Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 9.6, Oracle 11g, SQL, IDQ, DataStage,SSIS, PL/SQL, TOAD, Microsoft Visio, SQL Server 2008.

Confidential, Oklahoma City, OK

ETL Informatica Developer

Responsibilities:

• Involved in Business Analysis and Requirements collection.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management
• Created and designed sources to target mapping for SQL Server, Oracle and SAP database using Power Center.
• Worked on Informatica Power Center 8x tool - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used were: connected & unconnected lookups, Expressions, source qualifier, aggregators, filters, sequence generator etc.
• Hands on experience in other ETL tools like SQL server Integration Services (SSIS), Alteryx and Informatica.
• Extracted data from various heterogeneous sources like Oracle, Netezza, MS Access, and Flat files
• Created and configured workflows, worklets & Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Hands on experience with Informatica Data Explorer (IDE) / Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance
• Troubleshoot problems by checking sessions and error logs.
• Successfully used Agile/Scrum methods for gathering requirements and participated in story point discussions to analyze the level of effort required for development.
• Configured sessions using server manager to have multiple partitions Source data & to improve performance.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Comprehensive Cloud Integration and Data Management Solution for Microsoft azure
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Extensively worked on the Triggers, Functions and Database Constraints.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Perform process analysis in order to provide detailed documentation and recommendations to the Load forecasting team for future improvements
• Transition support of the Load forecasting applications/tools to an IT support organization and implement standard IT support processes and procedures.
• Prepared Unit test case documents
• Have performed Peer Reviews within the project.

Environment: Informatica Power Center 8x (Repository Manager, Designer, Workflow Manager), SQL server 2000, Oracle 9i, Autosys, Windows NT, Windows 2000, UNIX, Shell Scripting, TOAD, SAP database.

Confidential, SanFrancisco, CA

ETL Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Worked on developing SSIS packages and Informatica mappings.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Primary activities include data analysis identifying and implementing data quality rules in IDQ and finally linking rules to Power Center ETL processes and delivery to MDM Data Hub and other data consumers
• Designed and Developed Autosys to Schedule Informatica workflows.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created mapplets to use them in different mappings.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• 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.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension.

Environment: Informatica Power Center 9.0, cognos, Oracle 10g, SSIS, SQL, IDQ, MDM, PL/SQL, TOAD, UNIX, Flat Files, Teradata 14.0.

Confidential, Harrisburg, PA

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Involved in understanding of Business Processes, grain identification, identification of dimensions and measures for OLAP applications
• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processesusingInformatica power center.
• Have Knowledge on Informatica MDM concepts and implementation of De-duplication process
• Extensively used all the features of Informatica Versions 9.x and 8.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Extensively worked on Informatica IDE/IDQ.
• Involved in Migrating repository and mapping from Informatica 8.6.1 to 9.1.1.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width), and Excel files to staging database and from staging to the target Teradata Warehouse database.
• Created Data Marts and did System Testing of the Application.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and expression transformations in extracting data in compliance with the business logic
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Wrote stored procedures inPL/SQLand UNIX Scriptsfor automated execution of jobs
• Involved in Unit and System Testing of ETL Code (Mappings and Workflows)
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shell scripts.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.1.1, 8.6,SQL, IDQ, MDM PL/SQL, Oracle 10g, Flat Files, SSIS, UNIX, TOAD.

Confidential, Des Moines, IA

Informatica Developer

Responsibilities:

• Prepared High-level Design and Low-level Design based on Functional and Business required documents of the project.
• Extensively used all the features of Informatica Version 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Designed ETL process using Informatica Tool to load from Sources to Targets through data Transformations.
• Migrated data from Oracle, Flat files, Excel Files into the staging area which is in My Sql Server and Designed ETL processes that span multiple projects.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Developed Oracle Stored Procedures to update the data in control tables and account tables
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Extensively developed Stored Procedures and database triggers to support business functionality.
• Involved in Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Development to Test, Test to Prod environments.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Union, Rank, Normalizer, Update strategy and Router transformations for populating target table in efficient manner.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involved in Creation of SQL, Packages, Functions, Procedures, Views, and Database Triggers.
• Involved in Debugging and Troubleshooting Informatica mappings.
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Developed test cases for Unit, Integration and system testing
• Partitioned the Sessions for better performance.
• Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 8.6.1/8.1.1 , SQL, PL/SQL, SQL Server 2008, UNIX Shell Scripting, TOAD, Oracle 10g/9i.

Confidential

ETL Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Used Meta Data Manager to gather data from different applications and flat files for users to do impact analysis of the changes in the source systems.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the Oracle, flat files, and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Developed mapping parameters and variables to support SQL override.
• Worked on different Tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, work lets, Assignment, Timer and scheduling of the workflow.
• Created Scripts in Unix for installing Jobs for daily scheduling & alerting scenarios
• Used Debugger to test the mappings and fixed the bugs.
• Conducting the review of informatica code, Unit Test Cases and results with the developers
• Involved in Performance tuning of source, target, mappings, and sessions.

Environment: Informatica Power Center 8.6.1/8.1.1 , SQL, PL/SQL, UNIX Shell Scripting, TOAD, Oracle 10g/9i.