SUMMARY

• Informatica and Microsoft Certified Professional with 14+ years of experience in Data warehouse & Database Developer and Tester
• More than 11 years of extensive experience in Data Warehouse applications using Informatica, Oracle, DB2, Sybase, MS SQL server on Windows and UNIX platforms, which includes Analysis, Design, Development, performance tuning, Job scheduling, Test Data Management, Administration, Deployment & Production support
• Strong Data Warehousing ETL experience of using Informatica 9.6/9.1/8.6 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experience in Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in data modeling using Erwin.
• Knowledge Genie in Informatica Test Data Management Data TDM Masking Tool for data subset and data security.
• Experience in Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries
• Hands on experience in using Hadoop components like HDFS and HIVE
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, SYBASE, MS Access, XML and Teradata.
• Extensive experience in backend testing using Complex SQL Query using TOAD, Query Analyzer Tool, PLSQL Programming and T-SQL queries DDL/DML
• Demonstrated excellence in understanding of all phases in the software life cycle entailing requirement study, analysis, design, development, testing, implementation and support.
• Experience in using Automation Scheduling tools like Autosys and UNIX Shell scripts.
• Excellent Communication, presentation, interpersonal, analysis and leadership skills
• Proven ability to work efficiently in both independent and team work environments

TECHNICAL SKILLS

Databases: PL/SQL,SQL (2000/2005/2008 ), Oracle 10g/9i, DB2, Sybase, Toad, Erwin, SQL*Plus, Oracle SQL Developer, Oracle 11G SOA Suite and MS Access

Data warehouse Informatica: PowerCenter 9.1/8.6 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server), SSIS, SSRS, SSAS, Hadoop and BI Reports

Programming Languages: SQL, PL/SQL, T-SQL, JAVA/J2EE, JAVA Script, XML, HTML and UNIX Shell Scripting.

Operating System; Windows, UNIX and LINUX:

Testing and Automation Tools; QTP, QC, JIRA, Bugzilla, Autosys, OPTIM and ab initio.:

Domains: Banking, Insurance and Finance

Build Management Tools;Jenkins, JBOSS and GitHub/GitLab:

Content Management Tools: Helios and Alfresco

WORK EXPERIENCE

Confidential, Mclean, VA 

Informatica Developement/Team Lead

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Working experience as End to End ETL Development, Informatica ETL/Power center developer and ETL Tester with strong business understanding of client’s ILM life cycle management and SDLC and STLC testing methodologies.
• Experience in building the ETL architecture and Source to Target mapping to load data into Target using Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions.
• Develop mapping parameters and variables to support SQL override.
• Develop Autosys JIL Scripts to execute and Schedule the jobs         
• Creating the Tables, Views and Constrains
• Logical and physical Data modeling using erwin tool
• Handle Big Data using Hadoop Distributed File System and HIVE
• Incident Management for Production issue fix and change request
• Monitoring sessions using the workflow monitor and debugging the mappings for failed sessions.
• Coordinate requirements with Team and guide the team during Development and testing Phases. 
• Build and Code Deployment to Development integration, UAT and PROD
• Creating required TDM (Test Data Management)process documents for the new team members.
• Extensively used Rapid SQL utility for executing SQL scripts and Wrote complex SQL Queries involving multiple tables with joins.
• Wrote PL/SQL Store Procedure and Functions as part of the process to handle different scenarios.
• Attended daily status call with internal team and weekly calls with client and updated the status report.
• Data Validation and UNIT Testing

Informatica Developer/Team Lead

Responsibilities:

• requirements gathering, business analysis and designing of the data warehouse.
• Copied subset of secured data from Production databases to development and Testing environments using Informatica Test Data Management TDM by applying masking techniques.
• Create Complex mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Developed mapping parameters and variables to support SQL override.
• Used Debugger to test the mappings and fixed the bugs.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Logical and physical Data modeling using erwin tool
• Performance tuning at source, target, mappings, sessions, and system levels.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Creating required TDM (Test Data Management)process documents for the new team members.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Performed complex defect fixes in various environments like UAT, SIT etc. to ensure the proper delivery of the developed jobs into the production environment.
• Incident Management for Production issue fix and change request
• Unit Testing using the data compare Automation Tool and create the SQL Script for Data Validation
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Attended daily status call with internal team and weekly calls with client and updated the status report.

Confidential,Boston, MA 

Onsite Coordinator/ETL Team Lead

Responsibilities:

• Daily stand up meeting with Client. And updating the ongoing/planed Activity’s and its status
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Created and scheduled Sessions and Batches through the Informatica Server Manager.
• Designed and documented validation rules, error handling and test strategy of ETL process.
• Tuned Informatica mappings/sessions for better ETL performance by eliminating bottlenecks.
• Logical and physical Data modeling using erwin tool
• DDL script creation from the Logical Data Model that best suited the business requirement
• updated the Daily and Weekly status report.
• Create multiple SQL Server Agent Jobs to automate ETL and database maintenance processes.
• Develop a Utility for profiling, validating and cleaning data in the Operational Data Store.
• Develop a routine that detect, store and alert any Activity/Change that happened within the Data Warehouse and the Business Intelligence Environment.
• Responsible for UNIT testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Test data management (TDM)
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Responsible to send the Data Warehouse Quality report
• Lead and mentor other team members.
• Co-coordinating the onsite and Offshore activities/action items
• Preparation of Weekly/monthly status and metrics report
• Content Management using Helios and Alfresco Tools
• Metrics calculation and reporting to Client

ETL Lead

Responsibilities:

• requirements gathering, functional/technical specification, Designing and development of end-to-end ETL process for Sales Data Warehouse.
• Extraction, Transformation and Load was performed using Informatica Power Center to build Data warehouse.
• Accomplished automated data extraction from various RDBMS via UNIX shell scripts, ETL processing using Informatica and loading into Data Mart.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator) in a Mapplet and created new mappings using Designer module of Informatica.
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction
• Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc.,
• Implemented Type II slowly changing dimensions using date-time stamping.
• Extensively used ETL to load data from different databases and flat files to Oracle. 
• the development of Informatica mappings and also tuned them for better performance. 
• Created and scheduled Sessions and Batches through the Informatica Server Manager. 
• Worked with sessions and batches using Server Manager to load data into the target database. 
• Testing for Data Integrity and Consistency. 
• Metrics calculation and reporting
• Process Related activity
• Preparing Weekly and Monthly Status report.
• Analyzing and preparing the Effort estimation.

Offshore Coordinator/ Team Lead

Responsibilities:

• Requirement Analysis
• Used Informatica Power Center in Linux to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (SQL server, Oracle, Flat files).
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
• Physical database models creation for the insurance applications
• Created Tables, Stored Procedures, Triggers, Packages, and Views
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the DataMart and feeder systems in the aggregation effort.
• Responsible to send the Data Warehouse Quality report
• Developed Forms and Reports
• Automation Testing using QTP Tool
• Database and Data warehouse Testing
• Defect Reporting and Defect Retesting
• Application Support
• Metrics calculation and reporting
• Process Related activity

Team Lead

Responsibilities:

• Analysis of Requirements, Creating the Test plan
• Gathered business requirements from Business Analyst.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements.
• Designed and developed Informatica ETL mappings to extract master and transactional Large data from heterogeneous data feeds and load
• Installed and Configured the Informatica Client tools.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Created the environment for Staging area, loading the Staging area with data from multiple sources.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated
• Developed SQL Applications for extracting the data from the Oracle tables.
• enterprise web service development using J2EE and SOA SUITE
• Extensive testing was done on the programs for achieving accuracy, timely processing of data.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Responsible to send the Data Warehouse Quality report
• the development of backend procedures by using PL/SQL for ledger posting and for reversing the journal ledgers.
• Defect Reporting with Bug Priority and Status
• Preparation of Test Summary Reports

Team Lead

Responsibilities:

• Analysis of Requirements
• Preparation of Test cases reviewing the same.
• Execution of Test cases
• Created SSIS package for loading the data coming from various interfaces and also used multiple transformation in SSIS to collect data from various sources
• bug fixing and connectivity problems in JAVA J2EE Framework
• Created reports from Data Warehouse using SQL Server Reporting Services (SSRS).
• Used SQL Server Analysis Services (SSAS) to design and developing Tabular and Multidimensional Models
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Database Backend testing using SQL queries
• Build Management
• Defect Reporting with Bug Priority and Status
• Preparation of Test Summary Reports

Team Member

Responsibilities:

• Analysis of Requirements
• Preparation of Test cases reviewing the same.
• Execution of Test cases
• Defect Reporting with Bug Priority and Status
• Database Backend testing using SQL queries
• Preparation of Interim Test Reports