SSIS Developer

Experience these Xtraordinary benefits when you join Med-Metrix

• 8-Hour Shifts, Fixed Weekends Off

• Day 1 HMO with 2 of your dependents covered for FREE

• Medical Cash Allowance

• Rice Allowance

• Clothing Allowance

• Free Lunch Daily

• Paid Time Off

• Training and Staff Development

• Employee Engagement Activities

• Opportunities for Internal Mobility

Description

• 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 requirement 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.

• Participates 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.

Requirements

• Requires a four-year degree in Computer Science/Information Technology

• Minimum two years working as a Database engineer or a related role.

• Minimum of one year 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.

• Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations.

• Strong oral and written communication skills with the ability to communicate technical and non-technical concepts to peers, customers, and management

• Must be capable of routinely making effective and timely decisions in alignment with departmental direction and based on sound business knowledge and industry best practices.

• Require ability to work independently with minimal supervision

• Ability to multi-task with several complex and demanding Projects

Working Conditions:

• Remote: You'll be joining a distributed, fully remote team. Experience working remotely is a plus.

• Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear.

• Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress.

• Work Environment: The noise level in the work environment is usually minimal.

• Work Timings: You are expected to work in Eastern time zone with US team initially.