Data Engineer – SAS ETL, Oracle Database, SQL & Control-M

Job Summary

Synechron is seeking a Data Engineer – SAS ETL – LPA with 4–6 years of relevant experience in SAS ETL and Oracle Database development. The role will focus on designing, developing, enhancing, and supporting enterprise-scale data integration and ETL solutions. The successful candidate will use SAS, Oracle Database, SQL, and Control-M to deliver reliable data processes, support data quality, troubleshoot issues, and contribute to analytics and data delivery objectives.

Software Requirements

Required

-

SAS ETL: Hands-on experience developing, enhancing, maintaining, and supporting ETL processes using SAS.

-
Oracle Database: Mandatory hands-on experience with Oracle Database, including queries, stored procedures, data models, data validation, and performance tuning.

-
SQL: Strong experience writing and optimizing SQL queries for data extraction, transformation, validation, reconciliation, and analysis.

-
Control-M: Experience scheduling, monitoring, managing, and troubleshooting ETL jobs.

-
Data Warehousing Tools and Processes: Experience with data warehouse structures, ETL workflows, data integration, and data delivery practices.

-
Development and Support Tools: Experience using tools for technical documentation, issue tracking, job monitoring, and production support.

Preferred

-
Exposure to additional enterprise data integration, scheduling, or data quality tools.

-
Experience supporting analytics-focused data projects and large-scale data processing environments.

-
Familiarity with performance monitoring and optimization tools for SAS and Oracle environments.

-
Exposure to automated testing, deployment, or release management tools used in data engineering delivery.

Overall Responsibilities

-
Develop, enhance, maintain, and support ETL processes using SAS to meet approved business and technical requirements.

-
Design, develop, and optimize Oracle Database queries, stored procedures, data models, and related data processing components.

-
Analyze business requirements and translate them into scalable, maintainable, and technically accurate data integration solutions.

-
Perform data validation, reconciliation, troubleshooting, root-cause analysis, and performance tuning across ETL and database processes.

-
Schedule, monitor, and troubleshoot ETL jobs using Control-M to support reliable and timely data delivery.

-
Collaborate with business analysts, data teams, application teams, testing teams, and other stakeholders to clarify requirements and resolve delivery issues.

-
Apply data warehousing and ETL best practices to support data accuracy, completeness, consistency, maintainability, and operational stability.

-
Investigate production issues, document findings, coordinate resolutions, and support post-implementation validation.

-
Create and maintain technical documentation, data mappings, process specifications, job schedules, support procedures, and operational records.

-
Contribute to continuous improvement by reducing manual processing, improving job efficiency, reusing ETL components, and optimizing resource usage where applicable.

-
Deliver reliable data integration solutions that support enterprise-scale data delivery and analytics objectives.

Technical Skills (By Category)

Programming Languages

Essential

-
SAS programming for ETL development, data transformation, data validation, and processing.

-
Strong SQL skills for complex queries, joins, subqueries, aggregations, stored procedures, reconciliation, and data analysis.

-
Ability to interpret business rules and implement them through SAS ETL processes and Oracle Database components.

Preferred

-
Exposure to scripting or programming languages used for job monitoring, automation, data validation, or operational support.

-
Experience developing reusable utilities for ETL testing, reporting, or process monitoring.

Databases and Data Management

Essential

-
Mandatory hands-on experience with Oracle Database.

-
Experience designing and optimizing Oracle queries, stored procedures, data models, and data processing logic.

-
Understanding of data warehousing concepts, ETL architecture, staging processes, data marts, and target data structures.

-
Experience performing data validation, reconciliation, completeness checks, consistency checks, and data quality analysis.

-
Ability to analyze data lineage, source-to-target mappings, transformation rules, and downstream data dependencies.

-
Experience troubleshooting database and ETL performance issues.

Preferred

-
Exposure to additional relational databases or enterprise data platforms.

-
Experience with data profiling, metadata, data governance, data quality controls, or data lineage tools.

-
Experience supporting large-volume data processing and analytics environments.

Cloud Technologies

Essential

-
Ability to support ETL and database processes in the environments used by the assigned project.

-
Understanding of data integration, job scheduling, monitoring, and data delivery across enterprise environments.

Preferred

-
Exposure to cloud-based data platforms, databases, data warehouses, or ETL services.

-
Experience supporting hybrid data environments or cloud migration initiatives.

Frameworks and Libraries

Essential

-
SAS ETL development and processing capabilities.

-
Control-M job scheduling and monitoring capabilities.

-
Understanding of ETL design patterns, data transformation methods, error handling, restartability, dependency management, and batch processing.

-
Ability to develop maintainable and reusable ETL workflows.

Preferred

-
Exposure to data quality, testing, automation, or deployment frameworks used in enterprise data environments.

-
Familiarity with reusable ETL frameworks, job control standards, or process automation utilities.

Development Tools and Methodologies

Essential

-
4–6 years of relevant experience in SAS ETL and Oracle development.

-
Experience with requirements analysis, technical design, development, testing, deployment, monitoring, troubleshooting, and production support.

-
Experience scheduling and monitoring ETL jobs through Control-M.

-
Understanding of structured software development life cycle and ETL delivery practices.

-
Experience creating technical documentation, data mappings, job specifications, support procedures, and implementation records.

-
Ability to collaborate with cross-functional teams to deliver accurate and timely data solutions.

Preferred

-
Experience working in Agile, Scrum, or comparable iterative delivery environments.

-
Exposure to version control, release management, automated testing, continuous integration, or deployment practices.

-
Experience participating in code reviews, technical walkthroughs, sprint planning, defect resolution, and continuous improvement activities.

Security Protocols

Essential

-
Understanding of secure handling of enterprise data during ETL processing, database development, testing, and support.

-
Ability to follow access-control, data privacy, confidentiality, audit, and environment-specific data handling requirements.

-
Awareness of secure database access, credential management, logging, and controlled use of production and non-production data.

-
Ability to comply with Synechron’s applicable security, data governance, and operational standards.

Preferred

-
Experience supporting data solutions in regulated or controlled environments.

-
Exposure to data masking, encryption, role-based access, audit logging, and security validation practices.

Experience Requirements

-

4–6 years of relevant professional experience in SAS ETL and Oracle Database development.

-
Strong hands-on experience developing, enhancing, maintaining, and supporting SAS ETL processes.

-
Mandatory practical experience with Oracle Database, including SQL development, stored procedures, data models, validation, and performance tuning.

-
Exp