Data Engineer
Job Description
The Data Engineer position in Trenton, NJ is an onsite role with an initial term of 10 months plus a possible extension at Robotics Technologies. This engagement focuses on building and maintaining reliable data pipelines and database capabilities across PostgreSQL and Oracle environments, including reconciliation, data protection, and change data capture.
Role Details
- Location: Trenton, NJ (onsite)
- Schedule: 10 Months + Extension
- Compensation: USD 76 - 76 per hourly
- Minimum Experience: 7 years
- Education: Bachelor’s degree in Computer Science, Information Systems, or a related field
Key Responsibilities
- Design PostgreSQL schemas and support migration tooling
- Extract data from Oracle sources
- Perform reconciliation and drift detection between two systems that hold the same records
- Apply data masking for non-production use
- Use advanced SQL and scripting in a language such as Python
- Read and interpret Oracle PL/SQL
- Work with change data capture tooling
- Support HR or personnel data use cases
- Contribute to work aligned with Human Services or Child Welfare programs
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or a related field
- 7+ years of experience in data engineering or database administration
- Proficiency in PostgreSQL schema design and migration tooling
- Experience extracting data from Oracle sources
- Experience with reconciliation and drift detection between two systems holding the same records
- Experience with data masking for non-production use
- Advanced SQL skills and experience with a scripting language such as Python
- Ability to read Oracle PL/SQL
- Experience with change data capture tooling
- AWS database certification or experience with Amazon Aurora
- Experience with HR or personnel data
- Experience within Human Services or Child Welfare programs
Technology Stack
- PostgreSQL
- Oracle
- SQL
- Python
- Oracle PL/SQL
- AWS
- Amazon Aurora