06 Aug
|
DTCC
|
Hyderabad
Are you ready to make an impact at DTCC
Pay and Benefits:
- Competitive compensation, including base pay and annual incentive
- Comprehensive health and life insurance and well-being benefits, based on location
- Pension / Retirement benefits
- Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
- DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).
The Impact you will have in this role:
We are seeking a skilled Database Engineer/ Snowflake Developer to design, develop, optimize, and maintain enterprise data solutions. The ideal candidate will have solid experience with SQL, database platforms, data modeling, ETL/ELT processes, cloud-based data environments, and performance tuning. This role involves working closely with cross-functional teams to ensure reliable, secure, and efficient data pipelines and database systems.
Your Primary Responsibilities:
- Design, develop, and maintain 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 tools such as DBT, Snowpipe, and COPY INTO.
- Develop and maintain data models, including relational, dimensional, star, and snowflake schemas.
- Manage and optimize databases on platforms such as Snowflake, SQL Server, Oracle, PostgreSQL, Databricks, and AWS.
- Implement data integration solutions using APIs, SFTP, and batch processing methods.
- Ensure data quality through validation, reconciliation, and data profiling activities.
- Monitor database and pipeline performance, troubleshoot issues, and implement performance enhancements.
- Implement security controls including RBAC, database roles, and access management.
- Maintain version control using Git and GitHub.
- Support Agile delivery processes, including participation in Scrum ceremonies and Jira-based project management.
Qualifications:
- Minimum of 5 years of related experience
- Bachelor''s degree preferred or equivalent experience.
Talents Needed for Success:
- Strong experience with SQL and database development.
- Hands-on experience with Snowflake and at least one major database platform (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 methodologies.
- Strong problem-solving and analytical skills with excellent communication abilities.
- Good communication skills with the ability to explain technical concepts to non-technical stakeholders.
- Experience working in Agile/Scrum delivery environments.
📌 Database Engineering Associate - Snowflake Developer (Hyderabad)
🏢 DTCC
📍 Hyderabad