Devanshu Raj

About Devanshu Raj

Professional SummarySeasoned IT professional with 13 years of experience in Data Engineering, Technical Leadership, and Enterprise Architecture. Expert in Snowflake, Python, ETL, and Data Warehousing, with a track record of delivering data-driven solutions and leading cross-functional teams. Skilled in cloud migration, stakeholder communication, and agile methodologies.Core SkillsSnowflake, Teradata, Oracle, DB2, MySQL, SingleStore | ETL, Data Warehousing, Informatica, DataStage | Python, Unix, Big Data, Hive, Azure | Jira, GIT, CA WA, WLM, Keystone | Agile, Scrum, SDLC, Data Modeling, TableauProfessional ExperienceTechnical Manager, TCS, Bangalore (Oct 2023 – Present)• • Led Snowflake-based data projects and customer success engagements.• • Developed architecture for enterprise-scale ingestion, BI, and backup solutions.• • Resolved complex technical issues and ensured high client satisfaction.Technical Lead, TCS, Bangalore (Oct 2021 – Oct 2023)• • Designed GDPR Python solutions integrating Oracle, Teradata, Snowflake.• • Led Keystone cloud migration; monitored production failures.• • Reviewed team code and managed change requests (CRQ).Senior System Engineer, GAP.INC, Hyderabad (Nov 2017 – Oct 2021)• • Led an 8-member team; created end-to-end data flow models.• • Designed dimensional models for analytics and reporting.• • Collaborated with product teams for business requirement gathering.Senior Software Engineer, Tetrasoft, Hyderabad (Jun 2016 – Nov 2017)• • Migrated Excel reports to Power BI dashboards.• • Designed Informatica ETL workflows and supported client SLAs.• • Owned Agile development lifecycle from requirements to testing.Associate Software Engineer, IBM, Bangalore (Aug 2012 – Apr 2016)• • Resolved client-reported data issues; automated QA processes.• • Enhanced ETL performance using Datastage.• • Prepared design docs and reviewed specifications with business users.EducationMBA, Symbiosis Center of Distance Learning (2019–2020)B.Tech, Bangalore Institute of Technology, Bangalore (2008–2012)CertificationsTeradata SQL Certification – Teradata Corp.(Sep 2013)Teradata Architect Certification – Teradata Corp.(Aug 2014)LanguagesEnglish, HindiHobbies & InterestsChess, Traveling, Gym, Cricket, Meditation, Intellectual Talks

Experience

1. Senior Consultant

   Tata Consultancy Services

   Oct 2021 — Present · Bengaluru, IN

   Designing and developing the framework in gdpr space that will take care of GDPR compliance on various database technologies like Teradata, Oracle as well as on cloud platform like Snowflake and Singlestore (Memsql)Development of the snowflake procedure written in java script which will take care of business logic and rules as per the requirements.Analyzing and taking care of the performance impacts during the execution of these frameworks on high volumes tables.Working with Platform owners and Architects while creating the design of the application and review the approach for execution to achieve the Performamce effieciency.Identifying the bottlenecks and improvement areas in the framework and designing a solution for increasing the Operational efficiency of the processes.Migration of data and loading of tables from Teradata to snowflake.Creating data pipelines for migrating data from on prem system to cloud platform using Apache airflow.Creating pipeline to migrate data from snowflake to single store database using S3 stage.Designing and developing the framework in gdpr space that will take care of GDPR compliance on various database technologies like Teradata, Oracle as well as on cloud platform like Snowflake and Singlestore (Memsql) Development of the snowflake procedure which will take care of business logic and rules as per the requirements. Analyzing and taking care of the performance impacts during the execution of these frameworks on high volumes tables. Working with Platform owners and Architects while creating the design of the application and review the approach for execution to achieve the Performance efficiency. Identifying the bottlenecks and improvement areas in the framework and designing a solution for increasing the Operational efficiency of the processes. Migration of data and loading of tables from Teradata to snowflake. Creating data pipelines for migrating data from on prem system to cloud platform using Apache airflow.

Education

• Symbiosis Centre for Distance Learning

  Postgraduate Degree, International Business

• BANGALORE INSTITUTE OF TECHNOLOGY

  Bachelor of Technology (B.Tech.), Engineering degree in Instrumentation and engineering from BIT, Bangalore

  2008 — 2012

• Symbiosis Centre for Distance Learning

  Master of Business Administration

• Delhi Public School-Patna

  CBSE X BOARDS, ALL

  2000 — 2006

• D.a.v.hehal Ranchi

  CBSE XII BOARDS, PHYSICS,CHEMISTRY,MATHS,ECONOMICS

  2006 — 2008

• ST. MICHAEL HIGH SCHOOL,PATNA

  Secondary education degree, Secondary Education and Teaching

  1997 — 2000

• Symbiosis Institute of Management Studies

  Master of Business Administration - MBA, International Business

• Bangalore Institute of Technology

  Bachelor of Technology

Skills

• Teradata
• Oracle
• Requirements Analysis
• Microsoft Office
• Unix
• Java
• Databases
• Singing
• Data Warehousing
• Sql
• C
• Etl
• Db2
• Javascript
• Informatica
• C++
• Bteq
• Chess