PROFESSIONAL EXPERIENCE

Teradata Developer/ETL Developer

Confidential

Responsibilities:

• Around 8+Years of IT experience with expertise in Data Warehouse Process involved in Analysis, Design, Development of various business applications, different platforms using InformaticaPowercenter 9.5.1/8.6, PowerExchange 9.5/9.1, Oracle 11g,10g.9i,Teradata12/13/14, Sybase,DB2.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow &Worklet Designer.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments
• Expertise in optimizing the session performance by eliminating performance bottlenecks by optimizing target, source, mapping, transformations, session, grid deployment and optimize the system
• Expertise in tuning the throughput of source and targets not only relational source and targets but also flat files and XMLs
• Worked withTeradata12 utilities like BTEQ, Fast Load, Multi Load and Query man and Have experience on implementing business rules in BTEQ scripts.
• Extensive experience in fine tuning the session by using pushdown optimization, increasing DTM buffer memory and error tracing
• Involved in generating Mload and Tpump scripts to load the data intoTeradatatables.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes inTeradatadatabase.
• Extensively worked withTeradatautilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Expertise in Database Design, Entity-Relationship Modeling, Dimensional data modeling, Star schema modeling, Snowflake modeling with Ralph Kimball methodologies, Data Normalization. Experience working with Rapid SQL, SQL Developer and TOAD.
• Experienced in integrating various data sources/targets like Oracle,Teradata, SQL Servers, B2B, DB2, Fixed Width delimited Flat Files & XML Files.
• Knowledge about the Facets, EDI and ITS.
• Experience on both Unix and Windows platforms. Extensive experience in creating UNIX Shell Scripts.
• Experience in scheduling informatica jobs using external job schedulers likeIBM Tivoli Workload SchedulerandAutosys
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Experienced in interacting with Business users in analyzing the Business process requirements and transforming them into documents, designing, and rolling out the deliverables.
• Good understanding of Project Life Cycle and gathering requirements forETLDevelopment.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions, Triggers and Packages. Extensive experience working with Mainframe datasets.
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.
• Good Analytical, Strong Interpersonal and Excellent communication skills.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

TeradataDeveloper/ETLDeveloper

Confidential - Buffalo Grove, IL

Responsibilities:

• Handled multiple Project Under this client.
• Designing & documenting the functional specs and preparing the technical design.
• UsedTeradatautilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implementedTeradataFastload, Multiload and Bteq scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• Wrote views based on user and/or reporting requirements.
• WroteTeradataMacros and used variousTeradataanalytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those toTeradata.
• Good knowledge onTeradataManager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using both the Informatica PowerCenter and IDQ.
• Migration of code between the Environments and maintaining the code backups.
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, PowerCenter transformations and sessions using techniques like Explain plans, Oracle hints, re-designing the mappings. Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.

Environment: Informatica PowerCenter 9.1/9.6, PowerExchange 9.1/9.6, DB2 UDB, Informatica Data Quality 9.1, Oracle 11g, TOAD,Teradata12/13/14,TeradataSQL Assistant, SQL Developer, Putty, TWS Tivoli Job scheduler, Sun Solaris Unix and Windows Enterprise 2000

Teradata Developer/ETL Developer

Confidential - Buffalo Grove, IL

Responsibilities:

• Worked extensively in full System Development Life Cycle like participating in requirement gathering, business analysis, user meeting.
• Interacted with functional teams and users for finalizing the data models and reporting structures.
• Worked closely with Facets 4.48, 4.51, 4.81and different EDI transaction file like837,834, 835, 270, 271 to understand the source structure and the source data pattern.
• Involved in analyzing different modules of facets system and EDI interfaces to understand the source system and source data and worked closely with the Business Analyst, Data Modeler and Database Architect during the design and development ofETLtechnical specification document.
• Used Informatica PowerCenter as anETLto extract data from source like MS SQL Server, Flat files, Oracle, DB2 andTeradataand loaded to target.
• Extensively worked with the various client component of Informatica like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Extensively used different transformations like Lookup, Joiner, Aggregator, Filter, Sorter, Expression, Update Strategy, Source Qualifier, Rank, Router to create several mapping and mapplets.
• Implemented extracting, cleansing, transformation, integration and loading into Data marts using Informatica.
• Implemented Slowly Changing Dimension phenomenon Type - 1, Type-2 using InformaticaETLmapping.
• Created mapplets and reusable session for the performance tuning.
• Implemented error-processing strategy to reprocess the error data and manage notification of error data to corresponding business team.
• Worked with Informatica workflow monitor in running and debugging its components and monitoring the resulting executable version
• Involved in fine-tuning of sources, targets, mappings and sessions for performance optimization.
• Extensively used complex SQL queries to unit test the system and to test the existing project also used to validate the data in data warehouse.
• Extensively used SQL and PL/SQL tuning techniques to improve the performance.
• Daily monitoring of the mappings that ran the day before and fixing the issues
• Involved in unit, system and end-to-end testing of the design. Worked with DBA and Reporting team to generate Materialized View of the data warehouse.
• Worked on call for production support.

Environment: Informatica PowerCenter 8.1.1, Facets 4.48, 4.51, 4.81, Oracle 10g, SQL Server 2005, flat files, DB2,Teradata, Erwin R7, SQL, PL/SQL, SQL*PLUS, Shell Scripting, Micro Strategy 8.0, Unix System.

Teradata Developer

Confidential - Deerfield, IL

Responsibilities:

• Used Informatica Power Center 9.1 for extraction, transformation and load (ETL) of data in the data warehouse and Implemented performance tuning logic on targets, sources, mappings, sessions to provide efficiency and performance.
• UsedTeradatautilities fastload, multiload, tpumpto load data and wrote BTEQ scripts to transform data and Fastexport scripts to export data.
• Documented to describe program development, logic, coding, testing, changes and corrections.We Supported the application as well.

Environment: Informatica PowerCenter 9.1, PowerExchange9.1,Teradata12,Teradata5500, SQL Assistant 12.0, Business Objects, Hyperion, BTEQ, FastLoad, FastExport, Multiload, Korn Shells, MS Visio, Data Mover.

ETL Analyst

Confidential - St. Louis, MO

Responsibilities:

• Monitoring theETLjobs, generating tickets and fixing the bugs in HP ALM. Used Tivoli Enterprise Scheduler for running the shell scripts, performing actions, event tasks, scheduling the workflows and dynamically updating the parameter file.
• Worked with XML targets and tuned them. Solved various performance issues while working with XML targets and identifying the bottlenecks and tuning them accordingly Created and maintained the shell scripts and parameter files in UNIX for the proper execution of Informatica workflows in different environments.

Environment: Informatica Power Center 8.6/9.1, PowerExchange8.6/9.1, DB2 UDB, Informatica Data Quality 9.1, Oracle 11g, TOAD,TeradataR12/R13,TeradataSQL Assistant, SQL Developer, UNIX and Tivoli Job Schedule.

ETL Developer

Confidential - New York, NY

Responsibilities:

• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of complex Informatica mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally.
• Extracted data from Oracle and SQL Server and load the data into target database.
• Handled slowly changing dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Extensively involved in performance tuning of theETLprocess by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Involved in creating the runbook and migration document (from Development to Production).
• Document the process for further maintenance and support.

Environment: Informatica PowerCenter 8.6, PowerExchange 8.6, Informatica Data Quality 9.1, Oracle 11g, TOAD,TeradataR12/R13,TeradataSQL Assistant, SQL Developer, UNIX and Erwin3.5