Ab initio Developer

Pantar Solutions INC

Apply to this job
Andes, NY, us on site Until 8/21/2026 H-1B sponsor history First posted March 26, 2025 Last posted March 26, 2025
Job description

Ab Initio Technical Lead

NYC, NY

Long term


Requisition Details:
Skills/Experience:
An Ab Initio Technical Lead with primary focus of this position to provide
technology leadership, technological recommendations and reusable solutions
that support the development and implementation of  DW/BI solutions in
Business Insurance area.

Requirements:
Candidate must be experienced working in  ETL based projects involving Ab
Initio
Other ideal qualifications include experiences in:
* Ab Initio (Technical Expert)
* Understands where to obtain information needed to make the appropriate
decisions
* Demonstrates ability to break down a problem to manageable pieces and
implement effective, timely solutions
* Identifies the problem versus the symptom
* Manages problems that require involvement of others to solve
* Reaches sound decisions quickly
* Carefully evaluates alternative risks and solutions before taking action
* Optimizes the use of all available resources
* Develops solutions to meet business needs that reflect a clear
understanding of the objectives, practices and procedures of the
corporation, department and business unit

Responsibilities:
* Under the direction of the Portfolio Architect, assists with ETL design
and solutions
* Supports maintenance of plans to address significant architecture gaps
between current and target state
* Collaborates with business leaders to determine how to best use technology
to enable growth and success (e.g. operational reporting and advanced
analytics).
* Participates in defining and driving architecture competencies, processes,
and best practices across Business Insurance.
* Understands potential impacts of proposed solutions on other systems,
processes or projects. Articulates and documents designs, considering
tradeoffs, costs, and benefits.
* Participates in day-to-day execution of the architecture strategy
* Works within a single project to develop, communicate, and mentor others
on design/implementation standards, guidelines and best practices
* Stakeholder Management

Skills:
* 7-8 years of work experience in Ab Initio
* Good analytical and logical skills in writing SQLs, Stored Procedures and
creating Marts/Views in Oracle
* A good end to end knowledge in ETL landscape; starting from source system,
warehouse, mart and reports
* Very strong ETL Concepts and hands-on experience on Ab Initio ETL Tool
(Basic & Advanced)
* 4-year degree in a related field (or equivalent experience)
* Experience working within a highly-matrixed organization
* Strong communication and presentation skills

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

About this role

Summary

Lead ETL development using Ab Initio, design solutions, collaborate with stakeholders.

Job title

Ab initio Developer

Experience level

7-8 years

Industry

software

Location requirements

On-site in Andes, NY, no remote work allowed.

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

Ab InitioSQLOracleETL concepts

Preferred skills

communicationproblem solving

Specializations

ETLAb InitioSQLOracle
Locations

Structured locations inferred from the posting.

Andes, NY 13731, USA

On-site City