Database Engineering Associate - Snowflake Developer
Depository Trust & Clearing Corporation (DTCC)3 months ago
Hyderābād, IndiaSenior
Responsibilities
- Design, develop, maintain, and optimize database solutions across cloud and on-premise environments.
- Write and optimize complex SQL queries, stored procedures, views, and database objects.
- Build and support ETL/ELT pipelines using DBT, Snowpipe, and COPY INTO.
- Develop and maintain relational, dimensional, star, and snowflake data models.
- Manage and optimize Snowflake, SQL Server, Oracle, PostgreSQL, Databricks, and AWS database environments.
- Implement data integration through APIs, SFTP, and batch processing.
- Perform data validation, reconciliation, and profiling to ensure data quality.
- Monitor database and pipeline performance, troubleshoot issues, and implement enhancements.
- Implement database security controls, roles, RBAC, and access management.
- Maintain version control with Git and GitHub and support Jira-based Agile project delivery.
Requirements
- At least 5 years of related experience.
- Bachelor's degree preferred or equivalent experience.
- Strong experience with SQL and database development.
- Hands-on Snowflake experience and experience with at least one of SQL Server, Oracle, PostgreSQL, or Databricks.
- Experience designing data models and data warehouse solutions.
- Knowledge of ETL/ELT frameworks and data transformation techniques.
- Experience with AWS cloud services and data platforms.
- Understanding of database security, monitoring, and performance tuning.
- Familiarity with Git, GitHub, and Jira.
- Experience working in Agile/Scrum delivery environments.
- Strong problem-solving, analytical, and communication skills, including the ability to explain technical concepts to non-technical stakeholders.
Benefits
- Competitive compensation including base pay and annual incentive.
- Comprehensive health and life insurance and well-being benefits, based on location.
- Pension and retirement benefits.
- Paid time off, personal and family care, and other leaves of absence.
- Flexible hybrid work model with three days onsite and two days remote.
- Investment in professional development.
Tech Stack
Categories
Data Engineering
About Depository Trust & Clearing Corporation (DTCC)
Depository Trust & Clearing Corporation (DTCC) runs global post-trade market infrastructure, delivering clearing, settlement, securities depository, trade reporting, and data services for broker-dealers, banks, and asset managers. It provides these services through subsidiaries such as DTC, NSCC, FICC, and the Global Trade Repository, with revenue primarily from transaction and service fees. Founded in 1973 and headquartered in Jersey City, NJ, DTCC is industry-owned and privately held, serving markets across multiple regions.