Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Able to Provide Sponsorship
Skills
SQL Server
Informatica
ETL
Powercenter
SSMS
SSIS
Azure
Azure SQL
AWS RDS
data quality
Job Details
Job Overview:
We are seeking a skilled SQL Server Developer with expertise in database development, performance tuning, and Informatica development to design, implement, and optimize data solutions that support business objectives. The ideal candidate will have hands-on experience with SQL Server, database development, and Informatica, as well as a strong understanding of performance optimization techniques.
Key Responsibilities:
- Design, develop, and maintain SQL Server databases, tables, stored procedures, functions, and views to support various application and reporting needs.
- Write optimized SQL queries and scripts for data extraction, transformation, and loading (ETL).
- Develop and maintain ETL processes using Informatica PowerCenter, ensuring data accuracy and integrity.
- Monitor, analyze, and optimize database performance by identifying bottlenecks and tuning queries, indexes, and server configurations.
- Collaborate with business analysts, data analysts, and other stakeholders to understand data requirements and translate them into technical solutions.
- Troubleshoot and resolve database issues promptly.
- Stay updated with the latest SQL Server features and improvements, and recommend enhancements to existing systems.
- Document database schemas, processes, and procedures thoroughly.
Required Qualifications:
- Proven experience as a SQL Server Developer or similar role.
- Strong proficiency in T-SQL, stored procedures, functions, views, and performance tuning.
- Hands-on experience with Informatica PowerCenter for ETL development.
- Familiarity with database design, data modeling, and data warehousing concepts.
- Experience with performance monitoring and optimization tools (e.g., SQL Server Management Studio, SQL Server Profiler, Dynamic Management Views).
- Excellent problem-solving, debugging, and communication skills.
- Ability to work collaboratively with cross-functional teams and stakeholders.
- Bachelor s degree in Computer Science, Information Systems, or a related field (or equivalent work experience).
- Experience with SQL Server Integration Services (SSIS) in addition to Informatica.
- Knowledge of cloud databases (Azure SQL Database, AWS RDS for SQL Server) and related services.
- Exposure to data governance and data quality practices.
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.