ETL Consultant

ETL Consultant

Share This Job

Canada, Remote

Industrial

Contract

28/11/2022

201042

Aplin, one of Canada's Best Managed Companies, has partnered with our client to recruit an ETL Consultant to assist the organization with day-to-day business activities. This role is a 2-year contract opportunity, fully remote and is open to candidates across Canada.

Benefits & Perks:
  • Opportunities to learn and develop new skills
  • Great Onboarding and Training Support
Responsibilities:
  • Develop an approach and detailed work plan to accommodate completion of the application within the specified project timeline and budget
  • Design application as per process ‘flow’ of application
  • Design, implement and deploy ETL packages created using SSIS to Dev and Prod environments
  • Create high-performance and scalable packages leveraging features within SSIS for data feeds and transforms
  • Develop custom code to extend ETL packages complex extraction and cleansing of data
  • Utilize best practices for developing, testing, deploying, and monitoring SSIS packages
  • Perform knowledge transfer of the application, tools, and development methods to selected staff
 Qualifications:
  • 10+ years of recent experience in application, data, and software development, with expertise in high-performance and scalable data extraction, transform and loading activities
  • 5+ years of recent experience in trouble shooting performance issues by finding out the resource bottlenecks like load balancing, parallelism in data loads, index usage etc.
  • Must have a min. of 5+ years of recent experience in designing and implementing large scale enterprise level data extraction, transform and loading leveraging features within SSIS for data feeds and transforms
  • Requires experience in Microsoft SQL Server with experience in database design, writing and optimization of SQL
  • Strong knowledge with data analysis, transforming business requirement into technical specification and designing the business solution
  • Previous experience in reverse engineering of old scripts to build new ETL packages


Aplin, one of Canada’s Best Managed Companies, is an employment agency that finds top talent for exceptional organizations across North America. There are no fees to apply to our jobs or engage with our recruiters to find a new career. Companies hire us to help them grow their teams. Visit our website to learn more: www.aplin.com 

Easily manage your email preference and unsubscribe at any time. Aplin does not share your personal data with any third party, and our recruiters do not present your resume to any of our clients without first obtaining your permission.