KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
L #3159
Applications open Full-Time Job

Software Engineer (Java with Snowflake)

The Depository Trust & Clearing Corporation (DTCC)

  • Hyderabad, India
  • Competitive Package
  • 3-5 Years
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Are you ready to make an impact at DTCC?

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed.

We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance.

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

Being a member of the RDS (Repository and Derivative Services) Delivery Team, you will be part of the Application development of the GTR (Global Trade Repository) platform.

You would be part of an Agile squad and will collaborate with the other GTR regional teams (verticals) and the horizontals / CoE within the RDS group and across DTCC. You would actively participate and contribute on developing and delivering a robust and scalable platform solution as per the regulatory and client requirements.

The Software Engineering role specializes in planning, detailing technical requirements, crafting, developing, and testing all software systems and applications for the firm. Works closely with architects, product managers, project management, and end-users in the development and improvement of existing software systems and applications, proposing and recommending solutions that tackle sophisticated business problems.

Your Primary Responsibilities

  • Develop controls for core applications in compliance with functional
  • Construct unit test cases that ensure compliance with functional
  • Follow design and code standards, contributing to continuous improvement discussions
  • Create and maintain system documentation
  • Align risk and control processes into day to day responsibilities to monitor and mitigate risk; escalates appropriately
  • Contribute to the design of components or individual programs
  • Provide production support for applications as needed
  • Work with subject matter experts reviewing technical designs and specifications
  • Apply different software development methodologies dependent on project needs
  • Work with peers to mature ways of working, continuous integration, and continuous delivery

Talents Needed For Success

  • 3+ yrs of exp in in Python , SQL, Snowflake, Amazon Web Services, EC2, S3, UNIX and related technologies
  • Hands on experience in Java, J2EE, Spring (Boot, Core, MVC, JDBC, Security), JUnit.

Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Eligibility & process

Who can apply

Employment type: Full-time

Skills & stack

Python Java SQL AWS Snowflake Spring Boot Microservices REST APIs

Selection process

Details are shared by the recruiter after shortlisting.

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (Python, Java, SQL, AWS, Snowflake, Spring Boot, Microservices, REST APIs) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion The Depository Trust & Clearing Corporation (DTCC) Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join The Depository Trust & Clearing Corporation (DTCC) as a Software Engineer (Java with Snowflake)?
Highlight The Depository Trust & Clearing Corporation (DTCC)'s market reputation, recent tech innovations, and how your skills in Python directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
The Depository Trust & Clearing Corporation (DTCC) Competitive Package
Recruiter Resume Apply
Chat Chat with Kashii