Pentaho developer

SoftNice INC; Jersey City (NJ); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading IT solutions provider in Jersey City seeks a Database Developer with expertise in ETL processes and strong skills in Pentaho and SQL. The ideal candidate will have a Bachelor's degree in Computer Science and a minimum of 2 years of relevant experience. Responsibilities include monitoring job statuses, gathering requirements, and facilitating technical designs. Join a dynamic team that values self-starters and effective communication, driving impact in data warehousing and BI solutions.

Qualifications

• 2+ years of experience in architecture, design, and development of data warehousing and BI solutions.
• Strong experience in ETL, Pentaho, and Oracle.
• Effective oral and written communication skills.

Responsibilities

• Monitor job status, ensuring data integrity across systems.
• Facilitate technical designs for job efficiency.
• Gather requirements and communicate with developers.

Skills

Pentaho Data Integration

SQL

Communication

ETL Process

Oracle

Education

Bachelor's degree in computer science or equivalent

Tools

Postgres

Oracle

Pentaho

Informatica

SSIS

JasperSoft

SSRS

Job description

SoftNice...Your single source for end-to-end expertise and professional services in development of information solutions.Since its inception in 2001, the world’s leading IT organizations have tapped SoftNice’s expertise, resources and cost-effective processes to help them provide strategic information solutions.Unlike most IT solutions providers, SoftNice has evolved a best-practice approach to every aspect of information management and professional services. Combined with our firsthand knowledge of your industry’s business issues, our ability to deliver quality information management solutions and build highly skilled teams more rapidly and cost-effectively is exceptional.

Job Description

• Experience on Pentaho Data Integration and Pentaho Report.
• Running shell scripts to query, ensure data integrity across system and within HR Data warehouse.
• Experience on OLTP and OLAP operations.
• Hands on experience in database tools like Postgres (if not in Postgres then in Oracle).
• Perform preliminary information gathering and create tickets/cases in case of failure and track status to ensure remediation is in place.
• Facilitate the technical design to improve the efficiency of the job monitoring.
• Excellent communication, should be able to gather requirement and translate to the developers.
• Knowledge of SQL data.
• Monitor individual job status if it is not included in the status report.
• Monitor jobs by running status reports and scripts.
• Monitor job notifications from internal system or external vendors.

Qualifications

• Bachelor's degree in computer science or equivalent with around 2+ years of experience of architecture, design and development of data warehousing, ETL and Business Intelligence solution.
• Strong ETL/Pentaho/Oracle developer.
• Technical expertise working on database appliances, large databases specially (ExaData, Vertica, SQL Server), ETL (Pentaho, Informatica, SSIS) and BI (JasperSoft, SSRS) is a must.
• Able to drive priorities within the Enterprise and resolve any dependencies on Enterprise Solutions.
• Able to drive Functional requirements various regulatory development projects with the Enterprise target Architecture.
• Must be a self-starter with effective oral and written communication skills.
• A self-motivated personality, and able to work efficiently by himself/herself, as well as, in a team.
• Experience working with regulatory project (e.g. Basel III, CCAR, BCBS 239).
• Domain knowledge on Banking and Financial & Regulatory Reporting is a plus.

Additional Information

All your information will be kept confidential according to EEO guidelines.