SUMMARY

• Having 8+ years of IT experience focusing mainly on design, development, documentation in Teradata, Data warehousing environment and Application development.
• Having good knowledge on Teradata Database Architecture, Database Features and Teradata tools.
• Designed, developed, tested and supported Extract, Transform and Load (ETL) processes necessary to load and validate data warehouse.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De - normalization Concepts.
• Experience in designing and developing stored procedures, functions, constructing tables, views, indexes, triggers and user defined data types
• Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
• Attend and participate in meetings that pertain to assigned responsibilities.
• Expertise in Problem solving and Tracking Bugs during the production failure.
• Highly motivated with the ability to work effectively in teams as well as independently.

TECHNICAL SKILLS

• Expert skills in use of Fastload, Multiload, TPump, Viewpoint, and Teradata Analyst pack, Teradata SQL and BTEQ Teradata utilities.
• Expert skills in use of Informatica Power center tools.
• Expert knowledge converting logical data models into Teradata physical database designs via ERWIN, system implementation, performance tuning, and support.
• Skilled on UNIX environment and standard tools such as VI, UNIX commands, utilities, etc.
• PC skills in Windows NT & 2000 environment with Microsoft Office Products, MS Word, MS Excel, Outlook, ERWIN, & Teradata ODBC client tools.

PROFESSIONAL EXPERIENCE

Teradata Developer

Confidential, Reston, VA

Responsibilities:

• Involved in requirement gathering, business analysis, design and development, implementation of business rules.
• Development of scripts for loading the data into tables in EDW and to load the data from Source to staging and staging area to target tables.
• Develop ETL load process and Framework for the warehouse.
• Involved in creating framework to capture metadata to record the Job start and end timings on the ETL jobs.
• Created ETL Mappings and Transformations in accordance to the business rules to move data from various sources into warehouse.
• Designed looping process to load multiple days’ data, to accommodate loads behind schedule.
• Performance tuned Teradata SQL queries to optimize various ETL processes.
• Performed space management for Perm and Spool Space.
• Reviewed SQL for missing joins & joins constraints, data format issues, mismatched aliases, casting errors.
• Trained ETL developers and administrators as required for the new candidates.
• Worked in both Agile and waterfall methodology.
• Helped Teradata DBA’s in performance tuning on long running queries on Teradata server.
• Created Unix scripts to find, create, check file sizes and to change permissions on the files.
• Had administrator duties to migrate code from Development and testing environments to Production.
• Worked in Supporting Production environment for Informatica and Wherescape.
• Provide 24*7 production support for the Teradata ETL jobs for daily, Monthly and Weekly Schedule.

Teradata Developer

Confidential, Charlotte, NC

Responsibilities:

• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Dealt with Incremental data as well Migration data to load into the Teradata.
• Involved in Designing the ETL process to Extract translates and load data from Sybase database system to Teradata data warehouse.
• Experienced in SQL performance tuning experienced in writing complex SQL.
• Worked efficiently on Teradata Parallel Transport and generated codes.
• Created series of Teradata Macros and Stored Procedures for various applications inTeradata SQL Assistant.
• Involved in writing complex SQL queries based on the given requirements and for various business tickets to be handled.
• Created several SQL queries and created several reports using the above data mart for UAT and user reports.
• Worked efficiently on Teradata Parallel Transport codes.
• Used several of SQL features such as GROUP BY, ROLLUP, CASE, UNION, Sub-queries, EXISTS, COALESCE, NULL etc.
• Responsible for trouble shooting, identifying and resolving data problems.
• Created proper PI taking into consideration both planned access and even distribution of data across all the available AMPS.
• Loaded and transferred large data from different databases into Teradata using MLoad and FastLoad.

ETL Developer

Confidential, Dallas, TX

Responsibilities:

• Involved in the migration of Sybase database to Teradata. Created several macros, stored procedures, JCL scripts to migrate data from mainframe DB2 to Teradata.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Worked in life cycle development including Design, ETL strategy, troubleshooting and Reporting. Identifying facts and dimensions.
• Proficient in writing Mload, FastLoad and TPump scripts from windows, UNIX and Mainframes environments.
• Expertise in writing Teradata procedures using BTEQ and SQL assistant.
• To implement the type 2 process in more than one table created a dynamic procedure using metadata layer which will insert/updates the tables on the fly.
• Fine-tuned existing Teradata procedures, macros and queries to increase the performance. Re-designed the table structures on one AMP basis. Well organized the primary index mechanism.
• Performance fine tuning of existing SQL queries for reports, ETL jobs to reduce the procession time, reduced the number of procedures by creating dynamic procedures.
• Extensively worked under the Unix Environment using Shell Scripts and Wrapper Scripts. Responsible for writing the wrapper scripts to invoke the deployed Informatica mappings.
• Performed potential transformations at the staging area, such as cleansing the data (dealing with missing elements, parsing into standard formats) combining data from multiple sources, de-duping the data and assigning surrogate keys.
• Worked on developing various parameterized mappings in Designer.
• Expertise in SQL queries for cross verification of data.
• Involved in Unit testing, System testing and debugging during testing phase.

Teradata Developer

Confidential

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Involved in Data Modeling to identify the gaps with respect to business requirements and transforming the business rules.
• Used Informatica to extract, transform and load data from multiple input sources like flat files, Oracle files to the database.
• Involved in understanding the requirements of the End Users/Business Analysts and Developed Strategies for ETL processes.
• Analyze business requirements and develop metadata mappings. Involved in preparing high level and detailed design documents.
• Developed/Modified subject area mappings based on business requirements using various Informatica.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Reduced the response time for the end users of the system by using Teradata performance tuning.
• Writing scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
• Developing and reviewing Detail Design Document and Technical specification docs for end-to-end ETL process flow for each source systems.
• Worked on Multi file systems with extensive parallel processing.
• Extensively Used Transform Components: Aggregator, sorter, Joiner, Router, Update strategy.
• Dealt with initials, delta and Incremental data as well Migration data to load into Teradata.