ETL Software Developer

5 days ago


Markham, Canada Fossbytes Media Pvt Ltd Full time

Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.

What you’ll do

Monitor Month End & Pre Month End Cycles in accordance with the business requirements

Understand the relationship between data and business outcomes and can focus on long term strategies for data

Participate in special projects and ad hoc analyses as necessary.

Improve ETL performance for enterprise data warehouse system to shorten batch run completion time. Performance improvement from better table/index design and ETL code design.

Maintain build and release plans for new functionality and enhancements.

Establish and manage procedures for reviewing, estimating, and accepting development work requests on BAU Requests or Projects

Must be able to identify any gaps in the business requirement and assist Business Analyst to rectify the gaps

Introduce and enforce effective software development practices, coding standards and methodologies aimed at controlling costs and delivering quality solutions on a timely basis while building a strong well-motivated development team

Support high level end-to-end architecture design from business requirement for ODS/Enterprise data warehouse type systems

Maintain reconciliation procedure (between systems) to facilitate audit trail

Use appropriate ETL tools (Informatica, PL/SQL, Unix shell scripting) to facilitate efficient data transformation

Be proficient in the use of dynamic SQL when data transformation logic is table driven or via configuration file

Improve ETL performance for ODS and enterprise data warehouse system to shorten batch run completion time. Performance improvement from better table/index design and ETL code design.

Lead and champion the continuous development of the Systems Analysis function, promoting and enhancing the Systems Analysis tools/templates, techniques and approaches within the organization.

Work with subcontractors and Project Managers to ensure completion of agreed activities.

Remain abreast of relevant technology developments.

May act as the scrum master in a pod when working with Agile Methodology

Adhere to Agile and development best practices.

Perform analysis and defect and issue triage during project development.

Other duties as assigned.

What you’ll bring

Degree in Computer Science/Engineering would be an asset

4+ years of experience in Informatica ETL Development

2+ years of programming experience in Unix Shell Scripting

3+ years of experience in a data-driven software engineering environment

Preferred 2+ years of experience in Software Development and/ or Quality Engineering

Experience administering SQL Databases like Oracle SQL, Unix, MySQL

Advanced Knowledge of Oracle , Postgress, Access Skills

Strong skills in writing SQLS for any of the relational Databases (DB2,MS SQL Server, Oracle DB, Postgres, MySQL)

Ability to write and dissect complex SQL Queries

A deep understanding of SQL and relational database schema design.

Strong understanding of Data Warehouse concepts, ETL strategies and best practices.

Good Experience in Data Modelling Skills

Good Understanding of Software Development Lifecycle(SDLC) (Agile, Waterfall, Iterative)

A proven track record in building and maintaining a reliable, high performance data pipeline that processes a large amount of structured data from various sources.

Experience being a member of a design, development project team building Business Intelligence and reporting solutions

An appetite for problem solving with a creative and resourceful approach to finding the right solution for the job.

Ability to manage multiple responsibilities with tight deadlines in a fast paced agile environment

Strong communication and collaboration skills

Critical and independent thinking skills

Strong Verbal and written communication and presentation skills

What you’ll get

Compelling rewards package including base compensation, eligibility for annual bonus, pension and retirement savings, share plan, health benefits, donation matching, and volunteer opportunities.

Competitive vacation package with the option to purchase 5 extra days off per year

Exceptional Career Development opportunities and we’ll support your professional development education.

Inclusive culture driven by our passionate Diversity, Equity and Inclusion communities; Pride, Gender Balance, Generations; Origins and Abilities.

Corporate wellness programs to support your mental, physical, and financial wellbeing

Hybrid flexible work model

Additional Information: Aviva Canada has an accommodation process in place to provide accommodations for employees with disabilities. If upon commencement of employment you require a specific accommodation because of a disability, please contact your Talent Acquisition Partner so that an appropriate accommodation can be arranged. This process applies throughout your career with Aviva Canada.

#J-18808-Ljbffr
  • ETL Software Developer

    Found in: Jooble CA O C2 - 7 days ago


    Markham, ON, Canada Fossbytes Media Pvt Ltd Full time

    Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence. What you’ll do Monitor Month End & Pre Month End Cycles in accordance with the business requirements Understand the relationship between data and business outcomes and can focus on...

  • ETL Developer

    1 week ago


    Markham, Canada Kasapur IT Services Inc. Full time

    ETL developer – Markham,ON." 7+ years of working experience in testing including Data warehouses, data marts on Teradata / Oracle teams 2+ years of working experience on Big Data projects 5+ years of experience of ETL Development / testing - Informatica 3+ years of experience and strong knowledge of P&C Insurance Domain Hands on experience of working in...

  • ETL Developer

    1 week ago


    Markham, Canada Kasapur IT Services Inc. Full time

    ETL developer – Markham,ON." 7+ years of working experience in testing including Data warehouses, data marts on Teradata / Oracle teams 2+ years of working experience on Big Data projects 5+ years of experience of ETL Development / testing - Informatica 3+ years of experience and strong knowledge of P&C Insurance Domain Hands on experience of working in...

  • ETL Developer

    1 week ago


    Markham, Canada Kasapur IT Services Inc. Full time

    ETL developer – Markham,ON." 7+ years of working experience in testing including Data warehouses, data marts on Teradata / Oracle teams 2+ years of working experience on Big Data projects 5+ years of experience of ETL Development / testing - Informatica 3+ years of experience and strong knowledge of P&C Insurance Domain Hands on experience of working in...

  • ETL Developer

    Found in: Jooble CA O C2 - 7 days ago


    Markham, ON, Canada Kasapur IT Services Inc. Full time

    ETL developer – Markham,ON. " 7+ years of working experience in testing including Data warehouses, data marts on Teradata / Oracle teams 2+ years of working experience on Big Data projects 5+ years of experience of ETL Development / testing - Informatica 3+ years of experience and strong knowledge of P&C Insurance Domain Hands on experience of working...

  • Développeur SQL/ Software Engineer

    Found in: Jooble CA O C2 - 7 days ago


    Markham, ON, Canada Fossbytes Media Pvt Ltd Full time

    Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence. Understand the relationship between data and business outcomes and can focus on long term strategies for data Participate in special projects and ad hoc analyses as necessary. Improve ETL performance for enterprise data warehouse system...

  • software developer

    Found in: Talent CA 2 C2 - 6 days ago


    Markham, Canada JST Solutions Full time

    Education: Bachelor's degreeExperience: 5 years or moreTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist in the collection...

  • software developer

    Found in: Talent CA 2 C2 - 4 days ago


    Markham, Canada JST Solutions Full time

    Education: Expérience: EducationBachelor's degreeTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist in the collection and...

  • software developer

    Found in: Talent CA 2 C2 - 6 days ago


    Markham, Canada Eternal Technologies Inc. Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist in the...

  • software developer

    Found in: Talent CA 2 C2 - 4 days ago


    Markham, Canada Eternal Technologies Inc. Full time

    Education: Expérience: EducationBachelor's degreeTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist in the collection and...

  • software developer

    Found in: Talent CA 2 C2 - 6 days ago


    Markham, Canada Starzlink Corporation Full time

    Education: College/CEGEPExperience: 7 months to less than 1 yearTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist in the...

  • software developer

    Found in: Talent CA 2 C2 - 3 hours ago


    Markham, Canada Starzlink Corporation Full time

    Education: Expérience: EducationCollege/CEGEPTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist in the collection and...

  • Software Developer

    2 weeks ago


    Markham, Canada NextPit GmbH Full time

    IntroductionAt , work is more than a job – it’s a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you’ve never thought possible. Are you ready to lead in this new era of technology and solve some of the world’s...

  • Software Developer

    6 days ago


    Markham, Canada NextPit GmbH Full time

    IntroductionAt , work is more than a job – it’s a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you’ve never thought possible. Are you ready to lead in this new era of technology and solve some of the world’s...

  • Software Developer

    5 days ago


    Markham, Canada NextPit GmbH Full time

    IntroductionAt , work is more than a job – it’s a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you’ve never thought possible. Are you ready to lead in this new era of technology and solve some of the world’s...

  • software developer

    Found in: Talent CA 2 C2 - 6 days ago


    Markham, Canada Pinnacle Tech Solutions Inc Full time

    Education: College/CEGEPExperience: 1 year to less than 2 yearsWork settingOfficeTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of...

  • software developer

    Found in: Talent CA 2 C2 - 6 days ago


    Markham, Canada Galaxy Security Corporation Full time

    Education: Bachelor's degreeExperience: 2 years to less than 3 years or equivalent experienceTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance...

  • software developer

    Found in: Talent CA 2 C2 - 3 hours ago


    Markham, Canada Pinnacle Tech Solutions Inc Full time

    Education: Expérience: EducationCollege/CEGEPWork settingOfficeTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist in the...

  • software developer

    Found in: Talent CA 2 C2 - 4 days ago


    Markham, Canada Galaxy Security Corporation Full time

    Education: Expérience: EducationBachelor's degree or equivalent experienceTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist...

  • software developer

    Found in: Talent CA 2 C2 - 2 weeks ago


    Markham, Canada Powernode Computer Inc. Full time

    Education: Bachelor's degreeExperience: 3 years to less than 5 yearsTasksWrite, modify, integrate and test software codeMaintain existing computer programs by making modifications as requiredCommunicate technical problems, processes and solutionsPrepare reports, manuals and other documentation on the status, operation and maintenance of softwareAssist in the...