Custom Software Engineer

Project Role : Custom Software Engineer

Project Role Description : Develop custom software solutions to design, code, and enhance components across systems or applications. Use modern frameworks and agile practices to deliver scalable, high-performing solutions tailored to specific business needs.

Must have skills : Oracle Procedural Language Extensions to SQL (PLSQL)

Good to have skills : NA

Minimum 5 Year(s) Of Experience Is Required Educational Qualification : 15 years full time education Summary: A KDB+ / q-Language Developer is responsible for designing, developing, and maintaining high-performance time-series databases and real-time data processing systems. The role involves building q-based applications, optimizing queries, and ensuring low-latency ingestion of large financial datasets. The developer supports trading, analytics, and reporting teams by creating efficient data pipelines, real-time feeds, and analytical solutions. Key responsibilities include system performance tuning, production support, and integration with upstream/downstream platforms. The role requires strong analytical skills, proficiency in q-language, deep understanding of KDB+ architecture, and experience working in fast-paced financial environments. Roles & Responsibilities:

• Expected to be an SME.
• Design, develop, and maintain KDB+ databases Create schema, tables, partitions, and data pipelines. Implement reliable ingestion processes for real-time and historical data.
• Develop q-language scripts and applications Build q functions, queries, APIs, and utilities for performance-sensitive use cases. Optimize scripts for speed, memory usage, and scalability.
• Build analytics and reporting solutions Create time-series analytics, dashboards, and query interfaces for end-users. Support quants, traders, and data analysts with custom analytics.
• Troubleshoot slow queries, memory issues, and process bottlenecks. Optimize HDB (Historical Database) and RDB (Real-time Database) performance.
• Documentation & collaboration Maintain documentation for scripts, design decisions, and architecture. Collaborate with quants, traders, business users, and DevOps teams.
• Data quality, validation, and monitoring Ensure accuracy, consistency, and completeness of large financial datasets. Automate data checks and monitoring alerts.
• Engage with multiple teams and contribute on key decisions.
• Provide solutions to problems for their immediate team and across multiple teams.
• Facilitate knowledge sharing sessions to enhance team capabilities.
• Mentor junior team members to foster their professional growth. Professional & Technical Skills:
• Strong expertise in KDB+ database architecture (RDB, HDB, IDB).
• Advanced proficiency in q-language (vector programming, functional programming).
• Hands on Unix
• Strong experience with time-series data, tick data, and real-time processing.
• Hands-on with tick architecture, tickerplant, and real-time subscription systems.
• Understanding of memory-mapped files, partitions, and table schemas.
• Uses Q language which is an expressive & functional language.
• Relational dB + Column-Oriented Data Storage which is Ideal for time-series operations such as computing rolling averages, joins, and group-by on billions of records.
• In-Memory and On-Disk kdb+tick: A real-time, in-memory streaming database that captures and analyzes live data. Historical database (HDB): Persistent storage for historical data, usually on disk. You can combine & query both live and historical via a single interface (called kdb+ TP gateway process ) Additional Information:
• Knowledge of capital markets, trading, derivatives, fixed income, FX.
• Exposure to cloud environments (AWS/Azure/GCP) with KDB integrations.
• Experience with data visualization tools (QStudio, KX Dashboards, Grafana)
• Minimum 15 years of education is required