SUMMARY

• Around 8 Years of IT experience with expertise in Data Warehouse Process involved in Analysis, Design, Development of various business applications, different platforms using Informatica Powercenter 9.5.1/8.6, PowerExchange 9.5/9.1, Oracle 11g,10g.9i, Teradata 12/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 with Teradata 12 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 into Teradata tables.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities 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.
• Experience on both Unix and Windows platforms. Extensive experience in creating UNIX Shell Scripts.
• Experience in scheduling informatica jobs using external job schedulers like IBM Tivoli Workload Scheduler and Autosys
• 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 for ETL Development.
• 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.

TECHNICAL SKILLS

ETL TOOLS: PowerCenter9.5.1/8.6,PowerExchange9.5/9.1, XML/XSD files, Datastage and CDC

DATAMODELLING/ MODELLING TOOL: Star-Schema Modeling, Snowflake Modeling, MS Visio and Erwin

DATABASE EXPERIENCE: DB2,Sybase

Oracle 11g/10g/9i: Teradata 12.0/13.0/14.0

Microsoft SQL Server 2012/2008: ACCESS

LANGUAGES: C, C++, JavaScript, UNIX Scripting, PL/SQL, Unix Shell scripting

TERADATA TOOLS & UTILITIES: SQLAssistant, BTEQ, Index Wizard, View point

LOAD & EXPORT: FastLoad, MultiLoad, FastExport, BTEQ, OLE load, Oracle SQL Loader

SCHEDULER: AutoSys, Maestro

OTHERS: COGNOS7.X/8.X, BUSINESS-OBJECTS 5.X/6.X

PROFESSIONAL EXPERIENCE

Confidential, Buffalo Grove, IL

Teradata Developer/ETL Developer

Responsibilities:

• Designing & documenting the functional specs and preparing the technical design.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, 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.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Good knowledge on Teradata Manager, 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, Teradata 12/13/14, Teradata SQL Assistant, SQL Developer, Putty, TWS Tivoli Job scheduler, Sun Solaris Unix and Windows Enterprise 2000

Confidential, St.Louis, MO

ETL Analyst

Responsibilities:

• Monitoring the ETL jobs, 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
• Ceated and maintained the shell scripts and parameter files in UNIX for the proper execution of Informatica workflows in different environments.

Environment: Informatica PowerCenter 8.6/9.1, PowerExchange 8.6/9.1, DB2 UDB, Informatica Data Quality 9.1, Oracle 11g, TOAD, Teradata R12/R13, Teradata SQL Assistant, SQL Developer, UNIX and Tivoli Job Schedule

Confidential, New York

ETL Developer

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 the ETL process 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, Teradata R12/R13, Teradata SQL Assistant, SQL Developer, UNIX and Erwin3.5