| SQL DeveloperHealthcare Claim MUST Loc: Reston, VA Initial remote at Reston, Virginia, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=405935&uid= From: bhumika, adifice tehnologies [email protected] Reply to: [email protected] Title: SQL Developer (Healthcare Claim MUST) Location: Reston, VA (Initial remote) Duration: Long term Visa: GC/USC/H4/ L2/ GC-EAD Rate: $65/hr C2C Need candidate only trusted parties only Seeking an SQL Developer to assist our client with building a data store for their automation enterprise goals. Role and responsibilities include: - 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 Required Skills: - 6+ years experience of SQL Server Development experience (must have version 2019 R2) - Must have solid understanding of different types of healthcare claim transactions such as 837, 834, 270/271, 276/277 - 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 - Experience with 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. - Must have extensive experience with Agile or Scrum methodologies. - Must have excellent communication skills, both verbal and written (in English). Preferred: - Good to have used Azure or AWS Data Factory to create pipelines and orchestrate data movement from on premise to azure SQL databases and azure/blob storages. - 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 Keywords: business intelligence green card Virginia http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=405935&uid= |
| [email protected] View All |
| 02:14 AM 25-Jun-23 |