RQ08442 - Software Developer - Senior

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.

Demonstrated experience with MS SQL Server performance tuning (Profiler Tracing Execution Plan Analysis) data and application integration (ETL SSIS OS scripting) and data migration

Demonstrated ability to translate complex business requirements into technical solutions

Experience with and knowledge of UI Design Principles

Experience in SOAP and REST web services for processing realtime data streams

Demonstrated experience in responding to and troubleshooting issues related to data quality and performance and resolve them in a timely manner.

Experience working with teamcollaboration tools (Confluence and Jira)

• Proven experience developing ETL processes specifically in the Azure cloud environment.
  
• Ability to optimize ETL processes for performance and scalability.
  
• Strong skills in troubleshooting and debugging ETL processes to identify and resolve issues efficiently.
  

10 years of demonstrated experience in development of enterpriselevel 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 911 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.
  

Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills.

Strong consulting skills to engage with all stakeholders lead meetings with internal and external clients to gather and document business requirements.

Ability to work with minimal supervision in an agile environment be an effective communicator with other team members and the business owners.

A demonstrated team player with a proven track record for meeting deadlines

Demonstrated experience in creating of conceptual logical and physical data documentation for knowledge retention and transfer.

Experience in working on multiple projects at the same time

Experience in working on multiyear projects

Experience with building enterprise level reporting solutions that protect highsensitive information

Requirements

MUST HAVES:

10 years of experience in database and ETL development with Microsoft SQL Server including Microsoft SQL Server Reporting Services.

Experience in SOAP and REST web services for processing realtime data streams

Demonstrated experience with MS SQL Server performance tuning (Profiler Tracing Execution Plan Analysis) data and application integration (ETL SSIS OS scripting) and data migration