ETL BI Developer

2 weeks ago

Toronto, Canada Maarut Inc Full time

Resource Profile

  • This requirement is for a ETL and BI Developer to work  with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and data integration and reporting tooling such as IBM Infosphere Information Server DataStage and/or Cognos. Experience with the Guidewire suite or the insurance industry general would be an asset.

Resource Responsibilities

  • Analyze and assess legacy data landscape and reporting solutions and ascertain and identify the impacts to the legacy reporting based on the Dynamic Intake modernization initiative.
  • Design, develop, implement, and support through the full development lifecycle the creation/modification/enhancement of the data pipelines and reporting product as per requirements to support the modernized solution working with the broader Dynamic Intake project team
  • Monitor and administer automated and manual data integration and ETL and reporting jobs to verify execution and measure performance.
  • Work with management to provide technical assistance, advice and guidance to client IT staff and business clients in response to enquiries on the functionality of BI/ETL tools, and data in warehouse and related data marts to ensure efficient and uninterrupted IM services to the business users.

 



Requirements

Knowledge & Skills

MUST HAVE:

  • 5+ Years of experience in designing, developing, testing and implementing Extract/Transform/load (ETL) data pipelines and reporting with InfoSphere DataStage and/or Cognos
  • 4+ years’ experience in data modelling and working with common data warehouse models
  • 4+ years’ experience doing analysis and developing with SQL (e.g. Oracle, MS SQL, DB2)
  • Strong understanding of Data Engineering best practices for moving large volumes of data
  • Experience writing well documented unit tests and executing them.
  • Experience of reverse-engineering data mappings based on application-layer code highly desirable.
  • Ability to express complex technical concepts effectively, both verbally and in writing


NICE TO HAVE:
  • Good knowledge of popular data standards and formats (e.g, JSON, XML, Proto, Parquet, Avro, ORC)
  • Experience working with high volume data exchange and transaction processing systems Experience writing well documented unit tests and executing them
  • Strong understanding of SDLC and Agile Methodologies
  • Degree in computer science, math, engineering or equivalent work experience Excellent Communication Skills
  • Experience working with the Guidewire Suite or in the insurance industry would be an asset.


  • ETL BI Developer

    2 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionResource ProfileThis requirement is for a ETL and BI Developer to work  with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and data integration and reporting tooling such as IBM Infosphere...

  • BI Developer

    3 weeks ago

    Toronto, ON, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • BI Developer

    4 weeks ago

    Old Toronto, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • BI Developer

    3 weeks ago

    Old Toronto, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • BI Developer

    3 weeks ago

    Old Toronto, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • BI Developer

    19 minutes ago

    Old Toronto, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • ETL Developer

    3 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job...

  • Software Developer

    3 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    Title: Software Developer - ETL – Senior Duration: Business Days Location: Jarvis St, Toronto, Toronto, Ontario (Hybrid) General Skills:  Experience in programming and analysis; specialized software package support at the specified experience level  ...

  • BI Developer-Tableau/SQL

    3 weeks ago

    Toronto, ON, Canada Winsopro Full time

    We are seeking a skilled and experienced Business Intelligence (BI) Developer to join our team. As a BI Developer, you will be responsible for designing, developing, and maintaining our business intelligence solutions. You will collaborate with stakeholders to gather requirements, design data models, and create insightful reports and visualizations. Your...

  • ETL Developer

    3 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionJob...

  • BI Specialist/etl Specialist

    4 weeks ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Arthur Grand Technologies is currently seeking a highly motivated and skilled **Business Intelligence Specialist - Senior **for one of our clients. **Position: Business Intelligence Specialist - Senior** **Location: 315 Front St. West, Toronto, Ontario (Hybrid)** **Hybrid - 3 days on site and 2 days remote** **Duration: Long Term Contract** **MUST...

  • ETL Developer

    3 days ago

    Old Toronto, Canada Zortechsolutions Full time

    Role: ETL DeveloperLocation: Toronto, ONDuration: Full TimeJob DescriptionSkills and Responsibilities: ETL data warehouse- MS SSIS/SSRS- IBM Netezza, MS SQL server/Sybase database Hadoop (Hive SQL and Pentaho ETL design) AWS Cloud services (Spark, Redshift and EMR) Knowledge in lending systems and functional knowledge on the same Knowledge in MDM systems for...

  • ETL Developer

    2 days ago

    Old Toronto, Canada Zortechsolutions Full time

    Role: ETL DeveloperLocation: Toronto, ONDuration: Full TimeJob DescriptionSkills and Responsibilities: ETL data warehouse- MS SSIS/SSRS- IBM Netezza, MS SQL server/Sybase database Hadoop (Hive SQL and Pentaho ETL design) AWS Cloud services (Spark, Redshift and EMR) Knowledge in lending systems and functional knowledge on the same Knowledge in MDM systems for...

  • ETL Developer

    2 days ago

    Old Toronto, Canada Zortechsolutions Full time

    Role: ETL DeveloperLocation: Toronto, ONDuration: Full TimeJob DescriptionSkills and Responsibilities: ETL data warehouse- MS SSIS/SSRS- IBM Netezza, MS SQL server/Sybase database Hadoop (Hive SQL and Pentaho ETL design) AWS Cloud services (Spark, Redshift and EMR) Knowledge in lending systems and functional knowledge on the same Knowledge in MDM systems for...

  • ETL Developer

    39 minutes ago

    Old Toronto, Canada Zortechsolutions Full time

    Role: ETL DeveloperLocation: Toronto, ONDuration: Full TimeJob DescriptionSkills and Responsibilities: ETL data warehouse- MS SSIS/SSRS- IBM Netezza, MS SQL server/Sybase database Hadoop (Hive SQL and Pentaho ETL design) AWS Cloud services (Spark, Redshift and EMR) Knowledge in lending systems and functional knowledge on the same Knowledge in MDM systems for...

  • ETL Developer

    2 weeks ago

    Toronto, Canada Atlantis IT Group Full time

    ETL Developer with Financial Service TorontoMin. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domainMin. 10+ years of years of experience in developing automated scripts using SQL, VB Script and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • ETL Developer

    2 weeks ago

    Toronto, Canada Atlantis IT Group Full time

    ETL Developer with Financial Service TorontoMin. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domainMin. 10+ years of years of experience in developing automated scripts using SQL, VB Script and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • ETL Developer

    2 weeks ago

    Toronto, Canada Atlantis IT Group Full time

    ETL Developer with Financial Service Toronto Min. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domainMin. 10+ years of years of experience in developing automated scripts using SQL, VB Script and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • ETL Developer

    2 weeks ago

    Toronto, Canada Atlantis IT Group Full time

    ETL Developer with Financial Service Toronto Min. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domainMin. 10+ years of years of experience in developing automated scripts using SQL, VB Script and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • BI Specialist

    4 weeks ago

    Toronto, ON, Canada Nexus Systems Group Inc. Full time

    BI Specialist Typical Day in Role: • Collaborate with stakeholders to develop BI solutions to address operational needs • Combine multiple data sources across all contact center platforms and applications to build end-to-end BI products • Define metrics / KPIs and develop customer insights models • Assist MIS & Data Analytics team with architecture...