Upload a CV I want to hire talent Contact Shortlist & Notifications News About Us Job Search

C# SSIS Developer – 6 Months

C# SSIS Developer – 6 Months
Cork City 1 €400 per day Ref: E16294PK

Job Description

My client is a large corporate client in Cork looking for a Database SSIS/ C# Consultant for a minimum 6 months.

Key accountability:

  • Ability to work closely with Business Analysts and SMEs to understand business requirements
  • Create and validate the ETL design and ensure that technical specifications are complete, consistent, concise, and achievable.
  • Develop ETL code as per the technical specifications and business requirements according to the established designs
  • Exhibit competency in problem solving, data analysis, business rule validation, data integration, data quality, dependency analysis and estimation and delivery of complex SQL Server solutions
  • Design and develop ETL solution using SSIS to copy data from multiple sources to a centralised Operational Data Store and Data Marts
  • Create/maintain design related artifacts i.e. data models , Mapping documents, architecture diagrams, data flow diagrams
  • Experaince in integrating SSIS with  C#
  • Participate in system and integration test; identify and remedy solution defects.
  • Monitoring performance and advising of any necessary infrastructure and/or design changes
  • Analysis of source data to assist in preparing iterative design changes, database refactoring, and creating or modifying reference data
  • Experienced in database design with the ability to progress from concept to implementation, creating and maintain documentation including entity relationship diagrams, data dictionaries, and ability to create implementation scripts.
  • Provide SQL Server database, SSIS, and SSRS architecture leadership
  • Effectively communicate SQL Server SSIS architecture and approaches
  • Ability to work and deliver in a very high paced environment with limited information at times to support business needs

Knowledge, Skills & Experience 

  • Minimum 5 years’ experience of similar roles elsewhere
  • Strong SSIS development and implementation experience essential
    • modular solutions
    • full and delta table loads
    • robust error-handling logging
    • archiving
    • facilitating migration between environments
    • debugging and troubleshooting SSIS processes in production environments
    • packaging and deployment of SSIS solutions using scripts
    • grounded in SSIS best practises
    • incorporating data from a wide variety of data sources e.g. Oracle, SQL Server, external APIs
  • Experience of SQL Server 2016 desirable
  • Proficient in data modelling, data warehousing concepts and constructs, including star schema data models
  • Proficient performance tuning SQL, including use of explains plans, partitions, hints, etc.
  • Strong documentation skills required
  • Strong ability to work to project deadlines and project plans;

Consultant Details

Peter Kirby's Profile Picture
Name: Peter Kirby
Title: Director
Tel: 01 2866666
Apply for Job Call me now Add to Shortlist

How to Apply

If you are interested in this role, then please Apply along with your updated CV and I will be in touch with you to discuss your application in more detail, otherwise feel free to connect with me by whichever medium you are most comfortable with be that Linkedin, Email or Telephone. Remember we have limited our site to a maximum of 200 Jobs so if this Role is not a 100% match to your requirements please be sure to connect with us as we will most likely have another role which you may find more suitable.

Apply for Job

Not what you're looking for?

If this isn't the job for you then why not reach out to one of our consultants today and send us your CV so we can find the one that is?

Reach out to a Consultant Upload your CV

Email Job Details

  • Enter your details below to email this job to yourself or a friend.

  • In order to submit this form you'll need to agree with our Privacy Policy

Apply for Job

  • Enter your details below to apply for this job, the consultant will then contact you as soon as possible.

  • Accepted file types: pdf, doc, docx, odt, Max. file size: 4 MB.
  • In order to submit this form you'll need to agree with our Privacy Policy

Upload your CV

  • Send us your CV and we'll be in touch with jobs relevant to you.

  • Accepted file types: pdf, doc, docx, Max. file size: 10 MB.
  • In order to submit this form you'll need to agree with our Privacy Policy