ETL Developer

Jersey City, New Jersey Pierce Technology Corp

Our client seeks an ETL Developer who has experience in developing enterprise ETL solutions and demonstrates expert-level knowledge in SQL Server and or Oracle application framework. The successful candidate will be responsible for all phases of in-house application development and third-party package customization and implementation. This includes business requirement analysis, program design, coding, testing, implementing and maintaining/supporting the systems.

Key Duties and Responsibilities

System Development: Participate in full project lifecycle in implementing new or enhancing application systems (both in-house and third vendor packages). The task will include, but not be limited to:

Business requirement analysis

System design and technical specification writing Setup & configure system environment Develop application Develop & perform test cases. Support user acceptance test.

Make a plan for application/data migration. Prepare production release.

System/User Support

Respond to production troubles and user inquiries Foresee potential issues and address them Off-hour support is required to respond to troubles during nightly processing, etc.

Occasional weekend work is required

Participate in production support monthly rotation schedule


Maintain required documentation, which includes system environment diagram, system specification/design document, test plan/test cases/test evaluation, operations manual, etc.


Follow the policies and procedures of the Bank, including, but not limited to, Information Control Policy, the Project Promotion Procedures, System Trouble Reporting Procedures, and Production Release Approval Procedures.

Behavioral Competencies

Manage own priorities and time allocation Multi-tasking capabilities Excellent interpersonal and communication skills Must be self-motivated and a team player Strong judgment, decision=making and problem-solving abilities



Bachelors Degree in Computer Science

7+ years experience in SQL Server and or Oracle-based application development and architectural technologies, preferably in the financial services industry.

8-10 years experience with ETL tools (SSIS) and Data Integration projects.

5-7 years experience with ETL tools (SSRS).

Technical Skills Required

DBMS: Oracle, MS SQL Server

ETL/Data Integration tools (SSIS)


System optimization experience

UNIX: Shell scripting or Perl scripts

C# is a plus

Java, .Net is a plus

Knowledge of MVC frameworks is a plus

HP Unified Functional Testing (UFT), HP Quality Center and Application Lifecycle Management (ALM) is a plus SVN and Jenkins experience TIDAL job schedule is a plus Wolters Kluwer OneSumX is a huge plus

To apply for this job please visit the following URL: →