ETL/SQL developer (offline)

Project Description:
This project is one of the most critical areas within Investment Banking. In order to be on the top our client decided to launch a long-term strategic initiative called Data Management and Client Experience to align all business data, models, and processes to industry standards.
Potential technologies are yet to be explored, so this project is a great opportunity for skilled people interested in new horizons of enterprise solutions; particularly, but not limited to, in Enterprise Data Management.
Responsibilities:
SQL development:
• Team work on creating Bank critical Enterprise Data Management product
• Data modelling
• Performance tuning
• Query optimization
• Performance monitoring
• Stress testing

Mandatory Skills:
Skills:
a) Working level of English - ability to argue the case or explain something complex in English.
b) Database design principles (Referential integrity, 3rd Normal form, Primary/Foreign keys); when to use indexes; Different styles of schemas.
c) In depth knowledge of SQL (Joins, Sub queries, functions, grouping), Stored Procs, temp tables, optmisation. Know how relational database principles work with SQL.
d) Ability to understand explain plans and ability to identify performance bottlenecks, and refactor sql.
e) Demonstrate a confidence in their knowledge of databases in production and issues around them
f) Knowledge of ETL principles (above what the E the T and L stand for).
g) Clearly can demonstrate confidence to own work and deliver complex solutions without needing to be spoon-fed.
h) An interest or understanding of what a Banking project entails and the challenges and opportunities that will happen in an environment there

Nice-to-Have Skills:
Differentiator:
• Experience with Data Management product
• Experience with MarkIT product
• Experience with Investment Banking

About Luxoft

Luxoft (NYSE:LXFT) is a global consulting partner that offers end-to-end digital solutions to solve clients’ complex business challenges.

We are a new class of digital service provider that combines consulting, strategy, and engineering at scale. We use this to drive business change by applying engineering excellence, deep domain expertise, and our senior software engineering talent to improve your client’s customer experience, boost your operational efficiency, and strengthen your competitive advantage.

We have expertise in automotive, financial services, healthcare, life sciences, telecommunications, and other industries. As a highly committed partner, we take customer challenges as our own. Our dedication stems from a passion for technology and a bespoke attention to your needs.

With over two decades of consistent, timely delivery and management of complex projects, we now serve over 280 active clients. With our headquarters in Zug, Switzerland and 42 global locations, we operate in 21 countries across five continents, providing you with robust global delivery platform. With about 12,700 employees, we have the best technology talent to support your business needs.

Company website:
https://www.luxoft.com/