SAS Integration Developer (+3 Years Experience)

Valleysoft is a premier technology solutions provider dedicated to enabling organizations to harness the power of data for business growth and operational excellence. We specialize in delivering cutting-edge integration and analytics solutions that drive informed decision-making.We are seeking a proficient SAS Integration Developer to join our talented team. In this role, you will be responsible for designing, developing, and implementing integration solutions that connect SAS platforms with various enterprise systems, ensuring seamless data flow and process automation.The ideal candidate will have strong experience in SAS technologies and integration frameworks, coupled with excellent problem-solving skills and the ability to collaborate effectively with cross-functional teams. If you are passionate about driving data-centric integration initiatives and working with advanced analytics tools, Valleysoft invites you to apply!RequirementsDesign, develop, and maintain SAS-based integration solutions that connect core banking systems, data warehouses, and analytical platforms across the enterpriseBuild and optimize SAS Data Integration Studio jobs covering extraction, transformation, and loading (ETL) from heterogeneous source systems including Oracle, SQL Server, IBM Db2, and flat-file feedsDevelop and manage SAS stored processes, macros, and reusable code libraries to support downstream BI, reporting, and analytical consumersTranslate business and functional requirements into technical SAS integration specifications, mapping documents, and data flow designsImplement and maintain data transformation logic for complex business rules, data cleansing, enrichment, and aggregation pipelinesCollaborate with data architects and data governance teams to ensure integration solutions comply with metadata standards, data lineage requirements, and classification policiesIntegrate SAS pipelines with enterprise scheduling platforms (Control-M or equivalent) to ensure reliable, sequenced, and monitored job executionPerform performance tuning of SAS jobs — optimizing I/O, reducing dataset passes, applying SAS options (COMPRESS, BUFSIZE, SASTRACE) and SQL passthrough where applicableParticipate in system integration testing (SIT), UAT, and production release cycles following change management proceduresMaintain comprehensive technical documentation for all integration flows, job dependencies, error handling procedures, and recovery runbooksSAS-Specific RequirementsStrong proficiency in SAS Base programming — data steps, PROC SQL, macro language, and array processingHands-on experience with SAS Data Integration Studio — designing and deploying jobs, managing transformations, and configuring metadata connectionsSolid knowledge of SAS metadata architecture: Metadata Server, libraries, SAS LIBNAME engines (Oracle, ODBC, DB2, HADOOP)Experience with SAS Management Console for user administration, metadata management, and server configurationProficiency in SAS/ACCESS interfaces for connecting to relational databases with implicit and explicit SQL passthroughExperience with SAS Viya (CAS data loading, SAS Studio flows, REST API integration) is a strong plusFamiliarity with SAS Web Services or REST-based integration patterns for connecting SAS with external applications is a plusUnderstanding of SAS stored process deployment on SAS 9.x mid-tier and Viya environmentsExperience with SAS/CONNECT for remote job submission and parallel processing across SAS grid environments is advantageousBanking Sector Requirements (Preferred)Prior experience developing SAS integration solutions within a bank or financial institution, preferably in data warehousing, regulatory reporting, or risk analytics domainsFamiliarity with banking source systems commonly integrated via SAS — core banking platforms, GL systems, loan origination systems, and card management systemsExperience building SAS pipelines for regulatory reporting datasets (CBE submissions, IFRS 9 staging, AML transaction feeds)Understanding of data reconciliation requirements in banking: balancing ETL outputs against source system totals and ledger figuresExperience operating within change control and ITIL-aligned release processes, including impact assessment documentation and rollback planningExposure to data security and masking requirements for sensitive banking data flowing through SAS integration layers is a strong plusBenefitsPrivate Health InsuranceTraining & Development