Senior ETL / Informatica Engineer

Open Systems Technologies   •  

New York, NY

Industry: Technology

  •  

5 - 7 years

Posted 165 days ago

  by    Radhika Arora

This job is no longer available.

A global data based financial firm is seeking a Senior ETL/Informatica Engineer to join their team in New York. This candidate must be a hands-on ETL developer who will work on large volumes of data and complex business rules. You will help us build a hybrid platform that combines traditional warehouse technologies, MPP databases and Hadoop.

Responsibilities:

  • Build scalable, high throughput systems that process more than 10 billion data points a day
  • Work on developing and supporting technology platforms using Informatica, Greenplum, the Hadoop stack and a variety of BI tools
  • Automate the data pipelines to ETL our data
  • Interact directly with users to architect and design our solutions

Skills:

  • 5+ years of experience developing and supporting Business Intelligence/Data Warehousing environments
  • 3+ years of experience using ETL tools including Informatica
  • Experienceworking with large databases
  • Knowledge of database design techniques and experienced SQL skills
  • Programming experience in Python
  • Experience programming in a Linux/UNIX environment including shell scripting
  • Experience with Big Data technologies - Hadoop, Spark, HIVE
  • Knowledge of reporting tools such as QlikSense, Tableau, Cognos