Company Profile:
Job Title: Senior SQL Developer (SQL Server & SSIS)
Position: Senior Software Engineer
Experience: 7+ Years
Category: Software Development / Engineering
Shift: General Shift
Work Mode: Work from Office / Hybrid (as per business requirement)
Primary Location: India, Karnataka Bangalore / Tamil Nadu Chennai
CGI Office: Bangalore / Chennai
Employment Type: Full Time
Your future duties and responsibilities
SQL Server Development
Design, develop, and maintain SQL Server database objects including tables, stored procedures, functions, views, triggers, and indexes.
Analyze business requirements and translate them into optimized database solutions.
Develop reusable database components following SQL development best practices.
Database Performance Optimization
Analyze execution plans and perform query tuning activities.
Implement indexing strategies and database optimization techniques.
Monitor database performance and proactively identify performance bottlenecks.
ETL Development & Data Integration
Design, develop,
and maintain SSIS packages for data extraction, transformation, and loading (ETL).
Build ETL workflows integrating data from multiple sources including databases, flat files, and external systems.
Implement data validation, cleansing, transformation, error handling, and logging mechanisms.
Monitor ETL jobs and troubleshoot failures to ensure timely data delivery.
Data Migration & Quality Management
Perform data migration activities across multiple systems and environments.
Validate and reconcile migrated data to ensure accuracy and completeness.
Develop data quality checks and implement solutions to maintain data integrity.
Create and maintain technical documentation including data dictionaries and database specifications.
Production Support & Database Administration
Provide production support for database-related issues and ensure mínimal business disruption.
Troubleshoot and resolve database errors, performance issues, and data-related inc
📌 Senior SQL Developer (Chennai)
🏢 CGI
📍 Chennai