Job Description
SQL Database/ SSIS Developer
Job Description:
Seeking a SQL Developer to join our data team in analyzing, developing
SSIS projects, custom reports and work closely with the team on any SQL
platform issues. This is an excellent opportunity for an ambitious and agile
person looking to grow and learn in a very fast paced environment
Responsibilities:
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 SSRSSSIST-SQL
Experience with C# andor 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 Project
