SAS Developer-- AKHDC5246435

Senior SAS Developer- W2 Fully Onsite at Pisttsburgh, PA Long Term Contract W2 Applicable We are seeking a skilled SAS Programmer / Data Analyst to support the migration and manipulation of Oracle data through explicit and implicit SQL pass-throughs, create SAS macros for data validation, and generate reports according to business requirements. The ideal candidate will have experience in ETL processes, creating data quality reports, and benchmarking SAS systems, particularly around SAS exports. This role will also involve creating and documenting test cases for SAS programs and ensuring efficient data handling within the system. Key Responsibilities: SQL & Data Manipulation: Write implicit and explicit SQL pass-through queries to access and manipulate Oracle data. Involved in the migration of data from one system to another, ensuring data integrity and validating migration success. SAS Programming & Macros: Create SAS macros to check variable values across multiple Oracle datasets. Develop ETL processes to create SQL statements and export data in the form of text files for business users. Reporting & Data Quality: Generate reports based on business requirements, with a particular focus on the data quality of records. Provide insights into data quality and completeness, making recommendations for improvements where necessary. Testing & Documentation: Document SAS programs and write test cases to validate functionality. Ensure the integrity of programs by performing rigorous testing and validation. System Benchmarking: Benchmark the current SAS system, particularly focusing on SAS exports to understand and troubleshoot issues related to hardware limitations and when programs may fail. Required Qualifications: Experience: • Proven experience with SAS programming, including the use of SAS macros and SQL pass-through for data manipulation. • Hands-on experience with Oracle databases and data migration processes. • Strong background in ETL development and creating reports that focus on data quality. Skills: • Proficiency in SQL, particularly with Oracle databases. • Experience writing test cases and creating detailed documentation for SAS programs. • Strong problem-solving skills, particularly in benchmarking and optimizing SAS exports. Technical Knowledge: • Strong knowledge of data validation techniques, especially when working with large datasets. • Understanding of system performance, with a focus on hardware limitations and how they impact SAS performance. Preferred Qualifications: • Familiarity with other data manipulation and reporting tools such as Python or R. • Experience in data migration projects within large enterprise systems. Certifications: Preferred: SAS certifications (e.g., SAS Base Programming). Relevant certifications in data management, ETL, or database management.