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.

Responsibility:

  • 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