Direct Client :: Skype Hire
Location: Columbia, SC
Duration: 24+ months
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
. Work with project and business analyst leads in order to
develop and clarify in-depth technical requirements including logical and
physical data modeling activities.
. ETL Process and Development
o 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
o Staging and Aggregating Data Methodologies
o Error and Data anomaly handling
. MDX Queries
. Report and Dashboard creation
. SSAS skills
. SSIS skills
. SSRS skills
. TSQL skills
. SQL Server (Stored Procedures, Jobs, Performance Tuning)
Software People Inc.
Certification: SBA 8a/SDB, NJ MWBE, NY MWBE, VA SWaM, DE OMWBE, MA MWBE.
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to email@example.com.
Visit this group at http://groups.google.com/group/reqsresumes.
For more options, visit https://groups.google.com/groups/opt_out.