QA - Test Engineer - Fresher

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. 

Requirements:

• Proven experience as an OutSystems Solutions Lead or similar role.
• Extensive experience with the OutSystems platform, including architecture, development, and deployment.
• Strong understanding of software development lifecycle (SDLC) and agile methodologies.
• Excellent leadership, communication, and interpersonal skills.
• Ability to manage multiple projects and priorities effectively.
• Strong problem-solving skills and attention to detail. Certification in OutSystems is a plus.

Preferred Skills:

• Experience with other low-code/no-code platforms.
• Knowledge of web technologies such as HTML, CSS, JavaScript, and RESTful APIs.
• Familiarity with database management systems (e. g., SQL Server, Oracle).

Job Summary:-

We are seeking a highly motivated individual for Business Development Profile / Online Bidding
Should be comfortable in client interaction and proposal writing.
Should having knowledge of website bids.
Excellent Communication skills (written & Oral) can also apply for this position.
Should have knowledge of bidding portals.

Roles and Responsibilities

We are looking for a qualified Performance Marketing Lead to take the lead in developing successful, long-term digital marketing strategies for our company.

As a Digital Marketing Lead, you should have in-depth marketing experience and a passion for digital technologies. You will work closely with different teams to ensure consistency through all digital marketing channels. You should also provide forward-thinking ideas to build and maintain a strong company web presence.

Ultimately, you should be able to drive all digital marketing efforts to achieve our business objectives.

We need a spearhead who can:

Performance Marketing

• Continuously iterate and design A/B tests around different creatives, audiences and/or bidding strategies;

• Manage, review, and perform daily account responsibilities associated with different paid advertising platforms,

• Planning and control of the digital performance marketing budget and spend by allocating budgets to different channels;

• Work with campaign teams to plan successful campaigns focusing on audience, product and placements to drive volume and efficiency thresholds;

• Using A/B testing to optimize digital marketing performance;

• Developing and implementing comprehensive digital marketing programs in line with brand plans and business priorities;

• Reviewing and optimizing the design and content of all online assets including the company website and social media pages;

• Working with other stakeholders to optimize the conversion funnel for specific traffic sources, campaigns, user segments etc;

• Working with content marketing and design teams to create suitable content for each stage of a customers digital journey & overseeing multi channel content strategies.

• Analyze weekly and monthly reports from multiple ad channels, Google Analytics, and MMP to drive insights and opportunities along with working knowledge & tracking of analytics tools (GTM & GA)

• Developing and managing digital prospecting and remarketing campaigns

• Ensuring successful planning, execution, optimization for key traffic KPIs via paid, organic & own media channels

• Identifying and testing new channels to continue to meet or exceed established critical metrics

• Working closely with the management to share funnel conversion improvement ideas, feedback & present results

• Managing Digital Marketing Team.

• Knowledge around fraud & its prevention across web & app.

Organic Growth

• Proficiency with all major social media platforms (e.g: FB, Insta, Twitter etc)

• Test ads across devices to ensure the best branding and user experience

• Test ad messaging across segments and report on engagement

• Optimize organic social posts for content and messaging

• Optimize website content, landing pages, and paid search copy.

• Monitor and respond to customer comments on social posts

• Work with internal stakeholders to promote announcements

• Campaign management, measurement, optimization.

• Dive deep into reporting which includes but not limited to bids, device, audience segments, geo and demo targets, and creative, etc

• Maintain digital dashboard of several different accounts

• Strategizing and Maintaining Brand Consistency across social media platforms via tone, voice, and terminology.

• Manage community engagement, growth, and optimization

• Creating compelling social media content, collaborations and campaigns in order to grow Shiprocket's digital community, engage new audiences and sustain existing followers

• Interacting with new and existing audiences online and deepening engagement across all Shiprocket's social media platforms

• Draft social media content for Shiprocket and post it on platforms

• Scan and monitor digital and social media sites and hashtags, identify opportunities for Shiprocket on digital platforms

• Provide live coverage of events including by taking pictures and short videos and drafting messages for Shiprocket social media channels

• Monitor Shiprocket & social media channels, engage with community members and flag reputational risks or communication opportunities to Management

• Support efforts to ensure social media presence and branding are consistent and cohesive across all platforms

• Identify strategic opportunities for content and digital partnerships to enhance Shiprocket & social media reach and engagement