*BI ETL Developer - Direct Client * *Immediate Interview and Start ASAP!!!*
*Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * Job title: BI ETL Developer Location: Columbia, SC Duration: 12 Months Direct Client Position SCOPE OF THE PROJECT: ONGOING PROJECT TO DELIVER AN END TO END BUSINESS INTELLIGENCE SOLUTIONS CONTAINING DASHBOARDS AND REPORTS. 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 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 • 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. Database Platforms SQL Server Yes 1 Expert Currently Using 2 - 4 Years Database Platforms SQL Server Analysis Services ( SSAS) Yes 1 Expert Currently Using 2 - 4 Years Database Platforms SQL Server Integration Services (SSIS) Yes 1 Expert Currently Using 2 - 4 Years Database Platforms SQL Server Reporting Services (SSRS) Yes 1 Expert Currently Using 2 - 4 Years Database Platforms SQL Tuning Yes 1 Expert Currently Using 2 - 4 Years Miscellaneous Dashboards and Reports Yes 1 Miscellaneous ETL Process and Development Yes 1 Miscellaneous KPI's - Key Performance Indicators Yes 1 Miscellaneous Multidimensional Expressions (MDX) queries Yes 1 Miscellaneous Slowly Changing Dimensions (SDC) Yes 1 Specialties OLAP Yes 1 Expert Currently Using 2 - 4 Years Specialties Reporting/OLAP/DW Yes *Please send resume to s...@cncconsulting.com <s...@cncconsulting.com> * Thanks, Sam CNC Consulting, Inc. 201-546-3096 s...@cncconsulting.com -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/groups/opt_out.