Teradata Developer & Data Lakehouse Application Support Engineer

VMC Soft Technologies, Inc; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

VMC Soft Technologies, Inc. in Pan India is seeking an experienced Teradata Developer & Data Lakehouse Application Support Engineer to join our Data Engineering team.

You will design, develop, and optimize Teradata SQL scripts, build ETL/ELT pipelines, and ensure high availability of enterprise data workloads. The role covers production support (L1/L2), performance tuning, incident management, data movement, and DR readiness.

Qualifications

• 5–8 years of experience in Teradata development and data engineering.
• Proficient in Teradata SQL, Vantage, and ETL/ELT processes.
• Experience with production support and incident management.

Responsibilities

• Design, develop, and optimize Teradata SQL scripts and database objects.
• Build and optimize ETL/ELT pipelines across data layers.
• Provide L1/L2 production support for Teradata Data Lakehouse.

Skills

Teradata SQL

Teradata Vantage

ETL/ELT

Production support

Performance tuning

Incident management

Data Lakehouse tech

Data pipelines

Tools

Teradata Viewpoint

Teradata Data Mover

QueryGrid

ClearScape Analytics

DSU

Job description

Job Title: Teradata Developer & Data Lakehouse Application Support Engineer

Location: Pan India

Experience: 5 8 Years

Employment Type: Full-Time

Role Summary

We are seeking an experienced Teradata Developer & Data Lakehouse Application Support Engineer to join our Data Engineering team. The ideal candidate will be responsible for both application development and L1/L2 production support within the Teradata Data Lakehouse ecosystem. This role involves designing, developing, optimizing, monitoring, and supporting enterprise data pipelines, ETL/ELT processes, and analytical workloads while ensuring high availability, performance, and operational excellence.

The candidate should possess strong expertise in Teradata SQL, Teradata Vantage, ETL/ELT development, production support, performance tuning, incident management, and Data Lakehouse technologies.

1. Teradata Development & Data Engineering

• Design, develop, and optimize Teradata SQL scripts, stored procedures, macros, and database objects.
• Build, maintain, and optimize ETL/ELT pipelines across Raw, Curated, and Semantic data layers.
• Develop scalable data integration solutions using Teradata Vantage.
• Perform SQL optimization, query tuning, indexing, and workload performance improvements.
• Develop reusable components and support enterprise data engineering best practices.
• Participate in application enhancements, code reviews, and technical design discussions.
• Support deployment activities, release validation, and post-production stabilization.

2. Production Support & Operations

• Provide L1/L2 application support for Teradata Data Lakehouse environments.
• Monitor ETL jobs, workloads, pipelines, and system health using Teradata Viewpoint.
• Perform daily operational health checks and publish status reports.
• Monitor query performance, resource utilization, and workload execution.
• Ensure successful execution of batch jobs and end-to-end data processing.

3. Incident & Problem Management

• Act as the primary point of contact for production incidents.
• Troubleshoot ETL failures, query performance issues, and application errors.
• Perform job reruns, recovery activities, and SLA-based service restoration.
• Conduct Root Cause Analysis (RCA) and implement preventive measures.
• Coordinate with development, infrastructure, and business teams for issue resolution.
• Maintain incident documentation and support continuous improvement initiatives.

4. Data Movement & Integration

• Support Teradata Data Mover for data replication, migration, and environment refresh activities.
• Monitor and troubleshoot Data Mover job failures.
• Manage QueryGrid connectivity between Teradata and external platforms.
• Ensure seamless data synchronization across multiple environments.

5. Business Continuity & Disaster Recovery

• Support Business Continuity Management (BCM) activities.
• Monitor Disaster Recovery (DR) synchronization and failover readiness.
• Participate in DR drills and recovery testing.
• Perform backup and restore operations using DSU.
• Validate recovery procedures and ensure business continuity compliance.

6. Analytics, Governance & Documentation

• Support ClearScape Analytics workloads and advanced analytical processing.
• Ensure compliance with enterprise data governance standards.
• Support metadata management, data lineage, and audit requirements.
• Prepare technical documentation, SOPs, operational runbooks, and knowledge base articles.
• Follow organizational security and compliance standards.

7. Release & Change Management

• Support application deployments, release management, and production cutovers.
• Execute deployment validation and smoke testing.
• Participate in change management activities.
• Adhere to ITIL best practices for Incident, Problem, Change, and Release Management.