Logo
Avenues International, Inc.

ETL Data Engineer

Avenues International, Inc., Princeton, New Jersey, us, 08543

Save Job

Title: Senior Software Engineer – ETL Developer (Python/Pyspark)

Location: Skillman, NJ (Three days onsite is must)

JD:

Must have Skills:

10+ years of experience in designing and developing

ETL pipelines leveraging pyspark/python.

Experience on python database libraries like

SQLAlchemy, psycopg2 .etc

Strong understanding of data warehousing methodologies, ETL processing and dimensional data modeling.

Advanced SQL capabilities are required. Knowledge of database design techniques and experience working with extremely large data volumes is a plus.

Demonstrated experience and ability to work with business users to gather requirements and manage scope.

Experience in workflow tools such as oozie or Airflow or Tidal

Experience working in a big data environment with technologies such as Greenplum, Hadoop and HIVE

BA, BS, MS, PhD in Computer Science, Engineering or related technology field

Desirable Skills:

Experience with large database and DW Implementation (20+ TBs)

Understanding of VLDB performance aspects, such as table partitioning, sharding, table distribution and optimization techniques

Knowledge of reporting tools such as Qlik Sense, Tableau, Cognos

#J-18808-Ljbffr