Overview
Skills
Job Details
Role :: ETL Developer
Location :: onsite in either Jersey City or White Plains, NY 1-2x/week
Hybrid
*must have strong SQL Server experience *Must have strong data factory experience *Out of FS/domain experience in compliance, risk or fintech
1. Performs analysis and design of the business requirements and specifications as required.
2 Develops and maintains interface ETL processes between databases and/or flat files.
3 Works with various application team members to obtain the requirements for their development work.
4 Creates unit test plans and performs unit testing for the interface processes that they developed or modified.
5 Creates documentation for the processes that they developed as well as updates documentation for the processes that they modified.
6 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.
7 Coordinates code promotion activities through all SDLC environments and validates that promoted interface code is working as expected.
8 Assists QA team with identifying QA test cases and supports them during QA testing.
9 Updates team leader and project manager with status of assigned development/project work.
10 Troubleshoots production issues independently and assists in timely resolution of incidents.
11 Keeps up to date on new features and enhancements in the development tools used by the team.
Qualifications and Skills
1 Strong ETL tool experience, specifically within datafactory 2 Strong knowledge of Azure ADF/ADL 3 Strong knowledge of relational and dimensional database concepts.
4 Experience working in all phases of a full project life cycle, including design.
5 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.
7 Demonstrate ability to work on multiple projects simultaneously.
8 Excellent communication skills both verbal and written with the ability to write and communicate requirements to business and technology partners.