Welcome to IGNITE GenAI

  • Follow Us
How we saved over 20,000 hrs. of manual effort on a large-scale data modernization program ?
Case Studies

How we saved over 20,000 hrs. of manual effort on a large-scale data modernization program ?

CXOs, Data Engineering Teams

Problem Statement

  • 5000 + ETL workflows to be analyzed and moved from legacy platform into cloud ecosystem.
  • 8000 + tables needs to be migrated from legacy MPP databases into cloud ecosystem.
  • 40000 + script files in legacy code are used for data ingestion, data transformation and data loading into target data platform.
  • Developers spend an average of 20 hrs. for understanding every object migration planning.
  • Developers spend an average of 55 hrs. per script and object to migrate from legacy platform to target data platform.

Solution

Leveraging the power of Generative AI and our data domain expertise, we were able to build custom GenAI applications to accelerate bulk script analysis, code analysis, dependency analysis and code conversion with custom enhancements to the migrated code.

  • GenAI powered work flow analysis could crawl 1000s of job and create a comprehensive documentation to explain the job functions and dependencies.
  • Ability to automatically read and explain simple and complex scripts that contain shell scripts, SQLs, Java code.
  • Automated entity extractor from programs and SQL scripts.
  • Accelerated code migration with GenAI to get 1000s of ETL scripts converted from source platform into target platform code.
  • Custom code enhancements to the migrated code through GenAI prompt engineering.
  • One shot DDL conversion from source to target platform using GenAI and prompt engineering to define precise data types.

Benefits

  • Developers were able to save 60% of their time in script analysis for migration planning.
  • Developers were able to save over 45% of their code migration and validation process.
  • 8000 + table migration was done in one shot saving huge manual effort and increasing the accuracy.
  • After a few iterations, we were able to enhance the GenAI solution with prompt tuning to support several new use cases and scenarios.
  • Overall timeline was drastically reduced for the project and the quality of the deliverables went significantly high.

All our solutions are customizable to your requirements

Talk With Us