Database Engineering Senior Associate
Depository Trust & Clearing Corporation (DTCC)10 days ago
Hyderābād, IndiaSenior
Responsibilities
- Design, develop, and maintain database solutions across cloud and on-premise environments.
- Write and optimize SQL queries, stored procedures, views, and database objects.
- Build and support ETL/ELT pipelines using DBT, Snowpipe, and COPY INTO.
- Develop relational, dimensional, star, and snowflake data models.
- Manage and optimize Snowflake, SQL Server, Oracle, PostgreSQL, Databricks, and AWS database environments.
- Implement data integration using 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 participate in Jira-based Agile/Scrum delivery processes.
Requirements
- Minimum of 7+ 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, depending on location.
- Pension and retirement benefits.
- Paid time off, personal and family care, and other leaves of absence.
- Flexible hybrid schedule 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.