PL/SQL Developer (Informatica

Nivel cariera

Middle (2-5 ani), Senior (5-10 ani)

Limbi vorbite

engleză

Adresa/adresele jobului


Consider a new opportunity

Role Description Summary

The Senior Oracle PL/SQL developer designs and develops reports, data reconciliation routines, ETL processes and application code in response to business problems and participate as part of a team on development related The Senior Oracle PL/SQL developer defines a technical solution based on business and technical requirements and writes application code to meet the technical solution. Plans, designs and conducts tests of his artefacts; corrects errors and re-tests to achieve an error-free Conducts reviews of supplied specifications, with others as necessary, estimate implementation effort and documents all work in accordance with agreed standard

Responsibilities / Tasks 

 Design: 

  • Performs design reviews, provides input and estimates effort required for implementation
  • Designs components/reports to meet the business requirements and the functional design
  • Identify data, defines the data model and the integration strategy including rationale, integration environment requirements and determines the product-component integration sequence
  • Assesses and identifies mitigation for risks, including those related to high level design, integration, and data quality
  • Ensures architectural/design changes are implemented

Development:

  • Development of all the necessary report components – layout, templates, PL/SQL codeincluding documentation, in accordance with the functional and technical design
  • Implements ETLs and data reconciliation routines
  • Integrates software components following the integration strategy
  • Verifies integrated software components by unit and/or integrated software testing according to the software test plan. Software test findings must be resolved.
  • Creates builds and deployment baselines, deployment notes and operating instructions
  • Provides Level 3 support - maintenance of applications/reports by fixing defects/bugs and performs technical change requests scheduled according to Release Management processe

Experience / Exposure 

 

  • Good experience with PL/SQL, Oracle functions, procedures, triggers, packages & performance tuning 
  • Experience in implementing data reconciliation routines and/or data migration and/or ETL processes
  • Proven working experience in Reporting area with different reporting tools or frameworks
  • Working experience with different RDMS or DW (any of Oracle, MS SQL Server, others) and SQL language
  • Working experience with Oracle BI Publisher and/or Oracle Business Intelligence is a plus
  • Ability to understand and design logical and physical data models
  • Financial, banking and/or accounting knowledge is a big plus
  • SQL and application/reports performance analysis and tuning
  • Knowledge build and deployment processes
  • Strong analytical skills, able to solve business or production problems and to write high quality code
  • Excellent communication skills, able to articulate technical  and non-technical issues
  • Highly collaborative, supportive and team player that demonstrates a proactive ‘can do’ attitude
  • Responsive, assertive and drive a continuous improvement ethos in all interactions
  • Ability to work in fast paced environment
  • Passion about sharing knowledge and best practices
  • Ability to work in virtual teams and in matrixed organizations
  • Fluent English (written/verbal)