View all jobs

ETL Developer

Posted 2 months 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.