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