Data Specialist - R01571487

India·BangaloreEmployeemid

OtherData Specialist

2 views0 saves0 applied

Apply Now

Quick Summary

Overview

Data Specialist 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.

Technical Tools

OtherData Specialist

Data Specialist

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.