Position: Junior Oracle PL/SQL Developer
Company: Luxoft
Experience required: 1y
Category: SQL
English level: intermediate
Published: 2022-03-01T00:00:00+02:00

It is also used for Stress testing and runs hundreds of potential economic scenarios to confirm Bank's readiness for various business conditions to market regulators. Calculated exposures are used for Basel 3 reporting, RWA calculations, trading limits, valuation of Market and Credit risks etc. This platform performs overnight data loading and runs batch processing during the day to deliver data to downstream systems according to strict SLAs. It is also capable of intraday online calculations. This is a legacy platform to an extent, but we keep developing new components and modify existing ones, there is more development than support activities. Also, there is undergoing Automation program sponsored by Client's top management in order to bring platform to modern and automated delivery process. We strive to reduce manual work and bring best engineering ideas to life. Our team: We're part of Client's Risk Analytics IT department, there is around 80 Luxoft professionals organized into several cross-functional development and supporting teams. Team size is 8-10 people, with a Team Lead, .Net developers, Oracle developers, QA Engineers and System analysts. We generally follow 4 sprints development cycle, each sprint being 2 weeks, but team is free to adapt to their projects needs in terms of methodology and software development process. We value teamwork, as well as recognize individual contribution into success of the project.

Technology stack:
Programming Languages - C#, Python, Java/Scala, SQL, PL/SQL, XSLT, xQuery, PowerShell
IDE - Visual Studio 2019, VS Code, IDEA, PyCharm, PL/SQL Developer
Frameworks - .net 5/6, .net core, .net framework, Spring.net, ApacheThrift, ASP.NET MVC, TibcoEMS, gRPC, RestAPI
Cloud - Azure Provider, Azure Batch, CosmosDB, AKS, DataBricks, Functions, ADLS
DB/BI - Oracle 18c, MongoDB, MS-SQL BI (SSIS, SSAS), DataBricks, PowerBI
BigData - Spark, Hadoop, DataBricks, Tableau, Hive, ADLS
CI/CD/DevOps - GitLab, Docker, MS Build, Puppet, Nexus, NUnit, SonarQube, Unix
QA - Jira X-Ray, Python

Opportunities for you:
• Become a valuable expert by delivering top-notch Investment Banking regulatory programs (SIMM, CCAR, FRTB etc.)
• Grow as a seasoned professional by working on a complex business-critical platform, learn from a team of over 100 experts
• Favorable environment for career growth, which depends on your career goals: develop your seniority / change into new technology / grow into management. Good ambitions are very much appreciated
• Ownership, hardworking and efficient ideas are rewarded • Bonus program to acknowledge top performers
• New technologies / tools / inventions are appreciated by Client
• Become professional in risk-management systems, which is highly demanded on Investment Banking market
• Get experience with high performance system using distributed calculations and cloud computing
• Get experience in BigData, BI and Cloud
• Large amount of training materials from Luxoft, sponsorship of Certifications

Responsibilities:
- tuning of performance for various complex queries
- writing packages, views, functions in PL/SQL in order on new functionality creation according to business needs
- assess storage requirements and forecasting database growth.
- work with multiple dev and UAT environments, synchronize data across those envs.

Mandatory Skills Description:
• PL/SQL development and database design
• have strong analytical & design skills and be structured and systematic in your approach

Nice-to-Have Skills:
• GitLabs
• finance sector, banking and/or Treasury experience is an advantage
Languages:

English: B1 Intermediate