SUMMARY:

• 7+ Years of experience with all phases of SDLC including Analysis, Design, Development and Implementation of operational database systems (OLTP) and data warehouse systems (OLAP)
• Spent past 7 years primarily on Data warehouse projects using Informatica Power center, Oracle, SQL Server and Business Objects on UNIX and Windows platforms.
• Experience in database modeling like Erwin, MS Visio using ETL/Informatica and implementation of several database and data warehousing applications.
• Hands on experience with Informatica Data Explorer (IDE) / Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.
• Extensive ETL experience using Informatica 9.6.1/9.1/8.6.1 Power Center, Designer, Workflow Manager, Workflow Monitor, Server Manager and Power Exchange.
• Experience in Administration activities like Creating and Managing Repositories, Users, Groups, Folders and other administrator functions of Repository Manager.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) Star Schema, Snowflake, Slowly Changing Dimensions (SCD), Surrogate keys, Normalization/De normalization.
• Designed and developed Complex mappings from various transformations like Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more mappings using Stored Procedure’s, Normalizer, XML External Procedure
• Expertise in implementing complex business rules by creating re - usable transformations, and Mappings/ Mapplets and Creating Source and Target Databases.
• Good knowledge on SDLC, OOAD Techniques and experience with unit testing and integration testing.
• Experience in with major Relational Databases like Oracle, SQL Server, Teradata and MySQL.
• Worked on Data Integration using Informatica for the Extraction and loading of data from various data sources like databases, flat files, and XML files.
• Expertise on tools like Toad, SQL*Plus and SQL Server Management Studio.
• Performed ETL procedure of source system analysis, data transformation and load data from different sources into data marts and Data Warehouse.
• Experience in developing mappings and tuning existing mappings and sessions for better performance
• Used Informatica Version Control for checking versions of the objects used in creating the mappings, workflows and to keep track of the changes in the development, test and production environment.
• Written post SQL and pre-SQL at session level. Worked on session log files and workflow log files.
• Design, develop and unit test Informatica Power Center transformations.
• Execute ETL test plans, Document ETL processing and generate required metadata.
• Expertise in Production migration of new releases and Enhancements.
• Have a clear understanding of Business Intelligence and Data Warehousing Concepts.
• Worked with various clients in the Banking, Financial, HealthCare and Insurance industries.
• Participated in team meetings and proposed ETL Strategy, coordinating the work with offshore team.
• Ability to interact with individuals at all levels possess excellent presentation and interpersonal skills.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.5/8.6/8.1/7.1/6.2/5.1, Informatica Power Mart 7.x/6.x, Informatica Power Exchange 8.x/7.x, Repository Admin console, Repository Manager, Designer, Workflow Manager and Workflow Monitor Informatica MDM, IDQ

Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star schema, Snowflake schema, Dimensional data modeling, Snowflake modeling, Fact Tables, Dimension Tables

Databases/Files: Oracle 11g/10g/9i/8i, SQL Server, Teradata, MySQL, DB2, XML & Flat files

Oracle Utilities: Oracle SQL Developer, SQL * Plus

Operating Systems: Windows 7/vista/NT/2000/XP, MS-Dos, UNIX/ Linux, Ubuntu

Reporting Tools: Informatica Power Analyzer, Business Objects XI R3

Modeling Tools: Erwin 4.1/4.0, TOAD 9.x/8.x/7.x, SQL Loader 11g/10g, ER-Studio

Office Tools: MS PowerPoint, MS Word, MS Excel, MS Visio, MS Project

Programming: SQL, PL/SQL, C, C++, Java, Python, HTML

Scripting: UNIX Shell Scripting, Java-Scripting

Methodologies: Waterfall, Scrum, Agile

PROFESSIONAL EXPERIENCE:

Senior ETL Informatica Developer

Confidential, NY

• Created high and low-level design documents (LLD) for each mapping specification.
• Reviewed LLD’s with lead, peers and created mappings, mapplets, sessions, workflows as per it.
• Used Informatica repository manager to backup and migrate metadata in development, test and production environments.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Experience in integration of various data sources like Oracle, DB2, SQL server and MS access and non-relational sources like flat files into staging area.
• Coordinated with DBA in creating and managing tables, indexes, table spaces and data quality checks.
• Excellent Transact-SQL/PL/SQL (DDL/DML) programming skills using complex Stored Procedures, effective functions, Views, Indexes and appropriate Triggers.
• Used tools like TOAD and SQL navigator to run the queries and validate the dataloaded into Marts and different other layers like Data Warehouse and Persistent Staging.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, reporting and monitoring capabilities using IDQ 10.0.1.
• Solid Expertise in using both Connected and Un-Connected Lookup transformations.
• Developed Scripts to automate the Data Load processes to target Data warehouse.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and sequence buffer length.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Worked with BI team to deliver ETL based BI reports.
• Created documents like code review checklist and migration checklist for DB objects and Informatica objects (mappings, sessions and workflows)
• Migrated mappings, sessions and workflows from Development to Test environment.
• Involved in Performance testing of the mappings and workflows in production staging before installing in the Production environment.
• Performed the unit testing according to the test case documents created.
• Deployed the code to the User Acceptance Testing for further testing which includes Assembly testing, System testing and end to end testing for each module.

Environment: Informatica Power Center 9.5.1, Oracle 11g, Business objects, Unix/Windows.

Senior ETL/Informatica Developer

Confidential, Richardson, TX

• Involved in the source data landing process, wrote scripts to load various source files like txt, csv, delimited and oracle dump files.
• Responsibilities included source system analysis, data transformation and loading, validation for data marts and data warehouse.
• Worked closely with Business Analysts in requirements gathering (BRD) and source system analysis and translated the business requirements into technical specifications to build data warehouse.
• Analyze and Estimate durations for milestone after understanding requirements from Business Analyst.
• Interacted with both Technical, functional and business audiences across phases of the project life cycle.
• Upgraded from Informaticav9.1 to Informaticav9.5 and Converted Enabler Data into Frontier Compatible Systems.
• Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Worked with Oracle, Teradata and SQL stored procedure, table partitions, triggers, SQL queries, PL/SQL packages.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Extensively used various Data Cleansing and Data Conversion functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr, and IIF functions in Expression Transformation.
• Developed Informatica mappings, sessions and workflows as per the business rules and loading requirements using mapping parameters and variables.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Wrote ETL’s to build aggregate tables with roll ups and calculations to support BI reports.
• Ensured best practices like naming conventions, Performance tuning, and Error Handling.
• Responsible for Performance Tuning at the Source level, Target level, Mapping and Session Level.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Created the release requests and involved in the implementation of QA, UAT and Production releases.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.

Environment: Informatica Power Center 9.5, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer, Oracle 11g/10g, Teradata, XML

Informatica Developer

Confidential,Richardson,TX

• Extracted data transformed and loaded into Oracle database according to the specifications.
• Experience in creating Tables, Procedures, Functions, Views and other database objects on Oracle DB.
• Experience in writing Complex Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
• Developed mappings and mapplets extensively using Informatica Designer tools - Source Analyzer, Target Designer, Transformation Developer and Mapplet Designer and Mapping designer.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Union, Normalizer, Sequence Generator, Update Strategy, SQL Transformation, Stored Procedure, and Joiner.
• Created and ran workflows using Workflow Manager to load the data into the Target Database. Optimized/Tuned mappings for better performance and efficiency.
• 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, worklets.
• Created reusable components in the shared folder as it reduces time and effort.
• Integrated and installed IDQ on a Informatica power center server machine to cleanse data.
• Designed IDQ mappings which is used as Mapplets in Power center.
• Validate data in the reports using Business Objects and provide update on business queries.
• Involved in each phase of Software Development Life Cycle such as design, build, test and deployment phase.
• Deployed the code to the Production that follows the migration checklist.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Migrated mappings and workflows from the development server to the Test Server to perform the unit, integration and system testing.
• Involved in all the existing releases and helped the team in resolving critical issues.

Environment: Informatica Power Center 8.6.1/8.1, Oracle 10g, Windows XP.

ETL/Data Warehousing Developer

Confidential,NJ

• Used Informatica to create and organize various Metadata types, including legacy Source and Data warehouse Target data definitions and ETL jobs.
• Loaded operational data from Oracle, SQL server, flat files, Excel Worksheets into various data marts.
• Developed numerous Stored Procedures, Triggers and common functions using PL/SQL.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Created update strategy and stored procedure transformations to populate targets based on requirements.
• Major involvement in creating and tuning the mappings, to perform maximum efficiency and have complete knowledge of session properties in Work flow monitor.
• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.
• Built-in mapping variable / parameters and created parameter files for imparting flexible runs of sessions / mappings based on changing variable values.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Worked extensively on IDQ Analyst for Profiling, Creating rules on Profiling and Scorecards.
• Created Tasks and Workflows using Task Manager and Workflow Designer.
• Generated reports using Business Objects Report Designer.
• Debugged the mappings when there are issues with the data and involved in creating test case documents and test case scenarios.

Environment: Informatica Power Center 8.1, Work Flow Manager, Oracle 8i/9i, PL/SQL, Erwin, TOAD, Business Objects.

Data Warehouse ETL / SQL Developer

Confidential

• Interacted with business analysts, data architects, application developers to develop a data model.
• Good Business and System analysis skills to understand the requirements customize client applications and designed Domain model for it.
• Worked on creating mapping documents and used ETL for data conversion from legacy to new model.
• Created data dictionary to map data points from source to destination that were used for conversion.
• Coordinated with front-end developers for implementing logic in stored procedures and functions for faster retrieval of data.
• Used Teradata utilities (FASTLOAD, MULTILOAD) to load the bulk data into the Tables and also for comma delimited and fixed-width data files onto Teradata.
• Created new database objects like tables, procedures, functions, indexes and views using SQL in development and production environments.
• Expertise in Data cleansing, setup & management of centralized business data dictionary using MDS (Master Data Services)
• Used Source Qualifier, Aggregator, Filter, Expression, Lookup, Update Strategy, Router, and Joiner transformation.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Implemented slowly changing dimensions according to the requirements and maintained historical data.
• Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
• Create new & optimize existing reports using gauges, charts, click-through reports, maps etc. as well as Power BI Reports
• Developed views necessary for structured and ad-hoc reporting.
• Designed testing procedure and test plans assisted in Production support.

Environment: Informatica Power Center 6.1, Data modeling, Oracle 8i, SQL, PL/SQL, Teradata, Flat Files, Windows 2000

Informatica Developer

Confidential

• Analyzed relationships of Flat Files and to extract the analyzed systems, met with end users and business analyst to define the requirements.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Developed data Mappings between source systems and warehouse components.
• Worked with Informatica Administrator to setup project folders in development, test and production environments.
• Extensively worked in Oracle SQL, PL/SQL, Query tuning, Created DDL scripts, Created database objects like Tables, Indexes etc.
• Created mappings using Informatica Power Center Designer and extracted data from various sources and transformed data according to the requirement.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy.
• Created and Monitored Batches and Sessions using Informatica PowerCenter Server.
• Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.
• Tested all the backend programs, Informatica mappings and update processes.
• Involved in generating reports from DM layer using Business Objects.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Perform analysis and resolution of Help Desk Tickets and maintenance for assigned applications.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Stayed on call for support for any workflow failures or any Technical Issues.

Environment: InformaticaPowerMart7.1, Oracle, PL/SQL, Windows.