Informatica/ETL Developer

Back to job search
  • Location:

    Jersey City

  • Job type:

    Contract

  • Job ref:

    345899

  • Published:

    about 1 month ago

  • Expiration date:

    10/17/2021

  • Start date:

    ASAP

Job Summary:

Signature Consultants is seeking a Informatica/ETL Developer for an opportunity with a client located in Jersey City, NJ.

Responsibilities:

  • Create Informatica mappings with PL/SQL store procedures/functions to incorporate critical business functionality to load data
  • Used connected, unconnect lookup, static and dynamic cache to implement business logic and improve the performance
  • Develop procedures and functions using PL/SQL and develop critical reports
  • Develop PL/SQL functions/procedures/cursors/packages/database triggers to implement business logic
  • Work with relational databases like DB2
  • Detail table design and index selection in for TeraData databases using SQL
  • Develop mappings with XML as target and formatting the target data according to the requirement
  • Work with logical, physical, conceptual, star, snow flake schema data models
  • Extract data from flat files, DB2 and to load the data into the SalesForce database
  • Create and used debugger sessions to debug sessions and create breakpoints for better analysis of mappings


Skills/Experience:

  • 3+ years of development experience in Actimize Risk Case Manager, Actimize Intelligent Server and Actimize Case Manager Designer
  • 7+ years of Oracle/PL SQL working on very large data sets
  • 1+ years' experience of ETL processes and principles including data quality standards and techniques
  • 1+ year' experience of working in an Agile environment and with experience of Jira/Horizon
  • Excellent written and communication skills and ability to clearly indicate data integration solution designs and implementations
  • Knowledge and fundamental understanding of Financial products such as Equities, Bonds, FX, Futures and Option along with the related reference data and market data
  • Experience of UNIX shell scripting
  • Experience of Informatica ETL tools
  • Experience of Autosys
  • Experience of working with larger projects involving multiple groups including near shore and offshore teams
  • Experience of working in a Compliance Environment, particularly Trade Surveillance, and experience of products such as SMARTS (Nasdaq)

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.

EEO Employer

Signature Consultants is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Signature will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or 888.838.1020.