Hi,
I have an urgent requirement on System Software Programmer-SQL,
Please send me your consultant profiles with contact details to Ashok.ch@infolob.com
Title : System Software Programmer-SQL
Duration : 12 Months
Location : Columbia, SC
Job description:
SCOPE OF THE PROJECT:
Ongoing project to deliver an end to end business intelligence solution containing dashboards and reports.
JOB DESCRIPTION:
Candidate will be responsible for creating, designing and developing logical and systematic layers used for end user dashboards, reports, KPI's and analytics.
Utilizing the Microsoft stack of BI tools (SQL Server, SSIS, SSAS, SSRS),
The candidate will be responsible to:
Ø Participate and at times lead in the gathering and documenting of data and analytical requirements.
Ø Design a logical blueprint for data design, extraction process, transformation methods, and presentation layout.
Ø Provide time and effort estimates for components of the BI solution.
Ø Develop logical and physical data model for data marts.
Ø Design data warehouses and create data cubes.
Ø Develop and promote data management methodologies and standards.
REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
Technical Skills:
· SQL Server, SSIS, SSAS, SSRS
· Best practice and standards for Business Intelligence (BI) On Line Analytical Processing (OLAP).
· (Multidimensional - MOLAP, Relational - ROLAP, and Hybrid - HOLAP)
· OLAP data model
· Tabular Data Models
· Dimensional Data Models (star and snowflake)
· Data Warehouse Skills
· Data Cleansing
· ETL Process
· Slowly Changing Dimensions (SDC) Types 1,2, and 3. i.e. data that changes over time.
· SDC Type 1 - Over write data changes
· SDC Type 2 - Add a row for data changes
· SDC Type 3 - Add a column for data changes
· Staging and Aggregating Data
· Error and Data anomaly handling
· Multidimensional Expressions (MDX) queries
· Key Risk Indicators (KRIs)
· Key Performance Indicators (KPIs)
· Tool-Set Skills
· SSAS
· SSIS
· SSRS
· Power Pivot
· Performance Point
· TSQL
· SQL Server (Performance Tuning)
· PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
· INTIMATE KNOWLEDGE OF CAPSS AND LCMS DATABASE DESIGN.
· STRONG PROJECT SKILLS
· SELF STARTER
· MINIMAL MANAGEMENT REQUIRED
--
Thanks & Regards,Ashok CH |
Infolob Solutions Inc.|
|Office: 972-535-5559 Ext 107 |Fax: 888-228-4125 Email: ashok.ch@infolob.com |www.infolob.com |
A MBE COMPANY | ORACLE PLATINUM PARTNER COMPANY
--
The Most Active and Happening #1 ERP/SAP Jobs Listserve for SAP Jobs in the US.
LIKE our Facebook page : https://www.facebook.com/ERPJobs
https://groups.google.com/group/sapjobs-usa
Follow us on Twitter:
https://twitter.com/sapjobsusa
Post your Jobs at SAP JOBS USA Linkedin Group by clicking this link
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
Join our Professionals Networks in Linkedin
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
https://www.linkedin.com/groups/Global-Network-SAP-Professionals-4081179/about
https://www.linkedin.com/groups/Network-SAP-Professionals-3874920/about
http://finance.groups.yahoo.com/group/SAPJobs-USA/
https://www.facebook.com/groups/mysapfico/
---
You received this message because you are subscribed to the Google Groups "SAP JOBS USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to SAPjobs-USA+unsubscribe@googlegroups.com.
To post to this group, send email to SAPjobs-USA@googlegroups.com.
Visit this group at http://groups.google.com/group/SAPjobs-USA.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment