OBJECTIVE:

• To obtain a position as a Sr. ETL Developer in the field of Data Warehousing.

SUMMARY:

• Professional work experience in Data Warehousing/Data Mart Design, System
• Analysis, Development, Database Design, SQL, Transact - SQL, PL/SQL programming, Scripting.
• Extensive experience in Data Warehousing, ETL (Extraction, Transformation,
• Loading) using Informatica 9.x/8.x/6.x.
• Expertise in implementing complex Business rules by creating robust Mappings,
• Mapplets, and reusable Transformation using Informatica Power Center.
• Working knowledge on different data sources such as Oracle, SQL Server, Flat Files.
• Experience in creating different mappings using Aggregator, Expression, Joiner,
• Router, Filter, Lookup, Update Strategy, Sequence Generator, Sorter, Rank.
• Experience in creating complex mappings which involved Aggregation, Fact, Slowly
• Changing Dimension Type I & Type II to implement Business logic.
• Experience in creating Sessions, Worklet, and Workflows by using Workflow
• Manager, test the flow, and monitor with Workflow Monitor.
• Experience in optimizing query performance, session performance, and fine tuning the mappings for optimum performance.
• Extensive experience in SQL, Transact-SQL, PL/SQL Procedures, Packages.
• Experience in UNIX Shell scripting, scheduling cron jobs using crontab.
• Extensive experience in Production Support such as quick research, identify issues, and resolve issues.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows 10/7/XP

ETL Tools: Informatica (Power Center 9.x/8.x/6.x), SAP Data Services 4.2/3.1

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2012/2008/2005

Database Tools: SQL, Transact-SQL, PL/SQL, TOAD, SQL *Plus, SQL *Loader

Data Modeling: ERwin 3.5.2

Reporting Tools: Cognos ReportNet, Business Objects 5.1

Scripting: UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. ETL Developer

Responsibilities:

• Analyzed existing business model and customer requirements.
• Provided proactive communication regarding the status of projects or key initiatives to project teams, management, and business stakeholders.
• Used ETL methodology for complete processing of Data Extraction, Transformations
• & Loading steps, in a corporate wide ETL solution using Informatica Power Center.
• Informatica Designer tool was used to design the source definition from SAP
• Hana Studio, target definition, and transformations to build mappings and loaded into data warehouse area which was in Oracle.
• Created ETL mappings using transformations such as Source Qualifier, AggregatorExpression, Joiner, Connected & Unconnected Lookup, Filter, Router, Sequence Generator, Update Strategy, Sorter.
• Created complex mappings which involved Aggregation, Summarize Fact, Slowly
• Changing Dimensions Type I and Type II to implement Business Logic and capturing historical records in the Data Warehouse.
• Created and scheduled Workflows, jobs based on run on customized repeat optionsrun on demand, and run only once using Workflow Manager.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error condition.
• Extensively worked in the performance tuning programs, ETL procedures and processes.
• Extensively used SQL, PL/SQL scripts to create different reporting scripts and loaded into monthly reporting tables.
• Extensively used and maintained UNIX shell script and automated the processes using Crontab.
• Extensively involved in Production Support of existing Data Warehouse such as quick research, identify issues, resolve all data integrity issues related to ETL processes or source data in production environment.
• Provided support and guidance to offshore team as needed to resolve nightly batch data load issues.

Environment: Informatica Power Center 9.6, SAP Hana Studio 2.3, Oracle 11g/10g, SQL, PL/SQL, TOAD, UNIX, Windows 10.

Confidential, Irving, TX

Sr. ETL Developer

Responsibilities:

• Primarily responsible to convert business requirements into system design.
• Provided consistent and reliable communication regarding the status of projects and leveraged existing tools to develop cost-efficient technology solutions that maximize business value.
• Extensively used PL/SQL to create Stored Procedures according to business rules and loaded data into Analytics Data Warehouse in Oracle which stores online activities data visited by prospective or existing customers using web application.
• Maintained Analytics Data Warehouse for the data analysis effort using TOAD and modified PL/SQL scripts to resolve issues uncovered related to design or source data.
• Designed ETL processes which extract data from SAP BW to Oracle database using
• SAP Data Services ETL tool, comprehensively using the functionality of the tool.
• Optimized the Data Services nightly batch cycle to improve data reliability and availability within Analytics Data Warehouse.
• Further implemented ETL processes to extract and load data from other SAP applications such as IS-U and CRM environments using Data Services ETL tool.
• Extensively involved in Production Support of existing Data Warehouses to resolve issues related to source data or design.
• Leveraged Service Now tool to provide consistent and reliable updates regarding the status of Incidents (IM), and Service Requests (SR).

Environment: SAP Data Services 4.2/3.1, Oracle 11g/10g, SQL, PL/SQL, TOAD, Business Objects, UNIX, Windows 7.

Confidential, Irving, TX

ETL Developer

Responsibilities:

• Primarily responsible to convert business requirements into system design.
• Analyzed existing business model to implement client’s business requirements and loaded conversion data into OLTP database area, which was in Oracle.
• Extensively used Oracle utilities and tools like SQL *Loader to load client’s data into
• OLTP database area.
• Extensively used SQL and PL/SQL scripts to define ETL processes for complete processing of data extraction, transformation, and loading steps to create outgoing batch files for clients.
• Extensively used SQL scripts and PL/SQL stored procedures to build business rules to create outgoing batch files and used SQL spool scripts to load daily/monthly data in a fixed length format into Flat Files that was sent to clients.
• Designed and developed complex Fact/Summary data identified by dimensions data using business rules which were used to create daily/weekly/monthly reports.
• Performed Unit testing and tuned SQL queries for better performance.
• Wrote UNIX Shell scripts and created automatic scheduling of jobs to automate batch processes using Maestro (Tivoli Workload Scheduler) job scheduler.
• Extensively involved in production support of existing batch jobs and data warehouse jobs such as research, identify issues, and resolve issues.
• Maintained all batch jobs and data warehouse jobs using SQL tools like TOAD to run
• SQL queries and resolved data integrity issues related to design or source data.
• Supported client’s ad hoc requests.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, Maestro (Tivoli Workload Scheduler), UNIX, Windows XP.

Confidential, Irving, TX

ETL Developer Consultant

Responsibilities:

• Primarily responsible to create a central Data Warehouse.
• Implemented business model in Informatica Power Center to standardize data from various sources and loaded into data warehouse area, which was in SQL Server.
• Extensively used ETL to load data from wide range of sources Flat Files, SQL Server.
• Created ETL mappings using transformations such as Source Qualifier, AggregatorExpression, Normalizer, Connected & Unconnected Lookup, Joiner, FilterRouter, Sorter, Update Strategy, Sequence Generator.
• Created complex mappings which involved Summarize Fact, Slowly Changing
• Dimensions Type I and Type II to implement Business Logic.
• Converted Stored Procedure into ETL mappings using Informatica Designer tool that was originally developed in Transact-SQL.
• Used Debugger to troubleshoot the mappings.
• Used pre-session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
• Created Workflow, Worklet, Workflow tasks and scheduled jobs based on customized repeat options using Workflow Manager.

Environment: Informatica Power Center 8.6, SQL Server 2008, SQL, Transact-SQL, Windows XP.

Confidential, Austin, TX

ETL Developer

Responsibilities:

• Primarily responsible to support four different Data Warehouses.
• Implemented business model in Informatica and used ETL to standardize data from various sources and targeted into Data Warehouse area, which was in Oracle.
• Created mappings using various transformations like Joiner, AggregatorExpression, Lookup, Filter, Sequence Generator, Update Strategy, Stored
• Procedure upon requirement.
• Created complex mappings which involved Aggregation, Fact, Slowly Changing
• Dimension Type I and Type II to implement business logic.
• Created and scheduled Workflows then executed sessions, sequential and concurrent batches for proper execution of mappings and sent on success and failure e-mail using Workflow Manager.
• Maintained all Data Warehouses for the data analysis effort using TOAD and modified ETL mappings to resolve issues uncovered related to design or source data.
• Extensively involved in Production Support of existing Data Warehouses such as quick research, identify issues, resolve issues, answering questions.
• Extensively involved in reviewing all data fixes and generated SQL script based on user request then implemented all those scripts in production environment to ensure data integrity of Data Warehouses.
• Remedy User tools are heavily used for all change management, incident management, and request task management.

Environment: Informatica Power Center 8.1, Oracle 10g/9i, SQL Server 2005, SQL, Transact-SQL, PL/SQL, TOAD, Windows XP.

Confidential, Carrollton, TX

ETL Developer Consultant

Responsibilities:

• This project involved creating a Data Warehouse for sales/inventory reporting system.
• Data from ODS (Operational Data Source) was extracted, transformed, and loaded into EDW (Enterprise Data Warehouse) using SQL, PL/SQL stored procedures.

Confidential, Lake Forest, CA

ETL Developer

Responsibilities:

• Involved in the design and development of a data warehouse environment based application for studying various segments of the customer base and for regular reporting. Primary responsibility was intended to extract, transform and load data into an Oracle database and maintain existing Data Warehouse.