Data Integration Developer (Level 2)

Job Description

As a Data Integration Developer (Level 2) at Blutic, you will be responsible for developing and maintaining ETL processes, reports, and database solutions using SSIS, SSRS, and SQL Server. Your role will involve implementing solutions, optimizing code, and collaborating effectively in an Agile/Kanban environment under the guidance of senior team members.Key Responsibilities:- Develop and maintain SSIS packages for data integration and transformation- Create and modify SSRS reports with basic to intermediate complexity- Write and optimize SQL queries, stored procedures, and functions- Perform data validation and troubleshoot ETL process issues- Work closely with Level 3 developer(s) and Offshore Lead to implement solutions- Participate in code reviews and apply best practices- Document technical specifications and maintain Confluence/Jira updates- Attend daily stand-ups and other Agile ceremonies- Conduct unit testing and support integration testing efforts- Identify and fix defects in developed solutions- Assist in performance tuning of database objects and ETL processesQualifications Required:- 4 years hands-on experience with SSIS and SSRS- Strong proficiency in SQL Server (T-SQL, query optimization)- Basic understanding of C#/.NET- Experience with Azure DevOps or similar ALM tools- Familiarity with Jira/Confluence for documentation- Strong analytical and problem-solving abilities- Ability to work in a team environment with onshore/offshore members- Good communication skills (written and verbal)Blutic offers a 100% long-term remote opportunity for this role. The candidate should be willing to work in a 9-hour shift anywhere between 11 am-11 pm IST with an overlap of 3-4 hours on the Pacific time zone. A Bachelors degree in Computer Science or a related field is required, along with relevant Microsoft certifications preferred. Experience in financial/healthcare domains is a plus. As a Data Integration Developer (Level 2) at Blutic, you will be responsible for developing and maintaining ETL processes, reports, and database solutions using SSIS, SSRS, and SQL Server. Your role will involve implementing solutions, optimizing code, and collaborating effectively in an Agile/Kanban environment under the guidance of senior team members.Key Responsibilities:- Develop and maintain SSIS packages for data integration and transformation- Create and modify SSRS reports with basic to intermediate complexity- Write and optimize SQL queries, stored procedures, and functions- Perform data validation and troubleshoot ETL process issues- Work closely with Level 3 developer(s) and Offshore Lead to implement solutions- Participate in code reviews and apply best practices- Document technical specifications and maintain Confluence/Jira updates- Attend daily stand-ups and other Agile ceremonies- Conduct unit testing and support integration testing efforts- Identify and fix defects in developed solutions- Assist in performance tuning of database objects and ETL processesQualifications Required:- 4 years hands-on experience with SSIS and SSRS- Strong proficiency in SQL Server (T-SQL, query optimization)- Basic understanding of C#/.NET- Experience with Azure DevOps or similar ALM tools- Familiarity with Jira/Confluence for documentation- Strong analytical and problem-solving abilities- Ability to work in a team environment with onshore/offshore members- Good communication skills (written and verbal)Blutic offers a 100% long-term remote opportunity for this role. The candidate should be willing to work in a 9-hour shift anywhere between 11 am-11 pm IST with an overlap of 3-4 hours on the Pacific time zone. A Bachelors degree in Computer Science or a related field is required, along with relevant Microsoft certifications preferred. Experience in financial/healthcare domains is a plus.

Keyskills :
SSISSSRSSQL ServerTSQL