Risk Analytics - SQL and ETL Developer - Staff

Job Summary

Risk Consulting - SQL ETL Developer - Staff

Role Overview

We are looking for a team player who brings strong expertise with 2-4 years of experience in SQL Development, ETL, Database Management, Data Modeling, and Data Validation, along with exposure to data warehousing and performance tuning.

Requirements

• Complex Joins
• Window Functions
• Common Table Expressions (CTEs)
• Stored Procedures
• Query Optimization
• Execution Plan Analysis
• Indexing Strategies
• Partitioning
• Performance Tuning

• Azure Data Factory (ADF)
• SSIS
• Informatica
• Talend
• DataStage
• Spark/PySpark
• Equivalent enterprise ETL platforms

• Data Ingestion Pipelines
• Incremental Load Frameworks
• Batch Processing Solutions
• Data Transformation Pipelines
• Data Integration Workflows

• Star Schema
• Snowflake Schema
• Fact Dimension Tables
• Slowly Changing Dimensions (SCD)
• Change Data Capture (CDC)
• Data Modeling Techniques

• SQL Server
• Oracle
• PostgreSQL
• Snowflake
• Azure Synapse
• Teradata

• Data transformation workflows
• Batch processing jobs
• Data integration solutions

• Strong understanding of data extraction, transformation, and loading processes across multiple systems
• Experience working with relational databases such as SQL Server, Oracle, PostgreSQL, Snowflake, or equivalent
• Ability to analyze business requirements and translate them into efficient ETL solutions
• Experience investigating and resolving data issues using SQL and ETL troubleshooting techniques
• Exposure to Python for automation, scripting, or data processing is preferred
• Familiarity with version control systems such as Git and Agile ways of working
• Strong analytical, problem-solving skills
• Experience in Banking/Financial Services domain is preferred

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.