JOB: SQL Developer (Need 10+ yrs ooverall experience)

Location NYC,NY

Long Term Contract

Responsibilities:

• Design, develop, and optimize complex SQL queries and stored procedures to support data integration and reporting needs.
• Collaborate with cross-functional teams, including data architects, business analysts, and application developers, to understand integration requirements and ensure data integrity.
• Participate in the design and implementation of database structures, schemas, and data models to facilitate efficient data storage and retrieval.
• Perform data analysis and profiling to identify data quality issues and propose solutions for remediation.
• Develop and maintain ETL processes to extract, transform, and load data from various sources into target databases.
• Monitor database performance, troubleshoot issues, and implement optimization strategies to enhance query performance and system efficiency.
• Ensure compliance with data governance and regulatory requirements within the financial services industry.
• Document database designs, processes, and procedures to maintain a clear record of technical specifications.
• Mentor junior developers and provide guidance on best practices in SQL development and database management.

Requirements:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 5+ years of experience as an SQL Developer or in a similar role, preferably within the financial services industry.
• Strong proficiency in SQL, T-SQL, and experience with relational database management systems (e.g., Microsoft SQL Server, Oracle).
• Experience with ETL tools (e.g., SSIS, Informatica, Talend) and data integration methodologies.
• Solid understanding of database design principles, indexing strategies, and query optimization techniques.
• Familiarity with data modeling tools and methodologies.
• Knowledge of financial services products and regulatory requirements is a plus.
• Excellent analytical and problem-solving skills, with a strong attention to detail.
• Strong communication and interpersonal skills, with the ability to work collaboratively in a team environmen