An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
AI summary of this job
Beta Read in 10 secondsAn ETL Developer role at State Street Corporation in Hyderabad for people with 2–5 years of experience. You'll build data pipelines using Snowflake, Azure, and dbt, develop complex data transformation and business logic, and optimize SQL queries and Snowflake workloads.
- Hyderabad
- Work from office
- 2–5 years
What you'll do
- Design and maintain scalable data pipelines
- Develop complex data transformation and business logic
- Optimize SQL queries and Snowflake workloads
Good fit if you
- Have experience with Snowflake Data Cloud
- Bring advanced SQL development skills
- Understand Azure-based data engineering architecture
AI-generated from the job description. Check the full description before you apply.
Job Description
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
Read our CEO Statement
Skills
SQLData EngineeringDbtSnowflakeETLData ModelingAzureCI/CDGitReconciliationTeamsIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
State Street Corporation, a leading financial services provider, offers a broad spectrum of opportunities through State Street Careers, targeting ambitious professionals eager to excel in the finance sector. Specializing in investment management, asset servicing, and data analytics, State Street Careers encompass roles across a diverse range of functions such as finance, technology, risk management, and operations. The company prides itself on fostering an inclusive and innovative work environment, where employees are encouraged to grow their skills and contribute to State Street's global success. Joining State Street Careers means being part of a team dedicated to excellence, integrity, and client service, making a significant impact in the financial world.
Similar Jobs
View allLooking for something similar?
New IT / Software Development & Related roles in Hyderabad.
One email a day. Unsubscribe any time.

