SQL Server Developer

Global Business Ser. 4u; Jersey City (NJ); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Global Business Ser. 4u in Jersey City, NJ is seeking an experienced SQL Server Developer with Collibra to design and optimize OLAP schemas for Tier 1 and Tier 2 applications.

You will mentor the team, implement data quality and lineage measures, and support CI/CD deployments. The role requires 7 to 10 years of SQL Server development, strong data modeling (PowerDesigner), Collibra expertise, and financial services domain experience (Bank of America systems preferred).

Qualifications

• 7–10 years of SQL Server development experience.

Skills

SQL Server

Data Modeling

Collibra

OLAP

Stored Procedures

Performance Tuning

CI/CD

Jenkins

DACPAC

Informatica/SSIS

Unix

Version Control

Tools

Collibra

PowerDesigner

Jenkins

DACPAC

Informatica PowerCenter 10.x

OSS/Bitbucket

Job description

Role: SQL Server Developer with Collibra

Location:Jersey City, NJ (Hybrid Role )

At: [e-mail]

Must Haves

• The core skills and experience (7 to 10 years) that we are looking for are as follows:
• Strong SQL Development Skills (esp. MS SQL Server)
• Data Architecture (Data Modeling using PowerDesigner)
• Metadata Management Tool (Collibra)
• Financial Services experience (preferably – BofA systems) – is a must.
• Strong SQL Server development experience required. Analyze, Design and Mentor team on designing OLAP database schema.
• Design tables, stored procedures, views, indexes, user defined functions, and other DB objects to support delivery on multiple Tier 1 and Tier 2 applications.
• Analyze and performance tune SQL queries to reduce the response time without impacting the application.
• Implement and document better practices for DB object creation , maintenance , performance tuning and optimization for future development.
• Develop and document data quality, data discovery and data lineage measures. Experience in CI-CD (Jenkins/DACPAC) deployments.
• Good to have Informatica or SSIS development experience.
• 10+ years SQL Server development experience.Informatica PowerCenter 10.x, Oracle 11g/12c SQL/PLSQL, AutoSys
• Familiar with any version control tool
• Unix Concepts
• Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
• Agile best practices

Skill Category

Data

Skill Title

Database Developer

Skills

SQL Server