SQL SERVER,MSBI(SSIS,SSRS,POWER BI)
-
Strong technical knowledge in SQL, SSIS, SSRS.
- Extensive experience with writing batch routines involving complex business scenarios and scheduling them.
- Strong healthcare domain knowledge (Healthcare Terminology)
- Good understanding of the Facets Data Model
- Good understanding and working experience in Member Enrolment, Claims Processing, and Stars Measures.
- Ability to develop relationship with stakeholders and understand the requirements through excellent listening and effective written and verbal communication
- Self-driven, innovation, motivated, well-organized, willingness to work on an onsite/offshore model and ability to work in remote setting.
- Exemplary personal and professional integrity
- Minimum of three to five years’ experience in software development required, with demonstrated expansion of skills over that time.
- Experience working in a project integrating data with MDM platforms preferred.
- Experience writing and tuning complex SQL statement and reporting in RDBMS such as SQL Server, Oracle, DB2, SSRS, Performance Point or Teradata required.
- Java or C# and .Net along with scripting, python and cypher experience preferred.
- Experience with common ETL tools (SSIS, IBM Datastage, Ab Initio, Informatica, Talend) is a plus.
- Experience working with GitHub / source-control systems.
- Knowledge or experience interfacing with Restful or SOAP API’s in both real-time and batch applications is required.
- Must have and maintain a valid driver’s license unless otherwise noted.
- Basic knowledge of CLI tools / dotnet cli build commands.
- Extensive knowledge of SQL Server including the writing of complex stored procedures, functions and SSIS packages as well as basic knowledge of database administration
- Strong understanding and experience of database development methodologies (Agile and Scrum)
- Expert level knowledge of SQL administration, engineering, and monitoring tools
- Demonstrated expertise in performance tuning including both query and server optimization
- Experience with the LOOKML, SQL reporting/data visualization with Looker
- Use Looker tools such as Looker IDE, SQL Runner, & LookML Validator
- Strong knowledge and experience in data modeling, relational database design, optimization for performance, T-SQL, stored procedures, SSIS packages
- Expertise in understanding complex business needs, analyzing, designing and developing solutions
