Minimum 3+ years of Hands-on programming experience in SAS.
Minimum 3+ years of working experience into Python development.
Must have strong SAS Programming skills and be able to understand business requirement Build and modify SAS codes, macros & logics.
Must have experience in managing very large amounts of data from multiple data sources.
Must be proficient in writing ,testing and validating SAS Codes/macros in order to construct & aggregate analysis datasets.
Hands-on experience in connecting different data bases and able to extract data from flat files, SaS7bdat, JSON, CSV, Excel.
Must have hands on experiecne into SQL topics like Stored Procedures vs Functions (when to use each), Dense Rank, Rank, Window functions, Partitioning, Duplicate removals, Indexing (Difference between Clustered and Non Clustered), Transactional queries, CTE, Aggregations, Correlated subqueries, Normalization Denormalization, Null and Outliers handling
Good to have
Banking experience and experience in Credit Risk will be considered as an advantage.
Transform the collected data to a structured sas7bdat format for further reporting tasks.
Good experience in Understanding the business logic/definition for key variables and be able to prepare STM files in the migration process.
