Senior Developer

Job Opportunity

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

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