SUMMARY

• 16 plus years of extensive IT experience in gathering Business Requirements, Analysis, Design & Data Modeling, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence. Expert in utilizing ETL tool Informatica Power Center 10.x/9.x/8.x/7.x/6.x for developing the Data warehouse loads with work experience focused in Data Acquisition and Data Integration.
• Interacted with Customers and business directly to understand the requirements and to provide IT solutions.
• Strong Working Experience with various clients ranging from Healthcare, Banking Industries.
• Highly involved in preparing High - Level and Low-level Design Documents.
• Strong understanding of Data warehouse project development life cycle. Expertise in documenting all the phases of DWH projects.
• Strong experience in handling the production support projects.
• Strong ETL (Extract Transform Load) Data Warehouse experience using Informatica Power center, Informatica Power Mart, Repository Admin console, Repository Manager, Designer, Workflow manager, Work flow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Mapplets, Mappings, Workflows, Sessions, Re-Usable Transformations.
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements. Expertise in Data Flow Diagrams, Process Models, and ER diagrams with modeling tool ERWIN.
• Extensive Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Excellent knowledge in identifying performance bottlenecks and tuning the Mappings and Sessions by implementing various techniques.
• Experienced in logical and physical data modeling of staging and warehouse environments using Data modeling tools like Erwin and Oracle Designer.
• Expertise in implementing complex Business rules by creating robust mappings, Mapplets, reusable transformations using transformations like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc. .
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.
• Expert in implementing Type 1 and Type 2 Slowly Changing Dimensions as per the requirements.
• Extensive Experience in Performance tuning in Informatica on various levels like sources, mappings and sessions.
• Expertise in Session partitioning, tuning and lookup/aggregator/joiner caches for performance enhancements
• Strong in database programming using PL/SQL and SQL with creation of packages, stored procedures, functions, triggers, materialized views, cursors and performance tuning of SQL.
• Practical knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, Surrogate keys, Normalization/De normalization, FACT and Dimensional Tables.
• Strong in scheduling ETL load using Informatica scheduler and, Austosys.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
• Exposed to Quality related activities like Project Process Monitor, Software Project Plan, Traceability matrixes, Fish bone analysis, Metrics, Estimated and Actual Effort, Schedule variance, Configuration managements, Defect prevention etc.
• Involved in various stages of testing (Black Box, White Box, Unit, System, Integration, and User Acceptance Test).
• Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.
• Knowledge on DevOps processes

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter9.x/8.x/7.x/6.X Power Exchange / Power Connect, Data Validation Option DVO, Data stage, Abinitio

Business Intelligence: OBIEE, Cognos, business objects, tableau,SSRS, Power BI

Databases: Oracle 12g/11g/10g/9i/8i, SQL Server 2008/2012/2014/2017/2018 , MS Access

Utilities: Quest Toad for Oracle, SQL * Loader, Aqua Data Studio, Aginity

Operating Systems: Windows, Unix, Linux

Languages: SQL, PL/SQL, HTML, XML, core JAVA 1.2

Methodologies: Data Modeling Logical / Physical, Star, FACT & Dimension Tables, OLAP, SDLC, ETL

Data Modeling Tool: ERWIN, MS Visio

Job Scheduling Tools: Informatica scheduler, Autosys, Control-M

Quality & devOps: DVO(data validation option), Undraleu, HP ALM

PROJECT EXPERIENCE:

Confidential, Tampa, Florida

Senior software engineer

Responsibilities:

• Responsible for working with the Business analysts for gathering functional requirements and analysis.
• Analyzed the functional specification requirement document and created technical design document for mapping all the business requirements.
• Formulating the ETL mappings to implement the business logic Using transformations like lookup, update strategy, expression, filter, router, aggregate, Sorter, Rank, Joiner, Source Qualifier, XML Generator, Unstructured Data transformation, Stored Procedure, Normalizer.
• Extensively worked with Joiner transformation using the four types of joins- Normal Join, master outer join, detail outer join, and Full Outer join.
• Extensively worked with various look up cache like Static Cache, Dynamic Cache, Persistent Cache, and Shared Cache
• Worked increasing the DTM Buffer Size, Incremental Loading, Incremental aggregation
• Worked with tracing levels for performance tuning of the mappings-Terse, Normal, Verbose Initialization, and Verbose Data.
• Extensively worked with Pipeline Partitioning like Round Robin Partitioning, Hash Partitioning, Key Range Partitioning, and Pass-through Partitioning.
• Extensively worked with Incremental Aggregation.
• Developed Reusable Transformations and Reusable Mapplets.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Development environment.
• Capturing requirements from the Business Analysis Team, designing Test Plan, Test Strategy, Test scenarios and executing SIT test cases, reporting defects and performing regression testing to ensure minimal UAT/post-production defects.
• Worked with the third party scheduler Autosys for scheduling Informatica Power Center Workflows
• Responsible for the Promotion of Mappings, Workflows and other Informatica objects like sources, targets, and transformation between environments like DEV, INT, UAT and PRD-Development, Integration Testing, User Acceptance Testing, and Production.
• Creating B2B Mapper & serializer to convert the data from XML to X12 (Healthcare Proprietary format) using Informatica Data transformation Studio.
• Creating Reusable Transformations to prevent redundancy of transformation usage and modularity.
• Leading the technical design reviews, assisted with database design and architecture.
• Supported migration of ETL code from development to QA and then QA to production.
• Production support and bug fixing.
• Experience in analyzing and converting EDI transaction set 837,835,999 and 277.
• Experience on ASC X12 versions 4010 and 5010.

Environment: Informatica Power Center 10x/9x, Oracle12g, SQL Server 2018, Aginity Greenplum, UNIX, Data Validation Option DVO, SQL Developer, HP ALM, TFS, Autosys, Control-M, DevOps, Windows 10.

Confidential, Warren, New Jersey

Senior software engineer

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Involved in Requirement Analysis, ETL Design and Development for extracting the data, which is stored in different sources like Oracle, XML, and SQL Server.
• Analyzed, designed and developed an environment that would facilitate the use of Informatica to transform data coming from OLTP into DataMart.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, Worklets, workflows for the mapping to run daily, biweekly based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development mappings for all the dimension tables.
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
• Implemented Slowly Changing Dimension type2 methodology in Informatica.
• Worked on handling performance issues of Informatica Mappings, evaluating current logic for tuning possibilities.
• Tuned SQL Queries in Source qualifier Transformation for better performance.
• Created and executed unit test cases for various scenarios for all the mappings, workflows and scripts.
• Extensively worked with Designer tools like Source Analyzer, Target designer, mapping designer.
• Extensively used various Active and Passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Lookup Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Developed Reusable Transformations and Reusable Mapplets.
• Responsible for implementing Incremental Loading using Mapping Variables and Parameter Files.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Worked on multiple input and output ports to improve the streamer in transformation B2B.
• Eliminated programmatic effort to handling various translations formats in data exchange.
• Improved partner network efficiency in integration hubs with data exchange.
• Extensively used SQL override function in Source qualifier Transformations.
• Used parallel processing capabilities, Session-partitioning and Target table partitioning techniques.
• Expertise in using TOAD and SQL for accessing the Oracle database.
• Provided data to the reporting team for their daily, weekly and monthly reports.
• Responsible for the performance tuning in Informatica for target, source, mapping, transformations, session and system levels.
• Production support and bug fixing.
• Interacted with business users and business analyst to understand requirements and system requirement specifications document.
• Implemented dimension model (logical and physical modeling) in the existing architecture using Erwin.
• Worked with active transformations in Informatica power center like Filter, Aggregator, Joiner, Rank, Router, Sorter, Source qualifier, and Update Strategy transformations.
• Designed and developed complex mappings from various transformations like unconnected and connected lookup’s Expression, Sequence generator and more.
• Implemented slowly changing dimensions according to the requirements.
• Used Workflow manager for creating, testing and running sessions and batches.
• Extracted data from DB2 and Oracle source systems and loaded into flat files using Informatica.
• Designed incremental loading process to load data into staging tables...
• Optimized existing applications at the mapping level, session level and target level for better performance.
• Developed PL/SQL procedures, functions to facilitate specific requirement.
• Configured the sessions using Workflow manager to have multiple partitions on source data and to improve performance.
• Identified and removed bottlenecks in order to improve performance of mappings and workflows.
• Developed shell scripts for Informatica pre-session, post-session scripts
• Developed test plans and test scripts to test the data based on the business requirements.
• Responsible for regression testing ETL jobs before test to production migration.
• Scheduling the jobs by using third party tool Autosys.
• Working on jil script of inserting/updating/deleting jobs in Autosys.
• Moving the scripts/files into different servers.
• Working on UNIX scripts to move data from Source system to ODS tables.
• Exporting and Importing of Informatica and Database objects between servers.
• Scheduling, Project Monitoring and controlling.
• Impact Analysis, Re-design the functionality changes of all the effected.
• Coordination for Unit, Integration, System and UAT testing.

Environment: Informatica Power Center, Abinitio, OBIEE, Oracle9i/10g, Toad, PL/SQL, PeopleSoft, Essbase, Autosys, Aqua Data Studio, Win NT, UNIX, MS Visio, Windows XP

Confidential, Bridgewater, New Jersey

Software engineer

Responsibilities:

• Assisted in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation for the project.
• Created Workflows, Tasks, database connections, FTP connections using Workflow Manager.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Created the Mappings using Informatica to create the input feed according to the standard format work file to process for accounting engine.
• Extensively used Transformations for heterogeneous data joins, complex aggregations and External procedure calls.
• Created various mappings and Mapplets, transformations, lookups etc. to validate the fields and derive the fields based on the input and converting raw input data into standard accounting data format.
• Wrote several stored procedures for recycling and other extraction purposes.
• Populated the warehouse and documented the existing mappings as per standards.
• Used Workflow Manager for Creating, Validating, Testing and running the workflows and Sessions and scheduling them to run at specified time.
• Identified and resolved the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Used TOAD to run SQL queries and validate the data in Data warehouse and Data mart.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Optimized SQL queries for better performance.
• Extensively worked with performance tuning of ETL mappings and sessions.
• Responsible for determining the bottlenecks and fixing the bottlenecks.
• Responsible for Unit Testing of Mappings and Workflows.
• Worked on creating staging Tables, Indexes, Sequences, Views and performance tuning like using SQL Loader/Parallel to load into tables, analyzing tables, proper indexing and dropping.
• Performed the Unit Testing, which validated that the data mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.
• Experience in working with XML sources.
• Created and Documented ETL Test Plans, Test Cases, Test Scripts, Test Procedures, Expected Results, Assumptions and Validations.
• Worked with Session logs and Workflow logs for Error handling and troubleshooting in Dev environment.
• Involved in writing the Kornshell programming.
• Developed UNIX Shell Scripts, AIX and PL/SQL procedures and LINUX VM functions as well as coding.
• Responsible for testing ETL jobs before test to production migration.
• Supported migration of ETL code from development to QA and then QA to production

Environment: Informatica, Business objects, Oracle 8i/9i, Windows 2000/NT, SQL*Plus, TOAD, UNIX

Confidential, Columbus, Ohio

Software engineer

Responsibilities:

• Understanding existing business model and customer requirements.
• Working on ETL Mapping design using Informatica.
• Used heterogeneous data sources, like flat files and Oracle.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
• Worked on connected as well as unconnected Lookup transformation to look up values in a table.
• Created reusable transformations and Mapplets using Informatica.
• Created and Monitored Informatica sessions.
• Worked on Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer and Transformations, Workflow Manager and Monitor.
• Used various transformations like expression, rank, lookup, filter transformations etc.
• Resolving issues in transformations and mappings
• Analyzed the sources, targets, transformed the data, mapped the data and loading the Data into targets using Informatica Power Center.

Environment: Informatica, Cognos, Oracle, Win NT, UNIX TOAD, PL/SQL, UNIX