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.
Strong 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