Senior ETL - Informatica Engineer in New York, NY at Open Systems Technologies

Date Posted: 1/15/2020

Job Snapshot

Job Description

A prominent, data based global technology firm is currently seeking a Senior ETL / Informatica Engineer to join their team in New York. This tech company has multiple focuses, the main one being the creation of one of the world’s most widely utilized financial software applications. In this role you will work in a small, dynamic team with some of New York City’s top engineers, to solve very unique, large scale challenges.  Their systems are very large and highly distributed, and engineers are always looking for creative solutions to solve problems, including employing a variety of modern programming languages, open source and big data technologies, as well as Machine Learning and Natural Language Processing.

Not only can you grow professionally in this company but they have an excellent engineering culture, work/life balance, and great benefits. The company is also very philanthropic; many employees give back to the community and the company also donates a significant portion of their profits to philanthropy. This is an exciting opportunity for anyone looking for the next step in their career and for a work place they can call home.

A key objective of this role is for you to help is to build an enterprise level data analytics platform using industry standard concepts against our Data Warehouse, Data Lake, and Big Data environments.


  • Develop, architect, standardize and support technology platforms using Industry leading ETL solutions
  • Build scalable, high throughput systems that process more than 10 billion data points a day
  • Assist with interim Data preparation for Data Discovery & self-service needs


  • Must have a Bachelor's degree in Computer Science or related field 
  • 5+ years of experience in ETL tools
  • 5+ years of experience implementing Informatica in an Enterprise environment is a plus
  • Knowledge of industry standard Data Infrastructure tools (Warehouse, BI, Analytics, Big-Data, etc.)
  • Advanced SQL capabilities
  • Knowledge of database design techniques and experience working with extremely large data volumes is a plus
  • Strong understanding of data warehousing methodologies, ETL processing and dimensional data modeling
  • Experience programming in a Linux/UNIX environment including shell scripting
  • Programming experience in Python
  • Experience with large database and DW Implementation (20+ TBs)
  • Understanding of VLDB performance aspects (table partitioning, sharding, table distribution and optimization techniques)
  • Experience working in a big data environment with technologies such as Hadoop, Spark, and HIVE
  • Programming experience, including Java, C++, ksh
  • Knowledge of reporting tools such as QlikSense, Tableau, Cognos
  Job category:
  • Information Technology
Job keywords:
  • ETL
  • Informatica
  • Developer