Specialist Development
Core
Develop and maintain database objects, build SQL queries for data maintenance and analysis, and provide production support for batch processes.
Role type
Senior IC data engineer (SQL/ETL)
Builds
Data maintenance fixes, ad hoc reports, and optimized batch processes
Domain
Financial services / Insurance
Required skills
SQL, SSIS, Informatica, RDBMS, SQL optimization, batch production support, Shell scripting, Unix/Linux
Preferred skills
PL/SQL, AWS, Snowflake, Autosys, Agile/Scrum
Technologies
SQL Server, Autosys, Unix, Linux
Responsibilities
Develop and maintain complex SQL functions, procedures, and packages; Build SQL queries for data maintenance, analysis, and ad hoc reporting; Optimize SQL queries for performance and scalability; Provide production support for batch processes and troubleshoot issues; Monitor and manage job schedules using Autosys; Collaborate with business analysts and stakeholders to understand requirements.