What are the responsibilities and job description for the Oracle Database Architect with Informatica position at Cynet Systems?
Job Details
We are looking for Oracle Database Architect with Informatica for our client in Jersey City, NJ
Job Title: Oracle Database Architect with Informatica
Job Location: Jersey City, NJ
Job Type: Contract
Job Description:
Pay Range: $70hr - $75hr
Responsibilities:
- 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.
- 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.
- 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.
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.
Salary : $70 - $75
