Database Engineering Associate
Depository Trust & Clearing Corporation (DTCC)23 hours ago
Hyderābād, IndiaSenior
Responsibilities
- Design, develop, and maintain database solutions across cloud and on-premises 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-based database environments.
- Implement data integration using APIs, SFTP, and batch processing methods.
- Ensure data quality through validation, reconciliation, and data profiling.
- Monitor database and pipeline performance, troubleshoot issues, and implement enhancements.
- Implement security controls including RBAC, database roles, and access management.
- Maintain version control with Git and GitHub.
- Participate in Agile/Scrum ceremonies and Jira-based project management.
Requirements
- Minimum five years of related experience.
- Bachelor’s degree preferred or equivalent experience.
- Strong experience with SQL and database development.
- Hands-on experience with Snowflake and 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, Jira, and Agile/Scrum delivery environments.
- Strong problem-solving, analytical, communication, and technical explanation skills.
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 and personal/family care and other leaves of absence.
- Flexible hybrid work model with three days onsite and two days remote; onsite days include Tuesdays, Wednesdays, and a third team- or employee-specific day.
- Professional development investment and a supportive internal community.
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.