*Hi,*
*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 (rank in order of Importance):
*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*
Thanks and Regards,
*IT INTELLECTS*
*[image: cid:[email protected]]*
1125 Victoria Blake Ln Belmont, NC 28012 - 6529
USA
*Brad Hunt*
*Work: **828 202 6177*
*Fax: **732 359 1525*
*[email protected] <[email protected]> |
**www.itintellects.com*<http://www.itintellects.com/>
--
You received this message because you are subscribed to the Google Groups "it
req" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/it-req.
For more options, visit https://groups.google.com/groups/opt_out.
