Senior Oracle PL/SQL & ETL Engineer

TechDigital Group; Jersey City (NJ); On-site; USD 120,000 - 160,000; Full time

Job summary

TechDigital Group is seeking an experienced Oracle/ETL Engineer in Jersey City, NJ to design, develop, and maintain data-driven applications using Oracle SQL, PL/SQL, Informatica PowerCenter, Python and Unix scripting. You will collaborate with cross-functional teams to deliver scalable features and improve performance.

The role requires 12+ years of hands-on experience with ETL tools, Oracle databases, and strong debugging and design skills.

Qualifications

• 12+ years of experience with Oracle, Informatica, Python and shell scripting.
• Proficiency in Oracle PL/SQL and SQL.
• Hands-on experience with Informatica PowerCenter or similar ETL tools.
• Translate functional and technical requirements into detailed design.
• Coding and unit testing; support SIT, UAT and Production deployments.
• Database programming: Stored Procedures, Functions, Tables, Triggers; tune SQL queries for performance.
• Develop ETL processes using Informatica for data integration tasks.
• Proficiency in shell scripting.
• Oracle database performance tuning.
• Document system configurations, procedures, and best practices.
• Excellent problem-solving and attention to detail.
• Ability to work collaboratively in a team environment.

Responsibilities

• Design, develop, and maintain applications using Oracle SQL, PL/SQL, Informatica, Python and Unix technologies.
• Collaborate with cross-functional teams to define, design, and ship new features.
• Optimize application performance and ensure scalability.
• Troubleshoot, debug, and upgrade existing systems.
• Write clean, maintainable, and efficient code.

Skills

Oracle SQL

PL/SQL

Python

Shell scripting

Performance tuning

Stored Procedures/Functions

Data integration

Troubleshooting

Documentation

Team collaboration

Tools

Informatica PowerCenter

Shell scripting

AWS

Snowflake

Job description

TechDigital Group is seeking an experienced Oracle/ETL Engineer in Jersey City, NJ to design, develop, and maintain data-driven applications using Oracle SQL, PL/SQL, Informatica PowerCenter, Python and Unix scripting. You will collaborate with cross-functional teams to deliver scalable features and improve performance.

The role requires 12+ years of hands-on experience with ETL tools, Oracle databases, and strong debugging and design skills.