Data Specialist - R01571487
Brillio · Bangalore, Karnataka, India 🇮🇳
Job requirements
- 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
Posted 22 Sept 2026 (22 Sept 2026) · Source: Brillio via Lever