Integration Analyst / Trouble-shooter / Programmer
Requires excellent analytical skills to be applied to monitoring / trouble-shooting the continuous population of data provided from an external data feed into a pre-defined, normalized database schema.
This will require an understanding of the following components:
The ClearMechanic (CM) web application (training will be provided)
The Dealer Management System (DMS) / CM integration functionality (including the C# source code and stored procedures)
The CM database schema
Candidate should have experience with C# /.NET applications that integrate with SqlServer (2005/2008) to feed continuous data from external data sources (flat files and XML) to a pre-defined and normalized database schema. The integration / data feed adheres to best practices and uses stored procedures to insert and update dependent / key-linked record sets into schema tables. Stored procedures implement error trapping and execute rollback on error.
Candidate should be able to build ad-hoc queries using SqlServer Management Studio to trouble-shoot errors and that may result from anomalies in the data feed, and also identify the cause of the error and potentially propose / implement changes to the integration algorithms to trap for or correct the error conditions.
Candidate should have good communication skills and be able to work collaboratively CM customers, using interactive tools such as GoToMeeting, Mikogo, and the like.
Candidate should have the ability to work collaboratively with other CM team members on MS Visual Studio C# applications using Visual SourceSafe and should have a working knowledge of collaborative application development.
All equity compensation initially