SMBC Group

Returning Candidate?

Senior Interface Developer II

Senior Interface Developer II

Job Locations 
US-NJ-Jersey City
Career Category 
Information Technology
Position ID 
Corporate Title 
Posting Date 

More information about this job


JRI America, Inc. (a subsidiary of SMBC) is seeking an Applications Developer to work in the Applications Development - Internal Interface department. The Internal Interface Team is responsible for developing and maintaining interfaces between the bank's applications which are pivotal to the bank's operations in Europe and North America.

The Senior Interface Developer II (ETL) designs, develops, maintains and supports various interface ETL 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 Interface Development ETL team. Reports to the Team Leader. Has no direct/indirect reports.

Acts as subject matter expert with 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.



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.
Supports weekend maintenance, technology / business recovery tests and system verification / validation events.
Provides overall guidance to less experienced developers and assists them with addressing development issues and bug fixes.
Provides subject matter expertise based on past experiences with IIB development and SOA/ESB implementations.
Keeps up to date on new features and enhancements in the development tools used by the team.
Opens problem tickets with development tool vendors for issues identified with the development tools.



Experience/Knowledge  Requirements

Work Experience: 7 to 10 years of specialized experience

Expert experience implementing 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 knowledge and experience using IBM Quality Stage.

Expert understanding of data warehouse concepts and experience implementing data warehouse using Datastage ETL Tool.

Demonstrated 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.

Ability to influence people outside the immediate span of control.
Required  Skills/Abilities

Work Experience: 7 to 10 years of specialized experience    
  Datastage Parallel and server experience.      
Education: Required: High School or Equivalent    
  Preferred: BA / BS (or equivalent experience)    
  Degree in Finance, Mathematics, Computer Science, or Management Information Systems is preferred.     
Language Skills: Business fluency in the following language(s): English
Skills  and  Special  Requirements  (heavy lifting, excessive overtime, etc.)

Late night and weekend work may be required as necessary