Software Developer

We are seeking a dedicated and detail-oriented Software Developer to join our dynamic team. The ideal candidate will have at least 4 years of experience in Node.js, PostgreSQL, and ETL processes, with strong skills in SQL, AWS, and TypeScript. In this role, you will be responsible for analyzing and implementing user requirements and business needs as new and/or enhanced product functionality. The job role also requires you to learn new tools and technologies fast, and you should have in-depth database knowledge as well as export programming and scripting skills. You will help to build and maintain efficient and stable data pipelines which can be easily maintained in the future. You should have expertise in the design, creation, management, and business use of large datasets.

Responsibilities:

⦁ Design, develop, and maintain NodeJS applications using typescript.

⦁ Create and manage SQL Server databases, including database design, optimization, and maintenance.

⦁ Optimize/Enhance data pipeline (ETL process), integrate and maintain new data sources into the pipeline.

⦁ Designing and implementing storage solutions, security improvements and other server improvements.

⦁ Participate in project planning, code reviews, testing, and debugging activities.

⦁ Collaborate with cross-functional teams to define, design, and ship new features.

⦁ Analyze and implement user requirements/business needs as new and/or enhanced product functionality

⦁ Communicate with technical and business leaders on business requirements, system-related capabilities, programming progress, and enhancement status.

Required Skills:

⦁ Proficiency in Node JS (Typescript).

⦁ Knowledge of RESTful APIs and web services

⦁ Proficient in SQL with a strong understanding of advanced concepts (Functions: COALESCE, CONCAT/CONCAT_WS, HAVING, JOINs, PARTITION, UNIONs, CTEs, nested queries, etc...)

⦁ Experience working with relational databases specifically PostgreSQL.

⦁ Experience in writing and debugging complex SQL queries, functions, stored procedures, views.

⦁ Strong problem-solving skills for data integration and pipeline management.

⦁ Expertise in data warehouse, technical architectures, infrastructure components (AWS)

⦁ Ability to integrate and maintain new data sources

⦁ Must have experience with Jira and bitbucket.

⦁ Should have understanding of ETL process.

Good to have Skills:

⦁ Knowledge of AWS services. (Lambda, S3, CloudWatch etc...)

⦁ Knowledge of yarn workspace

⦁ Knowledge of OData

⦁ Concept of authentication and authorization mechanisms (SAML, Oauth2 etc.)

⦁ Knowledge of Kafka

Qualifications:

⦁ Bachelors degree in computer science, Information Technology, or a related field.

⦁ Minimum 4 years of experience in Node JS and PostgreSQL.

Working Conditions:

This is a full-time position based in our office. The successful candidate will be required to work Monday through Friday during regular business hours. Candidate should be flexible working in overlapping hours if required (depending on the client location). The office environment is professional, fast-paced, and dynamic, with a focus on teamwork and collaboration.