Brillio
Brillio
Brillio is a technology consulting company helping organizations navigate digital transformation across healthcare, insurance, logistics, financial services, telecom and media, life sciences, and retail. Its work spans customer experience, data and AI, generative AI, product and platform engineering, and infrastructure, cloud, and security. Brillio combines engineering expertise with industry knowledge to develop digital products and modernize technology environments, helping businesses respond to changing market and technology demands.

Data Specialist - SAS/SQL ETL | Brillio Bangalore Hybrid

Join Brillio’s Bangalore-based data engineering team to build and support SAS and SQL ETL pipelines. The role covers data integration, quality validation, scheduled processing, and production issue resolution.

Description

  • Create and support SAS and SQL ETL workflows and data pipelines
  • Develop and refine SAS programs, macros, procedures, and stored processes
  • Source data from Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs
  • Clean, transform, validate, aggregate, and reconcile datasets
  • Write advanced SQL using joins, subqueries, views, and stored procedures
  • Develop and support batch-processing and scheduled ETL workflows
  • Map data sources and analyze source-to-target relationships against business needs
  • Establish data quality controls and investigate inconsistencies
  • Improve SAS and SQL performance, scalability, and execution efficiency
  • Conduct unit, integration, regression, and production validation testing
  • Track daily ETL processing and resolve job failures, data defects, and performance issues
  • Investigate production incidents and complete root-cause analyses
  • Keep technical documentation, data mappings, ETL specifications, and operating procedures current
  • Collaborate with Business Analysts, Data Analysts, Developers, QA teams, and business stakeholders
  • Contribute to Agile/Scrum activities including planning, refinement, stand-ups, reviews, and retrospectives

Requirements

  • Demonstrated experience as an ETL or SAS Engineer
  • Background designing, developing, testing, and maintaining SAS- and SQL-based data integration and ETL processes
  • Hands-on knowledge of SAS Base, SAS Macro, SAS SQL, and SAS Enterprise Guide
  • Experience retrieving data from Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs
  • Strong capability in data cleansing, transformation, validation, aggregation, and reconciliation
  • Proficiency with advanced SQL queries, joins, subqueries, views, and stored procedures
  • Experience building and managing batch-processing and scheduled ETL jobs
  • Experience performing data mapping and source-to-target analysis
  • Experience introducing data quality checks and resolving data discrepancies
  • Experience tuning SAS programs and SQL queries for performance and scalability
  • Experience carrying out unit, integration, regression, and production validation testing
  • Experience monitoring ETL jobs and resolving failures, data issues, and performance concerns
  • Experience investigating production incidents and conducting root-cause analysis
  • Experience maintaining technical documentation, data mappings, ETL specifications, and operating procedures
  • Ability to collaborate effectively with Business Analysts, Data Analysts, Developers, QA teams, and business stakeholders
  • Experience working within Agile/Scrum ceremonies

Related Jobs