Description

You will develop, optimize, and tune complex SQL stored procedures, queries, and scripts for data staging, transformation, and validation.

Responsibilities

• Develop and tune complex SQL stored procedures, queries, and scripts.
• Collaborate with analysts and architects to translate data requirements into efficient SQL solutions.
• Maintain and enhance existing SQL-based ETL jobs and workflows.
• Monitor SQL job performance and troubleshoot data quality or latency issues.
• Document SQL processes, data mappings, and technical specifications.

Required Skills

• 3+ years of hands-on experience with SQL Server development, including stored procedure development and query tuning.
• Strong proficiency in writing and optimizing complex SQL queries and stored procedures.
• Experience with data profiling, cleansing, and validation techniques.
• Understanding of data warehousing concepts and dimensional modeling.
• Knowledge of job scheduling tools and version control systems.
• Bachelor's degree in Computer Science, Information Systems, or related field.
• Excellent problem-solving and communication skills.

Key Skills

Education

Bachelor's degree