Backend/ETL Developer in Jersey City, NJ at Signature Consultants

Date Posted: 5/8/2020

Job Snapshot

Job Description

Backend ETL Developer Summary:

Signature Consultants is seeking a Backend ETL Developer for a contract opportunity in Jersey City, NJ. This position will be responsible for designing and developing batch/ETL interfaces using the proprietary meta data driven approach as part of the LIBRA Interface Team.

Responsibilities:

  • Maintenance and support of the existing interface processes including investigation of issues and production troubleshooting
  • Maintaining the data lineage to facilitate the end to end traceability as and when changes to the ETL
  • Responsible for Liquidity report specific derivations

Required Skills:

  • Extensive experience with Oracle/Exadata SQL, PL/SQL and perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports. Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) & SGA (System Global Areas) to optimize memory usage.
  • Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handling
  • Experience in Unix/Linux shell scripting and/or Perl Scripting. Knowledge of python is desirable.
  • Implementation experience with monitoring and measurement of data quality using business rules. Hands on experience hands with data quality assessment and resolution desirable.
  • Maintain metadata, data glossary and data catalog processes. Ensure adherence to data security by using data encryption procedures and protocols.
  • Ability to work in fast paced environment

Desired Skills:

  • Experience in Financial Industry with some risk background
  • Knowledge of Agile methodology is desirable.
  • Knowledge of Liquidity Reports like Fed5g, LCR, NSFR, CRD IV etc is a plus.
  • Knowledge of Tableau is desirable.

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn