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.
Required
Software Requirements
- 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.
- Experience using Control-M to schedule, monitor, troubleshoot, and manage ETL jobs.
- Experience with data warehousing, ETL best practices, data integration, data validation, and data quality activities.
- Demonstrated ability to analyze business requirements and translate them into technical data solutions.
- Experience troubleshooting ETL and database issues and supporting reliable data delivery.
- Experience collaborating with cross-functional teams, including business, development, testing, data, and support teams.
- Experience in enterprise-scale data integration and analytics projects is preferred.
- Candidates may qualify through equivalent professional experience in SAS development, ETL engineering, database development, or data integration roles where they can demonstrate comparable technical outcomes.
Day-to-Day Activities
- Develop and maintain SAS ETL workflows, write and optimize Oracle SQL and stored procedures, and validate data against source-to-target requirements.
- Schedule and monitor ETL jobs in Control-M, investigate failures, perform troubleshooting, and coordinate resolution of data or processing issues.
- Participate in requirements discussions, technical reviews, testing activities, status meetings, and collaboration with cross-functional delivery teams.
- Prepare technical documentation, data mappings, validation results, support records, and implementation deliverables while making technical decisions within approved standards.
Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Management, or a related field; equivalent relevant professional experience may be considered.
- 4–6 years of professional experience in SAS ETL and Oracle Database development, with demonstrated enterprise data integration experience.
- Relevant training in SAS ETL, Oracle Database, SQL, data warehousing, Control-M, data quality, and production support practices is preferred.
- Certifications in SAS, Oracle Database, data engineering, data management, or related technologies are preferred but not required.
- Commitment to continuous professional development through relevant technical training, product updates, data engineering practices, and evolving delivery standards.
Professional Competencies
- Apply critical thinking and structured problem-solving to analyze requirements, investigate data issues, troubleshoot ETL failures, and identify root causes.
- Collaborate effectively with business stakeholders, data teams, developers, testers, support teams, and other delivery participants.
- Communicate technical findings, data quality results, risks, dependencies, progress, and resolution plans clearly and accurately.
- Adapt to changing business requirements, data structures, ETL processes, technology environments, and delivery priorities.
- Identify opportunities to improve ETL performance, data quality, automation, reusability, maintainability, and efficient use of processing resources.
- Manage time and priorities across requirements analysis, development, validation, job monitoring, troubleshooting, documentation, and delivery commitments.
S YNECHRON’S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.
Candidate Application Notice