ETL Developer (SSIS/ADF/Data Bricks)- Only W2 Consultants

Job Title: ETL Developer (SSIS/ADF/DataBricks)- Only W2 Consultants

Duration: 12 Months

Location: Irving, TX

Linkedin Is Mandatory

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.

Project Info:

• 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
• 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
• both ADF/Databricks AND SSIS SQL work
• Building out platform to centralize company data into stakeholder 360 customer 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

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.