We are looking for a talented C# developer with advanced SQL Server knowledge to build a connector to the Sage CRE 2017 SQL Server system and download data for nine (9) metrics that will be used to feed into a Power BI report.
The work is expected to take one week to complete, upon approval, and a bonus amount of 10% will be awarded for delivering one day earlier or better.
The successful candidate should be able to demonstrate recent experience extracting data from Sage CRE 2017 and proficiency with C# and SQL Server.
The developer must possess the following qualifications:
Demonstrated experience with SQL Server RDBMS
Advanced T-SQL knowledge and ability to structure queries
Experience with C#, .net Core, and Entity Framework Core 2.2
Experience extracting data from Sage CRE 2017 SQL Server and advanced working knowledge of its schema
The performance review is provided on a 5-star basis with the stars assigned as follows:
3 stars for delivering the working project on or before the deadline
1 star for the quality of the source code and following the delivery criteria and other specifications
1 star for proper consideration of unit tests and full code coverage including forced error testing
Note: The timeline is of exceptional importance to us and our clients. We may never, under any circumstances, request more time for a small project such as this unless the scope of the project changes.
This work must be completed by the 21st of June, 2019.
The budget for this work is $50 CAD per hour, up to a maximum of $2,000 CAD. The project is not to exceed the maximum budget, and the developer guarantees with confidence that this can be accomplished.
The client requires a Sage CRE 2017 data connector written in C# which is capable, upon being executed, of pulling data from the Sage system, transforming it into the needed output formats, and saving it in SQL Server.
Design SQL schema needed to store data for Power BI reporting
Connect to Sage SQL Server
Write queries to pull data into a row-based ledger with time stamps to track synchronization status
Write queries to pull data from ledger data store into a star schema for reporting purposes
Proposed design (ERD) of Sage data store (star schema)
Proposed design (ERD) of Sage synchronization ledger table
Product source code
C# .net Core 2.2 library project “[login to view URL]”
C# X-Unit test project “[login to view URL]”
C# SQL Server project “[login to view URL]”
Minimum two unit tests for each public method in the connector library, one for successful pass and one for each potential failure condition
Developer will be provided with connectivity to git
Client will be available to answer questions as needed throughout the project with a minimum response time of same-day response
Project will be built using (or compatible with) Visual Studio 2019
The developer is not required to build dimension tables for time unit, this will be done at the Power BI reporting layer
The code must operate in a stateless manner
Concurrent processes of the same code can operate independently of each other
Process is capable of being interrupted and resume work where it left off
Process does not require downloading data that has already been downloaded
The developer is expected to provide answers to the following question upon project completion
What is the optimal way to configure the star schema for Power BI query performance?
What is the fastest way to reliably extract data from Sage 2017 CRE?
How can we design the synchronization ledger to allow for
Multiple concurrent processes in parallel without overwriting any data
Fault tolerance by resuming the synchronization if interrupted
Fault tolerance by avoiding any half-written records if interrupted
31 freelancers are bidding on average $2283 for this job
Hello, I saw all details properly and i have very confident i can Build a Connector to the Sage CRE 2017 SQL Server system. i am really very interested to get start. just knock me via chat. Thanks Rashedul