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). Samprasoft