SUMMARY:

• Around 8 years of total IT experience in the Analysis, Design, Development, Testing, Implementation, Administration and Support of Database Systems in UNIX and Windows environments.
• Strong working experience in designing and developing of Extract transfer and Load ETL processes on Teradata.
• Hands on experience using Teradata utilities SQL, BTEQ, FastLoad, MultiLoad, FastExport, Queryman, WinDDI and Unix Shell scripting.
• Strong working experience on Data Warehousing applications, directly responsible for the Transformation, Extraction and Loading data of multiple formats into Data Warehouse.
• Proficient in Database Performance Monitoring, SQL Query Tuning.
• Managed scheduling of large ETL systems using CTRL-M and Shell Scripts.
• Coded well-tuned SQL and UNIX Shell scripts for high volume data warehouse instances.
• Well versed with Data Warehousing concepts, design techniques and dimensional modeling
• Extensive experience in designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger..
• Good Knowledge of Data Modelling, Data Extraction, Data Integration and Data Mining for DSS as a Data Warehouse developer using ETL Ab Initio, Data Stage, Informatica and OLAP Tools.
• Involved in Data Migration between Teradata, Oracle Peoplesoft, and MS SQL server.
• Programming experience using SQL, PL/SQL Stored Procedures, Functions and Triggers , Oracle, VBScript and UNIX Shell Programming
• Strong knowledge of Extraction Transformation and Loading ETL processes using UNIX shell scripting, SQL Loader.
• Proficient in using DataStage Director to schedule jobs.
• Proficient in Teradata Database Design Physical and Logical , Application Support, Performance Tuning, Optimization, User Security Administration, Data Administration and setting up the Test and Development environments.
• Extensive experience in handling ETL using Informatica Power Center/Power Mart 8.X/7.x/6.x/5.x., Oracle 10g and Unix Shell Scripts.
• Strong experience in developing complex mappings using various transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Stored Procedure, Update Strategy and Re-usable transformations.
• Strong experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.

Technical Skills

Confidential

Sr. ETL Developer

Confidential is well known as America's largest 4G LTE network. Its ranked 15th among Fortune 500 companies. Verizon also provides converged communications, information and entertainment service FIOS all over USA, and also delivers business solutions to customers in more than 150 countries.

Responsibilities

• Played Senior ETL consultant role from the Requirement phase
• Organized multiple requirement discussion meetings with Business Users and Source system experts and formed functional and technical specs
• Major part of the project involves migration from oracle to teradata. This includes migration of code, migration of data, documenting the migration process, extensive testing and validation.
• Developed a standard ETL framework to enable the reusability of similar logic across the board.
• Extensively used Informatica Power Center 8.6/9.1 for extracting, transforming and loading into different databases.
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Developed Mappings for loading data from Multiple Sources into Teradata tables.
• Performed Database/ETL migrations from Dev. environment to Test/Training/UAT/Staging and PROD environments.
• Used database objects like views, Partitioning for accomplishing the Complex logical situations.
• End to end development of Data Warehouse.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Scheduled the tasks to be run using the Workflow Manager.
• Responsible for Self and Peer Review of Informatica mappings under Development Phase
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation Connected and Unconnected , Joiner Transformation, Router Transformation and Normalizer Transformation in Informatica.
• Implemented slowly changing dimensions according to the requirements and Partition sessions
• Prepared the test execution plan and tracking the execution plan.
• Done ETL mapping unit testing, UAT and also developed test plans.
• Created and Monitored Sessions and various other Tasks using Informatica Workflow
• Used EXPLAIN Table plans to tune the SQL Quires.
• Used IDQ for data quality.
• Extensively writing Teradata Coding with multiple SQL statement scenarios in Dev and Prod Environment.
• Preparing Mloads, Bteq's, FastExports, and Fastloads for loading and modifying data according to the requirements
• Tuning and optimization of SQL/Teradata Queries, Change request management.

Environment: Informatica 8.6/9.5.1, Teradata 14.10,IDQ, Oracle 10g, MDM,UNIX Shell Programming

Confidential

Systems Engineer Developer

Responsibilities

• Communication with business users and analysts on business requirements.
• Creating Scope doc's and coming up with Technical design.
• Working on SQL's to get required data.
• Using Informatica to load data from source to staging.
• Helping the Reporting team by providing the Teradata SQL queries.
• Working on Claims and memberships Subject Areas.
• Involvement in implementation of BTEQ and Bulk load jobs.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Exporting Data using BTEQ and Fast Export.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator
• Execute the SQL's on UNIX environment.
• Expertise in working with various operational sources like Oracle and Mainframe.
• Have Knowledge on PMON.
• Performance tuning the long running queries.
• Developed processes on Teradata using RDBMS utilities such as Fast Load, FastExport, BTEQ Teradata .
• Involved in understanding requirements and in modeling activities of the attributes identified from different source systems which are in Oracle, Teradata, CSV FILES and Mainframe.
• Troubleshooting the failure Jobs.
• Checking the table skewing.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Tuning and optimization of Teradata Queries.
• Code review's in production issue's.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities.

Environment: Teradata V2R13, Teradata Queryman, Oracle 8i, Utility: Teradata Loading Utilities Bteq, Multiload, Fastload, Fast Export , Powercenter9.

Confidential

Role: Sr. ETL Developer

Confidential is a biotech company aimed towards providing innovative solutions of high quality for unmet medical needs. The project was aimed toward facilitating user access to key services via the Patient Access Programs. These programs are driven towards providing patients and healthcare providers with coverage and reimbursement support, patient assistance and informational resources

Responsibilities:

• Developed forward and backfill strategies to load data as per requirements Created several DB2/UDB7 Database scripts to load backfill data to Data Warehouse.
• Worked within a team to populate Type I and Type II slowly changing dimension tables from several operational source files.
• Extensively used DB access to DB2 and Oracle 9i using SAS SQL pass-thru facility. Extensively used the following SAS features: data, data null , sort, merge, append, transpose, tabulate, freq, means, summary, contents, copy, print, datasets, compare, report, format, proc sql, macros, symput, symget, includes and ods to create various SAS reports.
• Did the production support and maintenance of the existing Data Mart processes. Involved in enhancements to the existing Data Marts.
• Did the performance tuning of user queries by analyzing the explain plans, recreating the user driver tables by right primary Index, scheduled collection of statistics, secondary or various join indexes.
• Involved in the collection of statistics on important tables to have better plan from Teradata Optimizer.
• Created several BTEQ scripts involving derived tables and volatile/Global temporary tables for adhoc purpose to extract data for several business users on scheduled basis.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, DDL Commands and DML Commands SQL . Created various Teradata Macros in SQL Assistant for to serve the analysts.
• Created proper Teradata Primary Indexes PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth fast and easy access of data.
• Involved heavily in writing complex SQL queries based on the given requirements such as complex DB2 Joins, Sub Queries, Stored Procedures, Macros etc.
• Participated in Unit and Integration testing and also participated in User Acceptence Testing UAT .
• Used existing Enterprise Balance and Control framework to do the audit checks with ETL processes.
• Did the SQL performance tuning by scanning through.
• Involved in user training and support for data mining and reporting.

Environment: Teradata-V2R6, BTEQ / BTEQWin, FastLoad, MultiLoad, FastExport, Visual Explain, Queryman, Oracle 9i, PL/SQL, IBM-MAINFRAMES.

Confidential

ETL Developer

Confidential offers a broad range of financial services including wholesale finance plans, dealer finance plans, dealer services, retail consumer finance plans, lease programs and insurance programs. The central Data Warehouse stores data from all the areas and generates reports to help customers and staff to analyze the trends in the business and come up with the most innovative and efficient methods of doing business.

Responsibilities:

• Member of core ETL team involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target DW.
• Analyzed the business requirement document and created functional requirement document mapping for all the business requirements.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Extracted source data using power exchange from legacy systems.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Designed and Developed ETL logic for implementing CDC by tracking the changes in critical fields required by the user.
• Developed Informatica sessions and workflows for all mappings.
• Used mapping parameters and variables.
• Automated the load process using UNIX shell scripts.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created reusable objects in Informatica for easy maintainability and reusability.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Developing UNIX scripts and PERL scripts for pre data manipulation.
• Responsible for regression testing ETL jobs before test to production migration.
• Supported migration of ETL code from development to QA and then from QA to production.

Environment: Informatica Power Center 8.1, Teradata: V2R5, Erwin, TOAD, PL/SQL, Oracle 10g and UNIX Scripting.

Confidential

ELT Developer

Confidential most recognized brands in Mortgage loans and Refinancing services. This company has provided many loans and financing too many people. Informatica Power Center was used to build the base tables in the data warehouse. Source analyzer, Transformation developer and Mapping designer have been used to build data for the metadata, which was then stored in the repository. Transformation language was used for writing filter conditions and expressions

Responsibilities:

• Major part of the project involves migration from Informatica 7.1 to 8.1. This includes training, migration of code, migration of data, documenting the migration process, extensive testing and validation.
• NCM is America's most recognized brands in Mortgage loans and Refinancing services. This company has provided many loans and financing too many people. It has many customers all over the United States with a large capital share in the market. As an ETL Developer, my role was to generate the information of customers, their Loan rates, interests, Home equities, and generate the end reports using Informatica.
• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Analyzed the logical model of the databases and normalizing it when necessary.
• Involved in identification of the fact and dimension tables.
• Extensively used Informatica Power Center 7.1 for extracting, transforming and loading into different databases.
• Wrote PL/SQL stored procedures and triggers for implementing business rules and transformations
• Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.
• Created Source and Target Definitions in the repository using Informatica Designer Source Analyzer and Warehouse Designer.
• Worked extensively on different types of transformations like Source qualifier, Expression, Filter, Aggregator, Rank, Lookup, Stored procedure, Sequence generator.
• Used Mapping Designer to create mappings.
• Replicated operational tables into staging tables, to transform and load data into the enterprise data warehouse using Informatica.
• Created and scheduled Worklets, configured email notifications. Set up Workflow to schedule the loads at required frequency using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Manager.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse
• Documented Data Mappings/ Transformations as per the business requirement.
• Performed testing, knowledge transfer and mentored other team members

Environment: Informatica Power Center 8.1/7.1, Oracle 10g, TOAD, XML and Flat files, Windows.

Confidential

ETL Developer

Implementation of Informatica Power center has helped the company better understand market dynamics, improve customer relationships and increase bottom-line revenue.

Responsibilities

• Understanding BRD, Data required document and mapping documents.
• Experienced in Creating the Data bases and users
• Space estimations and User maintenance on dev machine
• Designing the ETLs and conducting review meets.
• Coded test SQLs and analyzed results.
• Created ad-hoc reports using SQL server 2005 Reporting Services SSRS .
• Involvement in implementation of BTEQ and Bulk load jobs
• Working on different transformations. router,Aggregator,Expression
• Coding using BTEQ SQL of TERADATA.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities.
• Execute the SQL's on UNIX environment. Performance tuning the long running queries.
• Worked with Teradata EXPLAIN facility, which describes to end-users how the database system will perform any requests.
• Migrated all DTS packages to SQL Server Integration Services SSIS and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Populate or refresh Teradata tables using Fast load, Multi load Fast export utilities for User Acceptance testing and loading history data into Teradata.
• Reduced Teradata space used by optimizing tables adding compression where Appropriate and ensuring optimum column definitions.
• Monitoring ETL jobs until production jobs are stabilized.
• Tuning and optimization of Teradata Queries.
• Using the UNIX wrappers to make the workflows.

Environment: Teradata V2R6, Teradata Queryman, Informatica V 7.1.2, SQL server 2005, Oracle 8i, Erwin7.2, Utility: Teradata Loading Utilities Bteq, Multiload, Fastload, FastExport, Tpump .Informatica 8.

Confidential

DW Consultant

Responsibilities:

• Interacted with Business users to understand the Business requirements and created High Level Process flow, High level technical design, and Low Level technical design documents.
• Designed Informatica process and developed mappings/Sessions/Workflows to load data from Source to Staging and from staging to Warehouse.
• Involved in designing the data model.
• Prepare Process Flow Diagrams, Flow Charts, File layouts, Report Layouts, Run Charts for Both Batch Online Programs
• Provide with Design alternative for the development.
• Responsible for Self and Peer Review of Programs and Test Records under Development Phase
• Prepare Unit, System, Integration and Load Test Plan's, Test Specifications and Test Records under Test Planning Phase
• Perform Unit, System, Integration and Load Testing under Testing Phase and simultaneously reviewing and Recording the Test Results.
• Done data quality and comprehensive data cleansing and parsing capabilities, which enable data analysts and data stewards to standardize, validate, enhance, and correct all types of enterprise data
• Designed and developed transformation rules to generate consolidated data using Informatica ETL Power Mart/Center tool.
• Created Informatica mappings, batches and session.
• Worked extensively on Flat files as the data from various legacy systems are Flat files
• Used indicator files to schedule Event based Sessions using Informatica Server Manager.
• Used Partitioning techniques to improve session performance.
• Used Parameter Files defining variable values for mapping parameters and variables
• Involved in data cleansing using Trillium data analytics, matching, standardization, and cleansing routines.
• Involved in writing Perl scripts to run batch jobs and automating their schedules
• Created reports in Business Objects and exported to the repository.
• Written UNIX Shell scripts for threshold check for the incoming files.
• Written UNIX shell scripts for cross checking the parameter in the job.

Environment: Informatica Power Center 7.1.2, Erwin3.5, SQL Scripting, Sybase, UNIX, Korn Shell Programming Oracle 10g/9i, DB/2 UDBv7.1, PL/SQL, Transact-SQL.