Database Developer (PostgreSQL)

Job Description: Software Engineer - Backend ( 3-5 Years)

Location: Bangalore

WHO WE ARE:

TIFIN is a fintech platform backed by industry leaders including JP Morgan, Morningstar, Broadridge, Hamilton Lane, Franklin Templeton, Motive Partners and a who’s who of the financial service industry. We are creating engaging wealth experiences to better financial lives

through AI and investment intelligence powered personalization. We are working to change the world of wealth in ways that personalization has changed the world of movies, music and more but with the added responsibility of delivering better wealth outcomes.

We use design and behavioral thinking to enable engaging experiences through software and application programming interfaces (APIs). We use investment science and intelligence to build algorithmic engines inside the software and APIs to enable better investor outcomes.

In a world where every individual is unique, we match them to financial advice and investments with a recognition of their distinct needs and goals across our investment marketplace and our advice and planning divisions.

OUR VALUES: Go with your GUT

●Grow at the Edge: We embrace personal growth by stepping out of our comfort zones to

discover our genius zones, driven by self-awareness and integrity. No excuses.

●Understanding through Listening and Speaking the Truth: Transparency, radical candor,

and authenticity define our communication. We challenge ideas, but once decisions are

made, we commit fully.

●I Win for Teamwin: We operate within our genius zones, taking ownership of our work

and inspiring our team with energy and attitude to win together.

Responsibilities:

• Contribute to the entire implementation process including driving the definition of improvements based on business needs and architectural improvements.

• Review code for quality and implementation of best practices.

• Promote coding, testing, and deployment best practices through hands-on research and demonstration.

• Write testable code that enables extremely high levels of code coverage.

• Ability to review frameworks and design principles toward suitability in the project context.

• Candidates who will demonstrate an ability to identify an opportunity lay out a rational plan for pursuing that opportunity, and see it through to completion.

Requirements:

• Engineering graduate with 3+ years of experience in software product development.

• Proficient in Python, Django, Pandas, GitHub, and AWS.

• Good knowledge of PostgreSQL, and MongoDB.

• Strong Experience in designing REST APIs.

• Experience with working on scalable interactive web applications.

• A clear understanding of software design constructs and their implementation.

• Understanding of the threading limitations of Python and multi-process architecture.

• Familiarity with some ORM (Object Relational Mapper) libraries.

• Good understanding of Test Driven Development.

• Unit and Integration testing.

• Preferred exposure to Finance domain.

• Strong written and oral communication skills.

What’s the opportunity?

Are you a backend developer looking to fast-track your learning and growth? Have you looked at world-class products like Asana, Notion, or Airtable, and felt “I wish I were part of the early team that built these products”?

We’re a team that has previously built and rolled out globally successful SaaS products used by tens of thousands of customers. We’re laser-focused on delivering a world-class product again, and looking for an ambitious backend engineer to join our existing team of 9 engineers. 

If it excites you to think of a fast-paced start-up environment, building something big from scratch, breaking down new problems, creating new APIs, working on performance issues, getting hands-on with DevOps initiatives, and showcasing demos of your work every Friday with a happy and passionate team, then this is the right opportunity for you.

Some of the tech problems you get to work on as a backend engineer would be to build the backend for a modern spreadsheet experience from scratch, work on infra as code, write robust code that is fault-tolerant, work on performant code that adheres to SLOs set by the organization.

About you:

● 3- 5 years of experience

● Expertise in the following areas ○ Java ○ HTTP Protocol

● You’ve heard of or worked with some of the following tech stacks/products ○ Spring ○ PostgreSQL ○ Redis ○ Docker ○ Message brokers ○ GitHub

● These non-functional areas are familiar to you ○ Performance ○ Debugging ○ Log management

Nice to have:

● Familiarity with AWS

What’s in it for me?

● Great opportunity: We genuinely care about everyone we hire. You’ll learn new things and grow no matter how experienced you are; you will be working with founders who have more than three decades of collective experience in building significant B2B SaaS startups.

● Great team: Work with a world-class, high-velocity team that truly embodies the values of empathy, curiosity, and customer-centricity. Check out the MTT(Meet The Team) videos on our LinkedIn.

● Great culture: An open, fun, and exciting startup culture that empowers its people to champion big problems with the freedom to think and innovate.

● Growth: You could easily and quickly transition into other roles you might like.

● Impact: You get to be part of a global, passionate team in a fast-paced and growth-oriented environment. The team has a work philosophy of being high on ambition, ownership, and a bias for action.

● Monetary rewards and benefits: Competitive stipend, flexible leave policy, and more

• Experience in either of these Relational DB’s MS SQL Server / PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch DB.
• Design database tables, views, indexes
• Write functions and procedures for Middle Tier Development Team
• Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
• Query Optimization for performance improvement
• Design & develop SSIS Packages or any other Transformation tools for ETL

• Banking / Insurance / Retail domain would be a plus.
• Interaction with a client a plus

• Knowledge in a Cloud Platform (AWS / Azure)
• Knowledge on version control system (SVN / Git)
• Exposure to Quality and Process Management
• Knowledge in Agile Methodology

• Team building (attitude to train, work along, mentor juniors)
• Communication skills (all kinds)
• Quality consciousness
• Analytical acumen to all business requirement
• Think out-of-box for business solution

Responsibilities :

- Knowledge of Node.js and frameworks available for it {such as NestJS, Express, StrongLoop, etc.}

- Experience in Database, Postgres Preferred.
- Integration of user-facing elements developed by front-end developers with server-side logic
- Writing reusable, testable, and efficient code
- Design and implementation of low-latency, high-availability, and performant applications
- Implementation of security and data protection
- Integration of data storage solutions 
- Strong proficiency with JavaScript

Description:

For over 10 years, Zscaler has been disrupting and transforming the security industry. Our 100% purpose-built cloud platform delivers the entire gateway security stack as a service through 150 global data centers to securely connect users to their applications, regardless of device, location, or network in over 185 countries protecting over 3,900 companies and have detected 100 Million threats/day. 

We work in a fast-paced, dynamic and make it happen culture. Our people are some of the brightest and passionate in the industry that thrives on being the first to solve problems.  We are always looking to hire highly passionate, collaborative and humble people that want to make a difference.

About the role :

This is a senior staff backend engineer role in the engineering team that designs, implements and maintains our state of the art product IllusionBLACK. The team is responsible for designing and implementing secure, highly performant and maintainable product.

Responsibilities:

• Architect, develop and maintain high performance, fault tolerant and scalable cloud hosted service using NodeJS
• End to end responsibility to continuously create and monitor the services you build
• Help design reusable and clean API's for our frontend React app
• Guide team members with handling complex issues
• You will also be responsible for database schema design and development of migration scripts
• Experiment with new technologies and ideas and help shape our stack and processes

Requirement:

• 10+ years professional SW development experience
• All our production applications are built with either Typescript or Python. You must have a strong understanding of NodeJS express apps written in Typescript and ES6
• Must have good experience with Python
• Solid experience with databases is a must. We use and love Postgres here at Smokescreen
• You should be able to design a complex database SQL schema normalized to 3NF on the back of a napkin at 3am in the morning
• Deep understanding and working knowledge of Redis cache
• Experience with Solr or Elasticsearch is a must. We use Solr for our event analytics exclusively
• Experience with AWS, Azure or GCP is a plus. We have a large distributed application running on AWS
• Experience with Docker/Swarm is a plus
• Experience in some stream processing platforms like Kafka/Redis stream is a plus