DI ETL Developer – Senior

1 week ago


Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time
Senior Data Integration (DI) ETL Developer

We are looking for a Senior Data Integration (DI) ETL Developer to join our team. As a Senior DI ETL Developer, you will play a crucial role in loading target databases with complex transformations from various systems. Your responsibilities will include monitoring loads, troubleshooting issues, collaborating with ETL Design and Project Leads, participating in design sessions, and more.



Duties:
  • Load target databases using complex transformations from multiple systems
  • Monitor loads and troubleshoot any arising issues
  • Meet with ETL Design and Project Leads to understand business, financial, and operations requirements
  • Participate in design sessions and code reviews
  • Collaborate in planning, design, development, and deployment of new functionality
  • Develop test scenarios and perform in-depth unit tests
  • Define ETL job sequence, dependencies, and error logging processes
  • Understand and develop ETL processes based on Business Requirements Document (BRD)
  • Participate in Agile team meetings

Skills and Experiences:
Must Have:
  • 3 to 5 years of ETL/DI experience
  • 3+ years of development experience in Python, Pyspark
  • 3+ years experience in IBM InfoSphere tool suite (DataStage & QualityStage)
  • 3+ years development with database technologies
  • 1+ year experience with data warehousing methodologies
  • Teradata experience

Nice to have:
  • Cloud Technologies knowledge (Azure, AWS, etc.)
  • Familiarity with Agile methodology
  • Familiarity with JIRA


  • Ottawa, Ontario, Canada SegmentStream LTD Full time

    We are looking for a Senior Data Engineer to join the core product development team of SegmentStream and own the data & ETL architecture of our next-generation marketing analytics platform. If you are really passionate about AI & ML, enjoy working with the latest data technologies and tools, and want to make a great impact on our global success, you found...


  • Ottawa, Ontario, Canada CB Canada Full time

    Company DescriptionFounded in 1967, ADGA is a privately owned and operated Canadian company. We employ over 700 highly skilled team members who apply their knowledge and expertise in service delivery of advanced technology solutions for clients in the Defence, Security and Enterprise Computing markets across Canada.Celebrating over 50 years in business, we...


  • Ottawa, Ontario, Canada SegmentStream LTD Full time

    We are looking for a Senior Data Engineer to join the core product development team of SegmentStream and own the data & ETL architecture of our next-generation marketing analytics platform. If you are really passionate about AI & ML, enjoy working with the latest data technologies and tools, and want to make a great impact on our global success, you found...

  • Senior Developer

    2 days ago


    Ottawa, Ontario, Canada National Research Council Canada Full time

    Priority may be given to the following designated employment equity groups: women, Indigenous peoples* (First Nations, Inuit and Métis), persons with disabilities and racialized persons*. The Employment Equity Act, which is under review, uses the terminology Aboriginal peoples and visible minorities. Candidates are asked to self-declare when applying to...

  • Software Developer

    1 week ago


    Ottawa, Ontario, Canada MD Financial Management Full time

    Requisition ID: 194846 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Global Wealth Engineering client technology team is transforming the digital experience for its clients. The team partners and works closely with the Scotia Digital team to bring world-class digital experiences for all Scotia...

  • Senior Developer

    1 week ago


    Ottawa, Ontario, Canada Agility PR Solutions Full time

    About the role : As a Senior Java developer , you will mentor other developers and be responsible for the overall architecture and evolution of backend software components. You will be creating and implementing software designs, but also reviewing and overseeing the designs and implementations of other team members. You may also be asked to delegate tasks...

  • Python developer

    1 week ago


    Ottawa, Ontario, Canada CGI Full time

    Software Developer (Python)Position DescriptionWe are seeking an experienced Software Developer to contribute to the development of innovative Human Capital Management (HCM) solutions.Clearance:Reliability or eligible (must be a resident of Canada for 5+ years)Location: RemoteYour Role:The Software Developer will be in charge of creating new products and...


  • Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    Poste chez Canadian Medical Protective Association • DATA INTEGRATION ANALYSTCONTRIBUTING TO THE CMPAActuarial Services supports the CMPA's mission and goals through proper valuation of the Association's liabilities. This is accomplished through detailed actuarial work following the Standards of Practice set by Canadian Institute of Actuaries. The...


  • Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    Position at Canadian Medical Protective Association • DATA INTEGRATION ANALYSTCONTRIBUTING TO THE CMPAActuarial Services supports the CMPA's mission and goals through proper valuation of the Association's liabilities. This is accomplished through detailed actuarial work following the Standards of Practice set by Canadian Institute of Actuaries. The...


  • Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    Poste chez Canadian Medical Protective Association • DATA INTEGRATION ANALYSTCONTRIBUTING TO THE CMPAActuarial Services supports the CMPA's mission and goals through proper valuation of the Association's liabilities. This is accomplished through detailed actuarial work following the Standards of Practice set by Canadian Institute of Actuaries. The...


  • Ottawa, Ontario, Canada Canadian Medical Protective Association Full time

    Position at Canadian Medical Protective Association • DATA INTEGRATION ANALYSTCONTRIBUTING TO THE CMPAActuarial Services supports the CMPA's mission and goals through proper valuation of the Association's liabilities. This is accomplished through detailed actuarial work following the Standards of Practice set by Canadian Institute of Actuaries. The...


  • Ottawa, Ontario, Canada Fullscript Full time

    Fullscript is making optimal care easy for everyone. Through our care delivery platform, health practitioners can seamlessly design personalized health plans, provide support and education tools, and effortlessly prescribe and manage the use of healthcare's best supplements — all in one place.Since 2011, Fullscript has enabled over 90,000 practitioners to...


  • Ottawa, Ontario, Canada CB Canada Full time

    Senior Software Developer ( Performance testing/Performance optimization ) Senior Software Developer (Performance testing/Performance optimization)On behalf of our client, Procom is looking for a Senior Developer who strives on building high-quality solutions for both performance test automation and data engineering of performance information to help...

  • Software Developer

    1 week ago


    Ottawa, Ontario, Canada MD Financial Management Full time

    Is this role right for you? In this role you will: Lead technical decisioning for the scrum teams, collaborating with solutions architects and other technical leads. Capable of applying technological knowledge to the design and implementation of software Work at the highest technical level of software development while maintaining a good knowledge of...


  • Ottawa, Ontario, Canada Fullscript Full time

    Senior Fullstack Developer, Identity Access Management Fullscript is making optimal care easy for everyone. Through our care delivery platform, health practitioners can seamlessly design personalized health plans, provide support and education tools, and effortlessly prescribe and manage the use of healthcare's best supplements — all in one place. Since...


  • Ottawa, Ontario, Canada 2i Solutions, Inc Full time

    Job Title: Senior Drupal DeveloperCompany: Innovative Solutions Inc.We have an exciting year-long contract opportunity with the possibility of extension for a Senior Drupal Developer position in either Toronto or Ottawa.This position allows for mostly remote work.Requirements:6+ years of experience in developing web solutions using DrupalAdvanced...


  • Ottawa, Ontario, Canada Curtiss-Wright Corporation Full time

    Senior Business System Developer (SAP) Onsite Ottawa We are looking for Senior Business System Developer (SAP) to join our world class organization in Ottawa, ON. As our Senior Business System Developer (SAP) you will be responsible for designing, building, and supporting system/reporting solu

  • Senior Developer

    1 week ago


    Ottawa, Ontario, Canada Skylock Full time

    Skylock is a blockchain security startup dedicated to protecting DeFi protocols from smart-contract hacks. Our mission is to detect and block malicious transactions in real-time, ensuring the stability and security of the blockchain industry. We are a small, dynamic team with a strong technical focus and we are looking for a motivated individual to lead our...


  • Ottawa, Ontario, Canada CB Canada Full time

    Senior Software Developer Job Description:We are looking for a skilled, dynamic, and motivated Software Developer who will be responsible for developing world-class messaging systems that meet remarkably high standards of quality, performance, and reliability on a massive scale to a diverse array of customer environments. The flagship product suite, Solace...


  • Ottawa, Ontario, Canada Fullscript Full time

    Fullscript is making optimal care easy for everyone. Through our care delivery platform, health practitioners can seamlessly design personalized health plans, provide support and education tools, and effortlessly prescribe and manage the use of healthcare's best supplements — all in one place.Since 2011, Fullscript has enabled over 90,000 practitioners to...