ETL Developer

BinTech Group; Jersey City (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

BinTech Group is seeking an ETL Developer to join the Data Analytics team in Jersey City. You will design, build, deploy, and support DataStage ETL interfaces and data integration processes for a data warehouse environment.

You will work across the full project lifecycle, collaborate with business and technology teams, and participate in production support and weekend maintenance to ensure reliability of interfaces.

Qualifications

• Expert experience implementing and supporting large data warehouse/data mart using DataStage ETL.
• Strong ability to design, develop, deploy and maintain ETL interfaces for data integration.
• Experience across all phases of the project lifecycle and production support.

Responsibilities

• Performs analysis and design of requirements for ETL interfaces.
• Develops and maintains DataStage ETL interfaces between databases and files.
• Collaborates with application teams to gather development requirements.
• Creates unit tests and documents developed processes.
• Performs code reviews and ensures adherence to standards.
• Coordinates code promotion across SDLC environments and validates interfaces.
• Supports QA by helping define test cases and participating in testing.
• Provides status updates to leads and managers.
• Troubleshoots production issues and supports weekend maintenance.

Skills

ETL development

DataStage

Unix

SQL

Data warehousing

Production support

SDLC

QA collaboration

Data integration

Tools

IBM InfoSphere DataStage

Oracle

SQL Server

Job description

The ETL Developer is part of the Data Analytics team group and is responsible for designing, building, deploying, supporting and maintaining ETL A2A DataStage interfaces using the IBM InfoSphere DataStage ETL development tool.

SCOPE

The ETL Developer will be main DataStage ETL interfaces and will design, develop, maintain, and support DataStage ETL compliance processes using the IBM InfoSphere DataStage tool. This role is also responsible for complex interface process development, troubleshooting issues, supporting weekend maintenance and production support of the interface processes development by the ETL Team. Reports to the Team Leader. Has no direct/indirect reports.

Takes full ownership of one or more projects primarily focused on developing integration solutions for multiple projects. This role executes deliverables with minimal supervision applying standard operating procedures as well as technical expertise to unique sets of facts, refers more complex matters to supervisors or other experienced staff. This role participates in a production weekly support roster.

PRIMARY RESPONSIBILITIES

The job responsibilities are described herein:

• Performs analysis and design of the business requirements and specifications as required.
• Develops and maintains interface ETL processes between databases and/or flat files.
• Works with various application team members to obtain the requirements for their development work.
• Creates unit test plans and performs unit testing for the interface processes that they developed or modified.
• Creates documentation for the processes that they developed as well as updates documentation for the processes that they modified.
• Performs peer code reviews including verification of compliance with coding standards and ensures that the code they developed adheres to coding standards and functional / technical specifications.
• Coordinates code promotion activities through all SDLC environments and validates that promoted interface code is working as expected.
• Assists QA team with identifying QA test cases and supports them during QA testing.
• Updates team leader and project manager with status of assigned development/project work.
• Troubleshoots production issues independently and assists in timely resolution of incidents.
• ETL Support. Supports weekend maintenance, technology / business recovery tests and system verification / validation events.
• Keeps up to date on new features and enhancements in the development tools used by the team.

CRITICAL JOB KNOWLEDGE AND CORE COMPETENCIES/SKILLS

• Expert experience implementing and supporting large data warehouse/data mart, using Datastage ETL tool.
• Functional experience using data model as the main document to design and develop the Datastage load process for a data warehouse/data mart.
• Strong knowledge of relational and dimensional database concepts.
• Experience working in all phases of a full project life cycle, including design.
• Experience developing both server and parallel jobs running on a Unix platform against relational databases (i.e., Oracle or SQL Server systems) as source and target data environment.
• Expert understanding of data warehouse concepts and experience implementing data warehouse.
• Demonstrate ability to work on multiple projects simultaneously.
• Excellent communication skills both verbal and written with the ability to write and communicate requirements to business and technology partners.

Requirements

Need only locals NJ,NY

The ETL Developer is part of the Data Analytics team group and is responsible for designing, building, deploying, supporting and maintaining ETL A2A DataStage interfaces using the IBM InfoSphere DataStage ETL development tool

The ETL Developer will be main DataStage ETL interfaces and will designs, develops, maintains, and supports DataStage ETL compliance processes using the IBM InfoSphere DataStage tool. This role is also responsible for complex interface process development, troubleshooting issues, supporting weekend maintenance and production support of the interface processes development by the ETL Team. Reports to the Team Leader. Has no direct/indirect reports.

ETL Support. Supports weekend maintenance, technology / business recovery tests and system verification / validation events.

Assists QA team with identifying QA test cases and supports them during QA testing.