ETL Developer – Sligo

  • Reference: SJ45892
  • Job Type: Permanent
  • Location: Mayo, Roscommon, Sligo
  • Category: Information Technology

Our client, an exciting expanding company in Sligo requires a talented and highly motivated ​ETL Developer responsible for the design, development, and testing of operating systems-level software, including building and maintaining ETL (Extract – Transform – Load) processes to populate the enterprise data warehouse and structures optimized for reporting, to support a top ranking eCommerce web site.

Job Responsibilities:

  • ​Review and document existing application code
  • Provide maintenance support to existing application code
  • Develop and test new ETL processes
  • Define functional design for requirements implementation
  • Develop sql scripts using Teradata utilities (BTEQ, Fastload, Mload & Fastexport) to transform and load data from various sources
  • Design and build data structures and processes to populate data warehouse tables using knowledge of relational and dimensional data modeling techniques
  • Integration with legacy data and applications
  • Work closely with the business, reporting team, business analyst and end users in end-to-end Business Intelligence solutions
  • Maintain a working knowledge of the in-use data structures and monitor performance providing system level changes to facilitate growth and efficiency.
  • Maintain ETL/ELT operation in support of data warehousing
  • Provide for reporting operations including visual data representations
  • System administration for cloud based BI

Job Requirements

  • ​Minimum of 3-5 years recent Software Development experience
  • Proficiency in using Teradata; Business Intelligence; end-user reporting tools; ETL; Perl; Linux/UNIX; Oracle GoldenGate; Oracle Data Integrator; BMC Control-M; MicroStrategy; Big Data Tools; DMExpress; Shell Script;
  • Strong SQL skills
  • Write, test and implement Teradata Fastload, Multiload and Bteq scripts, DML and DDL
  • Create and execute detailed test plans
  • Ability to quickly troubleshoot and resolve production related issues
  • Strong communication skills and the ability to perform customer facing duties

Skills

  • ETL Tools:
    Experience pulling data from a variety of data source types. 
    Experience in Perl/Shell Scripting.
    Experience with job scheduling systems
    Source code management/version control systems
    Ability to document complex systems
  • Database Knowledge:
    Understanding of RDBMS concepts.
    Understanding of Entity Relationship Diagrams.
    Understanding of data modeling, database design, and data warehousing.
  • Teradata Competency:
    Experience with SQL involving complex queries
    Ability to write and tune efficient SQL code.
    Understanding of joins and indexes.
    Experience writing BTEQ scripts.

For a confidential discussion and more information on the role, please contact Aideen Cummins on 071-9140252 or email aideen.cummins@collinsmcnicholas.ie

For more information on our Recruitment and HR Services and to see a full list of our available jobs across Ireland, please visit our website www.collinsmcnicholas.ie

Follow us on LinkedIn and connect with our Recruitment Consultants to discuss the latest jobs as well as our job searching tips and videos!


Firstname (required)

Surname (required)

Your Email (required)

Your phone

Upload CV (required)

Security Code captcha

Comment

Aideen Cummins

Contact Consultant

  • Aideen Cummins
  • Principal Recruitment Consultant
  • 071 9140252
  • Connect with Aideen

Collins McNicholas Galway Team Welcomes New Team Leaders!

Eoghan Curtin (left) and Christopher O'Toole (right)
  Collins McNicholas Galway welcomes the appointment of Eoghan Curtin and promotion of Christopher O’Toole to Team Leaders! Eoghan is a highly experienced Account Manager with 12 years recruitment experience across all industry sectors with multiple agencies in Ireland, Canada & Switzerland. A native of Bushypark, Galway, Eoghan holds a Masters of Business and a […]
read whole article

Job Seekers Guide

cmcn_hr_color
Everything you need to know to find a job, including; how to prepare a CV and cover letter, how to prepare for a job interview, how to navigate the modern job market, and much more.
view more

The ICT Labour Market Report 2016

circular tech graphic, blue
This report provides you with all of the recent developments in the ICT sector in Ireland, including skills availability, graduate output, industry trends, regional investment, and our expectations for the year ahead.
view more