People Matter

Technical Architect - ETL

Ayasdi

Ayasdi

IT
Bengaluru, Karnataka, India · India
Posted 6+ months ago
Introduction

At SymphonyAI, we are building the leading AI SaaS company for enterprise transformation across the most critical industry sectors. We provide focused AI applications designed to rapidly solve challenging business problems and deliver breakthrough insights, increasing operational efficiencies and growing revenue for customers.


Job Description

SymphonyAI is at the forefront of innovation leveraging cutting-edge artificial intelligence and machine learning technologies to transform industries and drive business growth. As a global leader in AI-powered solutions, we empower organizations to harness the full potential of data-driven insights. SymphonyAI enterprise applications rapidly deliver transformative business value across retail, CPG, financial services, manufacturing, media, IT, and enterprise operations, and the public sector. SymphonyAI combines unrivaled AI technology, vertical expertise, and industry-specific data and insights into applications that drive the highest value for customers. We are one of the largest and fastest growing AI portfolios. We are on a mission to build a “World Class Engineering Team” with a high-performance culture. Over 3000 talented leaders, data scientists, and other professionals incubate and build SymphonyAI Group solutions.

Join our dynamic team and play a pivotal role in shaping the future of AI technology.

Key Responsibilities:

  • Lead the design and architecture of data warehouse (DWH) solutions within the retail domain.
  • Ensure data integrity between DWH and Business Intelligence (BI) tools.
  • Monitor, maintain, and troubleshoot auto-refresh processes of DWH & BI tools, systems, and software.
  • Maintain the structure of DWH tables and layout.
  • Translate complex business needs into technical ETL solutions.
  • Perform performance tuning, including collecting statistics, analyzing explain plans, and determining necessary table statistics.
  • Resolve incidents and investigate problems to ensure maximum uptime and functionality as per agreed SLA and business needs.
  • Manage version control and branching strategies (git/DevOps).
  • Communicate effectively with both onshore teams and internal stakeholders.

Skills & Experience

Essential:

  • 7-10 years of experience, with 4-5 years in the retail domain.
  • Understanding of Massive Parallel Processing (MPP) Databases (Yellowbrick or Teradata).
  • Ability to understand and write advanced SQL queries and Unix scripts.
  • Experience managing data integrity between DWH and BI.
  • Proficiency in monitoring, maintaining, and troubleshooting DWH & BI tools.
  • Ability to maintain the structure of DWH tables and layout.
  • Competence in translating complicated business needs into technical ETL solutions.
  • Performance tuning experience, including collecting statistics and analyzing explains.
  • Incident resolution and problem investigation skills to ensure SLA compliance.
  • Understanding of version control and branching strategies (git/DevOps).
  • Good communication skills (both written and verbal).

Desirable:

  • Experience with Azure Data Warehouse (DW), Databricks, and Data Factory.
  • Data modeling expertise.
  • Proficiency in Python scripting.
  • Familiarity with Talend ETL tool.
  • Comprehensive understanding of overall architecture, not limited to development.
  • Knowledge of Microsoft SQL Server, JIRA, CRM.
  • Experience working with onshore teams.

About Us

SymphonyAI is an enterprise AI company transforming the world's largest industries with packaged AI applications. SymphonyAi is at the forefront of innovation, leveraging cutting-edge artificial intelligence and machine learning technologies to transform industries and drive business growth. As a global leader in AI-powered solutions, we empower organizations to harness the full potential of data-driven insights. SymphonyAi enterprise applications rapidly deliver transformative business value across retail, CPG, financial services, manufacturing, media, IT and enterprise operations, and the public sector.

We are on a mission to build a “World Class Engineering Team” with a high-performance culture. Over 3000 talented leaders, data scientists, and other professionals incubate and build SymphonyAI Group solutions.