Artificial Intelligence Engineer

a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }

Copilot said:

Movate Format JD

Job Title: GenAI Migration Engineer (Python, Snowflake & dbt)

Experience: 5-7 Years
Location: Remote / Bengaluru / Chennai / Hyderabad
Employment Type: Full-Time

Job Summary

Movate is seeking a highly skilled GenAI Migration Engineer to design and develop AI-powered modernization solutions for enterprise data transformation and legacy system migration initiatives. The ideal candidate will build and enhance GenAI-driven pipelines that automate the conversion of legacy SQL code, stored procedures, data models, and warehouse constructs into modern cloud-native architectures using Snowflake and dbt.

This role requires strong expertise in Python development, LLM integration, Prompt Engineering, Snowflake, dbt, and AI-assisted automation frameworks. The candidate will work closely with Data Architects, Data Modellers, and Data Engineering teams to improve conversion accuracy, automate validation, and accelerate cloud migration programs.

Key Responsibilities

• Design, develop, and maintain GenAI-powered code modernization and migration pipelines.
• Build AI-driven solutions to automate conversion of legacy SQL, ETL, stored procedures, and data warehouse objects into Snowflake-compatible implementations.
• Develop Python-based orchestration frameworks for LLM integrations and automated migration workflows.
• Collaborate with Data Architects and Data Modellers to understand source systems and target-state architectures.
• Design and optimize prompts for code conversion, SQL transformation, and migration use cases.
• Automate validation and quality assurance of AI-generated outputs.
• Implement confidence scoring mechanisms and human-in-the-loop review processes.
• Build scalable migration frameworks for enterprise data modernization programs.
• Develop dbt models, transformations, and testing frameworks to support cloud migration initiatives.
• Validate data warehouse conversions from legacy platforms to Snowflake.
• Create reusable frameworks, templates, and accelerators for migration projects.
• Monitor, measure, and improve AI conversion accuracy and performance metrics.
• Maintain prompt repositories, version control, and experiment tracking processes.
• Work closely with engineering teams to ensure migration outputs meet enterprise quality standards.

Mandatory Skills

Generative AI & LLMs

• Prompt Engineering
• LLM Integration
• GPT-4, Claude, Gemini, or equivalent foundation models
• Few-Shot Prompting
• Chain-of-Thought Prompting
• AI-Assisted Code Generation
• AI Automation Pipelines

Python Development

• Advanced Python Programming
• API Development & Integration
• Pipeline Orchestration
• Code Parsing & Validation
• Workflow Automation
• Batch Processing Frameworks
• Object-Oriented Programming

Snowflake (Must Have)

• Snowflake Architecture
• Snowflake SQL
• Snowpipe
• Virtual Warehouses
• Data Migration to Snowflake
• Data Warehouse Modernization
• Performance Optimization
• Query Tuning
• Security & Governance

dbt (Must Have)

• dbt Core
• dbt Cloud
• Data Transformation
• Data Lineage
• Data Testing
• Data Quality Validation
• CI/CD Integration
• ELT Framework Design

SQL & Data Warehousing

• Advanced SQL
• SQL Optimization
• Stored Procedures
• Data Warehouse Concepts
• Data Modeling Fundamentals
• Legacy SQL Conversion
• ETL/ELT Frameworks

GenAI Frameworks

• LangChain
• LlamaIndex
• Prompt Flow
• Embedding Models
• Vector Databases
• Retrieval Augmented Generation (RAG)

Validation & Quality Engineering

• Automated Code Validation
• Pattern Matching
• Rule-Based Quality Checks
• Confidence Scoring Frameworks
• AI Output Assessment
• Human Review Workflows

DevOps & MLOps

• Git
• CI/CD Pipelines
• Prompt Versioning
• Experiment Tracking
• Model Evaluation
• Monitoring & Reporting

Required Qualifications

• 5-7 years of experience in Software Engineering, Data Engineering, or Data Platform Development.
• Minimum 2 years of hands-on experience with LLMs, Generative AI, or AI-powered automation pipelines.
• Strong expertise in Python development and automation frameworks.
• Hands-on experience with Snowflake implementation, migration, or development.
• Strong experience with dbt transformations and cloud data engineering practices.
• Experience working with SQL-heavy applications, databases, and data warehouse environments.
• Knowledge of modern cloud-based analytics architectures.
• Experience evaluating and validating AI-generated outputs.
• Excellent problem-solving and analytical capabilities.

Preferred Qualifications

• Experience in legacy system modernization or migration projects.
• Exposure to SAP HANA, Oracle, Teradata, SQL Server, or other enterprise databases.
• Experience with Data Vault, Kimball, and Medallion Architecture concepts.
• Hands-on knowledge of RAG-based applications and vector database implementations.
• Snowflake Certification and/or dbt Certification.
• Experience with Azure, AWS, or GCP cloud environments.

Nice to Have

• SAP HANA Migration
• Databricks
• Apache Spark
• Azure Data Factory
• AWS Glue
• Airflow
• OpenAI APIs
• Claude APIs
• MLFlow
• Vector Search Platforms

Key Competencies

• Prompt Engineering
• Python Development
• Snowflake Data Engineering
• dbt Development
• AI Automation
• Cloud Data Modernization
• Data Migration
• Technical Problem Solving
• Stakeholder Management
• Agile Development