Search by job, company or skills

Data Engineer - DBT, Snowflake & SSIS

Early Applicant
  • Posted 10 days ago
  • Be among the first 20 applicants

Job Description

About Us

Kumaran Systems: Engineering Future-Ready Transformations Since 1992, Kumaran Systems has been helping enterprises bridge the past and the future, reimagining legacy systems and embracing AI-led possibilities. With over 34 years of delivery excellence, we specialise in re-engineering core applications, driving cloud transformation, and building automation-first, GenAI-enabled ecosystems across the Banking and Financial Services, Insurance, Telecom, and Automotive sectors. We help organisations not just upgrade their systems but reimagine what's possible.

Job Description

Key Responsibilities:

  • A strong understanding of common data integration challenges within the insurance industry, as well as the best-practice technical approaches & solutions available through data integration, data warehouse, and data lake technologies
  • Ability to lead by example, having worked as a technical build resource
  • Experience in how technology solutions can enable business transformation
  • Incorporate and implement ETL/ELT best practices within the group
  • Identify and recommend new ETL/ELT features/tools and design and develop the optimal solution to address business requirements
  • Responsible for the development and maintenance of CAESAR (i.e. EDW) ETL/ELT Processes
  • Translate functional requirements into technical specifications and solutions
  • Perform ad hoc analysis using SQL to extract data sets
  • Research innovative technologies and provide ideas for technological or workflow/process improvements
  • Identify opportunities to re-engineer existing solutions to utilize technology better, optimize performance, and simplify support
  • Analyze current processes to determine or update Key Performance Metrics

Requirements

Experience: 4 to 5 years

NP: Immediate to 15 days

Location : Chennai / Bangalore

Qualifications/Skills:

  • Experience with Snowflake, DBT - 1 to 2 years - Required
  • Experience with SSIS, SQL Server, SQL, relational database, etc. - 1 to 3 years - Required
  • Knowledge of the Property and casualty
  • Insurance industry is a plus
  • Ability to recognize past issue patterns and apply them to the existing problem-resolutionprocess
  • Self-motivated team player with the ability to work with and mentor junior resources across different regions.
  • Ability to work with other groups and lead the ETL solution
  • Excellent analytical, problem-solving, written, and oral communication skills
  • Experience with Azure - 0-2 years - good to have
  • Comfortable working with complex ETL solutions and large data sets
  • Organized with strong written and Verbal communication skills
  • Familiar with Jira, Confluence, and Agile Processes

Interested candidates, please share your updated resume via email [Confidential Information]

About Company

Job ID: 151286099

Similar Jobs

Chennai, India

Skills:

snowflake SqlData ModelingPerformance TuningdbtGit version controlOptimizationELT pipelines

Remote

Skills:

GitSqlAwsdbt