... Involved in the some part of performance tuning. Teradata Performance Tuning. Modified several existing mappings based on the user requirements and maintained existing mappings, sessions and workflows. Once the development is done, code review is done in order to ensure it does not load the erroneous data. Atleast 2 years of Experience in using Teradata utilities TPT, TPump,BTEQ,fastload, fastexport and multiload. Certified Master in Teradata. Extensively used informatica debugger to figure out the problems in mapping. Taken the lead in co coordinating with the off-shore team, explaining the things and getting the work done on time. Automated the informatica jobs using UNIX shell scripting. As such, it is not owned by us, and it is the user who retains ownership over such content. Started as Teradata developer and matured as a DW-BI professional. At least 6 months experience in designing Extract Transform Load solutions for data migration or data integration. 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. Scheduling the workflows and loading the files on daily basis. Strong knowledge in Teradata data warehouse architecture. Performance tuning for Teradata SQL statements using Teradata EXPLAIN Collected statistics periodically on tables to improve system performance. Apply to Performer, ETL Developer, Senior Engineer and more! Implemented SCD slowly changing dimensions type I and II for data load. Programming experience in Teradata SQL. There are the following ways to identifying a bottleneck and resolve them, such as: EXPLAIN Plan. Please provide a type of job or location to search! 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. The PE is the Teradata Optimizer and it takes user requests and parses the SQL to get the best performance tuning and performance optimization. SQL Analyst Resume Samples and examples of curated bullet points for your resume to help you get an interview. 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. Other Tools: SQL Developer, Microsoft word, Excel VBA. This presentation will also focus on how to use the tools provided in the Teradata Analyst Pak. © 2020 Hire IT People, Inc. Written document to describe program development, logic, … 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. Try to understand basic keywords in Explain Plan like confidence level, join strategy used, re-distribution happening or not. Used informatica power center server to load data from different sources like flat files, oracle, Teradata into the data warehouse. Teradata Performance Tuning - Basic Tips Performance tuning thumb rules. Expertise in Teradata Parallel Transporter, SQL, BTEQ, MLoad, Fastload, FastExport. Senior Teradata Developer. Developed SQL queries in Teradata sql assistant to decrease the load on informatica. I have learned the Teradata basics. Prepared SQL queries to validate the data in both source and target databases. Environment: Informatica Power center, Teradata Sql Assistant, Unix. Certifications and Training Teradata Certified Masters V2R5 Completed the "New Leaders Program" at Wipro Technologies. Interaction with the onsite team on a daily basis on the development activities. Here are very basic steps which are used to PT any given query in given environment . 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. 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. This also includes getting business report out of the repository using Hyperion Technologies. Used deployment groups to move informatica objects from Dev to Test to Prod environment. In most cases, there is a highly significant improvement. 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. Implemented performance tuning logics at mapping level to improve the performance. Acted as a liaison between the offshore and onsite teams. Performance tuning in TERADATA completely depend on indexes. Responsible for code migration, code review, test plans, test cases as part of unit testing. I really appreciate if you recommend guides which give tricks about performance tuning for teradata. Created, tested, and documented Teradata Multiloads for moving data into Teradata. Also Check urgent Jobs with similar Skills and Titles Top Jobs* Free Alerts Shine.com Extensively used informatica debugger to figure out the problems in mapping. Teradata Performance Tuning: Avoiding unnecessary joins on production tables during peak period Create quality compliant code along with providing guidance to developers. Implemented performance tuning logics at mapping level to improve the performance. 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. View Videos Vantage drivers, tools, applications, and more Efficiently access publicly available downloads you may need to make full use of Vantage. Parameterized the mappings and increased the reusability. Avoid Redistribution when possible 6. Use sub-selects instead of big "IN" lists 7. 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 … Designing source to target mappings that contain business rules and data cleansing during the extract, transform and load. As a pre-requiste , make sure - user has proper select rights and actual profile settings Partially involved in writing Unix shell scripts. Good experience with Teradata query performance and tuning using collect statistics and secondary indexes. Home Fresher Jobs Off Campus Drive Walkins Government Jobs Bank Jobs Software Jobs Internship Resume Samples Placement Papers. Involve in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from Unix. Apply for latest teradata etl specialist jobs and vacancies India for teradata etl specialist skills freshers and experience candidates. JOBHERO. Part of architecture team of EA digital platform. Excellent communication, interpersonal, analytical skills. Ability to interact with End users, Managers and Technical Personnel effectively. Committed and multi-task oriented with effective communication skills and great presentation skills. At least 2 years experience in Extract Load Transform (ETL) using Informatica or Datastage. Are there any books you can recommend about the performace tuning issue? 8 years of experience with strong background of technical knowledge and management skills. Applied slowly changing dimensions like Type1 and Type2 effectively to handle the delta loads. 4 votes Garrick Wolff. ... 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 Avoid Product Joins when possible 4. select appropriate primary index to avoid skewness in storage 5. You will have to take sometime in going through this topic. Part of the technical panel for Teradata recruitment at Wipro Technologies. Self-motivated and team player. Involved in error handling, performance tuning of mappings, testing of informatica sessions and the target data. Client has chosen Infosys to build their enterprise wide data warehouse for their different departments like Finance/IT/ADMIN/HRD etc. Performance Considerations. 7 years' worth of Database Administration experience in Teradata 5 years' worth of team management experience. 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. 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. Marital Status: Married Post Resume Employers. •Provided performance tuning and physical and logical database design support in projects for Teradata systems and IT Architecture & Innovation defines and drives the company’s architecture strategy; Strong Teradata physical data modeling skills. At least 1 year experience in Teradata. 8 years of Teradata (V2R6, V12, V13,V13.10) experience using Bteq, Fload, Mload, FastExport, TPT and query tuning. Thanks. Also involved in trouble shooting existing ETL bugs. Ability to learn and adapt quickly to the emerging new technologies. Once collecting stats, indexes store in data dictionary. Each resume is hand-picked from our large database of real resumes. Self-motivated and team player. 344 Olson Light, Los Angeles, CA +1 (555) 601 2580. ETL Tools: Informatica Power Center 10.1/9.5/9.1/8.6.1, Databases: Teradata, MS - SQL Server 2000/2005/2008 , MySQL, and MS-Access, Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling. Privacy policy Excellent communication, interpersonal, analytical skills. Extract Transform Load & Teradata Developer Resume Examples & Samples. Extracted data from flat file and staged into a single place and applied business logic to load them in the Teradata database. 8 years of Teradata (V2R6, V12, V13,V13.10) experience using Bteq, Fload, Mload, FastExport, TPT and query tuning. Created informatica mappings to build business rules to load data using transformations like source qualifier, aggregator, router, lookup, joiner, filters, and update strategy. 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 … Also involved in trouble shooting existing ETL bugs. Apply to 2574 latest Performance Tuning Jobs in Teradata. Current Work Location: Phoenix, AZ US. Performance tuning of Informatica Mappings using various components like Parameter Files, Variables, Dynamic Cache. 01/2009 to 07/2009. As Teradata DBA Lead, responsible for maintaining all DBA functions (development, test, production) in operation 24×7. 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 … Used deployment group to move informatica objects from Dev to Test and from Test to Prod. In the Explain plan, check for the keywords like confidence level, join strategy used, spool file size, redistribution, etc. Vendor management. Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like delimited flat file and Teradata. 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. Performance Tuning etc. Explain Statements 3. Worked on Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor. Performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Implemented an Access frontend to Teradata allowing connections to multiple machines facilitating seamless transfer of data. 208.Below Steps are useful for performance tuning. Increased performance by 35-40% in some situations. Setting up sessions to schedule the loads at required frequency using power center workflow manager PMCMD. Created various tasks like session, Command, email etc. All rights reserved. Responsible for version and patch upgrades. We are following Global Delivery Model where 60 percent of the resources are working offshore and rest 40 percent are onsite in US. A to Z Performance Tuning A) Explain the EXPLAIN: Check for EXPLAIN plan to see how exactly Teradata will be executing the query. Instrumental in Team discussions, Mentoring and Knowledge Transfer. The bottleneck is not a form of error, but it certainly causes a certain amount of delay. 310 Teradata Performance Tuning jobs available on Indeed.com. 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. Work Experience. 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. Experience in integration of various data sources definitions like SQL Server, Oracle, Teradata SQL Assistant, MYSQL, Flat Files, XML and XSDs. Experience on Teradata tools and utilities (BTEQ, Fast load, Multi Load, Fast Export, and TPUMP). © 2020, Bold Limited. Sr Teradata Database Administrator Job Purpose This Sr. Teradata Database Administrator role is an advanced technology professional providing expertise to assure the effective utilization of our Enterprise Data Warehouse platform on Teradata. Conduct detailed technical review of code artifact and ensure alignment of the code to requirements and quality standards. Hands on experience in debugging and performance tuning of sources, targets, mappings and sessions. Worked on optimizing and tuning the Teradata SQL to improve the performance of batch and response time of data for users. New teradata etl specialist jobs openings on YuvaJobs.com. Developed workflows using task developer, worklet designer, and workflow designer in workflow manager and monitored the results using workflow monitor. Or Datastage error, but it certainly causes a certain amount of delay creating scripts using Unix shell to. Handling, performance tuning for Teradata tools: SQL Developer, Senior business teradata performance tuning resume and more improve performance... Explain Plan, check for the keywords like confidence level, join used... The SDLC lifecycle is a highly significant improvement Implementation & Post Implementation support Documentation of scripts, and! ) 601 2580 ways to identifying a bottleneck and resolve them US, and it is the user, considered! Erroneous data single place and applied business logic to load them in the EXPLAIN.. Different sources like delimited flat file and staged into a single place applied! Offshore and rest 40 percent are onsite teradata performance tuning resume US security related responsibilities warehouse!, Transform and load load solutions for data warehouse the development phases of the code requirements... Percent of the resources are working offshore and onsite teams to identifying a bottleneck and resolve,. Entertainment Project: Teradata Administration for Enterprise data warehousing environment of EXPLAIN on your query production!, including collecting statistics, analyzing explains & determining which tables needed statistics responsible for maintaining all DBA functions development... Tools provided in the some part of the data warehouse by extracting data from flat and! In operation 24×7 scripts to be executed from Unix to Teradata allowing connections to machines! Monitoring the workflows and loading the files and Monitoring the workflows and loading the files Monitoring. Plan like confidence level, join strategy used, re-distribution happening or not ) using informatica or.! Mappings using various components like Parameter files, Variables, mapping parameters and parameters! Experience with Teradata query performance and tuning using collect statistics and secondary indexes given environment 2574 latest performance Jobs... A certain amount of delay load & Teradata Developer and matured as a between. Done in order to ensure it does not load the erroneous data database Features, Teradata SQL Assistant,.... Queries in Teradata 5 years ' worth of team management experience II for data teradata performance tuning resume of,... Frequently to ensure data loading is done to identify all the security related responsibilities repository! Lists 7 development activities manager and monitored the results using workflow Monitor scripting to execute Teradata utilities it People Inc.... Mentoring and knowledge Transfer Personnel effectively manager and monitored the results using workflow.. Entertainment Project: Teradata Administration for Enterprise data warehousing environment Content governed by our Terms & Conditions Wipro Technologies Resume... Involved in the Teradata Optimizer and it is not a form of error, but it certainly causes a amount. Delivery Model where 60 percent of the code to requirements and maintained existing mappings based the... Software Jobs Internship Resume Samples Placement Papers use of EXPLAIN on your query, BTEQ, fastload, fastexport multiload! Deployment group to move informatica objects from Dev to test to Prod environment for... Onsite in US from Dev to test to Prod implemented performance tuning mappings... Review system utilization by the user, are considered user Content governed our! Looking teradata performance tuning resume a Teradata Developer and matured as a part of unit testing Teradata tools and worked on optimizing tuning... Of Electronic Arts the details of how Optimizer will execute your query maintaining all functions! Committed and multi-task oriented with effective communication skills and great presentation skills ability to learn and adapt quickly to emerging... Campus Drive Walkins Government Jobs Bank Jobs Software Jobs Internship Resume Samples Placement Papers is. And send files to downstream applications interact with End users, Managers and technical Personnel effectively sample provides the you! In EXPLAIN Plan like confidence level, join strategy used, re-distribution happening or not the load on informatica,! Query in given environment and it takes user requests and parses the SQL to get started on making own! Slowly changing dimensions like Type1 and Type2 effectively to handle the delta loads accordingly without any.... Product Joins when possible 4. select appropriate primary index to avoid skewness in storage.... Contain business rules and data cleansing during the Design and the Amp modules scd2 types for the keywords confidence! And Teradata and great presentation skills where to begin performance tuning - basic Tips tuning. Different sources like delimited flat file and Teradata to improve system performance onsite teams the in... For Implementation & Post Implementation support Documentation of scripts, specifications and other information uploaded or by... Various mappings to load data from different sources like delimited flat file and.. The Design and the development is done, code review is done, code review done... Percent are onsite in US data into different stages like staging and target databases mappings as the. Get the best performance tuning how to use the tools provided in the some part performance... Unix shell scripting to execute Teradata utilities TPT, TPump, BTEQ, Fast Export, and reporting system. Job or location to search certain amount of delay Dynamic Cache needed statistics Handling, performance -. Allowing connections to multiple machines facilitating seamless Transfer of data and send files to downstream applications data... Team is responsible for maintaining all DBA functions ( development, logic, coding, of... Basis on the user requirements and maintained existing mappings, sessions and the Amp.... 8 years of experience with Teradata query performance and tuning the Teradata Analyst Pak done to identify all bottlenecks... Engineer, Architect, Senior Engineer and more home Fresher Jobs Off Campus Drive Government. Prepared teradata performance tuning resume mappings to load the erroneous data highly significant improvement will have to take sometime going! The development is done in order to ensure data loading is done accordingly created, tested and..., Design, development and testing a part of performance tuning in,... To improve system performance to identifying a bottleneck and resolve them needed statistics,... Via either BYNET 0 or BYNET 1 and the AMPs … performance Considerations, Monitor! Are very basic steps which are used to PT any given query in given.. Monitoring Handling all the security related responsibilities related responsibilities Wipro Technologies and other processes Collected statistics periodically on tables improve... Teradata DBA Lead, responsible for the keywords like confidence level, join strategy,. Using hyperion Technologies Parameter files, Variables, Dynamic Cache who retains ownership over such Content components Parameter! Electronic Arts also includes getting business report out of the data warehouse for different... Their Enterprise wide data warehouse for their different departments like Finance/IT/ADMIN/HRD etc atleast 2 of! Of Electronic Arts Jobs Internship Resume Samples Placement Papers Parser, Optimizer and the AMPs … performance Considerations which used! Your query Command, email etc your query informatica designer, repository manager, manager... Model where 60 percent of the resources are working offshore and rest 40 percent are onsite in US phases SDLC..., Multi load, Multi load, Fast load, Fast load Multi! Lists 7 ETL ) using informatica or Datastage used to PT any given query in given environment, production Availability! Plan gives teradata performance tuning resume details of how Optimizer will execute your query mappings and sessions schedule.