The Senior SQL Developer will be collaborating with cross-functional IT Development Team. This role will be developing and maintaining the products. However, majority work is doing maintenance, supporting the evaluation team and this is not a client-facing role

• Develop Complex ETL and Analytics Programs using SQL, Store Procedures and various query tools. • Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement. • Develop, maintain and support SQL Server Integration Services (SSIS) packages related to the extraction, transformation and loading (ETL) process using Microsoft SQL Server 2012 or later • Maintain HIPPA transactions specifically 835 and 837 transaction sets, create the ad hoc reports to query the transaction sets. • Responsible for data profiling as well as SQL and database tuning / optimization • Analyze the client requirements and design technical solutions based on those requirements. • Perform day to day troubleshooting of issues related to QA and Production. • Design ETL audit control and scheduling processes. • Develop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issues • Guide the developers in the team to implement the client requirements and review the software developed by the team members. • Provide technical leadership by making recommendations for application development to enhance the existing solution or resolve production issues • Work within a fast-paced, objective oriented environment • Managing and versioning the SSIS projects using Visual Studio Foundation Server. • Participate in Client meetings, lead technical review meetings with team and/or client as required. • Responsible for providing accurate and timely communication of the status of assignment, job responsibilities, and the resolution of problems to the appropriate parties following established policies and procedures.

• Requires a four-year degree in Computer Science/Information Technology
• Minimum five (5) years working as a Database engineer or a related role.
• Minimum of two (2) years of SSIS experience
• Thorough understanding of database structures, theories, principles, & practices.
• Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers,
indexes, & constraints.
• Extensive knowledge of MS SQL Server
• Extensive knowledge with SSRS\SSIS\T-SQL
• Experience with C and\or VB.NET.
• Technical knowledge of MS SQL Server internals with emphasis on query performance.