Test Engineer

We are looking for a skilled Oracle Developer with strong expertise in PL/SQL development and database management. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining robust Oracle database solutions to support business applications and operations.

Key Responsibilities

Design, develop, test, and maintain robust PL/SQL code including stored procedures, functions, packages, triggers, and views.

Participate in database design and development activities ensuring efficient database structure and performance.

Optimize SQL queries and PL/SQL code for maximum efficiency and performance.

Identify, troubleshoot, and resolve database performance issues.

Develop and implement data migration, transformation, and ETL processes using Oracle tools and PL/SQL scripts.

Provide support for existing database applications and resolve issues within defined SLAs.

Collaborate with application developers, business analysts, and stakeholders to understand business requirements and translate them into technical solutions.

Maintain proper documentation for database designs, code, and technical processes.

Follow best practices in database development including code reviews, version control, and coding standards.

Required Skills & Qualifications

Bachelor’s degree in Computer Science, Information Technology, or a related field.

3–5 years of hands-on experience as an Oracle Developer.

Strong expertise in Oracle PL/SQL development.

Experience in writing complex stored procedures, functions, packages, and triggers.

Strong understanding of database schema design, tables, views, indexes, and constraints.

Experience with data migration, ETL processes, and data transformation.

Knowledge of Oracle backup and recovery techniques including RMAN.

Strong analytical and problem-solving skills.

Good communication and collaboration abilities.

Ability to work independently and manage multiple tasks effectively.

Preferred Skills

Experience working in performance tuning and query optimization.

Familiarity with version control and development best practices.

Exposure to Oracle tools and enterprise database environments.

Why Join Us?

Opportunity to work on enterprise-grade Oracle database solutions.

Collaborative and growth-oriented work environment.

Exposure to challenging projects and modern database practices.

Sr. DE / Data Engineer (Healthcare Data & SQL Expert)

Experience Level: 5–7 Years

Focus: Database Design, Advanced SQL, ETL/ELT Pipelines, and Healthcare Interoperability.

Summary

We are looking for a highly skilled Senior Data Engineer to join our healthcare data team. This role is perfect for a technical powerhouse who excels at building robust data pipelines and deeply understands database internals. You will be responsible for designing schemas, writing complex stored procedures, and optimizing SQL performance to handle clinical and claims data at scale. You will bridge the gap between raw data ingestion and high-performance analytics, ensuring all solutions meet HIPAA and FHIR standards.

What You’ll Do

1. Advanced SQL & Database Development

• Schema Design: Design and implement relational schemas (MSSQL, PostgreSQL, Oracle) ensuring data integrity through constraints, triggers, and normalized structures.
• Programmability: Write and maintain sophisticated Stored Procedures, Functions, and Views to handle complex business logic within the database layer.
• Performance Tuning: Own query optimization. You should be the expert in reading EXPLAIN/ANALYZE plans, implementing advanced indexing strategies (Clustered, Non-Clustered, Columnstore), and managing partitioning.
• Data Modeling: Build and manage dimensional models (Star/Snowflake) and implement Slowly Changing Dimensions (SCD Types 1, 2, and 4).
• 
  
• Getty Images

2. Data Engineering & Ingestion

• Pipeline Development: Build and operate scalable ETL/ELT pipelines using Python and SQL to ingest data from EHRs, REST APIs, and flat files.
• Orchestration: Use Apache Airflow to schedule jobs, manage dependencies, and implement robust retry/alerting logic.
• API Integration: Develop Python-based ingestion frameworks that handle OAuth, pagination, and throttling for third-party healthcare data partners.

3. Healthcare Interoperability & Compliance

• Standards: Map complex clinical data to HL7 FHIR resources and curated analytic layers.
• Security: Implement "Privacy by Design" by enforcing HIPAA safeguards, including encryption at rest, access controls, and PII/PHI de-identification.

4. Operational Excellence

• CI/CD: Use GitHub and automated pipelines to deploy database changes and data code.
• Observability: Implement data quality tests (using tools like dbt or custom Python/SQL checks) to monitor freshness and accuracy.

What You’ll Bring

• Experience: 5–7 years of professional data engineering experience, with a heavy emphasis on backend database development.
• The SQL Expert Toolkit:
• Expert SQL: Window functions, CTEs, recursive queries, and set-based transformations.
• DB Internals: Deep knowledge of MSSQL, PostgreSQL, or Oracle. You should understand how the engine stores and retrieves data.
• Optimization: Proven track record of turning "slow" queries into high-performance assets via indexing and refactoring.
• The Engineering Toolkit:
• Python: Intermediate to advanced (Pandas/Polars, Requests, SQLAlchemy, or PySpark).
• Orchestration: Practical experience with Airflow (or Prefect/Dagster).
• Legacy/Cloud mix: Proficiency in SSIS/SSMA or PowerShell is a plus for migrating legacy workloads to modern platforms.
• The Domain Knowledge: Familiarity with FHIR/HL7 and an understanding of the importance of data governance in a regulated environment.

Technical "Must-Haves" for the Interview

• Ability to whiteboard a complex Database Schema from scratch.
• Ability to debug a long-running SQL query and explain the IO/CPU trade-offs of different index types.
• Experience handling JSON/BSON data types within a relational database context.

Nice to Have

• Experience with NoSQL systems like MongoDB or Elasticsearch.
• Cloud experience (Azure, AWS, or GCP) specifically regarding managed SQL services.
• Knowledge of dbt (data build tool) for managing transformations in the warehouse.

Skills

• Strong analytical thinking and problem-solving abilities.
• Solid understanding of system design, data structures, and algorithms.
• Proven experience in designing and implementing scalable architectures and robust design patterns.
• Ability to deliver end-to-end features and enhancements with minimal supervision.
• Proficient in debugging and resolving complex production issues and identifying root causes quickly.
• Ability to quickly learn and integrate new systems into existing platforms.

Programming Languages

• Strong expertise in Java or Python.

Database Skills

• Proficiency in SQL, with hands-on experience in PostgreSQL and MySQL.

Experience with NoSQL technologies, including MongoDB and Redis.

NOTE- This is a contractual role for a period of 3-6 months.

Responsibilities:

● Set up and maintain CI/CD pipelines across services and environments

● Monitor system health and set up alerts/logs for performance & errors ● Work closely with backend/frontend teams to improve deployment velocity

● Manage cloud environments (staging, production) with cost and reliability in mind

● Ensure secure access, role policies, and audit logging

● Contribute to internal tooling, CLI automation, and dev workflow improvements

Must-Haves:

● 2–3 years of hands-on experience in DevOps, SRE, or Platform Engineering

● Experience with Docker, CI/CD (especially GitHub Actions), and cloud providers (AWS/GCP)

● Proficiency in writing scripts (Bash, Python) for automation

● Good understanding of system monitoring, logs, and alerting

● Strong debugging skills, ownership mindset, and clear documentation habits

● Infra monitoring tools like Grafana dashboards

Context for the Candidates:

Blockchain engineers are tasked with building secure, scalable, and high-performance decentralized applications. This discussion focuses on how to utilize key technologies—Node.js, Rust, Go, TypeScript, Ethers.js, viem, and Hardhat—in smart contract and blockchain system development, while addressing the practical challenges that arise in such projects.

Key Discussion Points:

• How do you integrate Node.js, Rust, Go, and TypeScript in blockchain-backed applications?

• Discuss the trade-offs between using Rust or Go for performance-critical blockchain services.

• What are the key challenges in ensuring the security and scalability of smart contracts using tools like Ethers.js, viem, and Hardhat?

• How do you approach testing, debugging, and deploying smart contracts in a decentralized environment?

• Share best practices for gas optimization, contract upgradability, and backend scalability.

Evaluation Criteria:

1. Technical Knowledge:

• Strong knowledge of Node.js, Rust, Go, and TypeScript with practical experience in blockchain development.

• Proficiency in Ethers.js, viem, Hardhat, and smart contract lifecycle (development, testing, deployment).

• Understanding of security best practices, performance optimizations, and scalability in decentralized systems.

2. Problem-Solving and Integration Skills:

• How candidates approach integrating smart contract solutions with backend services using Node.js, Rust, Go, and TypeScript.

• Solutions proposed for common challenges in blockchain projects such as gas fees, security vulnerabilities, and system bottlenecks.

3. Experience and Expertise:

• Minimum of 2 years of IT experience, including hands-on development with the specified technologies.

• Practical knowledge of blockchain architecture, consensus mechanisms, and decentralized application deployment.

4. Innovation and Critical Thinking:

• Candidates’ ability to think creatively about system architecture, proposing scalable and secure solutions for blockchain-based applications.

• Discussion on the future potential of blockchain technology and how the tech stack can evolve.

5. Communication and Team Collaboration:

• Clear articulation of technical challenges and how to address them in a team setting.

• Ability to lead or contribute to discussions in a way that encourages collaboration and team-driven problem-solving.

Mandatory Skills

• C/C++ Programming
• Linux System concepts
• Good Written and verbal communication skills
• Good problem-solving skills
• Python scripting experience
• Prior experience in Continuous Integration and Build System is a plus
• SCM tools like git, perforce etc is a plus
• Repo, Git and Gerrit tools
• Android Build system expertise
• Automation development experience with like Electric Commander, Jenkins, Hudson

Qualification: Any Graduate or Pursuing Graduate.

Experience: Fresher -2 years

Job Description: Role as Recruiter

Roles and Responsibilities:

• Handling & routing End-to-End Recruitment from initiating the recruitment process to streamlining overall operations.
• Identify client needs on every requirement with quick response time
• Understanding the skill set required by our Corporate clients.
• Sourcing potential candidate for required skill set through various Job Portals like naukri, LinkedIn, monster, times jobs etc., existing database, internal and external references
• Conducting the preliminary interviews and briefing the candidates regarding the job profile, salary package and Organization, etc.
• Screening the candidates & forward their resumes for suitable positions based on the client’s requirements.
• Once shortlisted, scheduling the Interview, follow up and co-ordination towards clients.
• Handling on boarding process to ensure the joining formalities are carried out smoothly.
• Maintain candidate database and generate reports from time to time.

DUTIES & RESPONSIBILITIES 

• Own & lead full cycle development: design, implementation, testing & debugging for an automotive product.
• Create conceptual system designs, assess risks, conduct design trade studies, and develop a product that meets feature requirements for integrating sensor, processing and software systems. 
• Lead innovative system development projects with responsibility for achievement of cost, schedule, and technical requirements, with an eye toward technology maturation, transition, and follow on work. 
• Generate comprehensive engineering documentation.
• Responsible for end-to-end system firmware development to include power management, boot loaders, scheduling, RTOS and /or bare metal implementations.
• Troubleshoot and resolve complex software problems in embedded real-time systems.
• Source code development, review & maintenance (C/C++).
• Dive into & take ownership of critical design issues.
• Analyse & propose solutions for performance bottlenecks.
• Address all aspects of technology readiness, including manufacturability. 
• Help build robust methodology and processes to deliver the technology to products. 

REQUIRED SKILLS & EXPERIENCE 

• Experience in embedded architecture, external interfaces, product constraints, along with ability to develop architectures / features that meet these constraints while providing new value for the platform. 
• Experience in system architecture, operating system, device architecture, hardware design.
• Strong background in software methodology & full cycle development (Design, implementation, testing & debugging).
• Expertise in embedded microcontrollers’ architecture.
• Expertise in software designing and programming in C/C++ is a must.
• Algorithm modelling, benchmarking, implementation & digital signal processing.
• Understanding of hardware & software co-verification & emulation platforms
• Experience in understanding hardware, clock-level issues, bridges, delays, interrupts, clock gating, polling etc. 
• Experience with lab instrumentation like oscilloscope, logic/ protocol for debugging embedded systems at HW level. 
• Bachelors | Masters degree in Computer Science or Electronics &  Communication engineering with 2-5 years of relevant experience is a must.