App Dev & Support Engineer III

Open 46d

Primary Skill - SQL Server 2025, T-SQL SSIS

Secondary Skill - Azure Data Factory, SSRS, SSAS, Power BI

Good experience in design and developing SQL Server stored procedures, Tables, Indexes, functions, views, and triggers to be used during the ETL process
Good experience in designing and developing SSIS/ SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by
Strong experience in resolving and monitoring Performance related issues w.r.t to SSIS Packages and SQL
Good understanding of reading and identifying changes by reviewing the execution plans and actual plans/
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another
Provide production support for existing SSIS/ ETL processes and ensure data accuracy and integrity.
Ensure code quality of SQL and SSIS through code reviews and adherence to best practices.
Optimize performance and security of SQL and packages, debug and resolve technical issues in the SSIS.
Lead a team of developers, providing technical guidance, mentorship, and support.
Facilitate effective communication and collaboration within the team and with stakeholders.
Relevant certifications such as MCSA (Microsoft Certified Solutions Associate) or MCSD (Microsoft Certified Solutions Developer) or Azure Data Engineer Associate etc can be beneficial.

See also