Description

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

Key Skills

Education

Bachelor's degree