Opening with EY_SQL and Data Engineer

Role & responsibilities

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

• Expert-level proficiency in SQL with hands-on experience in:

• Complex Joins

• Window Functions

• Common Table Expressions (CTEs)

• Stored Procedures

• Query Optimization

• Execution Plan Analysis

• Indexing Strategies

• Partitioning

• Performance Tuning

• Strong experience designing and developing ETL/ELT pipelines using tools such as:

• Azure Data Factory (ADF)

• SSIS

• Informatica

• Talend

• DataStage

• Spark/PySpark

• Equivalent enterprise ETL platforms

• Hands-on experience building and maintaining:

• Data Ingestion Pipelines

• Incremental Load Frameworks

• Batch Processing Solutions

• Data Transformation Pipelines

• Data Integration Workflows

• Strong understanding of Data Warehouse concepts including:

• Star Schema

• Snowflake Schema

• Fact & Dimension Tables

• Slowly Changing Dimensions (SCD)

• Change Data Capture (CDC)

• Data Modeling Techniques

• Experience working with large-scale relational and analytical databases such as:

• SQL Server

• Oracle

• PostgreSQL

• Snowflake

• Azure Synapse

• Teradata

• Experience building and maintaining:

• Data ingestion pipelines

• 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, communication, and problem-solving skills.

• Experience in Banking/Financial Services domain is preferred.