Seeking hands-on Assessment & Discovery Engineers to analyze a complex Teradata ecosystem in preparation for migration to BigQuery. Candidates should combine strong legacy system analysis with coding/automation, quantitative analysis and stakeholder interaction.

Key Responsibilities

-

Inventory Teradata databases, tables, views, procedures, BTEQ scripts, loaders and ETL processes.

-

Analyze DBQL and metadata for query frequency, CPU, I/O, runtime, concurrency, object usage and application/user activity.

-

Perform volumetric analysis, including data volumes, table sizes, historical growth, processing volumes, workload distribution and peak patterns.

-

Analyze in-house ETL frameworks, BTEQ/load processes and embedded transformation logic.

-

Analyze Tivoli job streams, schedules, dependencies and critical batch chains.

-

Assess SSAS and Power BI dependencies and usage.

-

Build end-to-end lineage and dependency mappings.

-

Develop Python/SQL/Shell scripts and reusable utilities to speed up discovery and analysis rather than relying entirely on manual assessment.

-

Correlate DBQL, metadata, ETL, scheduler and BI findings to identify dependency gaps.

-

Produce meaningful statistics such as active vs inactive objects, workload utilization, query distribution, dependency counts,



complexity and migration candidates.

-

Create analytical views, charts, heatmaps and summaries from large discovery datasets.

-

Coordinate with technical/application SMEs to validate findings and resolve undocumented dependencies.

-

Present findings and recommendations clearly to the Architect and program stakeholders.

Must-Have Skills

-

Teradata and strong SQL.

-

Teradata DBQL and metadata analysis.

-

BTEQ / Teradata loaders.

-

ETL and Data Warehousing.

-

Batch/job dependency analysis.

-

Python/Shell/SQL scripting and automation capability.

-

Data lineage and dependency analysis.

-

Strong quantitative/volumetric analysis skills.

-

Ability to interpret large datasets and derive meaningful insights.

-

Robust communication, stakeholder coordination and presentation skills.

Preferred Skills

-

Tivoli Workload Scheduler.

-

Power BI / SSAS.

-

BigQuery / GCP exposure.

-

Experience creating discovery tools, scripts or assessment accelerators.

-

Automated SQL/BTEQ parsing or metadata analysis.

-

Dashboarding/data visualization skills.

-

Exposure to AI/GenAI or agent-based approaches for accelerating assessment, code analysis or dependency discovery.

📌 Teradata Migration Assessment & Discovery Engineer (Noida)
🏢 Recognized
📍 Noida