Information Technology JobsSenior DataWareHouse Engineer

  • CJ50158
  • Permanent
  • Cork, Cork City

Collins McNicholas

Role Responsibilities:

  • Functions as a primary contributor in designing, coding, testing, debugging, documenting and supporting all types of DW / OLTP applications consistent with established specifications and business requirements to deliver business value.
  • Gather business requirements, elicit technical requirements, and prepare specifications together with business area.
  • Design, Develop & Test components across development, test, production environments and implementation support as necessary.
  • Devises data verification and quality checks and system standard procedures that will be used to support Enterprise DW/BI platforms.
  • Develops complete descriptions of all specifications and solutions as required.
  • The Data Engineer also plays a key role in technological decision making for the future data, analysis, and reporting needs. He supports the business’s daily operations inclusive of troubleshooting and identify delivery mechanisms for acquiring and reporting such information as well as addressing the actual needs.
  • Shift work is a requirement of this role.

 

Role Requirements

  • University degree in Computer Science or similar, technical subject.
  • At least 5-7 years relevant work experience.
  • Expert level of knowledge with Informatica 10, Oracle RDBMS (Exa) & DWH concepts, SQL/PL-SQL, Java, Unix, Shell scripting and Control-M.
  • ETL fine tuning skills and data modelling skills are absolute necessary.
  • Extreme fluency in SQL, SQL/PL-SQL, Oracle Exadata is needed.
  • Knowledge on Financial Markets, systems and process will be an added advantage.
  • Experience with Real-time technologies (wire protocol like AMQP and TCP/IP) will be an added advantage.
  • Know-How on Java, Spark & BI reporting will be an added advantage.
  • Good understanding of Data Lake, Operational Data store and DWH concepts is needed.
  • Exposure to Bigdata platforms e.g. Cloudera / Data bricks etc will be added advantage.
  • Experience in CI/CD pipeline and exposure to DevOps methodologies will be considered as added advantage.
  • Excellent written and verbal communication skills in German and English with the ability to interact with business and technical IT management teams.
  • Additionally, you need to be a team player with good communication skills, problem-solving skills, highly motivated, flexible, and service-minded and the willingness for hands-on work across different projects.

For a confidential discussion and more information on the role, please contact Aideen Kehoe on 021-4911061 or email aideen.kehoe@collinsmcnicholas.ie

 

First Name

Surname

Your Email (required)

Your mobile (required)

Where did you hear about us?

Comment / Cover Letter

Upload CV

In order to provide you with our services, we need to process certain personal information about you. We will only use your personal information to deliver the job-seeking or related services you have requested.

We seek your consent to store your data and provide you with the best possible service. If you have any questions regarding our legal obligations to you or your rights under the GDPR please refer to our privacy statement which clearly outlines all of your rights.

Related Articles

Med Tech Report

A new report shows that Ireland’s medical technology sector employs over 32,000 people, hosts 18 of the 25 largest Med Tech companies in the world, and has €12.6 billion worth of exports annually, making Ireland the fifth largest exporter in Europe. Ireland develops some of the most sophisticated products in the industry, with particular strengths in high […]
Read More
  • Find a job
  • Apply
  • Get a job