Hi,
Please find the job description below.
Please send resumes to:
Locations: Columbia, SC
Duration: 12 + Months
Interview: Telephonic & Skype
Description:
Daily Duties / Responsibilities:
Candidate will be responsible for creating, designing and developing the process to extract and transform data from OLTP data source and load aggregated data into OLAP environment. The ETL process should utilize the Microsoft stack of BI tools (SQL Server, SSIS, SSAS, SSRS), the candidate will be responsible to:
- Design and implement ETL processes for data transactions related to Enterprise Data Warehouse and other data structures to support our Business Intelligence operations.
- Analyze requirements and existing resources to create efficient database and ETL designs to support system to system data integration.
- Work with project and business analyst leads in order to develop and clarify in-depth technical requirements including logical and physical data modeling activities.
Required Skills :
Technical Skills
- ETL Process and Development
- Slowly Changing Dimensions (SDC) Types 1, 2, and 3.
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 Methodologies
- Error and Data anomaly handling
- MDX Queries
- Report and Dashboard creation
- KPIs.
Tool-Set Skills
- SSAS skills
- SSIS skills
- SSRS skills
- TSQL skills
- SQL Server (Stored Procedures, Jobs, Performance Tuning)
Candidate must be able to communicate clearly with the development team, Project staff, and the user community.
Preferred Skills (rank in order of Importance):
Intimate knowledge of CAPSS and LCMS database design.
Strong Project skills
Self Starter
Minimal Management required
Please fill the below details for quick process:
Complete Legal Name |
|
Current Location (full address if possible) |
|
Best number to call |
|
Email ID |
|
Visa Status with validity |
|
Notice Period / Time Needed to Start |
|
Skype Id (This is taken if in case aren't available for in-person interview) |
|
Two professional references with name, email, and contact number( from Current Projects) |
|
End date of the current project |
|
Educational details(Degree, Year of passing and University) |
|
Total IT Exp? |
|
United States Experience? |
|
LinkedIn id? |
|
Communication skills (1-10, 10 being the highest)? |
|
Relocation(Yes or No) |
|
Last Four digits of SSN: |
|
Date of Birth(Date & Month): |
|
| Raj Sekhar Work: 828-202-6183 Fax: 732 359 1525 |
--
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