SSIS/SQL Server Developer/Solutions Architect

TecTammina; Livingston (NJ); On-site; USD 95,000 - 120,000; Full time

Job summary

A technology services company in Livingston, New Jersey, is seeking an experienced SSIS/SQL Server Developer/Solutions Architect. This full-time role involves leading ETL development, optimizing performance, and collaborating with project teams. The ideal candidate has extensive experience in SQL Server database development, logical data modeling, and strong communication skills. A BS/MS in Computer Science or equivalent is required, along with significant experience in the Financial Services industry. This position promises a challenging yet rewarding opportunity.

Qualifications

• 5 years of experience in logical and physical data modeling.
• 5 years of SSIS development in the more recent versions of SSIS.
• 7 years of SQL Server database development.

Responsibilities

• Participate in the ETL development function for a small data management program.
• Comprehend Source to target mapping specifications, design, code and testing.
• Lead design and analysis sessions with developers to ensure sound team decision-making.

Skills

ETL development

SQL Server database development

Performance tuning

Strong SQL development skills

Oracle PL/SQL

Data modeling

Excellent communication skills

Education

BS/MS in Computer Science or equivalent

Bachelor’s degree or foreign equivalent

Job description

Overview

SSIS/SQL Server Developer/Solutions Architect

• Full-time

Responsibilities

• Participate in the ETL development function for a small data management program
• Comprehend Source to target mapping specifications, design, code and testing
• Participate in code reviews of ETL, SQL processes
• Performance tuning and optimization
• Lead design and analysis sessions with developers to ensure sound team decision-making, and come up with the best appropriate solutions
• Standardize all design and development processes across the ETL framework
• Lead smaller on and offshore project teams to accomplish given project deliverables

Qualifications

• 5 years of experience in logical and physical data modeling
• 5 years of SSIS development in the more recent versions of SSIS
• 7 years of SQL Server database development
• Experience with SQL/Server 2008R2; 2012 a plus
• Very strong SQL development skills
• Performance tuning
• Knowledge of the latest releases of SQL Server
• 2 years of development or maintenance of Oracle PL/SQL packages
• Experience in developing of small to large data applications.
• Experience with leveraging 2008 R2 features such as partitioning, indexing schemes, table compression, etc
• Excellent oral and written communications skills
• Financial Services Industry experience
• BS/MS in Computer Science or equivalent
• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 7 years of experience with Information Technology.