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 :
- Implemented TASM (Teradata Active System Management) across enterprise for performance and load balancing.
- Responsible for design and implementation of entire DW Dimensional Model architecture using Join Indexes.
- Partitioned Primary Indexes to achieve and exceed desired performance.
- Defined account IDs, priority scheduler performance groups, system date and time substitution variables in user and profile definitions.
- Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.
- Set up Teradata Workload Manager with the proper partitions and workloads based on Service Levels.
- 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.
Experience
10+ Years
Level
Senior
Education
Bachelor Of Technology
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 :
- Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching business requirements to Teradata RDBMS.
- Used FastExport utility to extract large volumes of data at high speed from Teradata RDBMS.
- Modified MVS JCL load scripts to support various data lengths for BTEQ and FASTLOAD.
- Created scripts of BTEQ, FastLoad, MultiLoad written queries to move the data from source to destination.
- Partitioned Primary Indexes to achieve and exceed desired performance.
- Wrote scripts for data cleansing, data validation, data transformation for data coming from source systems.
- Involved in the analysis of Issues and proposing solutions to client Involved in analysis of test results and documenting test results.
Experience
2-5 Years
Level
Junior
Education
Bachelors Of Computers
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 : UNIX, Shell Scripting.
Description :
- Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
- Used FastExport utility to extract large volumes of data at high speed from Teradata RDBMS.
- Created stored procedures, macros, triggers, views, tables and other database objects.
- Modified MVS JCL load scripts to support various data lengths for BTEQ and FASTLOAD.
- Involved in performance tuning by implementing secondary indexes, join indexes, compression, collecting statistics also by checking the explain plan and skew factor.
- Used to run the ETL jobs every week through UNIX batch scripts to load data from source to development database.
- Created stored procedures, macros, triggers, views, tables and other database objects.
Experience
2-5 Years
Level
Junior
Education
Bachelors Of Computers
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 :
- Involved in enterprise level Performance Tuning, Workload Management Capacity Planning.
- Implemented TASM (Teradata Active System Management) across enterprise for performance and load balancing.
- 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.
- Defined account IDs, priority scheduler performance groups, system date and time substitution variables in user and profile definitions.
- Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.
- Set up the Teradata Workload Manager with the proper partitions and workloads based on Service Levels.
- 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.
Experience
10+ Years
Level
Senior
Education
Bachelor Of Technology
Associate. Teradata Developer Resume
Objective : Teradata Developer is responsible for the design, implementation, and administration of Teradata solutions. Work with customers to identify business problems and provide solutions to meet their needs.
Skills : Teradata, BTEQ, FastLoad, MultiLoad, Fast Export, TPump, Exp/Imp.
Description :
- Analyzed functional documents to understand healthcare domain fields.
- Created database object based on logical models and experience in planning of physical database and data-files mapping.
- Used Teradata DDLs created Tables, Views, Macros, Triggers and Stored Procedures.
- Developed SQL code as per ETL mapping document to pull data from source to target.
- Written SQL code in BTEQ scripts and transferred scripts from WINDOWS to UNIX environment.
- Created AJIs, PPIs, UPIs, NUPIs, SIs, and JIs, HIs for having better performance while interacting with data.
- Worked on optimizing and tuning Teradata SQLs to improve performance.
Experience
2-5 Years
Level
Junior
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.<div><br></div>
Skills : Teradata, SQL, Data Warehousing, Business Objects, FastLoad, Teradata SQL Assistant, BTEQ.
Description :
- Analysed and identification of tables and job list required for all applications migrated.
- Analysed to identify incompatibilities between Teradata V12.0(old version) and Teradata SO BOX (new version) and fixing identified issues.
- 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.
- Responsible for Code migration to production.
- Responsible for Writing SQL scripts and queries.
- Created scripts of BTEQ, FastLoad, MultiLoad written queries to move the data from source to destination.
- Created Star Schema model with required facts and dimensions.
Experience
2-5 Years
Level
Junior
Education
Bachelor Of Engineering
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 :
- Analyzed Data Mapping Sheets provided by client.
- Developed both Technical , functional specifications/Design Document through meetings with Business Analysts, Data modelers, users DBA team.
- Responsible for Understanding Data mapping Document and building Teradata load scripts.
- Loaded data from source systems into Teradata Warehouse using Teradata Tools and Utilities, CRs(Change request) Implementation for all Circles.
- Prepared Data Purging process for Every 2 Months and maintained Hutch Data warehouse (EDW).
- Responsible for problem detection correction for system related issues , resolving the Issues during the Data loading Process.
- Responsible for Tuning the existence process for better Performance.
Experience
5-7 Years
Level
Executive
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 :
- Involved in the analysis of Issues and proposing solutions to client Involved in analysis of test results and documenting test results.
- Prepared documents in details which will be shared across organization Create export scripts using Teradata Fast Export Utility.
- 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.
- Attended corporate meeting for kick off of major enhancements at corporate level.
- Organized meeting with the SME's of the dependent systems when changes are done for the existing system.
- Created UNIX scripts for file manipulation.
- Monitored the Teradata load process by using Teradata PMON.
Experience
5-7 Years
Level
Executive
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 :
- 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.
- Responsible for gathering requirements from business analyst and functional analyst and format them according to business needs, identify tables required for data model.
- Modified MVS JCL load scripts to support various data lengths for BTEQ and FASTLOAD.
- Created Teradata objects like Databases, Users, Profiles, Roles, Tables, and Views & Macros.
- Partitioned Primary Indexes to achieve and exceed desired performance.
- Responsible for problem detection correction for system related issues , resolving the Issues during the Data loading Process.
- Analyzed Data Mapping Sheets provided by client.
Experience
5-7 Years
Level
Executive
Education
Bachelor Of 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 :
- Responsible for gathering requirements from business analyst and functional analyst and format them according to business needs, identify tables required for data model.
- Wrote scripts for data cleansing, data validation, data transformation for data coming from source systems.
- Responsible for Extracting, Transforming Loading data from flat files using BTEQ, Fast Load, MultiLoad and loading data into Teradata Data Warehouse.
- Created scripts of BTEQ, FastLoad, MultiLoad and written queries to move the data from source to destination.
- Created Star Schema model with required facts and dimensions.
- Created load scripts using Teradata Fast Load and Mload utilities Code Reviews and Code walk through of prototype.
- Created procedures in Teradata SQL.
Experience
5-7 Years
Level
Executive
Education
Bachelor Of Technology