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.

- Robust 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 (Noida)
🏢 Topcoder
📍 Noida