Employee No: EMP142

Experience: 3 Years 9 Months

Job Description:

• Hands on experience in SAS programming for importing and exporting huge data sets from Flat files, Excel spreadsheets and external RDBMS (ORACLE) tables., Experience in performing Adhoc queries for various application and reports on a daily/weekly or monthly basis, Experience in working with SAS ENTERPRISE GUIDE SOFTWARE for reporting and analytical tasks., 
• Generating SAS EG stored processes with static and dynamic prompts for product-specific analyses., Modifying existing codes for improvement in the performance Advanced Querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets., Experience in developing different methods of Extraction, Transformation and Loading (ETL) into data warehouse
• Good experience in SAS Data Integration for development of SAS DI Jobs used different transformations like Append, Extract, Table Loader, Lookup, Data Validation, SQL, Surrogate Key Generator, SCD Type 2, Splitter and User-written Transformations
• Experience in LSF Scheduler, Creating Flows in SAS Management Console and monitoring in Process manager
• Experience in Scheduling Jobs through LSF and Cron-tab and Control-M and troubleshoot job failures
•  Strong experience in Data Validation, Data Quality and Error handling., Strong experience in Performance tuning and Optimization of the ETL jobs to meet the SLA., 

Salary: 3800 monthly

Industry: Information Technology

Certificates Holding: Not Specified

---