SUMMARY

• Over Five years of experience in Development using ETL tool like Informatica PowerCenter.
• Extensively worked with various source systems like Oracle, DB2, Faltfiles, Teradata, SQL server and MS Access.
• Experience in using various Teradata Utilities like Teradata Parallel Transporter, Mload, FastExport, BTEQ, FastLoad, Tpump and SQL Assistant.
• Experience of writing ETL Specifications based on the DA/Technical specs to have an evolved picture of the ETL design.
• Good working knowledge of UNIX (Scripting).
• Good working knowledge of Star Schema Dimensional and Third Normal Form Data models.
• Well versed with all the concepts/stages of SDLC.
• Performed Data Profiling and Analysis to identify source tables to meet the business requirements.
• Excellent Communication, analytical, problem solving, time management and Technical writing skills.
• Good exposure to development, testing, debugging, implementation, documentation, user training & production support.
• Goal - oriented, dedicated self-starter and dependable individual with a high degree of technical adaptability, initiative and reliability.
• Good Experience with Business Users to analyze the business process and gather the requirements and make necessary changes according to the Business.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.1, 8.x (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations) Power Exchange 8.1/5.2.2

Business Intelligence: Business Objects XI 4.0, 3.2, R3 (Designer, Supervisor, Reporter & WEBI), Micro strategy 9/8x.

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow Flake Modeling, FACT and dimensions Tables, Physical and Logical Data Modeling, Erwin 8.

Databases: Oracle 11g/10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, Siebel, IBM DB2 UDB 10.1/9/8, MS SQL Server 2012/2008/7.0/6.5 , Teradata 14/13x, MS Access 15/14, Sybase 15.7, Netezza 7.0.2.

Programming: SQL, Transact SQL, PL/SQL, Perl scripts, Korn Shell scripting, Unix Shell Scripting, Confidential, Java, HTML, DHTML

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Teradata / ETL Developer

Responsibilities:

• Analyzed the existing Teradata applications for complexity and Enhancement.
• Participated in Joint Analysis Design with user community and Business users.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Involved in performance tuning of the Mappings, SQL statements, Query optimization, and Explain Plan utilities for Optimum Performance and used Informatica Debugger.
• Conducted SQL testing for database sources for Insert and Update timestamps, Counts, Data definitions and Error logic for Facts and Reference tables.
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart Used Fast Load for loading into the empty tables.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit test.
• Created tables, access views and update views in the development database.
• Used MLOAD, Fast LOAD to load data from Load ready Files to Teradata Warehouse. Worked on Teradata Query man to validate the data in warehouse for sanity check.
• Used session level tasks, control task, email task, assignment, decision and workflow variables for session level processing.
• Created test plans, test strategies, setup the test environment, co-ordinate with the business analysts and business users to create test data to perform extensive testing.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.

Environment: Informatica Power Center 9.0.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 11i, UNIX, Flat files, Windows XP professional,, Flat Files, IBM Mainframe, COBOL files, SQL, PL/SQL. Visio, Clear case, TOAD.

Confidential, Memphis, TN

Teradata Developer

Responsibilities:

• Worked extensively on transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Router, Union and Update Strategy.
• Extracted data from various heterogeneous sources cleaned the data before applying business logic and loaded them into central Target Data Warehouse.
• Worked extensively with Teradata Utility tools like Teradata Parallel Transporter
• Mload, BTEQ, Fast Export, Fast Load and SQL Assistant.
• Created Sessions, Worklets and Workflows for designed mappings.
• Created and modified BTEQ Scripts to meet the business requirement.
• Created data profiles using Informatica Data profiler to analyze and report on the data quality to business and take decisions based on the same.
• Conducted SQL testing for database sources for Insert and Update timestamps, Counts, Data definitions and Error logic for Facts and Reference tables
• Created test plans, test strategies; setup the test environment, co-ordinate with the business analysts and business users to create test data to perform extensive testing.
• Used UNIX Shell Scripts for data extraction, running Pre-Session, Post-Session and SQL procedures.
• Used debugger to test the data flow and fixed the mappings.
• Transformed and loaded data sourced from various sources like EBCDIC files Teradata and Flat Files.
• Worked with various Sessions, Decision, Command, Email tasks in single workflows.
• Performed Data Profiling and Analysis on Source Systems to verify data availability to support the business requirements.
• Unit tested the developed code.

Environment: Informatica Power Center 9.1, Oracle 11i, Oracle SQL Developer, Teradata 12, SQL Assistant, MS Outlook, IBM Mainframe, COBOL files, JCL, SQL server 2005, SQL, PL/SQL.

Confidential, Keene, NH

Informatica Developer

Responsibilities:

• Maintain all necessary updates and/or patches for the ETL environment.
• Monitor and tune ETL repository and system for performance improvements.
• Identify, research, and resolve ETL root cause of production issues or system Problems.
• Perform On-Call production support.
• Code/folder migration from one environment to another as part of release Management.
• Provided production support to ETL Routines.
• Optimized the mappings and debugged the existing mappings to fix various issues that in production.
• Worked on Data Quality Integration transformation to import data from IDQ to Power center center designer.
• Worked on different (IDQ) plans such as Parsing, Data cleansing, Validation, enhancement, Grouping and Matching
• Extensively worked on the Database Triggers, Functions and Database Constraints.
• Created User defined functions(UDF) to reuse the logic in different mappings.
• Actively contributed in several key areas of Enterprise Data Warehousing such as Change Data Capture, Data Quality, and lookup Tables and ETL data movement.
• Crafted a generic algorithm to create a universal Oracle PL/SQL script, which read the Oracle internal data dictionary to perform data movements from large schema involving 800 tables
• Interacted extensively with the end users in prototyping and preparing various documents like Interface Requirement Document, Customer Requirement document, Integration test plan and Unit test plan.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Worked closely with business analysts to understand the business needs for decision support data.

Environment: Informatica 8.5.1/8.5.5 manger/monitor/Designer/Repository Admin Console, DB2, DM Express 4.2, Micro strategy 7.1.5, IDQ, AIX 5.3, VSAM.

Confidential

Teradata Developer

Responsibilities:

• Used Informatica for ETL operations, Created Universes for various functional areas of high level reports group.
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Developed, managed and administered UNIX scripts in a production data warehouse environment including the ability to read/code K-shell scripts.
• Real-time root cause and service impact analysis capabilities to pinpoint the source of a given problem and determine its impact on all the systems.
• Establish Loading process using MLOAD, FLOAD, and BTEQ.
• Exporting Data using BTEQ and Fast Export.
• Writing Teradata SQL queries according to Process needs.
• Used Visual Explain for query Optimization.
• MVS JCL/Unix load scripts to support various data lengths for BTEQ and FAST/MULTILOAD.
• Performed tuning of Informatica Mappings, SQL for optimum performance.
• Customized BO Universes for quicker performance of reports
• Unload / load data into Teradata RDBMS using fast load/fast export/multiload tools.
• Performance Analysis of all DW databases was done with appropriate recommendations
• Worked with Oracle, Flat File, XML files as Sources in Mapping Designer.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Created the joins strategies while designing the universes.
• Changed the universe parameter settings to optimize the performance of universe.
• Created different universes which contains the information about the customer
• Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Involved in Working with Erwin tool in Data Modeling (both Physical and Logical Design).

Environment: Teradata V2R5, Informatica 8.1.1, Business Objects (Supervisor, Designer, Reporter), Crystal Reports, Oracle 8i, PL/SQL, ERWIN.

Confidential

Informatica Developer

Responsibilities:

• Developed Informatica Mappings, Mapplets and Transformations to load data from different relational sources like Oracle, Teradata, DB2, and flat files sources into the data mart.
• Worked with most of the DB client tools like SQL Navigator, TOAD, Data Browser, Teradata SQL Assistant, etc.
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Optimized the Mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Schedule, Run and Monitor sessions by using Informatica Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Wrote Unix Shell Scripts for extracting parameters and automating the FTP and SFTP Processes.
• Redesigned some of the existing mappings in the system to meet new functionality.

Environment: Informatica 8.1.1, UNIX, Teradata V2R6, Oracle 8i.