Their environment is primarily SSIS and SQL Server shop – they need to move data with ETL and SSIS on prem SQL Server and move data and process with SSIS
They are now moving to cloud environment slowly – building ADF instance for all future ETL – build out ELT in ADF – Azure Data Factory- and move data in the cloud
need to be okay doing both ADF/Databricks AND SSIS SQL work
Building out platform to centralize company data into stakeholder 360 is their own customer 360 – data points on clients (hospitals and clinics)
Bring application data into databases to be able to do integration, interoperability, grab all data for future use cases into this data bricks platform
Job Description:
We are seeking a talented Data Developer with strong SQL skills to support the QA effort within the teams and work on enterprise data projects related to ETL development, production support, SQL development, and other related data initiatives.
Requirements: Experience:
Ability to lead QA efforts independently.
Provide objective, accurate, and comprehensive feedback to team members regarding defects and errors.
Draft quality assurance policies and procedures, and design, develop, and execute testing plans.
Work extensively with Azure services (Azure Functions, web apps, Azure Key Vault, Logic Apps).
Build ADF pipelines for various data development projects.
Build data transformations with SSIS, including importing data from files and moving data from one database platform to another.
Possess strong knowledge of relational databases, as well as skills in SQL query design and development.
Leverage best practices for error handling, error resolution, and archival processes.
Have strong knowledge of stored procedures and performance tuning, as well as skills in SQL query design and development.
Expertise in cloud deployments of ADF.