Enterprise Data Warehouse Developer

19 Mar 2025

Vacancy expired!

Position: Enterprise Data Warehouse Developer Location: NY City/ Hybrid Duration: 12+ months Rate: Open Interview: Video 2 positions Enterprise Data Warehouse Developer The candidate's primary function will be to provide EDW support to the current on-going implementation of Jack Henry products and secondary/back-up production support for ICBS/Signature. We can educate the person on ICBS/Signature. This engagement is to work within a team of 11 members who support a suite of financial applications in a NYC Bank. The Bank is currently undergoing migration of their Core Banking platform ICBS/Signature to Jack Henry. Responsibilities and Duties

  • EDW skill set to support and maintain interfaces from/to Jack Henry with all downstream apps/products
  • Experience working with windows servers installing, maintaining, troubleshooting programs in windows environment.
  • Ability to take ownership of various Jack Henry application products and ensure they are up and running.
  • Become familiar with various application products to provide Production Support, upgrading, troubleshooting and documenting for other team members.
  • Work closely with application vendors and IT-Infrastructure Team to implement, upgrade and test applications in UAT, Production and BC/DR Environment.
  • Troubleshoot issues by identifying the origination systems involved and depict the source of issues.
  • Document System/Design Specifications, Program documentation etc. as per Bank's SDLC policy.
  • Maintain Development Issues Log to keep track of on-going development issues and for timely resolution of priorities.
  • Good communication skills to work with internal and external 3rd party applications Production Support and Development teams to resolve issues, perform upgrades/enhancements etc.
  • Willing to support client's nightly core banking end of day processes on a monthly rotation basis. (Expect light support issues, Jack Henry to handle most EOD errors)
  • Proven ability to proactively work independently on multiple tasks based on priority.
  • Ability to interact and be a team player in a very diverse group.
Qualifications
  • 7-10 years of experience
  • Good knowledge of EDW Skills - Data Modeling, TimeXtender Discovery Hub, Daily loads, Batches, Mappings, Reconciliations etc.
  • Scripting - windows batch, Unix shell, vbscript, PowerShell, JavaScript
  • Database technologies - SQL server, Oracle PL/SQL, ETL tools SSIS, Discovery Hub
  • Web technologies - IIS, Apache Tomcat, html, Web services, MuleSoft
  • File transfer - ftp, sftp
  • Scheduling tools - Autosys, CA workload automation
  • Reporting tools- Crystal, Cognos, Qlik
  • Fiserv ICBS/CBS knowledge while not mandatory but a plus for secondary/back-up support - iSeries operating system, DB2, RPG IV/ILE knowledge. Some familiarity would help in order to get trained on the back-up prod support responsibilities. Willing to educate
  • Languages Java, C#, etc knowledge a plus
  • Networking/infrastructure knowledge a plus
experience leading Data Warehouse and Business Intelligence projects Strong experience in banking compliance/ Demonstrated knowledge and understanding of Data Warehouse and Business Intelligence concepts and the deliverables associated with these types of projects Demonstrated understanding of ETL and reporting processes as they relate to project delivery, e.g. : SSIS/ ETL/ DW/ Data integration / SQL Server / Design / Analysis/ other ETL tools like Informatica and Data Stage Knowledge and understanding of the SDLC Experience with Waterfall & Agile project methodologies

  • ID: #49498624
  • State: New York New york city 10045 New york city USA
  • City: New york city
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2023-03-19
  • Deadline: 2023-05-18
  • Category: Et cetera