Local or nearby candidates preferred
Title: Oracle Database Architect with Informatica
Location: Jersey City NJ || Day 1 Onsite
Terms: Contract
Job Details:
JD 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.
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.
Regards,
Srijan Roy
Talent Acquisition Specialist
Cynet Systems