Oracle PL/SQL

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

• Design, develop, and maintain applications using strong Oracle SQL and 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.

Requirements

• 12+ years of experience building solutions using Oracle, Informatica, Python and shell scripting.

• Proficiency in Oracle PL/SQL and SQL.

• Hands-on experience with Informatica PowerCenter or similar ETL tools.

• Experience in Translating functional and technical requirements into detailed design

• Experience in Coding and unit testing, support SIT, UAT and Production deployments

• Must have good database programming skills covering Design/development of Stored Procedures, -Functions, Tables, and Triggers and tuning SQL queries for optimal performance.

• Develop ETL processes using Informatica to manage data integration tasks.

• Proficiency in shell scripting

• Experience with performance tuning and optimization of Oracle databases

• Document system configurations, procedures, and best practices

• Excellent problem-solving skills and attention to detail.

• Ability to work collaboratively in a team environment.

Preferred Qualifications

• Experience with Tivoli Workload Scheduler (TWS)

• Experience with cloud services preferably AWS

• Experience with Snowflake

• Knowledge of DevOps practices and tools.

• Familiarity with Agile methodologies.