ETL Developer
State Street10 days ago
Hyderābād, IndiaMid Level
Responsibilities
- Design, develop, and maintain scalable data pipelines using Snowflake, Azure, and dbt.
- Develop complex data transformations and business logic with dbt models and advanced SQL.
- Build and optimize Snowflake databases, schemas, tables, views, stages, file formats, and data-loading components.
- Develop ingestion and integration solutions for loading data from multiple upstream systems into Snowflake.
- Implement incremental processing, reusable transformation models, macros, Jinja, and dependency-driven dbt workflows.
- Create automated data-quality checks, reconciliation, and validation controls.
- Optimize SQL queries, Snowflake workloads, and warehouse resources for performance and scalability.
- Support Azure-based data services, orchestration workflows, downstream delivery, testing, releases, and production implementation.
- Troubleshoot data-quality, pipeline, and production-processing issues and perform root-cause analysis.
- Collaborate with business analysts, application teams, and downstream reporting teams to translate requirements into technical solutions.
- Maintain documentation covering data flows, transformations, dependencies, and operational procedures.
- Use Git-based version control, code review, and CI/CD practices for data engineering components.
- Provide production support and resolve batch and data-processing failures in a timely manner.
Requirements
- Strong hands-on experience with Snowflake Data Cloud, including advanced Snowflake SQL, data transformation, objects, data-loading patterns, performance optimization, and large-volume workload troubleshooting.
- Strong hands-on development experience with dbt, including sources, staging and transformation models, incremental models, macros, and Jinja.
- Strong understanding of Azure-based data engineering architecture and experience building or supporting automated ingestion and orchestration workflows.
- Strong SQL development and performance-tuning skills.
- Experience handling high-volume datasets and complex transformations.
- Strong understanding of data modeling and data-quality validation.
Benefits
- Inclusive development opportunities.
- Flexible work-life support.
- Paid volunteer days.
- Employee networks and connection programs.
About State Street
State Street is a global custodian bank and asset manager serving institutional investors with investment servicing, fund accounting, trading/FX, data, and index/active strategies. Its products include State Street Global Advisors’ funds and ETFs, the Charles River Investment Management Solution, and the front-to-back State Street Alpha platform. Founded in 1792 and headquartered in Boston, the company is publicly traded on the NYSE (ticker: STT) and operates across major markets worldwide.