Data Specialist - R01571487

Brillio; Bengaluru; Presencial; INR 1.200.000 - 1.600.000; A tiempo parcial

Descripción de la vacante

Brillio is seeking a Data Specialist to design, develop, test, and maintain ETL processes using SAS and SQL. You will extract data from multiple sources, transform and validate it, and load into data warehouses and downstream applications.

The role involves building SAS programs, managing batch ETL jobs, performing data quality checks, and collaborating with analysts and developers in an Agile environment.

Formación

• Experience designing, developing, testing ETL processes using SAS and SQL.
• Experience with data extraction from Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs.
• Ability to perform data cleansing, transformation, validation, and reconciliation.
• Develop complex SQL queries, joins, subqueries, views and stored procedures.
• Experience with SAS Base, SAS Macro, SAS SQL, and SAS Enterprise Guide.

Responsabilidades

• Develop and maintain ETL workflows and data pipelines using SAS and SQL.
• Design, develop, and optimize SAS programs, macros, procedures, and stored processes.
• Extract data from Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs.
• Perform data cleansing, transformation, validation, aggregation, and reconciliation.
• Develop complex SQL queries, joins, subqueries, views, and stored procedures.
• Work with SAS Base, SAS Macro, SAS SQL, and SAS Enterprise Guide.
• Build and maintain batch processing and scheduled ETL jobs.
• Perform data mapping and source-to-target analysis based on requirements.
• Implement data quality checks and investigate data discrepancies.
• Optimize SAS programs and SQL queries for performance and scalability.
• Perform unit/integration/regression testing and production validation.
• Monitor daily ETL jobs and troubleshoot failures and data issues.
• Analyze production incidents and perform RCA.
• Maintain technical documentation and ETL specifications.
• Collaborate with BAs, Data Analysts, Developers, QA, and stakeholders.
• Participate in Agile/Scrum ceremonies and sprint activities.

Conocimientos

ETL

SAS

SQL

Data Warehousing

Batch processing

Data quality checks

Performance optimization

Herramientas

SAS Base

SAS Macro

SAS SQL

SAS Enterprise Guide

Oracle

SQL Server

DB2

APIs

Excel

Descripción del empleo

Data Specialist
Job requirements
Role Summary We are looking for an experienced ETL/SAS Engineer responsible for designing, developing, testing, and maintaining data integration and ETL processes using SAS and SQL. The role involves extracting data from multiple sources, transforming and validating the data, and loading it into data warehouses and downstream applications.

Key Responsibilities

• Develop and maintain ETL workflows and data pipelines using SAS and SQL.


• Design, develop, and optimize SAS programs, SAS macros, SAS procedures, and stored processes.


• Extract data from various sources including Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs.


• Perform data cleansing, transformation, validation, aggregation, and reconciliation.


• Develop complex SQL queries, joins, subqueries, views, and stored procedures.


• Work with SAS Base, SAS Macro, SAS SQL, and SAS Enterprise Guide.


• Build and maintain batch processing and scheduled ETL jobs.


• Perform data mapping and source-to-target analysis based on business requirements.


• Implement data quality checks and investigate data discrepancies.


• Optimize SAS programs and SQL queries for performance and scalability.


• Perform unit testing, integration testing, regression testing, and production validation.


• Monitor daily ETL jobs and troubleshoot job failures, data issues, and performance problems.


• Analyze production incidents and perform root-cause analysis (RCA).


• Maintain technical documentation, data mapping documents, ETL specifications, and operational procedures.


• Work closely with Business Analysts, Data Analysts, Developers, QA teams, and business stakeholders.


• Participate in Agile/Scrum ceremonies, sprint planning, backlog refinement, daily stand-ups, reviews, and retrospectives