Tech Lead

Job Title

Location- Middletown Rate- *** Requirement 1:

Area Skills/Technologies:

• Skill Requirement Excel Analysis VBA, business logic mapping
• Required Backend Java, Spring Boot, REST, error handling
• Required Database PostgreSQL, schema design, queries, ORM
• Required Workflow Temporal.io concepts, workflow/activity design
• Good to have Frontend React, API integration, UI/UX, state mgmt
• Required Integration API contracts, microservices, security
• Good to have Deep Platform Foundry data pipelines, ontology, APIs, code workbooks
• Required DevOps Git, Docker, CI/CD, testing
• Soft Skills Communication, documentation, problem-solving

Good to have Excel Macro/VBA Analysis Ability to read, understand, and trace complex VBA macro code. Reverse-engineering business logic, calculations, data flows, and hidden dependencies within the spreadsheet. Documenting and mapping out workflows, decision trees, and data structures from Excel.

Palantir Foundry Data Integration Understanding how to ingest, store, and transform data within Foundry. Familiarity with Foundry's ontology, data lineage, and asset management.

Code Workbooks Data Pipelines Experience with Code Workbooks (Python, SQL, JavaScript, etc.) for ETL and data processing. Designing and scheduling pipelines for batch or streaming data flows.

Data Modeling Schema Design Mapping application/database models to Foundry's data structures. Defining and maintaining schemas and relationships in Foundry's ontology.

Java Spring Boot Proficiency in Java (preferably latest LTS version). Experience building RESTful APIs, service layers, and microservices using Spring Boot. Dependency injection, configuration, and error handling in Spring Boot.

Database (PostgreSQL) Data modeling and schema design based on Excel data structures. Writing efficient queries, understanding transactions, indexing, and migrations. Using JPA/Hibernate or Spring Data for ORM, or direct JDBC as needed.

Workflow Understanding of workflow orchestration using Temporal or other workflow technologies (e.g., defining workflows, activities, retries, and error handling). Designing long-running, stateful processes that match the macro's workflow, but in a scalable, robust way.

ReactJS Building modern, modular, and maintainable GUIs. State management (e.g., React Context, Redux). Handling forms, validations, dynamic tables, and data visualization that mimic Excel's user interactions.

API Integration Consuming RESTful APIs in React (using Axios, Fetch, React Query, etc.). Handling async data flows, error states, and user feedback.

UI/UX Design Translating Excel UI and user interactions into intuitive, web-based components. Applying responsive design and accessibility best practices.