Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Worked on the Reports module of the project as a developer on MS SQL Server(using SSRS, T-SQL, scripts, stored procedures, and views).
- Created reports from OLAP, sub reports, bar charts, and matrix reports using SSRS Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and XML format data) to SQL Server.
- Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
- Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed an action in XML.
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
- Created cubes and defined the dimensions and responsible for defining calculated members
- Troubleshooting performance issues and fine-tuning queries and stored procedures.
- Wrote stored procedures to get the fields required for the reports.
Job Requirements
Education
- Computer Engineering, Computer Science, or equivalent
- Arabic Speaker is mandatory.
Technical Tools
- Power BI
- SSIS
- SSAS