SQL Developer - Sr Analyst

Overview

SQL Developer (Sr Analyst) to enhance risk reporting data warehouses, tools, and technologies.

What you'll do

• Design and develop data models, schemas, and pipelines.
• Write complex SQL queries, stored procedures, and functions for data extraction, transformation, and loading.
• Optimize query performance to support data integrity and consistency.
• Implement database security measures and access controls aligned with governance policies.
• Monitor and troubleshoot data pipelines and address performance bottlenecks.
• Participate in code reviews and document changes in the required format.
• Implement and maintain CI/CD pipelines for automated testing, deployment, and monitoring.

What you'll need

• 6–8 years of experience.
• Advanced SQL proficiency (stored procedures, views, triggers, and functions).
• Knowledge of data warehousing principles, dimensional modeling, and star schema design.
• Experience working with large data warehouses including performance tuning, query optimization, and execution plan analysis.
• Experience with data integration tools (SSIS, ADF) and ELT/ETL techniques.
• Hands-on SSIS development experience.
• Hands-on reporting tools experience (SSRS and Power BI).

Details

• Location: MGS - Bengaluru.