Oracle Informatica Developer with Python

Orb Enterprises - New York, NY

Full-time - Mid Level

New York, NY

Computer and Electronic Product Manufacturing

About the position

The Oracle Informatica Developer with Python role involves designing, developing, and maintaining applications using Oracle, Informatica, Python, and Unix technologies. The position requires strong technical skills in ETL processes, database programming, and collaboration with cross-functional teams to deliver new features and optimize application performance.

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).
• 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, supporting SIT, UAT, and production deployments.
• 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.

Nice-to-haves

• 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.