ETL Developer

State Street
Hyderabad, Telangana, India

Key Responsibilities

Design, develop and maintain scalable data pipelines using Snowflake, Azure and dbt.

Develop complex data transformation and business logic using dbt models and advanced SQL.

Build and optimize Snowflake objects including databases, schemas, tables, views and other data-processing components.

Develop data ingestion and integration solutions for loading data from multiple upstream systems into the Snowflake platform.

Implement incremental processing, reusable transformation models and dependency-driven workflows using dbt.

Develop automated data-quality checks, reconciliation and validation controls to ensure completeness and accuracy of reporting data.

Optimize SQL queries and Snowflake workloads for performance, scalability and efficient resource utilization.

Work with Azure-based data services and orchestration frameworks supporting ingestion, transformation and downstream delivery.

Troubleshoot data-quality, pipeline and production-processing issues and perform root-cause analysis.

Support development, testing, release and production implementation activities.

Work closely with business analysts, application teams and downstream reporting teams to translate requirements into technical solutions.

Maintain technical documentation covering data flows, transformations, dependencies and operational procedures.

Follow appropriate Git-based version control, code review and CI/CD practices for dbt and data engineering components.

Participate in production support and ensure timely resolution of batch and data-processing failures.

Mandatory Technical Skills

Snowflake

Strong hands-on experience with Snowflake Data Cloud.

Advanced Snowflake SQL and data transformation experience.

Experience working with tables, views, stages, file formats and data-loading patterns.

Good understanding of Snowflake performance optimization and warehouse/resource management.

Experience troubleshooting large-volume data-processing workloads.

Strong hands-on development experience with dbt.

Experience developing reusable dbt models using: Sources Staging and transformation models, Incremental models ,Macros/Jinja

Microsoft Azure

Strong understanding of Azure-based data engineering architecture.

Experience building or supporting automated ingestion and orchestration workflows.

SQL & Data Engineering

Strong SQL development and performance-tuning skills.

Experience handling high-volume datasets and complex transformations.

Strong Understanding Of

Data modeling

Data-quality validation

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement

Job ID: R-800344

Score my resume against this job, free →

Questions about this job

How do I apply for the ETL Developer job at State Street?

Use the apply link on this page: you apply directly with State Street on LinkedIn. Before you do, score your resume against this job description on Fitboard. It shows which skills and keywords the job asks for that your resume doesn't show, so you can fix them first.

What skills does State Street want for this ETL Developer role?

The job description asks for Snowflake, Advanced Snowflake SQL, dbt, Microsoft Azure, SQL, Data modeling and Data-quality validation. Make sure your resume shows the ones you have, in the words the job uses: applicant tracking systems look for them.

How can I get a job at State Street?

Apply to the State Street roles that match your experience, and tailor your resume to each job description: for this role that means showing Snowflake, Advanced Snowflake SQL, dbt. A resume that matches the job's own keywords is more likely to get past screening. Fitboard scores your resume against this exact job for free.

Is this ETL Developer job remote or onsite?

This is based in Hyderabad, Telangana.

Is it free to apply? Does Fitboard charge anything?

Applying is free: you apply directly with State Street, and this job page and its apply link cost nothing. Checking your resume against this job is free too, with 3 free scans when you sign in and no credit card needed.

Will you get shortlisted for this role? Check your match free →