Luxoft Company Profile

PL/SQL developer


Описание на работата

Project DescriptionAs part of our strategic partnership with one of the biggest financial institutions in the World, we are hiring various IT specialists, who will become part of their new IT Service Center in Sofia. The bank is an international organization dedicated to providing financing, advice, and research to developing nations to aid their economic advancement. The bank predominantly acts as an organization that attempts to fight poverty by offering developmental assistance to middle- and low-income countries. Our client is a provider of financial and technical assistance to individual countries around the globe. The bank considers itself a unique financial institution that sets up partnerships to reduce poverty and support economic development.ResponsibilitiesPosition Overview:The desired candidate will fill in the position of a PL/SQL developer. This person's primary responsibility will be to develop PL/SQL code - procedure, functions, and packages to transform the source data based on business rules and load them in to target tables in the warehouse. Other responsibilities include query analysis & optimization, and maintenance of the data models.Essential Job FunctionsConduct a detailed discussion with the SMEs and document the understanding of the business requirementsWrite Low Level Design, Unit Testing Plan, and Unit Test case documentationTroubleshoot performance related issuesSupport system and user acceptance testing activities, including issue resolutionResearch problems reported by clients and other stakeholders and recommend fixes and solutions to be implemented after review by SMEsComplete technical documentation to ensure system is fully documentedSkillsMust haveRequired Skills/AbilitiesGood analytical and problem-solving abilitiesBasic knowledge of data modeling concepts and methodologies (Kimball) used in a data warehousing environmentGood communication and writing skills with the ability to work in challenging environmentAbility to multi-task their workload assignmentsGood analytical, problem-identification/solving skillsSelf-starter who enjoys working in an international teamFlexibility, creativity and initiativeGood knowledge and experience in PL/SQL, Oracle 11x (latest DB version) and/or SQL server Superb communication and writing skills with the ability to work in challenging environment and must be able to multi-task their workload assignment Conduct a detailed discussion with the SMEs and document the understanding of the business requirements Independently design and develop Oracle procedure, packages, and functions based on the business requirements and rules and schedule them, as required Share best practices and lessons learnt from past implementation effortsEducational Qualifications and Experience: Bachelor's degree in Computer Science, Engineering, or related discipline, and 5+ years of experience in Oracle development environmentNice to have Informatica development experience Experience in maintaining data models using Erwin Familiarity with database administration activities - space management; Managing schema objects - Indexes, Materialized views, partitions; Database Maintenance - Optimizer stats, rebuilding indexes, partition maintenance, data purging, table analysis; Data loading using SQL loader Exposure to SAP BO or other BI/Visualization tools Exposure to Data Services Technology using tools such as CompositeLanguagesEnglish: C1 Advanced

Наскоро добавени работни места във Luxoft

Python/Data Modelling Developer

BigData\Scala Developer

Senior C makefile Build Engineer

ServiceNow Developer

Наскоро добавени работни места във България

Web Developer

Software Engineer

Senior Software Engineer - Backend

Junior Software Automation Engineer

Frontend Developer

TrafficMate LTD: Senior System Administrator

React Native Developer

Full Stack Developer