Position

PL/SQL developer,
Sofia

Location


Sofia

Office Address


Project Description


As 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.

Responsibilities


    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 Functions:
    • Conduct a detailed discussion with the SMEs and document the understanding of the business requirements
    • Write Low Level Design, Unit Testing Plan, and Unit Test case documentation
    • Troubleshoot performance related issues
    • Support system and user acceptance testing activities, including issue resolution
    • Research problems reported by clients and other stakeholders and recommend fixes and solutions to be implemented after review by SMEs
    • Complete technical documentation to ensure system is fully documented

Skills


Must have

    Certification Requirements:
    • Oracle Certification

    Required Skills/Abilities:
    • Good analytical and problem-solving abilities
    • Basic knowledge of data modeling concepts and methodologies (Kimball) used in a data warehousing environment
    • Good communication and writing skills with the ability to work in challenging environment
    • Ability to multi-task their workload assignments
    • Good analytical, problem-identification/solving skills
    • Self-starter who enjoys working in an international team
    • Flexibility, creativity and initiative
    • Good knowledge and experience in PL/SQL, Oracle 11x (latest DB version) and/or SQL server
    Pluses for Levels: (for level II, III):
    • Level II:
    o Essential Job Functions:
     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 efforts

    o Educational Qualifications and Experience:
     Bachelor's degree in Computer Science, Engineering, or related discipline, and 5+ years of experience in Oracle development environment

    o Required Skills/Abilities:
     Superb communication and writing skills with the ability to work in challenging environment and must be able to multi-task their workload assignments

Nice 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 Composite

Languages


English: C1 Advanced

Seniority


Senior

Relocation package


If needed, we can help you with relocation process. Click here for more information.

Work Type


Other System Languages

Ref Number


VR-59463