Job
Description
Role Overview: As a SQL Developer with SSIS, you will be responsible for developing and maintaining SQL database objects such as tables, views, stored procedures, triggers, and functions. Additionally, you will design, deploy, and manage production ETL pipelines using SSIS. Your role will involve optimizing queries, indexing, and database performance for low to medium scale systems. You will also create and maintain data models, ER diagrams, and technical documentation to ensure data integrity, accuracy, and security compliance. Troubleshooting and resolving database issues independently and collaborating with the Power BI team to deliver data solutions and support reporting requirements are also key aspects of this role. Key Responsibilities: - Develop and maintain SQL database objects (tables, views, stored procedures, triggers, functions) - Design, deploy, and manage production ETL pipelines using SSIS - Optimize queries, indexing, and database performance for low to medium scale systems - Create and maintain data models, ER diagrams, and technical documentation - Ensure data integrity, accuracy, and security compliance - Troubleshoot and resolve database issues independently - Collaborate with the Power BI team to deliver data solutions and support reporting requirements Qualifications Required: Must Have: - Advanced SQL skills including complex queries, CTEs, window functions, and execution plan analysis - Production experience with MS SQL Server and SSIS package development - Database design, normalization, and data modeling - Query optimization and performance tuning - Database security, backups, and access controls Good to Have: - Proficiency in Python or other scripting languages - Experience with version control systems like Git or TFS - Knowledge of cloud databases, particularly Azure SQL Soft Skills: - Strong communication and documentation abilities - Analytical problem-solving skills with the ability to work independently - Detail-oriented approach to tasks - Collaborative team player Additional Details: The company offers Provident Fund benefits to full-time permanent employees. (Note: The work location is in person at either Jaipur or Pune office.) Role Overview: As a SQL Developer with SSIS, you will be responsible for developing and maintaining SQL database objects such as tables, views, stored procedures, triggers, and functions. Additionally, you will design, deploy, and manage production ETL pipelines using SSIS. Your role will involve optimizing queries, indexing, and database performance for low to medium scale systems. You will also create and maintain data models, ER diagrams, and technical documentation to ensure data integrity, accuracy, and security compliance. Troubleshooting and resolving database issues independently and collaborating with the Power BI team to deliver data solutions and support reporting requirements are also key aspects of this role. Key Responsibilities: - Develop and maintain SQL database objects (tables, views, stored procedures, triggers, functions) - Design, deploy, and manage production ETL pipelines using SSIS - Optimize queries, indexing, and database performance for low to medium scale systems - Create and maintain data models, ER diagrams, and technical documentation - Ensure data integrity, accuracy, and security compliance - Troubleshoot and resolve database issues independently - Collaborate with the Power BI team to deliver data solutions and support reporting requirements Qualifications Required: Must Have: - Advanced SQL skills including complex queries, CTEs, window functions, and execution plan analysis - Production experience with MS SQL Server and SSIS package development - Database design, normalization, and data modeling - Query optimization and performance tuning - Database security, backups, and access controls Good to Have: - Proficiency in Python or other scripting languages - Experience with version control systems like Git or TFS - Knowledge of cloud databases, particularly Azure SQL Soft Skills: - Strong communication and documentation abilities - Analytical problem-solving skills with the ability to work independently - Detail-oriented approach to tasks - Collaborative team player Additional Details: The company offers Provident Fund benefits to full-time permanent employees. (Note: The work location is in person at either Jaipur or Pune office.)
