Amazon Web Services (AWS)
MongoDB
Laravel
Shubham Vishwakarma
Full Stack Developer - Averlon
About Squareboat Solutions Private Limited
About
Company video
Company social profiles
Similar jobs
📍 Location: Remote (India-wide)
🖥 Role: *Full-Time | Permanent WFH*
👤 Candidate Profile Required
- Fluent in English + Nepali
- Fresher or experienced
- Graduate/Undergraduate
- Age limit: up to 40 years
- Must own a device (smartphone, laptop/desktop) and have WiFi access
💼 Why Support This Role?
- ✅ Permanent Work From Home
- ✅ Company-provided system
- ✅ Transparent salaries:
• Nepali: Up to ₹5.4 LPA
- ✅ Pan India accessibility
- ✅ No certification needed — just strong language skills!
📝 Screening Workflow
1. HR Round
2. AMCAT Assessment (English 70 + Chosen Language) 3+
3 OPS round
Adobe Illustrator
FigmaAbout Bostem:
Blostem is backed by leading investors including Rainmatter (Zerodha), MobiKwik, AC Ventures, GrowX, and Blue Lotus and founded in October 2021. We provide a unified banking SDK and API that enables fintechs and financial institutions across India to embed financial products such as Fixed Deposits, Recurring Deposits, and more, directly into their apps without building backend infrastructure from scratch.
Our platform drastically reduces time-to-market: partners can go live in 7 days versus the traditional 9–12 months per bank integration. We handle regulatory compliance, bank onboarding, and reconciliation so our partners can focus entirely on user experience.
Job Summary:
We are looking for a creative and detail-oriented Graphic Designer with 3 months to 1 year of internship or professional experience. The ideal candidate should not be a beginner or blank slate - they must already have hands-on experience with design tools and a basic understanding of design principles and workflows.
This role is ideal for someone who has worked on real projects (internship/freelance/full-time) and understands how creative concepts are translated into final deliverables.
Key Responsibilities:
- Design social media creatives, banners, posters, emailers, and marketing collaterals
- Create basic branding materials such as logos, brochures, and presentations
- Work closely with the marketing/content team to understand briefs and deliver creatives on time
- Adapt designs across multiple formats and platforms (digital & print)
- Make revisions based on feedback quickly and efficiently
- Maintain brand consistency across all creatives
- Prepare final files for print and digital publishing
Required Skills & Qualifications:
- 3 months to 1 year of internship or work experience in graphic design
- Proficiency in design tools such as:
- Adobe Photoshop
- Adobe Illustrator
- Figma
- Canva (basic understanding)
- Basic understanding of:
- Typography
- Color theory
- Layout and composition
- Branding fundamentals
- Understanding of file formats, resolution, and print basics
- Ability to manage multiple tasks and meet deadlines
- Good communication skills and openness to feedback
Good to Have:
- Basic knowledge of video editing tools (Da Vinci /Premiere Pro /After Effects)
- Experience working on social media campaigns
- Basic UI/UX understanding
- Portfolio showcasing real projects (internship/freelance/live projects preferred)
- Experimented with AI workflows (Runway, Midjourney, Lottie, Veo etc)
What We Expect:
- Someone who already understands how creative workflows operate
- Ability to understand a brief without extensive hand-holding
- Proactive mindset and willingness to learn
- Attention to detail and creative thinking
PHP
Vue.js
JavascriptKey Responsibilities
Reporting & Analytics Development
• Design, develop, and maintain complex reporting solutions serving mission-critical emergency
response operations
• Build interactive dashboards and data visualizations that transform large datasets into
actionable insights
• Develop advanced analytics features including trend analysis, predictive metrics, and
operational intelligence
• Create self-service reporting capabilities enabling stakeholders to access critical data
independently
• Implement real-time and scheduled reporting systems with appropriate caching and
optimization strategies
SQL & Database Architecture
• Write and optimize complex SQL queries involving multiple joins, subqueries, CTEs, window
functions, and aggregations
• Review existing database architectures and identify performance bottlenecks and optimization
opportunities
• Design and implement database schema enhancements to support evolving reporting
requirements
• Develop and maintain stored procedures, functions, and views optimized for reporting
workloads
• Perform comprehensive query performance analysis and implement tuning strategies across
PostgreSQL and AWS Aurora environments
• Create efficient indexing strategies and data access patterns for large-scale datasets
• Establish data modeling best practices for dimensional and transactional reporting needs
Performance Optimization
• Conduct systematic performance analysis of reporting queries processing millions of records
• Implement query optimization techniques including execution plan analysis, index tuning, and
query refactoring
• Design and implement data aggregation strategies, materialized views, and summary tables for
improved performance
• Monitor and optimize database performance metrics including query response times, resource
utilization, and concurrency
• Develop ETL processes and data pipelines optimized for reporting and analytics workloads
• Implement caching strategies and data archival policies to maintain optimal system
performance
Technical Collaboration
• Partner with Product and stakeholder teams to translate business reporting requirements into
technical solutions
• Conduct code reviews focused on SQL quality, performance, and best practices
• Provide technical guidance to development teams on reporting architecture and database
optimization
• Document database schemas, reporting architectures, and optimization strategies
• Collaborate with DevOps on database infrastructure, monitoring, and scaling initiatives
Required Qualifications
Experience & Background
• 8+ years of software engineering experience with significant focus on reporting, analytics, or
business intelligence
• 5+ years of hands-on experience writing complex SQL in production environments
• 3+ years working with large-scale databases (millions+ records) and optimizing query
performance
• Proven track record developing enterprise reporting solutions and analytics platforms
• Experience conducting database architecture reviews and implementing performance
improvements
Technical Expertise - SQL & Databases
• Expert-level SQL proficiency including complex joins, subqueries, CTEs, window functions, and
advanced aggregations
• Deep PostgreSQL expertise with production experience in query optimization and performance
tuning
• Strong understanding of database internals including execution plans, indexing strategies, and
query optimization
• Experience with AWS Aurora or other cloud-based PostgreSQL solutions
• Proficiency in stored procedures, triggers, functions, and database programming
• Advanced knowledge of database design principles, normalization, and dimensional modeling
• Experience with database performance monitoring and profiling tools
• Strong programming skills in PHP (Yii framework or similar MVC frameworks preferred)
• Solid experience with Vue.js or similar modern JavaScript frameworks for building reporting
interfaces
What You'll Work With
• Databases: PostgreSQL, AWS Aurora, multi-tenant architectures
• Backend: PHP (Yii framework), RESTful APIs
• Frontend: Vue.js (Vue 2/3), modern JavaScript, data visualization libraries
• Infrastructure: AWS (RDS, Aurora, S3, Lambda), Postgres
• Tools: Git/GitHub, JIRA, Agile development workflows
Work Location
Hyderabad, India - On-site position with flexible working arrangements to accommodate both India
and onsite teams
An exciting opportunity has arisen for a 1st Line Technician to join our growing InVentry support team. This team is a vital part of the organization, as we're the first point of call for our 8,000+ customer base (and growing! ). We aim to deliver world-class service & make customers feel part of the team, working closely together to resolve technical issues.
Responsibilities:
- Answering incoming support queries from our customers via calls and live chat
- Logging and responding to customers through our ticketing system, Zendesk
- Managing assigned tickets promptly, ensuring customers are kept up to date
- Resolve customer queries using remote support software, following all correct processes to come to a timely resolution
- Assist in updating and building our customer knowledge base & best practice guides
- Meeting SLA's and KPI's
Requirements:
- Tech-savvy and have a passion for customer service
- A strong problem solver and think logically at all times
- An advocator of our one-team mentality and a great team player
- A great listener and pride themselves on their impeccable communication skills
- Great at driving their personal development
JavaJavascriptMongoDBJob description for Backend Developer:
Responsibilities
• Hands-on experience in Springboot and good knowledge of MySQL, MongoDB
• Hands-on experience in building RESTful based APIs
• Develop and manage well-functioning databases and applications
• Write effective APIs
• Integration of user-facing elements developed by front-end developers with server-side logic
• Building reusable code and libraries for future use
• Optimization of the application for maximum speed and scalability•
• Implementation of security and data protection
Skills And Qualifications
• Basic understanding of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3
• Understanding accessibility and security compliance (Depending on a specific project)
• User authentication and authorization between multiple systems, servers, and environments
• Integration of multiple data sources and databases into one system
• Management of hosting environment, including database administration and scaling an application to support load changes
• Data migration, transformation, and scripting
• Outputting data in different formats
• Understanding differences between multiple delivery platforms such as mobile vs desktop, and optimizing output to match the specific platform
• Creating database schemas that represent and support business processes
• Implementing automated testing platforms and unit tests
• Proficient knowledge of a back-end programming language (Java 8 and above and Spring Boot)
• Proficient understanding of code versioning tools, such as Git
• Proficient understanding of OWASP security principles
• Understanding of “session management” in a distributed server environment
Required qualification:
*) Any degree from a reputed university
*) Proven software development experience and Java/J2EE skills development.
The B2B manufacturing industry has a lack of digitisation globally. NowPurchase is building layers of technology to help improve the productivity and profits of the manufacturer. For this we are building the OS (Operating System) that will seamlessly connect factory equipment such as furnaces and spectrometers to our software systems that provide real time optimisations.
The end-game is to use this interconnected system to do great production planning and autonomous procurement of their raw materials. The Heart of NowPurchase will be a marketplace consisting of these smart factories and raw material suppliers.
Here a video that explains our product journey:
[https://www.loom.com/share/ccd0ed9e7bc349d7bba851d762253c21](https://www.loom.com/share/ccd0ed9e7bc349d7bba851d762253c21)
## **Role Description**
As a Product Manager, you will own NowPurchase’s strategy, approach, and product roadmap for the **MetalCloud** platform that aims to build the operating system of metal manufacturing. To achieve your objectives, you will collaborate with the 2 founders, the data guy, the technology engineering manager and the metallurgist. You are expected to understand the metal manufacturing domain intimately during your course at NowPurchase.
### **What are the expectations from this role?**
- **You will own Strategy**: You will identify the key strategy questions and drive to resolution and alignment with the stakeholders.
- **You will own Roadmap & Features**: You will own the product roadmap for the entire platform!
- **You will own Metrics**: You will define the metrics, goals and measure outcome by designing testable MVPs. We do quick iterations. Anything that works is taken forward, others are dropped and deleted.
- **You will create product strategy documents** that describe business cases, high-level use cases, technical requirements, revenue, and ROI
- **Learn Domain fast!** You are expected to understand the metal manufacturing domain as soon as possible. We have an in house metallurgist who can help you with that.
- **Tight team**: You will work with the 2 founders, the data guy, the engineering manager and the metallurgist.
- Expect yourself to be spending a LOT of time in factories observing the manufacturing process as part of your primary research to come up with product roadmap ideas and testing existing MVPs.
## **Qualifications and Experience**
- Experience with working with Product in your own startup or other startups.
- Experience identifying business opportunities, building a product strategy, and influencing delivery against a multi-year roadmap
- Understands core technologies utilized in their product domain and is fluent in pros and cons of technical alternatives
- Demonstrated ability to achieve goals in a fast paced and an unstructured environment.
- Hands-on experience of both qualitative and quantitative research methods such as AB testing, data analytics, and user research
- Excellent verbal and written communication skills
- Experience in leading a team with interaction designers and developers
## **Compensation & Benefits**
- **Cash Compensation:** As per industry standards & pedigree of candidate
- **ESOPs:** 10% of NowPurchase is dedicated to current & future team members. Your package would entail some ESOPs so that you own a part of the company and grow along with it.
- **Medical Insurance:** Benefits of group insurance of 3 lakhs for family including parents, spouse, children
- **Generous leave structure and WFHs** including Marriage, Maternity & Paternity leaves
- Snacks on the house
- **Complete Relocation Expenses:** We are building a unicorn out of the city of Joy (Kolkata). We will pay for everything you spend to relocate here.
## **Possible Growth path**
Product Manager> Senior Product Manager > Chief Product Officer (CPO)
## **Hiring Process**
1. Screening of applicants & initial telephonic call with Manager -HR
2. F2F/Video Interview with Cofounder CTO
3. F2F/Video Interview with Cofounder CEO
4. Take home written assessment
5. Email communication on final feedback
The end to end process shall take less than 10 days. We pride ourselves on being transparent & moving fast.
*Candidates who accept an offer may join within 1 hour, 1 week or up to 45days of signing - though, we have a preference for as short a gap period between signing and joining since we're at the most exciting part of our journey - laying the foundation for the NowPurchase platform!*
* Should have Inbound & Outbound Calling experience of minimum 6 months.
* Who is extremely good in communication (Written as well as Verbal).
* Who can speak Tamil Language (Mandatory).
* Who can make cold calls to customer.
* Handle both Outbound/Inbound calls.
* Can be on Phone for a long time and familiar using Dialer Systems.
* Must have decent typing speed (At least 20 WPM).
Graduate Fresher's who can speak Tamil can also apply .
Interested Candidates can share their updated CV.
React Native● Working alongside other developers, product managers and designers
● Own a feature and bring it to the production application.
● Build pixel-perfect, buttery smooth UIs across both mobile platforms.
● Leverage native APIs for deep integrations with both platforms.
● Diagnose and fix bugs and performance bottlenecks.
● Maintain code and write automated tests to ensure the product is of the highest quality.
● Writing clean, readable, and testable code
● Hiring and leading team (Senior Web Developers)
Skills Required
● Must have hands-on working exp on React-Native and different packages.
● Strong working knowledge on React Native and Redux
● Experience on REST with JSON.
● Proficient understanding of code versioning tools, such as Git
● Experience in building and supporting high-performance applications
● Java/Swift Knowledge to create a native bridge is a plus.
● Prior experience with Firebase is a plus.
● Javascript, React Native, Software Architecture, Mobile Development, Unit Testing, Swift, Java
We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS.
Requirements:
- Qualification: Engineering Graduate.
- Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS.
- Strong understanding of ETL/ELT concepts.
- Hands on experience on Azure Data Factory.
- Exposure of Cloud technologies, standards, and platforms.
- Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory).
- Strong Experience on SSIS.
- Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables.
- Azure Data Warehouse.
- Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob).
- Azure Data Migration tool.
- Well versed with RDBMS systems like Sql server, DDL, DML scripts.
- Sound knowledge of T-SQL and stored procedures.
- Strong Query writing skills, Scheduling tools.
- Ensure quality deliverable and ability to extend work hours if required.
- Azure Certification: Preferred.
- Ability to understand Customer requirements and convert the requirements into technical specifications.
- Ability to understand the overall solution and design components to fit the overall solution.
- Ability to take technical decisions and support the decisions with justifications.
- Ability to work in Agile manner.
- Ability to work independently without much guidance.
- Self-Motivated, team player, results oriented, strong Time Management skills.
- Excellent written and verbal communication skills.
- Willing to travel to outside India (Short term as well as long term)
HTML/CSSPHP
CodeIgniter
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon