Description

You will design, develop, and support complex data pipelines and ETL processes within a banking environment.

Responsibilities

• Build, enhance, and maintain scalable data pipelines and legacy platform solutions.
• Manage the end-to-end development and deployment of new ETL projects and enhancements.
• Write complex mapping, operations scripts, and triggers to load data into warehouses and databases.
• Design database tables and select appropriate data types for optimal performance.
• Troubleshoot SQL Server service outages and analyze query performance using Profiler traces.
• Evaluate architectural solutions such as clustering, log shipping, mirroring, or replication to meet business requirements.

Required Skills

• 7+ years of experience with IBM DataStage (versions 9.1 - 11.5).
• 5+ years of experience with ETL development using DataStage.
• 5+ years of experience with RDBMS including SQL Server, Oracle, DB2, and Vertica.
• 5+ years of experience coding with SQL, procedures, functions, and triggers.
• 8+ years of experience working for US companies within the US.
• 4+ years of recent banking industry experience (since 2017).
• Expertise in writing and improving SQL Server T-SQL queries.
• 2+ years of experience working in Agile development environments.

Key Skills

Education

Any Gradute