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 incidents. Manage SQL Server Agent jobs, scheduling, and automation activities. Support database backup, recovery, and maintenance activities.

Collaboration & Delivery Participate in requirement discussions, technical design reviews, and code reviews. Follow Agile methodologies and participate in sprint planning, stand-ups, and project ceremonies. Maintain development standards and promote database best practices.

Required qualifications to be successful in this role

Technical Skills 7+ years of hands-on experience in Microsoft SQL Server development. Strong expertise in T-SQL programming including: Complex stored procedures Functions Triggers CTEs Window functions Agile SQL Strong experience with SQL Server Integration Services (SSIS) development. Experience in SQL Server performance tuning, query optimization, indexing, and execution plan analysis. Hands-on experience with: Data migration Data transformation Data cleansing Data validation Strong understanding of relational database concepts, normalization, and data modeling. Experience with SQL Server Agent jobs, scheduling, and automation. Knowledge of database backup, recovery, and disaster recovery processes. Experience with database development tools and version control systems such as Git, Azure DevOps,



or TFS. Strong debugging, analytical, and problem-solving skills.

Preferred Skills Experience with SQL Server Reporting Services (SSRS). Exposure to Power BI reporting and analytics solutions. Experience working with Azure SQL Database or Azure Data Services. Knowledge of Azure Data Factory (ADF) and cloud-based data integration. Experience with SQL Server 2016/2019/2022. Knowledge of CI/CD pipelines and automated database deployment processes.

Soft Skills Excellent analytical and troubleshooting skills. Strong communication and stakeholder management abilities. Ability to work independently and collaboratively in a fast-paced environment. Strong documentation and technical writing skills. Good time management and ability to prioritize multiple tasks.

LI-SS65

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join

📌 Senior SQL Developer (SQL (Chennai)
🏢 CGI
📍 Chennai