JobRialto
ETLSQL Developer
JobRialto, Richmond, Virginia, United States, 23214
Description :
Top Skills' Details
This is an ETL/SQL Developer with strong business logic, integrations, and SQL with some exposure to kronos/UKG.
5+ years of ETL development/business logic experience (process and transform data)
1+ years of Kronos/UKG experience (development/upgrades/troubleshooting)
5+ years of SQL Database experience (tuning, from/where/join)(stored procedures)
Secondary Skills - Nice to Haves
C#
Linq
Stored Procedure
business logic
.net
Job Description
This is a 6+ month contract developer who has good communication and can do some gathering of requirements, very senior in SQL, has some .NET/C# skills, and ideally has some Kronos/UKG/dimensions experience (as this is a project in their payroll/HRIS/workforce development application group).
They need someone use SQL to extract data from a database, read/write Business logic that processes this data, transforming it into a required format (e.g., a CSV file), and once the data is processed and formatted, it can be saved as a file.
FTP is then used to transfer this file to another server or location for further use or storage.
For example, a common scenario might involve using SQL to query a database for sales data, applying business logic to format this data into a report, and then using FTP to upload the report to a remote server for access by other departments.
Additional Skills & Qualifications
Ideally also have:
5+ years in backend .NET framework development (MS environment and OOP fundamentals)
5+ years of C# language experience (method overloading/LINQ/factory pattern)
Employee Value Proposition (EVP)
Education:
Bachelors Degree
Top Skills' Details
This is an ETL/SQL Developer with strong business logic, integrations, and SQL with some exposure to kronos/UKG.
5+ years of ETL development/business logic experience (process and transform data)
1+ years of Kronos/UKG experience (development/upgrades/troubleshooting)
5+ years of SQL Database experience (tuning, from/where/join)(stored procedures)
Secondary Skills - Nice to Haves
C#
Linq
Stored Procedure
business logic
.net
Job Description
This is a 6+ month contract developer who has good communication and can do some gathering of requirements, very senior in SQL, has some .NET/C# skills, and ideally has some Kronos/UKG/dimensions experience (as this is a project in their payroll/HRIS/workforce development application group).
They need someone use SQL to extract data from a database, read/write Business logic that processes this data, transforming it into a required format (e.g., a CSV file), and once the data is processed and formatted, it can be saved as a file.
FTP is then used to transfer this file to another server or location for further use or storage.
For example, a common scenario might involve using SQL to query a database for sales data, applying business logic to format this data into a report, and then using FTP to upload the report to a remote server for access by other departments.
Additional Skills & Qualifications
Ideally also have:
5+ years in backend .NET framework development (MS environment and OOP fundamentals)
5+ years of C# language experience (method overloading/LINQ/factory pattern)
Employee Value Proposition (EVP)
Education:
Bachelors Degree