Data Warehouse Analyst
DMK Consultancy International, Pakistan
Experience
3 Years
Salary
Job Type
Job Shift
Job Category
Traveling
No
Career Level
Telecommute
No
Qualification
BS or BSSE or BCS or BCIT
Total Vacancies
1 Job
Posted on
Jan 30, 2015
Last Date
Feb 6, 2015
Location(s)
Job Description
- Able to work independently within specified time constraints
- Can handle/troubleshoot SQL Server
- Have knowledge of ETL process
- Optimizes complex query, index, and server functionality.
- Provide complex reports in MS Excel and able to troubleshoot and modify existing reports.
- Completes complex tasks utilizing Visual Management Studio including job, replication and SSIS package creation, modification and maintenance.
- Responsible for database administration, including backup and recovery procedures, maintenance and support.
- Completes production and development roll-outs of new schema/objects, DBs, tables, and table changes. Create and maintain appropriate documentation for databases, production support and end-users.
- Coordinate with software engineers for any data related issues.
Job Specification
- Should have 2 years of experience
- Candidates must be BS/BSSE/BCS/BCIT/ from reputable University.
- Must have strong SQL query writing skills in SQL Server.• Must have working experience in Query optimization, R&D Queries.
- SQL Server 2008 R2 (SSIS, SSAS, SSRS)
- MS Excel + VBA scripting
Staffing and Recruiting - Karachi, Pakistan