ETL Developer

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!