U-SQL is the new big data query language of the Azure Data Lake Analytics service.
It evolved out of Microsoft's internal Big Data language called SCOPE and combines a familiar SQL-like declarative language with the extensibility and programmability provided by C# types and the C# expression language and big data processing concepts such as “schema on reads”, custom processors and reducers. It also provides the ability to query and combine data from a variety of data sources, including Azure Data Lake Storage, Azure Blob Storage, and Azure SQL DB, Azure SQL Data Warehouse, and SQL Server instances running in Azure VMs.
It is however not ANSI SQL. For starters, its keywords such as SELECT have to be in UPPERCASE. And its expression language inside SELECT clauses, WHERE predicates etc is C#. This for example means, that the comparison operations inside a predicate follow C# syntax (e.g., a == "foo"), and that the language uses C# null semantics which is 2-valued and not 3-valued as in ANSI SQL. To help SQL users to get familiar with U-SQL, a section is providing the mapping of some common SQL expressions and how to express them in U-SQL.
Skills Required:
Back-End resources skillset:
T-SQL
Azure SQL Server
Reporting resources skillset:
SSRS
Power BI
SQL SERVER 2012, T-SQL, Azure SQL Server, SSRS, Power BI
Duties/Responsibilities
Responsible for database design and development as needed in SQL Server 2012 and develop reports using SQL Server reporting services
Build T-SQL queries, Stored Procedures, Views, Triggers, Functions, Cursors and JOINs.
Analyze the query performance issues and recommend solutions.
Develop various drill down and drill through reports based on the user information in existing database. Provide report predicting the future data, based on existing information.
Job Type: Contract
Pay: $63.00 - $73.00 per hour
Schedule:
Experience:
Contract Length:
Work Location:
Work Remotely: