Mandatory skills: SAS E.G, VBA, SQL, IBM Netezza, Aginity , Microsoft Office, Tableau
Preferred skills: SAS E.G, VBA, SQL, IBM Netezza, Aginity , Microsoft Office, Tableau
Detailed Job Description:
• Candidate must have minimum 5-10 years of experience with SAS, SQL, Tableau
• He / She must have excellent working knowledge on SAS Macros and SAS procedures
• Should have familiarity with Oracle / DB2 and Host files
• Must be able to rewrite SAS codes to fine-tune and automate various SAS processes.
• Strong communication skills and ability to work in groups as well as independently.
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Experience in creating SAS programs and performed data validation on raw data sets and created data set for analysis.
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Experience in creating test scenarios to find errors and confirm programs meet specifications.
• Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules.
• Capable of utilizing data management techniques like Merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step.
• Performed PROC SQL joins and worked with PROC SQL set operators to combine tables horizontally and vertically.
• Experience in using various MS office tools for analyzing, arranging, and presenting data.
• Responsible for accessing and managing data and for performing complex queries and analysis.
• Producing data in various output formats including HTML, RTF, PDF, MS-EXCEL using ODS (output Delivery System).
• Proven ability to support multiple projects under deadlines often with competing priorities and complexities.
• SAS Certification is desirable
• Experience in Banking and Insurance industry