Senior Developer

TSQL/SQL Server Developer Looking for a TSQL/SQL Server Developer!! Candidate must have extensive handson experience with TSQL!! Only considering candidates with strong Healthcare domain and EDI Transaction experience!!

Remote but the candidate must work in the EST Hours only

Manager Notes: Absolute Must Have!!

Candidate must know how to build the test data automation process and the test automation framework

Looking for Senior SQL Dev. Extensive exp in designing and development of database solutions

Design, develop and support the SQL Server 2019 R2 data warehouse by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex T-SQL queries

Needs to have good data profiling skills.

Goal is to move to Cloud soon so any exp with Azure or AWS Is nice to have

Needs to have good exp with EDI transactions. X12.. 835/834, 270/271

Need good comm skills as they will be working with many other teams.

Needs to have good exp with Jira and PowerBI.

Needs to have T-SQL expertise

For now they are using SQL Server but they will migrate it all to cloud in the future

Ex: If the EDI files are in server, will need to extract and put into databases

Sometimes they use Python to extract data, but that is only a preference

Top Skills Required

TSQL Development

SQL Server 2019

SSIS

Some level of cloud experience Azure or AWS (Azure is highly preferred)

Candidates must have experience with claim transactions such as 837, 834, 270/271, 276/277.

Python

JIRA/PowerBI

Role and Resp:

Develop SSIS packages using transformation tasks and script task to process excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table

Develop procedures, functions and other database objects to implement business logic using TSQL.

Design, develop and support the SQL Server 2019 R2 data warehouse by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex T-SQL queries

Develop functional and technical documentation to assist in the design, development and/or maintenance of deliverables

Requirements

8 years experience

Exposure to Automation software Testing and Test data generation using TSQL.

Understanding of different data structures such as JSON, X12 and XML and generation of files using TSQL

Good to have used Azure Data Factory to create pipelines and orchestrate data movement from on premise to azure SQL databases and azure/blob storages.

Used Power BI to produce Dashboards and KPI data for other teams and created interactive dashboards of scorecards.

Created interactive and highly informative reports, collaborate with different users and stakeholders to work on live data sources, performing data analytics and generating insights as per business requirements

Created Complex ETL Packages using SSIS to extract data from staging tables, JIRA or other APIs as incremental load.

Good understanding of different types of claim transactions such as 837, 834, 270/271, 276/277.

Good understanding in continuous integration within DevOps environment.

Good to have Experience working with GIT/BitBucket.

Good to have JIRA application and API exposure

Good to have Python programming exposure

Must have ability to work independently.

Must have extensive experience with Agile or Scrum methodologies.

Must have excellent communication skills, both verbal and written (in English).