Data Engineer - Python

TechDigital Group; Jersey City (NJ); On-site; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a skilled developer to design and maintain applications using Oracle, Informatica, and Python technologies. This role offers the opportunity to collaborate with cross-functional teams, optimize application performance, and implement security measures. Ideal candidates will have extensive experience in ETL processes, database programming, and shell scripting. Join a dynamic and innovative environment where your contributions will drive the success of impactful projects. If you're passionate about technology and eager to make a difference, this position is perfect for you.

Qualifications

• 8+ years of experience in building solutions with Oracle, Informatica, and Python.
• Strong knowledge of Python frameworks and proficiency in PL/SQL.

Responsibilities

• Design and maintain applications using Oracle, Informatica, and Python technologies.
• Collaborate with teams to define and ship new features.

Skills

Python

Shell scripting

PL/SQL

Unix shell scripting

Problem-solving skills

Education

Bachelor's degree in Computer Science

Engineering or related field

Tools

Informatica PowerCenter

Oracle

AWS

Tivoli Workload Scheduler

Snowflake

Job description

Skill set: Python (Pandas), Shell scripting, PL/SQL, Unix shell scripting
Exp: 10+ years

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, 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.
• Bachelor's 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.