Overview
On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Extract
Transform
Load
Hibernate
JPA
Java
JavaScript
Macros
SQL
Python
RESTful
PostgreSQL
Docker
JDBC
VBA
Microservices
Visual Basic
Spring Framework
Mapping
Job Details
Java developer with VB and Advance Excel experience
Location- Middletown, NJ onsite
Duration: Long term
Job Description:
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 |
DevOps | Git, Docker, CI/CD, testing | Required |
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.
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 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.