Overview
On Site
Accepts corp to corp applications
Contract - Long term
Skills
Data Modeling
Data Migration
Best Practices
SQL
Database Modeling
ETL
Database
Oracle
SQL Queries
Data Integration
informatica
Stored Procedures
MS SQL Server
data quality
t-sql
Data Analysis
remediation
Database Management
Large-Scale
Data Governance
Marketing Analysis
Relational Database
Financial Services
mentor
Problem-Solving
Data Integrity
Technical Specifications
Job Details
Senior SQL Developer
Alpharetta, GA (Need Onsite day 1, Hybrid 3 days from office)
Job Description:
We are seeking a highly skilled Senior SQL Developer to join our technical integration team. The ideal candidate will have extensive experience in SQL development, database design, and data integration within the financial services sector. This role involves working on large-scale projects to ensure seamless data migration, transformation, and integration between various systems.
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.
- 10+ 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 environment.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.