ETL Developer

  • Job Ref: 3731
  • Location: Dublin, Ireland
  • Type: Contract


We have an opportunity for a ETL Lead Developer position with our client a leading consultancy company, to join them for a 6 months project.

About the project:

The project goal is
to get a much better automated process in place that all works out of one application for automated reconciliations.

Your main responsibilities on this project will be:

  • Create/modify ETL (SSIS) packages to ensure correct data extraction
  • Perform data validation by writing/modifying complex SQL scripts
  • Record detailed results of validation including defects and documentation issues in tracking system
  • Review and validate responses to reported bugs
  • Analyze provided documentation to ensure scripts accurately test data accordingly
  • Interact with business subject matter experts and vendors relating to data migration activities
  • Collaborate with project Business Analyst and other project team members as needed
  • Provide status on assigned work as requested using established tools
  • Attend project related meetings
  • Complete other project related tasks as assigned
  • Analyze multiple scripts and ETL packages to gain an understanding of data flow in the absence of comprehensive documentation


  • SSIS / SQL development experience of a complex ETL process
  • Database development experience
  • Development experience in SSIS / SQL on the automated reconciliation of a complex ETL process containing large data sets
  • Access development experience would be a benefit
  • Development experience for Transfer agency/ financial services or something similar previously that would be advantageous
  • Experience writing and scripting complex SQL queries
  • Experience creating and modifying ETL based solutions in SSIS
  • Experience in working on a large data migration effort from a legacy database to a SQL server
  • Experience in translating ETL/Transformation rules into SQL scripts.
  • If this is something suitable for you do not hesitate to get in touch for more details.

    *Only applicants eligible to work in Ireland are considered for this position.

Anca Antonica, Recruitment Consultant - Your e-Frontiers consultant for this job

Anca is a Senior Technical Recruiter and brings value to both candidates and clients in offering end to end services. Anca has a track record of hiring Software Engineers for a range of clients from start-up companies to large multinationals across multiple industries. Anca offers support to her candidates to succeed in their interviewing process and match their skills with her clients' requirements. Anca holds a Degree in Social Work and with her extensive background in customer service, she focuses on providing excellent customer service for clients and candidates in both contract and permanent desk.

Specialises in: C#, .NET, SharePoint, CRM, BI, ETL, SSIS, ODI, Tableaux, Power BI, OBIEE