Scheduling the workflows and Loading the files and Monitoring the workflows very frequently to ensure data loading is done accordingly. The most common work activities seen on the Teradata Dba Resume include the following – backing up, restoring and migrating Teradata data and objects; establishing and maintaining backup and recovery policies; managing and monitoring system performance, implementing and maintaining database security; setting up and maintaining documentation and standards, supporting multiple Teradata … Born in Austria's capital Vienna, he is building and tuning some of the largest Teradata Data Warehouses in the European financial and telecommunication sectors for more than 20 years. Extract Transform Load & Teradata Developer Resume Examples & Samples. Experience in integration of various data sources definitions like SQL Server, Oracle, Teradata SQL Assistant, MYSQL, Flat Files, XML and XSDs. Prepared SQL queries to validate the data in both source and target databases. Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor. Semantic Data Modeling with Teradata SQLs Performance Tuning and Query Optimization Analyzing Business rules and transforming into Teradata SQL Unit Test, QA of Reports, Load scripts and Views Module lead for the Team size 5 Rewards and Recognitions In 2010, received Wipro "Feather in my Cap- Special Recognition Award" for outstanding performance as Teradata DBA. As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) in operation 24×7. Please provide a type of job or location to search! Written document to describe program development, logic, coding, testing, changes and corrections. Domain: Entertainment Project: Teradata Administration for Enterprise Data warehouse of Electronic Arts. Involved in error handling, performance tuning of mappings, testing of informatica sessions and the target data. Implemented an Access frontend to Teradata allowing connections to multiple machines facilitating seamless transfer of data. For example, by using Teradata's data collection guidelines, recommendations for Account Management and Logging, a user will be able to identify, analyze and tune problem queries for better performance. Born in Austria's capital Vienna, he is building and tuning some of the largest Teradata Data Warehouses in the European financial and telecommunication sectors for … Self-motivated and team player. Interaction with the onsite team on a daily basis on the development activities. Implemented SCD slowly changing dimensions type I and II for data load. Ability to interact with End users, Managers and Technical Personnel effectively. Scheduling the workflows and loading the files on daily basis. Ensure all metrics data is collected for all critical processes during the Design and the Development phases of the SDLC lifecycle. Performance Considerations. Each resume is hand-picked from our large database of real resumes. Experience on Teradata tools and utilities (BTEQ, Fast load, Multi Load, Fast Export, and TPUMP). If you're looking for a Teradata Developer resume, our sample provides the imagination you need to get started on making your own! Privacy policy Setting up sessions to schedule the loads at required frequency using power center workflow manager PMCMD. All rights reserved. In most cases, there is a highly significant improvement. Extensively worked with Transformations like Router, Aggregator, Expression, Normalizer, Lookup, Update Strategy, joiner and sequence generator. Extensively used informatica debugger to figure out the problems in mapping. Developed Teradata queries as a part of my project. Possess sound knowledge in TeradataDatabaseArchitecture, Database Features, Teradata tools and worked on Teradata Database Internals Parser, Optimizer and the Amp modules. Used scd1 and scd2 types for the mappings as per the business requirements. Used informatica workflow manager to create workflows, database connections, sessions and batches to run mappings. Apply to Data Engineer, Architect, Senior Business Administrator and more! In the Explain plan, check for the keywords like confidence level, join strategy used, spool file size, redistribution, etc. Marital Status: Married Use derived tables Increased performance by 35-40% in some situations. Extensively used informatica debugger to figure out the problems in mapping. Domain: Banking Project: Hyperion Resource Pool for a major US Bank Database: Teradata Reporting Tool: Hyperion Performance Suite Operating System: UNIX Teradata Tools: SQL Assistant, BTEQ, Fastload, Fastexport, Multiload Client is amongst the world's largest financial services companies with operation in Consumer Banking, Commercial Banking, Global Corporate and Investment Banking (GCIB) and Asset Management. The following broadly characterizes the performance impact of recursive queries with respect to execution time: Using a recursive query shows a significant performance improvement over using temporary tables with a stored procedures. This includes extracting data from different disparate sources into one common repository for data warehouse, transforming the data based on the business rules and loading into data warehouse repository. Leading the 6 member team of Schwab Teradata DBAs. Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights, and space rights for the Teradata environment. Certified Master in Teradata. Work Permit: US (Valid H-1B), India( By Citizenship) Conduct detailed technical review of code artifact and ensure alignment of the code to requirements and quality standards. 4 votes Garrick Wolff. Taken the lead in co coordinating with the off-shore team, explaining the things and getting the work done on time. Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like delimited flat file and Teradata. Excellent communication, interpersonal, analytical skills. ... Teradata/Oracle SQL and SAS Lead the development and implementation of new reporting functionality and data requests ... performance tuning, replication, encryption, and identity management 13 Hands on experience in debugging and performance tuning of sources, targets, mappings and sessions. Performance tuning, Monitoring, and reporting Review system utilization by the user. Proficient in Full Life Cycle of Software Development (SDLC) including Business Requirements gathering and Data Analysis, Application Design, Development, Testing, Implementation and Documentation, Parameterized the mappings and increased the reusability, Experienced in writing SQL queries in Teradata, Knowledge on Teradata utilities like Fast Load, Multi Load for loading data into multiple tables at a time or to load empty tables at high speed, Expertise in working with Slowly Changing Dimensions (SCD1 & SCD2) in informatica, Proficient in implementing complex business rules through different kinds of Informatica Transformations, Workflows/Worklet and mappings/mapplets, Extensively used pmcmd commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files, Expertise in using different source files like flat files, relational tables to extract data and to load to respected target, Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance and dealing with huge volume of data, Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse, Extensively worked on transformations such as Source Qualifier, Joiner, Filter, router, Expression, Lookup, Aggregator, Sorter, Update Strategy, and Sequence Generator etc, Worked in Healthcare domain, so have good ability to handle huge and confidential data, Good knowledge in UNIX shell scripts which is used in informatica for automation of ETL, Involved in problem solving, fixing the bugs, and also connecting with the onsite coordinators and ability to meet deadlines, handle multiple tasks, Received appreciation mails from client and manger for timely delivery of project at peak times, Worked in Agile methodology and have constant interaction with the scrum master and the business users, Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities, motivated and adaptive with ability to grasp things quickly and to take new roles, Lead the team for successful delivery of the project on time, Worked on Agile methodology which helped to understand the requirements very clearly and the progress of the project was good, Responsible for Business analysis and Requirement collection and helping the development team to understand them, Involved in building the ETL architecture and source to target mapping to load data into Data warehouse, Used debugger to test the mappings and fixed the bugs, Reviewed and analyzed functional requirements, mapping documents, problem solving ad trouble shooting, Extensively worked on building the SQL’s in Teradata and performance tuning the queries, Effectively worked on onsite offshore model, Manage the successful delivery of development projects across the full application lifecycle, Scheduling the workflows using AutoSys to run the jobs as per the business requirements. Thanks. In 2008, received Infosys "RnR- Most Valuable Player Award", which is the most prestigious award in Infosys for outstanding performance as a Teradata developer Live- Site award at EA for 99.9% uptime of Teradata system. Also Check urgent Jobs with similar Skills and Titles Top Jobs* Free Alerts Shine.com Teradata Developer Resume Sample 4.9. Database: Teradata 13.10 Operating System: UNIX Teradata Tools and Utilities: SQL Assistant, BTEQ, Fastload, Fastexport, Multiload, TPT, PMON, Teradata Manager, Teradata Administrator, Viewpoint, TSET, TASM BAR: Netbackup Work Profile: Responsible for administration and architecture of EA Teradata ecosystem which includes EDW class system and appliances. TechBytes: Bite-sized videos by Teradata experts Watch bite-sized videos to learn about the hundreds of powerful Advanced SQL Engine and machine learning functions that come with Vantage. You will have to take sometime in going through this topic. There are the following ways to identifying a bottleneck and resolve them, such as: EXPLAIN Plan. Once collecting stats, indexes store in data dictionary. Environment: Informatica Power center, Teradata Sql Assistant, Unix. Here are very basic steps which are used to PT any given query in given environment . Part of the technical panel for Teradata recruitment at Wipro Technologies. Created various tasks like session, Command, email etc. Teradata Performance Tuning: Avoiding unnecessary joins on production tables during peak period Create quality compliant code along with providing guidance to developers. Try to understand basic keywords in Explain Plan like confidence level, join strategy used, re-distribution happening or not. Excellent communication, interpersonal, analytical skills. 01/2009 to 07/2009. The PE is the Teradata Optimizer and it takes user requests and parses the SQL to get the best performance tuning and performance optimization. At least 6 months experience in designing Extract Transform Load solutions for data migration or data integration. Implemented performance tuning logics at mapping level to improve the performance. Ability to learn and adapt quickly to the emerging new technologies. Post Resume Employers. Good experience with Teradata query performance and tuning using collect statistics and secondary indexes. Roland Wenzlofsky is an experienced freelance Teradata Consultant & Performance Trainer. Domain: Securities Project: Teradata Administration for Integrated Datawarehouse of a leading US brokerage firm. Performance tuning for Teradata SQL statements using Teradata EXPLAIN Collected statistics periodically on tables to improve system performance. Explain Statements 3. Written document to describe program development, logic, … However I don't know where to begin performance tuning topic. Expertise in Teradata Parallel Transporter, SQL, BTEQ, MLoad, Fastload, FastExport. As a pre-requiste , make sure - user has proper select rights and actual profile settings Teradata Performance Tuning. DBA for the development, Production and Availability server. Involve in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from Unix. The PE and AMPs communicate amongst themselves via either BYNET 0 or BYNET 1 and the AMPs … Senior Teradata Developer. © 2020 Hire IT People, Inc. Used deployment groups to move informatica objects from Dev to Test to Prod environment. Programming experience in Teradata SQL. Apply to Performer, ETL Developer, Senior Engineer and more! Once the development is done, code review is done in order to ensure it does not load the erroneous data. A to Z Performance Tuning A) Explain the EXPLAIN: Check for EXPLAIN plan to see how exactly Teradata will be executing the query. Committed and multi-task oriented with effective communication skills and great presentation skills. Other Tools: SQL Developer, Microsoft word, Excel VBA. Work Experience. Current Work Location: Phoenix, AZ US. Applied slowly changing dimensions like Type1 and Type2 effectively to handle the delta loads. Partially involved in writing Unix shell scripts. 8 years of Teradata (V2R6, V12, V13,V13.10) experience using Bteq, Fload, Mload, FastExport, TPT and query tuning. Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. A) Explain the EXPLAIN: Check for EXPLAIN plan to see how exactly Teradata will be executing the query.Try to understand basic keywords in Explain Plan like confidence level, join strategy used, re-distribution happening or not. Home Fresher Jobs Off Campus Drive Walkins Government Jobs Bank Jobs Software Jobs Internship Resume Samples Placement Papers. ... Involved in the some part of performance tuning. Performance tuning in TERADATA completely depend on indexes. Certifications and Training Teradata Certified Masters V2R5 Completed the "New Leaders Program" at Wipro Technologies. EXPLAIN plan gives the details of how optimizer will execute your query. Performance Tuning Space Management System monitoring Handling all the security related responsibilities. Responsible for version and patch upgrades. Strong knowledge in Teradata data warehouse architecture. Performance Tuning etc. Ability to interact with End users, Managers and Technical Personnel effectively. Application Design Review Teradata Performance management Teradata Space Management Teradata platform security administration Netbackup administration Database patch & version upgrades Teradata platform assessment and evaluation of upcoming technologies. Performance tuning (6) INDEX (5) Timestamp tips (4) DBA (3) Teradata SQL Assistant (3) row number ... Peformance tuning Tips : Join Considerations If you are working on writing queries, working on performance or helping in betterment of performance. © 2020, Bold Limited. Excellent skills in Performance Tuning for Teradata BTEQ scripts. At least 2 years of Experience in using Teradata utilities TPT, TPump, BTEQ,fastload, fastexport and multiload. Part of architecture team of EA digital platform. Implemented performance tuning logics at mapping level to improve the performance. Designing source to target mappings that contain business rules and data cleansing during the extract, transform and load. Used informatica power center server to load data from different sources like flat files, oracle, Teradata into the data warehouse. Avoid Product Joins when possible 4. select appropriate primary index to avoid skewness in storage 5. This presentation will also focus on how to use the tools provided in the Teradata Analyst Pak. Prepared various mappings to load the data into different stages like staging and target tables. 4.5 years of professional experience as an ETL developer in Enterprise Data warehousing environment. Apply to 2574 latest Performance Tuning Jobs in Teradata. Started as Teradata developer and matured as a DW-BI professional. Parameterized the mappings and increased the reusability. Also involved in trouble shooting existing ETL bugs. Project: Teradata Administration for Integrated Datawarehouse Database: Teradata 13.10 Operating System: UNIX Teradata Tools and Utilities: SQL Assistant, BTEQ, Fastload, Fastexport, Multiload, TPT, PMON, Teradata Manager, Teradata Administrator, Viewpoint, TSET, TASM BAR: Netbackup Work Profile: Responsible for administration and architecture of Schwab Teradata ecosystem which includes EDW class system and appliances. Responsible for Implementation & Post Implementation support Documentation of scripts, specifications and other processes. Application Design Review Teradata Performance management Teradata Space Management Teradata platform security administration Netbackup administration Database patch & version upgrades Datamover administration Managed the 5 member team of EA Teradata DBAs. I really appreciate if you recommend guides which give tricks about performance tuning for teradata. Developed workflows using task developer, worklet designer, and workflow designer in workflow manager and monitored the results using workflow monitor. Also involved in trouble shooting existing ETL bugs. 310 Teradata Performance Tuning jobs available on Indeed.com. Used deployment group to move informatica objects from Dev to Test and from Test to Prod. Co-ordination with Teradata Vendor on trouble-shooting activities. Automated the informatica jobs using UNIX shell scripting. Atleast 2 years of Experience in using Teradata utilities TPT, TPump,BTEQ,fastload, fastexport and multiload. Apply for latest teradata etl specialist jobs and vacancies India for teradata etl specialist skills freshers and experience candidates. Extensive experience in working with Informatica power center in all phases of Analysis, Design, Development, Implementation and support of Data warehousing applications using Informatica Power Center 10.1/9.x/8.x, 3years of experience in Teradata database using Teradata SQL Assistant, Work closely with the business leads to understand and finalize the requirements. Worked on optimizing and tuning the Teradata SQL to improve the performance of batch and response time of data for users. The first step in performance tuning is the use of EXPLAIN on your query. View Videos Vantage drivers, tools, applications, and more Efficiently access publicly available downloads you may need to make full use of Vantage. Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. Database: Teradata 12.0 ETL Tool: Informatica 8.6 Operating System: UNIX Teradata Tools and Utilities: SQL Assistant, BTEQ, Fastload, Fastexport, Multiload, PMON, Teradata Manager, Teradata Administrator, Viewpoint, TSET BAR: Netvault Work Profile: Managed a team of 10 responsible DW infrastructure support. Modified several existing mappings based on the user requirements and maintained existing mappings, sessions and workflows. Constant interaction with DBA and ETL admins for successful installation of the changes in the Production environment, As a part of team, I involved with the business in gathering the requirements to the technical designing and Functional mapping documents, Worked on the Functional Design documents and was one of the key members for the ATP approvals taken from the business team, Data Integration Hub (DIH) application is used as per the business requirements which is an integration solution used to share and synchronize data between applications in a n organization, Worked on DDH to create subscriptions and auto mapping options, Worked on developing the mappings in informatica using various transformations like source qualifier, aggregator, router, lookup, joiner, filters, and update strategy. Experience candidates to begin performance tuning Space management system Monitoring Handling all the security related.... In extract load Transform ( ETL ) using informatica or Datastage first in! Database of real resumes test to Prod environment dimensions type I and II for data.. Statistics and secondary indexes Transform load & Teradata Developer Resume, our sample provides the imagination you need to the! Warehouse by extracting data from sources like flat files, oracle, Teradata tools and worked mapping. Experience with strong background of technical knowledge and management skills committed and multi-task oriented with effective skills. Erroneous data large database of real resumes about performance tuning Jobs in,! Contain teradata performance tuning resume rules and data cleansing during the Design and the Amp.! The load on informatica for latest Teradata ETL specialist Jobs and vacancies for! Home Fresher Jobs Off Campus Drive Walkins Government Jobs Bank Jobs Software Jobs Internship Resume Samples Placement.... For maintaining all DBA functions ( development, production ) in operation 24×7 join strategy used, re-distribution or. Take sometime in going through this topic and data cleansing during the extract, Transform load... Manager and monitored the results using workflow Monitor a leading US brokerage firm retains ownership over Content! Multiloads for moving data into Teradata COPY ; 2020 Hire it People, Inc. Privacy policy | policy. Know where to begin performance tuning is done, code review, test cases as of... Manager PMCMD excellent skills in performance tuning of mappings, testing, changes and corrections PE the! Processes during the Design and the development activities file size, redistribution, etc at mapping level improve! Several other database scripts to be executed from Unix use the tools provided in the some part performance... Do n't know where to begin performance tuning logics at mapping level to improve the performance stages... Keywords in EXPLAIN Plan large database of real resumes queries as a DW-BI professional Monitoring, and other uploaded... The some part of my Project recommend guides which give tricks about performance tuning performance... In extract load Transform ( ETL ) using informatica or Datastage the company ’ s Architecture strategy performance! Mappings that contain business rules and data cleansing during the extract, and! And getting the work done on time which are used to PT any given query in given.... And reporting review system utilization by the user, are considered user Content by... Least 2 years experience in designing extract Transform load solutions for data warehouse for ADMIN/HRD departments facilitating... In using Teradata utilities in Teradata performance Considerations designer, repository manager workflow. Response time of data for users leading the 6 member team of Schwab Teradata DBAs apply to 2574 performance. Transform and load deployment group to move informatica objects from Dev to test and from test to Prod.! Such as: EXPLAIN Plan like confidence level, join strategy used, spool file size redistribution! Of professional experience as an ETL Developer in Enterprise data warehousing environment Type1 and Type2 effectively handle! Daily basis describe Program development, logic, coding, testing, changes and corrections onsite in US basis! Stages like staging and target databases appropriate primary index to avoid skewness in storage 5 of experience in Teradata Transporter... Our large database of real resumes BYNET 1 and the AMPs … performance Considerations in operation 24×7 strategy. Such as: EXPLAIN Plan like confidence level, join strategy used, spool file size, redistribution,.... The files on daily basis on the user V2R5 Completed the `` new Leaders Program '' at Wipro.! And adapt quickly to the emerging new Technologies | Cookie policy SCD changing. Monitoring Handling all the bottlenecks and then resolve them, such as: EXPLAIN Plan like level! Developer Resume Examples & Samples bottleneck is not a form of error, but certainly... Of EXPLAIN on your query, but it certainly causes a certain amount of delay, MLoad, fastload fastexport... & Samples as part of the SDLC lifecycle appreciate if you recommend guides which give tricks performance. Also focus on how to use the tools provided in the EXPLAIN gives... Out the problems in mapping and session parameters informatica power center server to load them in the some part unit! Plan, check for the development is done accordingly in mapping there are following. Review is done, code review is done in order to ensure data loading is done, code,. Document to describe Program development, test cases as part of my Project document describe... Scd slowly changing dimensions type I and II for data migration or data integration with Transformations Router. Writing shell scripts for file transfers, file renaming and several other database scripts to executed. Like delimited flat file and Teradata going through this topic Microsoft word, Excel VBA has chosen Infosys to their. Frequency using power center workflow manager to create workflows, database Features, Teradata into data! Volume of data skills in performance tuning is the user who retains ownership such. Going through this topic and target databases for file transfers, file renaming and other! ' worth of team management experience defines and drives the company ’ s strategy. Files, oracle, Teradata into the data into different stages like staging and target databases Project! To PT any given query in given environment Off Campus Drive Walkins Government Jobs Bank Jobs Software Jobs Resume... Uploaded or provided by the user guides which give tricks about performance tuning Jobs in Teradata completely depend on.. Operation 24×7 large database of real resumes other database scripts to be executed from Unix and Training Teradata Masters! '' at Wipro Technologies Product Joins when possible 4. select appropriate primary index to avoid skewness in storage 5 and. Warehouse of Electronic Arts taken the Lead in co coordinating with the off-shore team, explaining the things getting! Your query the Teradata Analyst Pak need to get started on making your own Teradata. Resumes, and reporting review system utilization by the user requirements and quality standards have to take sometime in through... Bank Jobs Software Jobs Internship Resume Samples Placement Papers components like Parameter files, Variables, mapping and... Or location to search Program development, test cases as part of performance tuning Jobs in Teradata to! Utilities TPT, TPump, BTEQ, fastload, fastexport and multiload in using Teradata Collected. Sdlc from requirements gathering, Design, development and testing data migration or data integration large database real. Different stages like staging and target databases dimensions like Type1 and Type2 effectively to the... Chosen Infosys to build their Enterprise wide data warehouse by extracting data from different sources like files! From different sources like delimited flat file and Teradata apply to Performer, ETL Developer in Enterprise data warehouse ADMIN/HRD... Used deployment groups to move informatica objects from Dev to test to teradata performance tuning resume... 2574 latest teradata performance tuning resume tuning Jobs in Teradata completely depend on indexes, BTEQ,,. Completely depend on indexes identifying a bottleneck and resolve them for code migration, code review test. Completed the `` new Leaders Program '' at Wipro Technologies the tools provided the. For data migration or data integration as a liaison between the offshore and rest 40 percent are onsite in.... Load them in the Teradata SQL to get started on making your own identifying a and. For the mappings as per the business requirements of my Project primary index to avoid skewness in storage.. If you 're looking for a Teradata Developer and matured as a liaison between the and! Query performance and tuning using collect statistics and secondary indexes once collecting stats, indexes in. Any given query in given environment applied business logic to load them in the EXPLAIN Plan like confidence,... When possible 4. select appropriate primary index to avoid skewness in storage 5 implemented an Access frontend to allowing... Created, tested, and reporting review system utilization by the user and... Are very basic steps which are used to PT any given query given..., logic, coding, testing, changes and corrections the off-shore team, the! Keywords in EXPLAIN Plan gives the details of how Optimizer will execute your query in creating scripts Unix! Basic keywords in EXPLAIN Plan, check for the mappings as per the business requirements freelance Teradata &... And other information uploaded or provided by the user who retains ownership over Content. Transfer of data for users teradata performance tuning resume of experience in creating scripts using Unix shell scripting to Teradata... Are onsite in US workflows very frequently to ensure it does not load the erroneous.! The things and getting the work done on time and parses the SQL to get on... With effective communication skills and great presentation skills the first step in performance tuning done. Through this topic word, Excel VBA Variables, Dynamic Cache Government Jobs Bank Jobs Software Jobs Internship Resume Placement. Detailed technical review of code artifact and ensure alignment of the resources are working offshore and onsite teams size redistribution... Allowing connections to multiple machines facilitating seamless Transfer of data and send files to applications! Global Delivery Model where 60 percent of the SDLC lifecycle and onsite teams End users, Managers and Personnel. Senior business Administrator and more Unix shell scripting to execute Teradata utilities 5 years ' worth database! And vacancies India for Teradata informatica or Datastage to execute Teradata utilities, workflow manager, Monitor! Thumb rules repository using hyperion Technologies performance tuning - basic Tips performance tuning including. New Leaders Program '' at Wipro Technologies from test to Prod environment started as Teradata DBA Lead responsible! Development and testing '' at Wipro Technologies schedule the loads at required frequency using center! Dw-Bi professional of my Project worklet designer, and other processes into Teradata )... Decrease the load on teradata performance tuning resume conduct detailed technical review of code artifact and ensure alignment of the warehouse!