SUMMARY:

• To achieve a sound position in the corporate world and work enthusiastically with a team to achieve the goals of the organization.
• Extensively developed various mappings to perform ETL of source data into the OLAP/data warehouse.
• Worked with SQL, PL/SQL procedures and functions, stored procedures and packages within the mappings.
• Tuned Informatica mappings and sessions for optimum performance.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day - to-day ETL progress monitoring.
• Performed Confidential capture registrations
• Reusable transformations and Mapplets are built wherever redundancy is needed.
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
• Designed the Process Control Table that would maintain the status of all the Confidential jobs and thereby drive the load of Derived Master Tables.
• Used Teradata utilities like BTEQ, fast load, fast export, Multiload for data conversion.
• Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, ORACLE and Informatica.
• Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.
• Developed complex informatica mappings to load the data from various sources using different transformations
• Knowledge on Designing and Developing Amazon Redshift databases.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Parsing high-level design specification to simple ETL coding along with mapping standards.
• Strong trouble-shooting, problem solving, analytical and design skills.
• Effective communication, professional attitude, strong work ethic and interpersonal skills.

TECHNICAL SKILLS:

ETL Tool: Informatica 10.x/9.x/8.x PowerCenter/PowerMart/ PowerConnect, Workflow Manager, Workflow Monitor, Designer, Server Manager, Repository Manager, Informatica Cloud

Reporting Tool: OBIEE, MicroStrategy

Databases: SQL, Oracle, DB2, PL/SQL, Teradata, Greenplum, Amazon AWS Redshift

Development Process Models: Waterfall, Agile, Spiral, Prototype Model

Scheduling Tools: AutoSys, ESP CA workstation

Languages: C, C++, Java, PHP, Android, UNIX shell scripts

Office Package: MS: Office 2013/2010/2007/ XP/2003/2000

Web Technologies: Servlets, HTML, XML, CSS

Operating Systems: UNIX, MS DOS, Linux, Windows

EXPERIENCE:

Confidential, Ownings Mills, MD

ETL Lead developer

Responsibilities:

• Interacting with Business Users and Managers, stakeholders in gathering business requirements.
• Participate in High Level Design and Detailed design.
• Working on Impact analysis and system design documentations.
• Involving in System Development and Unit Test cases and support defect fixes for system integration and user acceptance testing.
• Implementation of the project requirements and providing warranty support. Working and resolving the incidents and problems management to ensure the client satisfaction.
• Providing the estimates for projects.
• Worked with SQL, PL/SQL procedures and functions, stored procedures and packages within the mappings.
• Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.
• Worked as Data analyst to analyze the source systems data.
• Created Design Documents for source to target mappings. Developed mappings to send files daily to AWS.
• Used UNIX scripting to apply rules on the raw data within AWS.
• Used Redshift within AWS
• Worked on Informatica PowerCenter 10.x tools like Source Analyzer, warehouse designer, Mapping Designer, Server Manager, Mapplets, and Reusable Transformations.
• Developed complex informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected lookup, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router.
• Developed Cloud mappings to extract the data for different source systems.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Performed Data validations and verification of source system to data and target system data which has been processed and loaded.
• Interacting with the Database Administrators for creating the new Databases, Tables and migration of scripts and DDL’s from one environment to the other environment.
• Working with offshore team to provide the support and guidance in resolving production issues.
• Working with Business to understand data related issues and resolve those production data issues.
• Involved in providing 24/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Worked with ESP for Job scheduling and created Scripts for ESP jobs.
• Created Unix Scripts for SFTP the files from one server to another.
• Tools Involved are Oracle, Mainframe, ESP, Informatica, Unix and MicroStrategy.

Confidential, Columbus, OH

ETL Lead Analyst

Responsibilities:

• Responsibilities included monitoring Data Loads and reporting on SLA’s and Data Availability.
• Involved in preparation of loading & extracting scripts using Teradata (MultiLoad, FastLoad, FastExport and BTEQ) utility.
• Troubleshooting data issues caused by various source systems.
• Working on Incidents (Job Failures/Missing and Invalid Data), Problems and enhancements requests.
• Worked on Informatica PowerCenter 9.x tools like Source Analyzer, warehouse designer, Mapping Designer, Server Manager, Mapplets, and Reusable Transformations.
• Wrote BTEQ scripts using complex business logic to load data. Offloaded certain calculations onto Teradata from SQL Server.
• Worked on Power Exchange for change data capture (CDC).
• Involved with preparation of High level and lowlevel Design documents and also with implement the jobs. Used SQ transformation and Teradata Queries to implement ETL logic.
• Loading data from several flat files sources to Staging using Teradata MLOAD, FLOAD, and TPUMP.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure, Java, Normalizer and Router transformations for populating target table in efficient manner.
• Performed Data validations and verification of source system to data and target system data which has been processed and loaded.
• Interacting with the Database Administrators for creating the new Databases, Tables and migration of scripts and DDL’s from one environment to the other environment.
• Working with offshore team to provide the support and guidance in resolving production issues.
• Working with Business to understand data related issues and resolve those production data issues.
• Involved in providing 24/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Worked with ESP for Job scheduling and created Scripts for ESP jobs.
• Created Unix Scripts for SFTP the files from one server to another.
• Tools Involved are Teradata, Mainframe, ESP, Informatica, Unix and MicroStrategy.

Confidential, Monterey Park, CA

ETL Developer

Responsibilities:

• Worked with Green Plum Database, Created Scripts and functions and wrote Psql queries in Greenplum.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Worked extensively on different types of transformations like Joiner, Aggregator, Router, Expression and Normalizer, connected / unconnected Lookups, Data Masking and Update strategy transformations.
• Overall coordination of all the ETL jobs developed and delivered.
• Used Parameter files with parameters and variables to restore multiple DB connections to the sources and targets.
• Extensively worked on Power Center Client Tools like Power Center Designer, Workflow Manager, and Workflow Monitor.
• Created Process Control and Metadata for Informatica jobs.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable Worklets and workflows in Workflow Manager.
• Involved in providing 24/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager
• Worked with trouble shooting in Production support and was responsible for fixing failed tests in Production Server.
• Worked with AutoSys for Job scheduling and created JIL Scripts for AutoSys jobs.
• Created Unix Scripts for SFTP the files from one server to another.
• Shared the work with offshore team members.
• Created Scripts in PostgreSQL to retrieve the data and to load the data into Greenplum.

Confidential, San Jose, CA

Informatica Developer

Responsibilities:

• Gathered the user requirements and designed data model flow for ETL mappings.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Used Pushdown Optimization to push the transformation logic on to the Database both on the Source and the Target sides where ever possible to improve performance of the mapping
• Implemented Star Schema for the data warehouse.
• Extensively worked on Power Center Client Tools like Power Center Designer, Workflow Manager, and Workflow Monitor
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like email, decision, command and pre/post SQL.
• To schedule the Informatica workflows we used DAC.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, dashboards, and star schema modeling.
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Performed migration and merging of RPD’s in OBIEE.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.

Confidential, Fremont, CA

Informatica Developer

Responsibilities:

• Involved in developing mapping from the design documents.
• Worked on Informatica PowerCenter 7.x tools like Source Analyzer, warehouse designer,
• Mapping Designer, Server Manager, Mapplets, and Reusable Transformations.
• Developed various Mappings, Mapplet and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Used various Transformations like Router, Filter, Joiner, Update Strategy and connected and unconnected lookups for better data messaging and to migrate clean and consistent data using the Informatica PowerCenter Designer.
• Built Repositories using Informatica PowerCenter Repository Manager to store Source, Target Transformations, Mapplet and Mappings metadata information
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
• Created Scripts using Teradata utilities (Fast load, Multi load, Fast export).
• Involved in creating secondary, join indexes for efficient access of data based on the requirements.
• Extensively used Multi-Load and Fast-Load utility to populate the flat file data into the Teradata database Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target Worked with the Business Analysts for requirements gathering, business analysis and testing.
• Created Informatica mappings with PL/SQL procedures/Functions to build business rules to load the data.
• Unix Scripts were written at various situations like event automation and job scheduling.
• Captured the business requirements, worked on gap analysis, and prepared the gap analysis document.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, dashboards, and star schema modeling.
• Created MUD (Multiple user Development) environment by utilizing projects in OBIEE.
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Performed migration and merging of RPD’s in OBIEE.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• OBIEE 10.2.3.x/ 11.1.1, Oracle Business Intelligence Admin, Presentation and Publisher.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Oracle 10g, 11g, 9i and 8i, SQL Server 2000/ 2005, My SQL, MS Access
• Informatica, Data stage and Meta Data
• SQL Developer, Data Warehouse Application Console
• HTML/ DHLTL/ XMS/ XML, UNIX Shell script
• Report to the senior OBIEE consultant with weekly and monthly project status report

Confidential

ETL/Oracle Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using stored procedures into the database. Involved in Logical and Physical modeling of the drugs database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.