Teradata Application Support Engineer

Location: Airoli Navi Mumbai, Maharashtra IN


This position is no longer open.

Requisition Number: 205766

Position Title: Managed Services II+

External Description:

Skill - Teradata-ETL (TPT/BTEQ/Utilities) operations support & environment-administration

Job Location: Airoli, Navi Mumbai/ Magarpatta City, Pune


  • Monitor, analyze, troubleshoot, rectify and resolve TPT/BTEQ workflow/session failures & related issues
  • Log, in detail, the root-cause, the troubleshooting-flow, the impact of an incident etc. on available incident-management tool/application
  • Ensuring complete adherence to SLAs for all operations of workflows/sessions/jobs
  • Configure & maintain TPT/BTEQ environment using recognized best practices (ODBC installation & configuration, TTU configuration etc.). Install/provide support for TPT/BTEQ hot fixes, patches, upgrades etc.
  • Configure & maintain components for the data integration environment (folder creation; folder/file privileges; create/maintain/manage TPT/BTEQ run-time environment on Unix/Linux machine, Archive-scripts/logs, capture & maintain logs and log directories, cleanup of log directories)
  • Proactively analyzing workflows/sessions/jobs and identifying, developing & implementing performance improvement opportunities
  • Handle deployment methodologies, code and data movement between Dev., QA and Prod Environments (deployment groups / folder copy/ data-copy etc)
  • Maintain data integration environment scheduler (Control-M, JCL, Unix/Linux-cron etc.) schedules and dependencies as required
  • Handle L1-level database operations support activities and database administration activities including data-movement between/within system(s), database-user-management, database-space-management (e.g. MVC), database-object-management (e.g. Table-Creation/ Table-Rebuild etc.), database-privileges-management, database-performance-monitoring (using Viewpoint or OS-level utilities), release session locks, initiate & monitor BAR jobs etc.
  • Attend periodic meetings with client
  • Develop and produce daily/ weekly operations reports and metrics as required by IT management
  • Develop clear and detailed technical & process documentation (processes for service-requests; SOPs for incidents). Develop and maintain known-error-database (KEDB) documentation for operational issues
  • Use command line (OS-shell interface) to monitor/ analyse/ administer domain

Required Skills & Attributes

  • 3+ years of experience in Teradata-TPT/BTEQ support and development role
  • Skilled in assimilating ETL business-requirements (BR), understanding the underlying data-model, converting BRs to Teradata-ETL workflow/session/job and implementing the same
  • Should have strong Teradata-SQL writing skills (write various investigative queries)
  • Experience in maintaining/versioning Teradata-TPT/BTEQ/TD-Utilities like TPump/ FLoad/ MLoad/ FExp etc. scripts/application on Linux/Unix servers
  • Good working knowledge of TPT/BTEQ and able to code TPT/BTEQ-jobs/workflow and integrate with Unix/ Linux shell-scripting
  • Good working knowledge and able to develop, maintain, schedule Unix/ Linux shell scripting, Unix/ Linux space management related with TPT/BTEQ Domain
  • Good understanding of LDM/PDM, Normalization and De-normalization concept; Ability to understand the data model; Exposure to Enterprise-DW environment (Knowledge of ETL/DI/BI Reporting)
  • Good understanding of Teradata-database systems, Teradata database-administration operations. Possess skills in database-administration operations
  • Well conversant with usage of ticketing system(s) and concept of change-request/ incidents/ service-requests/ problem-records
  • Basic Unix/Linux shell script maintenance and hands-on experience of OS-command usage
  • Able to function well in a fast-paced and adaptive environment
  • Must be ready to work in a 24 X 7 operations/production support SLA based environment, with on-shift & on-call model, involving handling of critical tickets(P1/P2)
  • Good writing & verbal communication skills using English as a language and should be able to express thoughts, technical-topics in clear & concise manner


Desirable Skills

  • Experience of and desirability to support data-integration applications like Informatica, Talend, Microsoft-SSIS and Master-Data-Management application like Teradata-MDM application is highly desirable and will be appreciated



City: Airoli Navi Mumbai

State: Maharashtra

Community / Marketing Title: Teradata Application Support Engineer

Job Category: Consulting

Company Profile:

Considering COVID-19, we are still hiring but conducting virtual interviews to keep our candidates and employees safe. Many roles will be temporarily remote or work from home to comply with current safety regulations. These roles will be required to be in the office once it is safe or restrictions are lifted. Read more on our response here: Teradata Response to COVID-19 

With all the investments made in analytics, it’s time to stop buying into partial solutions that overpromise and underdeliver. It’s time to invest in answers. Only Teradata leverages all of the data, all of the time, so that customers can analyze anything, deploy anywhere, and deliver analytics that matter most to them. And we do it at scale, on-premises, in the Cloud, or anywhere in between.

We call this Pervasive Data Intelligence. It’s the answer to the complexity, cost, and inadequacy of today’s analytics. And it's the way Teradata transforms how businesses work and people live through the power of data throughout the world. Join us and help create the era of Pervasive Data Intelligence.

Location_formattedLocationLong: Airoli Navi Mumbai, Maharashtra IN


© 2020, Teradata. All rights reserved. | Privacy | Terms of Use | Fraud Alert | Tracking Consent | Teradata is an Equal Opportunity Employer | www.teradata.com