Principal Consultant – BI /DI■

• The candidate should be well aware of the domain she /he has worked in for a project
• Basic SAS administration knowledge (Creating library, Reports authorization
• Should have in-depth knowledge of DW/BI concepts, Dimensional Modeling
• Experience in using SAS Data Integration Studio to extract, transform, and load source data into SAS or major DBMS environments from multiple sources including major DBMS and application system transaction files.
• Expertise in Creating Drill Down or OLAP-based complex reports
• Should be conversant with Job Scheduling using Windows Scheduler or LSF
• Creating ETLs using DI Studio, having good knowledge of transformation like Extract, SQL Join, Splitter, Lookup, Table Loader, and SCD Type Techniques.
• Deploying Jobs & Scheduling In SMC.
• Creating Backup using SPK’s
• Hands-on experience on Base SAS, Macros, Enterprise Guide, OLAP Cube Studio
• Experience in Unix Operating Systems and Scheduling tools like LSF and Cron-tab
• Knowledge Of creating users, assigning roles/rights to users
• Strong experience in Data Validation or Data Quality and Error handling
• Base SAS, Advance SAS Programmer, SAS Macros, SAS/Access, SQL, and optimization techniques
• SAS DI/ BI Developer
• SAS Visual Analytics

Desired profile of the candidate

• Hands-on experience in Base SAS, Advance SAS Programmer, SAS Macros, SAS/Access, SQL, and optimization techniques
• SAS DI/ BI Developer