Allscripts 2021 job vacancy in Pune As “SQL and ETL Developer”

Allscripts 2021 job vacancy in pune As “SQL and ETL Developer” | – Jobsdhost

Allscripts SQL and ETL Developer job details are given below

Company Name: Allscripts Healthcare

Company URL: https://as.allscripts.com/

Experience: 2+ Years

Qualification: Any Graduate / Any Post Graduate

Location: Pune

Role: SQL and ETL Developer

Employment Type: Full Time, Permanent

Allscripts – SQL and ETL Developer 2021 job vacancy in pune

Job Description

Position: SQL and ETL Developer

Development skills:

Minimum 2 years’ experience with SQL ETL and Database Development and Support with SAFe
Experience with healthcare EHR and Clinical software knowledge highly desired.
Experience in Operations Improvements & Development
Experience with Deployments, DevAssist, customer cases, monitoring and troubleshoot systems
Good understanding of Object-oriented concepts

SQL skills:

Strong SQL and pure SQL ETL knowledge and experience is essential for debugging and troubleshooting.
Strong experience in SQL Stored procedures and SQL complex queries for ETL
Good understanding and experience on SQL indexes
Good understanding on SQL Partitions
Good understanding on SQL Agent /SQL Jobs
SQL Performance tuning, is a very big plus
Experience and or strong approach in SQL and Software Internal tools development
Any scripting and programming language knowledge and experience would be a highly plus
BI or Reporting suite knowledge, a plus

Soft skills:

Team player
Self-motivated to be highly productive in a virtual work setting as much as an office setting considering the pandemic and post pandemic era
Quick Learning, Good grasping
Easy adoption to work culture, dynamically changing role / responsibilities, open for technologies and challenges
Problem-solving attitude, Innovative and creative thinker and implementer,
Must possess strong verbal and written communication skills

Processes skills:

Good understanding of Agile/SAFe Agile methodologies and should be a practitioner of agile processes for a few years
Hands on experience for TFS processes
Should have Software/Product development processes knowledge and should be a strong practitioner of it.

Implementing ETL process through T-SQL based on clinical workflows
Work on SQL performance tuning by improving the code
Construct/Modify Schema/tables in SQL to hold the Summarized or historic information of the outcome of clinical and financial data
Trouble shooting and Analyzing issues, workflow gaps using SQL, logical and analytical skills.
Design procedures for system troubleshooting and maintenance
Build tools to reduce occurrences of errors and improve customer experience
Work in the direction of the Manager to provide application solutions for assigned business areas
Interact with business users to understand new business requirements and enhancement requests
Good understanding of Agile methodologies and should be a practitioner of agile processes for a few years
Hands on experience for TFS processes Responsibilities
Develop software to integrate with internal back-end systems
Develop scripts to automate the overall processes
Any basic reporting through reporting tools
Perform root cause analysis for production errors

How to Apply:

Click Here to Apply