ETL Developer
View all jobs

ETL Developer

Posted 1 week ago
Apply Now
Shortlist

Job Description


Job title: ETL Developer

Company: LanceSoft

Job description: Must haves:

  • 10+ years of experience in database and ETL development with Microsoft SQL Server including Microsoft SQL Server Reporting Services.
  • Demonstrated experience with database architecture, data modeling, logical and physical database design (OLTP, OLAP, Data Warehousing, ERwin, Visio, UML) and database capacity planning.
  • 10+ years of demonstrated experience in development of enterprise-level information technology solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing applications utilizing Microsoft SQL Server.
  • Deep understanding of Azure data services such as Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure SQL Data Warehouse, Azure Data Lake Storage, etc.
  • Proficiency in ETL tools and frameworks for data integration and transformation, such as Azure Data Factory, Apache Spark (Azure Databricks), Apache NiFi, Talend, or Informatica.

Technical Skills:

  • 10+ years of demonstrated experience in development of enterprise-level information technology solutions by analyzing, coding, configuring, testing, and implementing new and by modifying/enhancing existing applications utilizing Microsoft SQL Server.
  • Demonstrated experience in all aspects of the software development cycle (SDLC, Agile)
  • Experience with designing and developing solutions for a 9-1-1 Public Safety environment
  • Demonstrated experience in DELIVERING and MEETING project deliverable timelines.
  • Deep understanding of Azure data services such as Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure SQL Data Warehouse, Azure Data Lake Storage, etc.
  • Proficiency in ETL tools and frameworks for data integration and transformation, such as Azure Data Factory, Apache Spark (Azure Databricks), Apache NiFi, Talend, or Informatica.
  • Strong programming skills in languages commonly used for ETL processes, such as Python, Scala, or C#.
  • Expertise in SQL for data querying and manipulation.
  • Understanding of data modeling concepts and experience with database design.
  • Familiarity with data integration patterns and best practices for handling large volumes of data in a cloud environment.
  • Ability to implement data quality checks and validation processes to ensure the accuracy and completeness of the data.
  • Proficient in version control systems like Git for managing and tracking changes to the ETL code.
  • Experience in setting up monitoring and logging for ETL processes to track performance, identify issues, and ensure data integrity.
  • Understanding of data security principles and experience implementing security measures in ETL processes.
  • Knowledge of compliance requirements relevant to the industry.
  • Skill in automating ETL workflows and orchestrating data pipelines using tools like Azure Logic Apps or Apache Airflow.

Expected salary:

Location: Toronto, ON

Job date: Fri, 11 Oct 2024 03:25:28 GMT

Apply for the job now!