Risk Analytics - SQL and ETL Developer - Senior

EY; Thiruvananthapuram; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

EY is seeking a Senior Risk Consulting - SQL & ETL Developer to join the Global Delivery Services. The role emphasizes building robust SQL data pipelines, data modeling, and ETL/ELT design across diverse data sources.

Collaboration with cross-functional teams will drive data-driven insights for client success. Ideal candidates bring 4-6 years in SQL development, ETL, data warehousing, and performance tuning, with exposure to modern ETL tools and a flavor of banking/financial services domain.

Qualifications

• Expert-level proficiency in SQL with hands-on experience in: Complex Joins, Window Functions, CTEs, Stored Procedures, Query Optimization, Execution Plan Analysis, Indexing Strategies, Partitioning, and Performance Tuning.
• Strong experience designing and developing ETL/ELT pipelines using tools such as Azure Data Factory (ADF), SSIS, Informatica, Talend, DataStage, Spark/PySpark, and other 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.

Responsibilities

• Lead the design and development of robust SQL-based ETL/ELT pipelines and data models.
• Develop and optimize data ingestion and batch processing workflows across multiple sources.
• Collaborate with data architects to implement data warehouse schemas and data quality controls.
• Translate business requirements into scalable ETL solutions and data integration processes.
• Troubleshoot data issues, perform root-cause analysis, and implement fixes quickly.
• Contribute to automation efforts with Python and maintain versioned code in Git.

Skills

SQL Development

ETL

Data Modeling

Data Validation

Data Warehousing

Performance Tuning

Azure Data Factory

SSIS

Informatica

Talend

DataStage

Spark/PySpark

Git

Agile

Tools

SSIS

Informatica

Talend

DataStage

Spark/PySpark

Snowflake

Azure Synapse

SQL Server

Oracle

PostgreSQL

Job description

At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.

Risk Consulting - SQL & ETL Developer - Senior:

At EY, we're all in to shape your future with confidence.

We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.

Join EY and help to build a better working world.

About Global Delivery Services

Global Delivery Services refers to EY's worldwide network of service delivery centers. The GDS team plays an important role in EY’s strategy by ensuring effective support to EY’s growth agenda.

Our journey started in 2002 with approximately 200 people. Today we stand at 80,000+ professionals in ten locations around the world. We operate in Argentina, China, Hungary, India, Philippines, Poland, Sri Lanka, Mexico, Spain and the United Kingdom.

Client service is focused on providing Consulting, Assurance, Tax, Strategy & Transactions, and Knowledge support to our clients around the world. The teams enable account teams worldwide to provide seamless, high-quality, value-added support, helping deliver exceptional client service.

Enablement Services provides cost-effective, high-skilled, and innovative services to support EY’s global and local enablement teams. Markets, BMC, AWS, Finance and Accounting, Risk Management, Procurement, People Shared Services, IT Service Delivery and IT Global Infrastructure services, are among the services offered by Enablement Services.

Our innovation specialists serve the GDS Client Service and Enablement Services teams, along with Service Lines, Core Business Services and Sectors. The team brings the desired environment, technologies and skilled teams together for facilitation, rapid prototyping and innovative thinking. The competencies offered include analytics, digital, user experience, mobile technology, infrastructure, Microsoft technologies and open innovation.

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.

What We Offer You

At EY, we'll develop you with future-focused skills and equip you with world‑class experiences. We'll empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams. Learn more.

To help create an equitable and inclusive experience during the recruitment process, please inform us as soon as possible about any disability‑related adjustments or accommodations you may need.

Our Commitment

As a commitment, we persistently endeavour to embody our values, fulfil our purpose, and champion inclusiveness. Our dedication is to cultivate EY into an environment where diverse perspectives are celebrated, creating a supportive atmosphere for individuals to authentically be themselves and contribute their utmost.

Professional Development:

From entry-level employees to senior leaders, we believe in continuous learning. We offer opportunities to build new skills, take on leadership roles, and connect and grow through mentorship.

People and Culture

In our dynamic workplace, diversity, equity, and inclusiveness are ingrained in our culture. We're united by a commitment to create an environment where every individual's differences are valued, practices are equitable, fostering a sense of belonging. Our shared values include integrity, respect, teaming, inclusiveness, energy, enthusiasm, courage to lead, and building relationships based on doing the right thing.

Benefits

Embark on a transformative career journey with us and indulge in a suite of premium benefits, encompassing exclusive health and wellness packages, enticing rewards, and cutting‑edge learning opportunities that empower you to continually grow and excel in your professional and personal development.

We are an equal opportunity employer and are committed to Diversity, Equity & Inclusion

EY | Building a better working world

EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.

Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.

Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.