Logo
MSys Inc

Oracle Database Developer (PL/SQL) - Onsite/Hybrid

MSys Inc, Jersey City, New Jersey, United States, 07390


Job summary:

Title:

Oracle Database Developer (PL/SQL) - Onsite/Hybrid

Location:

Jersey City, NJ, USA

Length and terms:

Long term - W2 or C2C

Position created on 11/06/2024 03:22 pm

Job description:

**** Webcam interview *** Long term project *** *** Onsite/Hybrid ***

Note from Project Team:

Exhaustive experience in PL/SQL with Unix and python. Informatica can be intermediate or more.

Beginner or intermediate in AWS or Snowflake or both.

Responsibilities:

Design, develop, and maintain applications using Oracle , Informatica, Python and Unix technologies.

Collaborate with cross functional teams to define, design, and ship new features.

Optimize application performance and ensure scalability.

Implement security measures and data protection protocols.

Troubleshoot, debug, and upgrade existing systems.

Write clean, maintainable, and efficient code.

Stay up to date with the latest industry trends and technologies.

Requirements:

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

Strong knowledge of Python frameworks (e.g., Pandas, Streamlit, etc).

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.

Bachelors degree in Computer Science, Engineering, or a related field.

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.

Contact the recruiter working on this position:

The recruiter working on this position is Mahesh Kodur(Raghu team)

His/her contact number is His/her contact email is kmahesh@msysinc.com

Our recruiters will be more than happy to help you to get this contract.