Arc Solutions

SQL Developer

Data Engineer in New York, NY

Posted 2020-01-18

Seeking Experienced Sql Developer - who can understand the process of -How to write the multiple joints and BI SSSI Packages. This position requires in person interview at client site in Purchase, NYC after phone round.Please review detail job description and apply asap.

Main skills required :
1)Consultant should have work with Insurance Domain during his career -at least 1-5 years experience required.
2)Strong communication skills required

Develop complex queries and stored procedures using T-SQL
Understand and analyze requirements to develop, test, configure and deploy complex SSIS packages. Use of SQL Server 2012, 2014 or 2016 experience to implement robust, maintainable solutions that meet requirements
Evaluate large and complex data sets
Troubleshoot SSIS packages to address critical production issues.
Assist application developers in refining complex queues and performance tuning
Create tables, assign permissions, import data, perform app configurations, etc.
Write and maintain technical documentation
Manage source code versioning and deployments
Stay knowledgeable with the latest advances in SQL Server and other data technologies

Minimum Qualifications:

7+ years development experience with Microsoft SQL Server including recent experience with 2014, 2016 and or 2017
7+ Years' experience coding T-SQL including the use of dynamic SQL
5-7 Years of SSIS development experience in developing ETL applications
Data warehouse development experience using SSIS/SQL best practices including the development of reconciliation and validation frameworks
Working knowledge of best practices for loading a data into normalized and/or Star schemas
Experience with best practice SSIS design patterns
Demonstrated skill and ability in interfacing programmatically with a variety of enterprise systems
Familiarity with source code management systems (TFS)

Preferred Qualifications:

Experience with development in other aspects of the Microsoft BI Stack – SSAS/SSRS a plus
Excellent written and verbal communication skills with the ability to formulate and communicate recommendations
Quick learner
Analytical, Problem Solving, creative thinking and design skills
Clearly demonstrated sense of urgency and bias for action
Ability to work well under pressure and independently

Ready to be seen?

Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.

Be seen in a new Data Engineer job

Skip the search

Zero stress and one profile that can connect you directly to 1000s of companies.

Best-fit jobs—for you

We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.

Free Career Coaching

Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.

You get tech. We get you.

Join now and be seen.