Data Specialist - R01571487

Brillio; Bengaluru; Sur place; INR 1 500 000 - 2 500 000; Plein temps

Résumé du poste

Lever, Inc. in Bengaluru seeks an experienced Data Specialist to design, develop, and maintain ETL pipelines using SAS and SQL. The role involves extracting data from Oracle, SQL Server, DB2, flat files, CSV, Excel, and APIs, then transforming and loading into data warehouses.

You will optimize SAS programs, build batch jobs, implement data quality checks, and work with cross-functional teams in an Agile environment to ensure reliable data availability.

Qualifications

• Experience designing, developing, testing, and maintaining ETL processes using SAS and SQL.
• Extract data from 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

Responsabilités

• Design, develop, and maintain ETL workflows and data pipelines using SAS and SQL.
• Create SAS programs, macros, procedures, and stored processes.
• Load data into data warehouses and downstream applications.
• Perform data cleansing, transformation, validation, and reconciliation.
• Develop complex SQL queries and stored procedures.
• Monitor and optimize batch ETL jobs for reliability and scalability.
• Collaborate with analysts, developers, QA, and stakeholders in Agile ceremonies.
• Document ETL specifications and data mappings.

Connaissances

ETL

SQL

SAS

Data Integration

Data Warehousing

Data Cleansing

Batch Processing

Agile/Scrum

Outils

SAS Base

SAS Macro

SAS SQL

SAS Enterprise Guide

Oracle

SQL Server

DB2

Excel

Description du poste

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