Teradata Developer Resume Samples

A Teradata Developer is a professional software engineer who undertakes responsibility for managing the database functions. A well-written Teradata Developer Resume highlights the following core duties – collecting needed information, analyzing statistics, transferring databases; managing and creating partitions, managing user accounts; identifying long-running queries, tuning and scripts; working with various Unix commands; moving database between machines; automating data warehousing and datamart refreshers, and managing partitions.

Those seeking to make a career move in this line should depict the resume the following skills and abilities – technical competences; analytical thinking skills, teamwork; problem-solving skills; attention to details; accuracy; and effective communication skills. On the technical front, the developer should show skills in Informatica, Unix Scripting; knowledge of CA7, and experience in the migration project and data warehouse. Computer science or software engineering is commonplace among job applicants.

 

Teradata Developer Resume example

Teradata Developer Resume

Summary : Over 7+ years of experience in DATAWARE HOUSING database TERADATA database Teradata Consultant in designing, development, testing, Implementation, maintenance and support of applications for Banking, Financial Retail domains various environments like Mainframes, Windows, UNIX. Professional Experience Extensive knowledge in Business Intelligence Data Warehousing Concepts with emphasis on ETL and Life Cycle Development.

Skills : Teradata version 12,13 and 14 Teradata Utilities :.

Description :

    1. Implemented TASM (Teradata Active System Management) across enterprise for performance and load balancing.
    2. Responsible for design and implementation of entire DW Dimensional Model architecture using Join Indexes.
    3. Partitioned Primary Indexes to achieve and exceed  desired performance.
    4. Defined account IDs, priority scheduler performance groups,  system date and time substitution variables in user and profile definitions.
    5. Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.
    6. Set up Teradata Workload Manager with the proper partitions and workloads based on Service Levels.
    7. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Technology In Computer Science


Sr. Teradata Developer Resume

Objective : Around 7 years of experience as Teradata Developer. 3 years of experience as Informatica Developer. Certified Teradata Professional. Extensive hands on experience in Teradata utilities BTEQ, FASTLOAD, FASTEXPORT MULTILOAD. Expert level experience Data Integration and Data Warehousing using ETL tool Informatica PowerCenter/7.

Skills : Big Data Developer/Data Analyst, Campaign Managment.

Description :

    1. Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching business requirements to Teradata RDBMS.
    2. Used FastExport utility to extract large volumes of data at high speed from Teradata RDBMS.
    3. Modified MVS JCL load scripts to support various data lengths for BTEQ and FASTLOAD.
    4. Created scripts of BTEQ, FastLoad, MultiLoad  written queries to move the data from source to destination.
    5. Partitioned Primary Indexes to achieve and exceed  desired performance.
    6. Wrote scripts for data cleansing, data validation, data transformation for data coming from source systems.
    7. Involved in the analysis of Issues and proposing  solutions to client Involved in analysis of test results and documenting test results.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors Of Computers Application In Computers Application


Jr. Teradata Developer Resume

Objective : 8 years of IT experience in Data warehousing, Teradata, ETL, Requirements Gathering in Banking Health care domains. 7+ years of experience Banking domain expertise in Retail banking concepts 4 years of Expertise in Teradata FSLDM Concepts Current role Technical Lead responsible to gather requirements, Design , develop and review code Teradata with Informatica ETL on UNIX operating system for health care client.

Skills : ETL, Design.

Description :

    1. Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
    2. Used FastExport utility to extract large volumes of data at high speed from Teradata RDBMS.
    3. Created stored procedures, macros, triggers, views, tables and other database objects.
    4. Modified MVS JCL load scripts to support various data lengths for BTEQ and FASTLOAD.
    5. Involved in performance tuning by implementing secondary indexes, join indexes, compression, collecting statistics also by checking the explain plan and skew factor.
    6. Used to run the ETL jobs every week through UNIX batch scripts to load data from source to development database.
    7. Created stored procedures, macros, triggers, views, tables and other database objects.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors Of Computers Application In Computers Application

Asst. Teradata Developer Resume

Summary : Database Teradata Consultant designing, development, testing, Implementation, maintenance and support of applications for Banking, Financial Retail domains in various environments like Mainframes, Windows, UNIX. Professional Experience Extensive knowledge in Business Intelligence Data Warehousing Concepts with emphasis on ETL and Life Cycle Development.

Skills : Teradata version, Windows, UNIX.

Description :

    1. Involved in enterprise level Performance Tuning, Workload Management Capacity Planning.
    2. Implemented TASM (Teradata Active System Management) across enterprise for performance and load balancing.
    3. Responsible for the design and implementation of entire DW Dimensional Model architecture using Join Indexes and Partitioned Primary Indexes to achieve and exceed desired performance.
    4. Defined account IDs, priority scheduler performance groups,  system date and time substitution variables in user and profile definitions.
    5. Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.
    6. Set up the Teradata Workload Manager with the proper partitions and workloads based on Service Levels.
    7. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelor Of Technology In Computer Science

Associate. Teradata Developer Resume

Objective : Having Seven (7+) years of comprehensive experience with s/w skills in Data Warehousing Involves Requirements Analysis.  Results-focused and recognized leader lauded by management for delivering the highest levels of customer service with diligent follow-up.


Skills : Teradata, BTEQ, FastLoad, MultiLoad, Fast Export, TPump, Exp/Imp.

Description :

    1. Analyzed functional documents to understand  healthcare domain fields.
    2. Created database object based on logical models and experience in planning of physical database and data-files mapping.
    3. Used Teradata DDLs created Tables, Views, Macros, Triggers and Stored Procedures.
    4. Developed SQL code as per  ETL mapping document to pull data from source to target.
    5. Written SQL code in BTEQ scripts and transferred scripts from WINDOWS to UNIX environment.
    6. Created AJIs, PPIs, UPIs, NUPIs, SIs, and JIs, HIs for having better performance while interacting with data.
    7. Worked on optimizing and tuning Teradata SQLs to improve  performance.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Teradata Developer III Resume

Objective : 2.2 years of experience in Tesco Hindustan Service Centre, Bangalore. Proficient in SQL Data warehousing concepts, Teradata Professional. Desires a role as a teacher assistant/para-educator. Experience in leadership skills, multi-tasking strengths and excellent customer service. Currently pursuing my teaching credentials in special education and love working with children.


Skills : Teradata, SQL, Data Warehousing, Business Objects, FastLoad, Teradata SQL Assistant, BTEQ.

Description :

    1. Analysed and identification of tables and job list required for all applications migrated.
    2. Analysed to identify incompatibilities between Teradata V12.0(old version) and Teradata SO BOX (new version) and fixing identified issues.
    3. Collated list of jobs (TDS and JCLs) which needed changes in the code, so that jobs pointed to right Teradata box and also making sure changes are correct.
    4. Responsible for Code migration to production.
    5. Responsible for Writing SQL scripts and queries.
    6. Created scripts of BTEQ, FastLoad, MultiLoad  written queries to move the data from source to destination.
    7. Created Star Schema model with required facts and dimensions.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor Of Engineering In Computer Science

Teradata Developer II Resume

Headline : Over 13 years of professional experience in Information Technology with extensive experience Design, Data Modeling, ETL Architecture, Development, Maintenance Support, Business Discovery implementation of Enterprise Data Warehousing (EDW) Data Integration Projects

Skills : Data Warehousing (EDW) Data Integration Projects.

Description :

    1. Analyzed  Data Mapping Sheets provided by  client.
    2. Developed both Technical , functional specifications/Design Document through meetings with Business Analysts, Data modelers, users DBA team.
    3. Responsible for Understanding Data mapping Document and building  Teradata load scripts.
    4. Loaded data from source systems into Teradata Warehouse using Teradata Tools and Utilities, CRs(Change request) Implementation for all Circles.
    5. Prepared Data Purging process for Every 2 Months and maintained Hutch Data warehouse (EDW).
    6. Responsible for problem detection correction for system related issues , resolving the Issues during the Data loading Process.
    7. Responsible for Tuning the existence process for better Performance.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Teradata Developer I Resume

Headline : Over 7 years of IT experience with extensive experience Data warehousing, Data Analysis, Reporting, ETL, Data Modelling, Development, Maintenance, Testing Documentation. Expertise in Teradata Database design, implementation, maintenance mainly in large-scale Data Warehouse environments Excellence in implementation of Data Warehouse Business Intelligence using ETL tools like Informatica PowerCenter (versions 9.

Skills : Reporting, ETL, Data Modelling.

Description :

    1. Involved in the analysis of Issues and proposing  solutions to client Involved in analysis of test results and documenting test results.
    2. Prepared documents in details which will be shared across organization Create export scripts using Teradata Fast Export Utility.
    3. Prepared Test cases and Test Data Create data manipulation and definition scripts using Teradata Bteq utility Involved in the analysis and design of the system Involved in Testing of prototype.
    4. Attended corporate meeting for kick off of major enhancements at corporate level.
    5. Organized meeting with the SME's of the dependent systems when changes are done for the existing system.
    6. Created UNIX scripts for file manipulation.
    7. Monitored the Teradata load process by using Teradata PMON.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Lead Teradata Developer Resume

Headline : 8 years of IT experience Data Warehouse developer using TERADATA (V2R5, V2R6, V12), ORACLE ETL processes involving in all SDLC phases like Business Requirements Analysis, Application Design, Data Modeling, Development, Testing Documentation. Experience developing Teradata databases, manipulating data making change dimensions in databases using Teradata Utilities Expertise in Design, development, testing of Extract, Transform Load (ETL) processes necessary load validate data warehouse using UNIX shell scripting.

Skills : Expertise in Design, development, testing of Extract.

Description :

    1. Set up Teradata Query manager to automate many of the DBA tasks such as collection of statistics, monitoring spool space, candidate tables for purge, etc.
    2. Responsible for gathering requirements from business analyst and functional analyst and format them according to business needs, identify tables required for data model.
    3. Modified MVS JCL load scripts to support various data lengths for BTEQ and FASTLOAD.
    4. Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.
    5. Partitioned Primary Indexes to achieve and exceed  desired performance.
    6. Responsible for problem detection correction for system related issues , resolving the Issues during the Data loading Process.
    7. Analyzed  Data Mapping Sheets provided by  client.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Technology In Technology

Teradata Developer Resume

Headline : Data Warehouse developer using TERADATA (V2R5, V2R6, V12), ORACLE and ETL processes involving in all SDLC phases like Business Requirements Analysis, Application Design, Data Modeling, Development, Testing Documentation. Experience developing Teradata databases.

Skills : ORACLE and ETL processes.

Description :

    1. Responsible for gathering requirements from business analyst and functional analyst and format them according to business needs, identify tables required for data model.
    2. Wrote scripts for data cleansing, data validation, data transformation for data coming from source systems.
    3. Responsible for Extracting, Transforming Loading data from flat files  using BTEQ, Fast Load, MultiLoad and loading data into Teradata Data Warehouse.
    4. Created scripts of BTEQ, FastLoad, MultiLoad and written queries to move the data from source to destination.
    5. Created Star Schema model with required facts and dimensions.
    6. Created load scripts using Teradata Fast Load and Mload utilities Code Reviews and Code walk through of  prototype.
    7. Created procedures in Teradata SQL.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelor Of Technology