ETL Developer

Mississauga, ON
Mississauga, ON
ETL Developer
View below the job description in addition to the application form.
Why BoomerangFX?

BoomerangFX is more than just a SaaS tech company – we are North America’s fastest growing cloud-based enterprise software and digital marketing company in the private healthcare industry including segments such as dermatology, cosmetic dental, vision, medspa, hair restoration and women’s health practices.

Our company is well-funded by international private equity. We have a market opportunity that is rare in its scale and powered by a strong business model coupled with an impressive leadership team consisting of executives from Silicon Valley, Digital Marketing, Fintech and leading SaaS technology start-ups. Trusted by a growing community of leading physician owners, our product is commercialized and delivers the only cloud-based SaaS enterprise solution with feature rich practice management dashboards, AI and integrated digital marketing tools to help our clients succeed in the marketplace.

What You Offer
  • Ability to write Advanced SQL queries & Good knowledge in data loader to insert/update or import/export bulk data
  • Maintain a solid understanding of software testing best practices, methodologies, and terminologies
  • Ability to go through the User stories and understand the technical aspects required for aspects of ETL/Data process.
What You Offer
  • Good knowledge on SSMS & Azure Data Factory [ETL]
  • Strong testing experience for data-based programs and validating data consistency
  • Strong experience with CRM domain
  • Good understanding of SQL (3+ years of experience)
  • Experience in Designing, developing, and testing SQL and PL/SQL
  • Nice to have experience in BOE dashboards, universes & reports, PowerBI, Crystal Reports
  • Experience with technology solutions and development methodologies
  • Experience in analyzing and designing changes to existing web-based software solutions
  • Complete knowledge of SDLC methodologies, e.g. Agile development
  • Experience in RDBMS design concepts
  • Experience with Data Warehouse design, Reporting and ETL concept
  • Experience with Data Warehouse architecture, design, dimensional modeling, development, and deployment of business intelligence systems
  • Excellent analytical, problem-solving, and decision-making skills
  • Leadership and collaboration skills
  • Proven track record for building strong working relationships
  • A demonstrated team player with a track record for meeting deadline
  • Strong verbal and written communication skills
  • Working directly with the customer on solving their often-complex ETL and integration needs
  • Identifying, recommending, and implementing integration process and architectural improvements
  • Working with team members, peers, and management to identify objectives and set priorities
  • Creating and maintaining document repository of mappings and processes
  • A minimum of 3+ years work experience as an ETL developer or architect
  • University Degree in Computer Science or related program
  • Previous experience working in a customer facing services-based environment
  • Ability to communicate and interact effectively with customers both written and spoken
  • Good to have experience ETL Tools
  • Knowledge of ETL best practices
  • Strong or advanced SQL & skills
  • Exposure to scripting languages

Required Experience:

  • 3 plus years of Experience in Designing, developing and testing SQL and PL/SQL
  • 3 plus years of experience in RDBMS design concepts
  • 2 plus years of Experience with Data Warehouse design, Reporting and ETL concepts
Job application:

    Attach Resume