Senior Data Engineer

Job Title:

Fullstack Software Developer Intern

About Us:

At Suntek.AI, is at the forefront of helping eCommerce businesses optimize their operations through advanced AI solutions and comprehensive eCommerce store management. Our goal is to empower online retailers with state-of-the-art technology that enhances efficiency and drives growth.. We're looking for a Fullstack Developer who shares our enthusiasm for learning, experimenting, and solving real-world problems with technology.

Note: This role is fully remote from day one, providing both flexibility and a high-impact learning environment.

Role Overview:

As a Fullstack Developer Intern, you will contribute across the entire stack—building, deploying, and maintaining robust web applications. You’ll leverage your strong JavaScript skills to develop intuitive UIs and scalable backend systems. We value individuals who are proactive problem-solvers, driven, and eager to learn every day.

Key Responsibilities (What will you do?):

• Frontend Development: Build and maintain dynamic user interfaces using React (Next.js preferred) and Tailwind CSS.

• Backend Development: Develop efficient backend systems and APIs with a solid grasp of client-server architecture.

• JavaScript/TypeScript: Write clean, scalable, and maintainable code, primarily in JavaScript or TypeScript.

• Database Management: Design and manage databases with PostgreSQL.

• ORM Integration: Work with ORMs like Prisma or Drizzle to streamline database interactions.

• API Design & Integration: Design and consume REST APIs for seamless frontend-backend integration.

• AI Integration: Explore and integrate AI APIs (e.g., OpenAI, Anthropic) to enhance product features.

• Debugging & Troubleshooting: Identify and resolve technical issues to ensure optimal performance and reliability.

• Continuous Learning: Stay current with emerging tools, technologies, and methodologies to keep our solutions cutting-edge.

Skills and Qualifications (What you should know ?):

You are not required to know everything!

• JavaScript/TypeScript: Strong foundation in JavaScript; TypeScript experience is highly preferred.

• React & Next.js: Proficiency in React, with Next.js experience being a significant plus.

• Database & ORMs: Hands-on experience with PostgreSQL and ORMs such as Prisma or Drizzle.

• Tailwind CSS: Familiarity with Tailwind for building modern, responsive UIs.

• REST APIs: Ability to design and consume REST APIs; solid understanding of client-server architecture.

• AI APIs (Preferred): Exposure to services like OpenAI or Anthropic.

• Proof of Work: GitHub (or similar) showing personal projects, contributions, or portfolio.

• Self-Motivation: High agency, with a desire to learn and solve problems daily.

• Communication: Strong verbal and written communication skills.

Nice-to-Have:

• Experience with cloud platforms, CI/CD pipelines, or GraphQL.

• Demonstrated track record of innovating and implementing unique solutions.

Experience:

1-2 years of experience 

Relevant experience building web apps

What We Don’t Care About:

• Your college degree or previous company affiliations.

What matters to us is your ability to deliver results, your eagerness to learn, and tangible proof of your work.

What We Offer:

• 100% remote position with flexible work hours.

• A supportive, high-agency team environment that encourages creativity and initiative.

• Ongoing opportunities for skill development and growth.

• Competitive salary and benefits package.

• 5 -10 years of experience in ETL Testing, Snowflake, DWH Concepts.
• Strong SQL knowledge & debugging skills are a must.
• Experience on Azure and Snowflake Testing is plus
• Experience with Qlik Replicate and Compose tools (Change Data Capture) tools is considered a plus
• Strong Data warehousing Concepts, ETL tools like Talend Cloud Data Integration, Pentaho/Kettle tool
• Experience in JIRA, Xray defect management toolis good to have.
• Exposure to the financial domain knowledge is considered a plus
• Testing the data-readiness (data quality) address code or data issues
• Demonstrated ability to rationalize problems and use judgment and innovation to define clear and concise solutions
• Demonstrate strong collaborative experience across regions (APAC, EMEA and NA) to effectively and efficiently identify root cause of code/data issues and come up with a permanent solution
• Prior experience with State Street and Charles River Development (CRD) considered a plus
• Experience in tools such as PowerPoint, Excel, SQL
• Exposure to Third party data providers such as Bloomberg, Reuters, MSCI and other Rating agencies is a plus

Key Attributes include:

• Team player with professional and positive approach
• Creative, innovative and able to think outside of the box
• Strong attention to detail during root cause analysis and defect issue resolution
• Self-motivated & self-sufficient
• Effective communicator both written and verbal
• Brings a high level of energy with enthusiasm to generate excitement and motivate the team
• Able to work under pressure with tight deadlines and/or multiple projects
• Experience in negotiation and conflict resolution

Job Title: Database Administrator (PostgreSQL) 

Experience: 3 to 6 years 

Location: Gurgaon (Hybrid) 

Employment Type: Full-time 

Job Description: 

We are seeking a skilled Database Administrator (DBA) with expertise in PostgreSQL and strong RDBMS concepts. The ideal candidate will be responsible for database performance monitoring, optimization, automation, and interaction with development teams to support business requirements. 

Key Responsibilities: 

1. Database Administration & Management 

• Manage, configure, and maintain PostgreSQL databases ensuring high availability and reliability. 
• Implement Primary-Slave replication architecture and ensure smooth data synchronization. 
• Work with AWS RDS for PostgreSQL database hosting. 
• Automate database backups and manage release versions for database changes. 
• Implement point-in-time recovery (PITR) backups in AWS RDS to ensure data integrity and disaster recovery. 

2. Performance Monitoring & Optimization 

• Regularly monitor database health and performance metrics. 
• Analyze and optimize slow queries to enhance application performance. 
• Fine-tune database performance using configuration parameters, buffers, connections, Disk IOPs, and memory. 

3. SQL Development & Optimization 

• Write, optimize, and maintain stored procedures, SQL functions, and SQL Views. 
• Implement indexing strategies to improve query performance. 

4. Collaboration & Requirement Analysis 

• Work closely with application developers and business analysts to understand new product requirements. 
• Provide recommendations on database design and architecture for scalable solutions. 

5. Database Security & Compliance 

• Implement best practices for database security, access control, and data integrity. 
• Ensure compliance with data governance and security policies. 

6. Automation & Maintenance 

• Automate database maintenance tasks such as backups, indexing, and archiving. 
• Establish monitoring and alerting systems to proactively address database issues. 

Technical Expertise Required: 

• 3 to 6 years of experience as a Database Administrator (DBA). 
• Strong knowledge of PostgreSQL and RDBMS principles. 
• Experience in writing stored procedures, SQL functions, and SQL Views. 
• Hands-on experience in query optimization and performance tuning. 
• Understanding of Primary-Slave architecture and replication setup. 
• Knowledge of database configuration tuning (buffers, connections, Disk IOPs, Memory, etc.). 
• Experience in automating database backups and version control for DB changes. 
• Familiarity with AWS RDS for PostgreSQL and point-in-time backup (PITR). 
• Experience in cloud-based database solutions (AWS RDS, Azure, GCP). 
• Strong problem-solving and analytical skills. 

Preferred Qualifications: 

• Experience in high-availability solutions and disaster recovery strategies. 
• Exposure to NoSQL databases is a plus. 
• Experience with database migrations and upgrades. 

Job Description - Sr. SDET

Creator of frameworks and tools that help engineering move fast. Advocates best practices. Metric & Data-driven in

decisions.

Do you thrive to help ship awesome software, not just prevent poor software from being released?

At TestVagrant we believe that shipping awesome software requires more than just testing and test automation. It

involves constant improvements to processes, tools, testing techniques, and approaches. It involves collaborating

with engineering & business teams, collecting metrics, analysing data, and innovating constantly.

If you're someone who champions & advocates quality, understands risks, and is courageous to drive the change,

then this position was made for you!

More about TestVagrant

We are a team of software consultants specializing in test engineering. We partner with our clients in their ambitious digital missions & integrate business, engineering, and technology to deliver quality software faster and safer.

As consultants, our goal is to ship awesome software. By expanding our identities and playing overlapping roles

across business, engineering & technology, we bring a deeper and more positive impact in amplifying business growth for our clients.

Our engineers have been building and contributing to open-source projects. Ekam.Studio and Optimus are a few to mention. Our thoughts and opinions are reflected in articles, blogs, and books.

You’ll spend time on the following:

● You will proactively seek out ways to avoid common software-testing problems such as test case duplication,

flaky tests, and maintainability

● You will pair including but not limited to devs, business analysts, engineering managers and operations to

identify gaps & improve team efficiencies

● Strive for quality to be baked-in and aspire to shift quality to the left

● Extend your passion for quality assurance practices to enable the engineering teams & coaches to adopt a

testing mindset.

● Spike, Compare and choose the right tools and eco-system for scalable and fast test automation

● Drive the creation of reliable automated testing frameworks with strong reporting capabilities that ensures

simple, effective analysis of failures for your team to use

● Capture metrics to measure the quality and make decisions that improve quality

The outcomes of this role include:

● The team is able to get faster feedback for changes and express confidence in safety-net

● The team is able to measure and gain insights into improvements to the product quality

● Team expresses increased confidence and trust in test assets

You’ll also spend time on the following:

● Storytelling and socializing the tech and engineering success stories across TestVagrant

● Take initiative and participate in others, that move organization forward, aligning with tech and engineering first culture

● Mentor the SDETs to grow in the direction of Sr. SDETs

● To achieve the above, most of the following experience is a must:

● You have worked as a Quality Analyst as part of a distributed engineering team, pairing with Devs, Business Analysts, and Infra teams

● You have championed the quality domain and are proficient in functional, non-functional, and exploratory testing techniques

● You have championed the testing domain and applied wisdom to prevent common mistakes

● You have collaborated with business and engineering teams to arrive at non-functional requirement

● You have contributed to various layers of the test pyramid

● You have designed, developed, and evolved scalable test automation frameworks from scratch

● You have proficiency in automation tools and techniques, including but not limited to Web, Mobile, and APIs

● You have the ability to pick up new tech stack and contribute to developing test assets

● You have worked with code coverage tools, linting, and static code analysers

Scrum Master(BA)

· Working with customers and product manager to prioritize and validate requirements.

· Coordinate with the work efforts of 8+ person team for various projects and help team complete tasks successfully and on-time and resolved obstacles encountered by team members.

· Should Coordinate and participate in weekly estimation meetings to provide high-level estimates (Story Points) for backlog items.

· Develop the crucial functional requirement specifications, creating detailed use cases and process flow diagrams to support functional specifications.

· Facilitate Daily Scrum Meetings and Monthly Reviews meetings. Conduct sprint retrospective and followed up on action items for continuous improvement.

· Prepare extensive cost - benefit analysis to support system and process changes

· Meticulously analyze complex data, staffing plans and variances to recommend solutions to improve revenue per call and customer satisfaction/retention

· Should be Responsible for two Agile Scrum teams

· Should be able to guide three development teams through transition from waterfall to Agile development.

· Coach the team members on Agile processes and facilitate  planning meetings and retrospectives. Maintained task board and produced daily burndown charts.

· Remove impediments and protect team members from interruptions and distractions to maximize productivity.

· Work closely with Product Owners, coordinating product backlog grooming and story.

· Generate test plans work instructions and procedures from client requirements and industry standards.

· Interface with stake holders and facilitate communication between client and the IT department.

· Prepare use case documents and utilized JIRA to create UML diagrams including use case, activity and class diagrams to extract business process flows and workflows, thereby assisting development and quality assurance teams in understanding the requirements.

· Work on a team environment to finalize use cases to develop functional and detail design specifications of the application.

· Participate in JAD sessions for requirement, feasibility and risk analysis with various stakeholders, including designers, developers, QA and management to identify critical and high risk areas of the application.

· Collaborate with the QA team in reviewing and validating test plans and test cases, ensuring that the final application catered to the user requirements.

· Develop a user acceptance test plan and test case scenarios to guide a select group of key end-users in testing the user interface and functionality of the application.

· Examine and evaluate testing fixtures and procedures for appropriateness in the specific requirements.

· Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.

· Should be able to Communicate client’s business requirements by constructing easy-to-understand data and process models.

• Translate designs and wireframes into high quality code for TV, tablets and mobile
• Design, build, and maintain high performance, reusable, and reliable Kotlin code
• Ensure the best possible performance, quality, and responsiveness of the application
• Identify and correct bottlenecks and fix bugs
• Help maintain code quality, organization, and automatization

Android Developer Requirements:

• Proven experience as an app developer (2 - 4 years).
• Strong knowledge of Android SDK, different versions of Android, and how to deal with different screen sizes
• Familiarity with RESTful APIs to connect Android applications to back-end services
• Strong knowledge of Android UI design principles, patterns, and best practices
• Experience with offline storage, threading, and performance tuning
• Ability to design applications around natural user interfaces, such as “touch”
• Familiarity with the use of additional sensors, such as gyroscopes and accelerometers
• Knowledge of the open-source Android ecosystem and the libraries available for common tasks
• Ability to understand business requirements and translate them into technical requirements
• Familiarity with cloud message APIs and push notifications
• A knack for benchmarking and optimization
• Understanding of Google’s Android design principles and interface guidelines
• Proficient understanding of code versioning tools, such as Git
• Familiarity with continuous integration