Technoidentity

At Technoidentity, we’re a Data + AI product engineering company delivering scalable, modern enterprise solutions.

We are seeking a seasoned Senior Database Developer & PostgreSQL Expert with 8–10 years of experience across multiple database systems, with deep hands-on expertise in PostgreSQL internals, performance tuning, advanced indexing, and enterprise data architecture. 

With a strong preference for Oracle to AlloyDB (PostgreSQL) migration expertise, this role blends modernization, advanced PostgreSQL engineering, and cloud-native architecture on Google Cloud Platform (GCP). If you thrive in transforming complex data logic, optimizing performance, and architecting enterprise-grade PostgreSQL systems, this opportunity is built for you. 

Requirements

Key Responsibilities 

Database Migration & Development 

• Lead database migrations from Oracle to PostgreSQL-based platforms like AlloyDB, applying both manual and automated strategies. 
• Re-engineer stored procedures, triggers, and packages from PL/SQL to PL/pgSQL. 
• Recreate and optimize DB objects (schemas, constraints, views, indexes) across target platforms. 
• Design PostgreSQL-specific architecture including partitioning strategies, indexing plans (GIN, GiST, BRIN), and query optimization paths. 
• Leverage PostgreSQL internals such as vacuum tuning, WAL configuration, and connection management for optimal system performance. 

Performance Optimization 

• Implement indexing strategies, query plans, and table partitioning to enhance database performance. 
• Use tools like EXPLAIN ANALYZE, pg_stat_statements, and GCP-native monitoring dashboards for tuning. 
• Collaborate with DevOps for deployment pipelines and infrastructure-as-code (IaC) best practices. 
• Perform deep-dive PostgreSQL performance fine-tuning including buffer cache analysis, autovacuum configuration, and planner optimization. 
• Optimize PostgreSQL workloads for high concurrency and large datasets, ensuring stable and predictable performance. 

Data Integrity & Validation 

• Build and execute validation scripts for source-to-target comparison. 
• Ensure row-level data accuracy, transformation logic fidelity, and zero data loss post-migration. 
• Manage large-scale datasets for archival and bulk processing tasks. 
• Implement PostgreSQL-native data integrity strategies like constraint management, row-level security (RLS), and trigger-based validations. 

Collaboration & Documentation 

• Work with cross-functional teams to translate business logic and legacy workflows to scalable, modern database systems. 
• Maintain clear documentation on schema conversions, validation methods, rollback strategies, and change history. 
• Create PostgreSQL architecture documents, optimization playbooks, and database best-practice guidelines for engineering teams. 

Ideal Candidate Profile 

Experience & Skills 

• 4–10 years of database development experience across Oracle, PostgreSQL, and similar RDBMS platforms. 
• Strong expertise in PL/SQL and PL/pgSQL for procedural logic, error handling, and performance tuning. 
• Proven track record of large-scale database migration projects (Oracle to PostgreSQL/AlloyDB preferred). 
• Proficient in query optimization, indexing, partitioning, and schema normalization. 

Are you ready to solve people challenges that fuel business growth? At Technoidentity, we’re a Data+AI product engineering company building cutting-edge solutions in the FinTech domain for over 13 years—and we’re expanding globally. It’s the perfect time to join our team of tech innovators and leave your mark!

Job Title: QA Engineer – Integration Platforms

Experience: 5+ years

Employment Type: Full Time, Permanent

Department: Engineering – QA & QE

Role Category: Quality Engineering, Assurance and Testing

What’s in it for You? 

At Technoidentity, we are seeking a detail-oriented and experienced QA Engineer who is strong in both manual testing and automation, with a keen understanding of system integrations. This role demands a quality-first mindset and practical exposure to validating end-to-end integration scenarios across multiple platforms and services.

You will collaborate with cross-functional teams including product, engineering, and DevOps, and play a key role in ensuring seamless system interoperability through robust testing processes.

What Will You Be Doing? 

• Own and execute manual and automated testing for new features, regression cycles, and integration workflows.
• Design and maintain test cases, test plans, and perform exploratory testing for complex, cross-service integrations.
• Validate API-level and user-facing functionality, ensuring complete coverage for end-to-end business scenarios.
• Document and track defects with clear steps and business impact.
• Work with automation engineers to include relevant manual test cases in automation suites.
• Build and maintain automation scripts using frameworks like Cypress, Playwright, or similar.
• Ensure seamless integration of test cases into CI/CD pipelines.
• Participate in design discussions and proactively advocate for quality at all stages of the SDLC.

What Makes You the Perfect Fit? 

• 5+ years of experience in Software QA with a strong emphasis on both manual and automated testing.
• Proven expertise in testing integrated systems, especially across platforms like Mulesoft, Tray.io, Oracle Integration Cloud (OIC), Dell Boomi, Salesforce, etc.
• Hands-on automation experience with integration-focused test scripts and tools.
• Solid understanding of API testing, cross-service workflows, and validation techniques.
• Familiarity with at least one scripting/programming language: JavaScript, Python, Java, etc.
• Experience with test management tools such as TestRail, Zephyr, or XRAY.
• Practical experience with CI/CD tools (e.g., Jenkins, GitHub Actions, Git) and version control systems.
• Excellent problem-solving skills and attention to detail, especially in edge-case discovery and impact analysis.
• Strong communication and interpersonal skills to work across agile, fast-paced teams.

Nice to Have

• Proficiency in tools like Postman, REST Assured for API testing.
• Working knowledge of SQL for backend validations.
• Exposure to agile methodologies and tools like JIRA, Confluence, etc.
• Experience working in containerized environments (Docker, Kubernetes).

Education

• Bachelor's degree in Computer Science, Engineering, or a related discipline, or equivalent practical experience.

Supercharge Your Career as a Sr. Dev Engg at Technoidentity!

Are you ready to solve people challenges that fuel business growth? At Technoidentity, we’re a Data+AI product engineering company building cutting-edge solutions in the FinTech domain for over 13 years—and we’re expanding globally. It’s the perfect time to join our team of tech innovators and leave your mark!

What Will You Be Doing?

• Translate the designs into production grade implementation for the Invoice user flows.
• Understand how to integrate with apis's using graphql or any other async library etc.
• Work cross-functionally with product, design, and other engineering counterparts to clarify and implement the requirements.
• Drive, lead, and contribute to the full software development cycle: design, development, QA, experimentation, analysis, and launch.

What Makes You the Perfect Fit?

• 5+ years of full stack software development experience with strong expertise on front-end implementation.
• Experience with modern Javascript / TypeScript frameworks such as React, Preact, Angular, Next, Vue or Meteor.
• Hands-on experience writing, optimizing, and monitoring GraphQL queries and mutations in a production environment.
• Proficient in at least one major programming language (preferably Java / Kotlin).
• Exposure to architectural patterns of large, high-scale web applications, such as well-designed APIs, modular integrations and efficient algorithms.
• Passionate about design and building UX for customer facing applications.
• Outstanding communication and interpersonal skills with strong attention to detail.

Requirements

Front End First

• Solid hands on experience with React and TypeScript or an equivalent modern framework
• Ability to convert designs into clean, functional UI without hand holding
• Comfortable building and owning end to end user flows like forms, dashboards, and workflows
• Working knowledge of performance basics, accessibility, and responsive design

GraphQL

• Practical experience consuming GraphQL APIs
• Writing queries and mutations confidently
• Understanding how to handle loading, error states, and basic caching
• Does not need to design the entire schema, but should not treat GraphQL as magic either

Backend Awareness

• Working experience in Java or Kotlin
• Ability to understand existing backend services and make incremental changes
• Familiarity with APIs, data models, and basic system interactions
• Not expected to design large systems independently, but should ask the right questions

Engineering Hygiene  

• Writes readable, maintainable code
• Comfortable with unit tests and basic integration tests
• Experience working with code reviews and CI CD pipelines
• Understands production readiness and release discipline

Product and UX Sensibility

• Good eye for design and usability
• Can spot obvious UX gaps and raise them early
• Thinks in terms of user flows, not just tasks
• Understands trade offs between speed and quality

Collaboration Skills

• Can work well with PMs and Designers
• Communicates clearly and proactively
• Takes ownership of features, not just tickets
• Receptive to feedback and able to iterate fast.

Supercharge Your Career as a Oracle Integration Cloud (OIC) Developer at Technoidentity!

Are you ready to solve people challenges that fuel business growth? At Technoidentity, we’re a Data+AI product engineering company building cutting-edge solutions in the FinTech

domain for over 13 years—and we’re expanding globally. It’s the perfect time to join our team of tech innovators and leave your mark!

What’s in it for You?

We are seeking an experienced Oracle Integration Cloud (OIC) Developer to design, develop,and implement integrations and reporting solutions across Oracle Cloud and third-party

systems. This role requires strong hands-on expertise in Oracle middleware, BI Publisher, OTBI, and VBCS, with the ability to work collaboratively with business, functional, and technical teams in a fast-paced, global environment

What Will You Be Doing?

• Design and build integrations using Oracle Integration Cloud (OIC) to meet business and application requirements.

• Configure and deploy Oracle middleware solutions aligned with functional and technical design specifications.

• Develop technical specification documents based on Functional Design Documents (FDDs).

• Collaborate with business and functional teams to translate requirements into technical solutions and detailed test cases.

• Build BI Publisher reports, reconciliation reports, and drill-down dashboards to support analytical and operational needs.

• Develop OTBI reports and infolets for ad hoc analytics and performance tracking.

• Create and enhance VBCS applications and APEX web pages for effective data management by business users.

• Perform unit testing, system testing, and support QA processes to ensure robust, high-quality deliverables.

• Participate in design discussions to understand end-to-end business processes and continuously enhance technical capabilities.

What Makes You the Perfect Fit?

• 5–8 years of overall experience with Oracle middleware, including 3+ years hands-on

with Oracle Integration Cloud (OIC).

• Proven experience integrating Oracle ERP Cloud / E-Business Suite with third-party

applications.

• Strong proficiency in OIC, SQL, PL/SQL, Web Services (SOAP, REST), JSON/XML,

and XSLT processing.

• Hands-on experience in VBCS (Visual Builder Cloud Service) — mandatory.

• Expertise in Oracle BI Publisher (data models, templates, XSLT/RTF layouts, bursting,

and advanced report capabilities).

• Experience building OTBI reports, dashboards, and infolets.

• Familiarity with Oracle PaaS architecture, cloud security concepts, and SaaS

integrations (e.g., Oracle ERP Cloud, Workday).

• Experience with CI/CD pipelines using Jenkins, GitHub, and JIRA.

• Strong communication and interpersonal skills for cross-functional collaboration.

• Bachelor’s or Master’s degree in Engineering, Computer Applications, or a related

discipline.

Additional Details

• Shift: Night shift (aligned to US PST time zone).

• Work Mode: Remote (India-based).

• Engagement: Full-time

Job description

Job responsibilities

• Gather functional requirements and develop Identify & resolve defects/bugs in pre-production, production, QA testing & post-release patches
• Design and build scalable APIs (application programming interface)
• Write clean, efficient, and reusable code
• Build compelling web applications using best practices of the AngularJS  Master’s degree in Computer Science (or equivalent experience)
• 3+ years of experience as a Full-stack developer (rare exceptions for highly skilled devs) framework
• Analyze website performance and drive improvements QA/QE

Minimum requirements

• Bachelor’sProficiency in AngularJS, Node.js, and related technologies
• Proficient in HTML5, CSS3, and JavaScript
• Experience with REST APIs and third-party libraries
• Good knowledge of JavaScript MV-VM/MVC frameworks including AngluarJS
• Fluency in English to collaborate with engineering managers
• The ability to work full-time (40 hours/week) with a 4 hour overlap with US time zones
• technical specifications
• Work cross-functionally with developers, designers, product managers, Preferred skills
• Command over complex code bases, large systems & version control systems like Git
• Working knowledge of database, APIs, proxies, caching layer, and other web services
• Experience in cross-browser compatibility, and responsive design of the applications
• Expert understanding of server-side logic and front-end performance optimization
• Excellent command over algorithms, data structures, and computer science fundamentals