DWH/ ETL Developer

Information about the offer
  • Type of employment: b/d
  • Offer ID: PL2115
  • Category: Software Developer
  • Place: Warsaw, Poland
Requirements
  • Minimal level of education:: b/d
  • Minimal experience: Between 2 and 5 years

VACANCY DESCRIPTION

A Senior Oracle/ETL developer is sought to support projects sponsored by Global Treasury under the Liquidity Program to enhance liquidity monitoring and reporting capabilities and ensure compliance with regulatory obligations. The primary responsibility for this role is to work closely with business and functional teams to understand business requirements and translate them into functional specifications for technical teams to deliver via technical solutions. The role would require involvement in end-to-end functional testing of the deliverables.

The team works in Agile methodology and also provides L3 support to the business queries that cannot be resolved by L1/L2 PTG support teams. The developer is engaged as required by the L3 team to investigate production issues that require technical knowledge

DUTIES

•Analyze, design, develop and support and maintain Data warehouse and processes designed using Oracle and Informatica (ETL tool) for data load and processing used for Liquidity Management and Reporting
•Closely liaise with Business Analysts and Change Partners to understand the functional requirements and develop technical solutions
•Participate in the team’s effort to ensure that the implemented results do meet the stakeholders requirements and perform the necessary IT testing and validation activities

REQUIREMENTS

•4+ years’ experience as a technical developer, including 2 years of extensive application development experience
•Strong relational database development experience – especially Oracle (PL/SQL, packages, procedures, tuning)
•Understanding of database warehousing concepts
•Demonstrated abilities for drafting detailed technical designs from functional specifications
•Conduct performance analysis and optimize data processes. Make recommendations for continuous improvement of the data processing environment
•Ability to perform technical code reviews for self and peers.
•Effective communication and interpersonal skills
•Ability to work in international team of developers and act as a mentor and coach to junior team members
•Understanding of Unix shell scripting
•Experience with database warehousing and ETL tools like Informatica
•Understanding of Agile software development methodologies, specially scrum is desirable
•Experience of working with source control tools (Subversion, Source Safe, etc.)
•Experience in batch scheduling packages such as Control-M

WHAT WE OFFER

b/d