ETL Informatica Developer

JPS Tech Solutions; New Jersey; On-site; USD 120,000 - 160,000; Full time

Job summary

JPS Tech Solutions is seeking an experienced data solutions engineer to design and implement ETL pipelines using Informatica, Oracle PL/SQL, and Python. The role requires translating requirements into detailed designs, coding, and unit testing while supporting SIT, UAT, and production deployments.

The ideal candidate will have 8+ years of relevant experience, strong SQL skills, and excellent problem-solving abilities. Collaboration within a team and adherence to best practices are essential.

Qualifications

• 8+ 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.
• Develop ETL processes using Informatica to manage data integration tasks.
• Document system configurations, procedures, and best practices.

Skills

Python

SQL

Shell scripting

ETL concepts

Performance tuning

Stored procedures/functions/triggers

Translating requirements

Team collaboration

Education

Bachelor's degree in computer science/Engineering

Tools

Informatica PowerCenter

Job description

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.
• Bachelor’s degree in computer science, Engineering, or a related field.