Sr. ETL Developer
Ainsworth
Mississauga, Ontario
8h ago

Responsibilities

  • Work with business analysts and team members to translate business requirements into a proposed solution, reviewing the design and requirements and build value-added solutions
  • Provide expertise in the development of data models, data warehouse design, ETL performance optimization and data quality
  • Research issues and identify the root causes to ultimately work with your Business Analysts to test solutions, ensuring that all solutions perform to expectations and meet all requirements for accuracy, clarity and ease of use
  • Partner with IT to manage, build and develop data warehouse ETL scripts. Hands-on collaborative development of analytical systems, strategies and best practices, production ETL processes and database models
  • Research issues and identify the root cause of information issues and design a solution that will prevent the problem from re-occurring
  • Analyze, design and introduce new opportunities and make appropriate recommendations to drive process improvements and productivity initiatives within the ETL function
  • Support new data source acquisition to promote self-serve capabilities
  • Improve ETL cycle time and standardize processes across the enterprise
  • Contribute to the development of predictive and data modelling frameworks in response to evolving business requirements
  • Travel to field offices intermittently to work with key stakeholders.
  • Document all ETL operations, processes and objects.
  • Ensure leading practices and standards are followed.
  • Qualification :

  • Required Education : College or University degree in Computer Science (or equivalent credits in management and Computer / Systems related)
  • Excellent knowledge of data modelling techniques in relational, dimensional, unstructured, and big data (7+ years’ experience) - Required
  • Experience in ETL design and development
  • Experience in Talend Integration Studio
  • Experience in MSSQL RDBMS
  • Expert understanding of SQL concepts and the ability to complex queries is required.
  • Hadoop experience preferred
  • End to End Data warehouse implementation experience is a must
  • Experience with enterprise application architecture and enterprise integration patterns
  • Ability to implement re-usable data-integration / ETL code in an enterprise data warehouse environment
  • Perform complex applications programming activities. Code, test, debug, document, maintain, and modify complex applications program
  • Examine and solve the performance bottlenecks in the ETL processes
  • Excellent interpersonal, verbal, and written communication skills are required
  • Ability to analyze and document business and system processes is required
  • Experience with Business Intelligence tools is preferred, Cognos is preferred (Controller, Planning Analytics and Analytics).
  • Ability to multitask and handle ambiguity is required
  • Ability to take charge and lead tasks to completion is required
  • Ability to work in a cross-functional organization and Ability to work in a team environment is required
  • Excellent decision making and problem-solving skills are required
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form