PROFESSIONAL SUMMARY:

• Eight (8) years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power center across Banking, Finance, Retail and Telecom Domains.
• Over 7 years of experience in Teradata 13.10/12 (Teradata SQL Assistant, BTEQ, Fast Load, MultiLoad, TPump, TPT (Teradata Parallel Transporter) and FExport).
• Worked in several areas of Data Warehouse including Analysis, Requirement Gathering, Design, Development, Testing, and Implementation.
• Over Seven (7) years of Solid ETL (Extract Transform Load) Data Warehouse experience using Informatica Power center, Repository Manager, Designer, Workflow manager, Work flow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Mapplets, Mappings, Workflows, Sessions, Re - Usable Transformations.
• Worked with re-usable objects like Re-Usable Transformation and Mapplets.
• Expertise in Informatica Performance Tuning and Error Handling.
• Extensively worked on Unix and Informatica environments to invoke Teradata Utilities and file handlings.
• Strong knowledge on Slowly Changing Dimensions, Fact and Dimensions tables and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Extensive knowledge on data marts, data warehouse and dimensional modeling.
• Good Knowledge on Teradata parallel architecture and its physical implementation. and Informatica Architecture.
• Knowledge on Schedulers like Tivoli Work scheduler (TWS) and Job Scheduling Console(Maestro).
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Comprehensive technical, oral, written and communicational skills.

TECHNICAL SKILLS:

ETL tools: Informatica Power Center 9.6/9.5.1/8.6 Repository Manager, Designer, Workflow manager, Work flow Monitor, Source Analyzer.

Databases: Teradata 13,Teradata 12, Sybase ASE, sql.

Teradata Utilities: BTEQ, FastLoad, MultiLoad, TPump, FastExport, TPT, Queryman(SQL assistant).

Other tools: Unix, Korn Shell, Maestro(Job Scheduling Console), Tivoli Work Scheduler.

Operating Systems: Windows Xp, Windows Server 2008,Unix.

PROFESSIONAL EXPERIENCE:

ETL/Teradata Developer

Confidential, Plano, Texas

Responsibilities:

• Participate in the requirement gathering sessions with the business users regarding current production enhancement projects.
• Create design documents and specs for the projects and work with team to develop using different Teradata utilities like FLOAD,MLOAD, BTEQ and TPT.
• Schedule the daily, weekly and monthly jobs and job streams using TIVOLI software.
• Monitor and analyze the daily production issues and provide the solutions to the users.
• Lead the team in offshore to take care of various ad hoc projects and enhancements.
• Extensively use UNIX shell scripts to build the fast export, fast load, mload and TIVOLI jobs.
• Reviewed and implemented the naming standards for the entities, attributes of the Telecom model.
• Document the existing and new processes for the audit purpose.
• Organize the KT and Deployment meeting to review new development that going on production.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using Informatica and Teradata utilities like fast export, fast load, multi load, TPT.
• Involved in QA testing and assist team in resolving defects.

Environment: Informatica Power center 8.6.1/9.5.1/9.6.1, Teradata 13, Teradata 14, UNIX/LINUX, Teradata SQL Assistant.

ETL Developer

Confidential

Responsibilities:

• Based on the functional requirements created technical design specification documents for ETL Process.
• Worked on Partition Primary Indexes (PPI), Secondary Indexes and Join Indexes in Teradata
• Responsible in building maps by uses various transformations like Source Qualifier, Expression, Aggregator, Rank, Joiner, Lookup, Update Strategy, Stored procedure Transformations based on the requirement from the end users using both Informatica power center.
• Used Error handling strategy for trapping errors by using the error function in the mapping level and sending errors to an error table.
• Created Mapplets and reusable Transformations using Mapplet Designer, Transformation Developer for the Standardization of data as per the business requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) based on the business requirements.
• Have Knowledge scheduling the jobs using Tivoli scheduler and scheduling the jobs .
• Worked on Push Down Optimization to achieve optimal Performance.
• Part of remediation(Performance tuning) work on complex Sql’s and client sql’s and work on improving performance of queries by checking the explain plan and Stats on tables, improve join strategies etc.

Environment: Informatica Power centre 9.01, Teradata 13, UNIX,Teradata SQL Assistant and Sql.

ETL Developer

Confidential

Responsibilities:

• Involved in gathering business requirements, Technical requirements, Design documents.
• Worked on ETL Informatica Power centre for creating mappings/workflows and also invoking bteq’s via workflows.
• Optimizing performance tuning at source, target, mapping and session level.
• Working on improvement of existing process by integrating various sources and helping in maintenance code hence ensuring process is efficient.
• Good knowledge on Teradata Manager, SQL assistant and BTEQ.
• UsedTeradata utilities fastload, multiload, Tpumpto load data from different sources.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Code Migration and testing support in QA environment.

Environment: Informatica Power centre 8.6, Teradata 12, UNIX, Teradata Utilies, Teradata SQL Assistant, Sybase ASE and sql.

System Engineer

Confidential

Responsibilities:

• Understanding the Business Requirements andFunctional specificationdocuments.
• Involved in CompleteSoftware Development LifecycleExperience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Preparing and Reviewing ETL Design Specification Document.
• Worked on various flat files to import data using Informatica Powercenter and Data Quality.
• Good knowledge on Teradata Manager, SQL assistant and BTEQ.
• UsedTeradata utilities fastload, multiload, tpumpto load data from different sources.
• Worked on createstored procedures, packages, Symantec Views and various functions.
• Worked on various Unix shell scripts for Teradata utilities and scheduling the jobs through scheduler.

Environment: Teradata 12, Informatica Power centre 8.6.1,UNIX, Teradata - Bteq, Fastload, Multiload, Fastexport, Teradata SQL Assistant and sql.