Company : Banking Corporation/ETL Design and Development Team Leader
Location : Jersey City, NJ, Must be hybrid in Jersey City 1x week
Description:
Looking to onboard a couple of ETL developers for different projects (Financial GL Transformation and FRY9C regulatory report transformation)
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.
CRITICAL JOB KNOWLEDGE AND CORE COMPETENCIES/SKILLS
- 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 understanding of data warehouse concepts and experience implementing data warehouse.
- Cloud technology experience is a plus.
- Excellent communication skills both verbal and written with the ability to write and communicate requirements to business and technology partners.
Prashant Kumar | Sr. Technical Recruiter
LARGETON INC | 13800 Coppermine Rd, Herndon, VA 20171
