Application Programmer - ETL / Informatica Engineer

Job Description

We are seeking skilled, enthusiastic and experienced technologists to join our developer productivity and data integration engineering team based at New York, Georgia and Montreal, Canada. 

The primary objective for the candidate is to work alongside with existing ETL engineers to complete the Informatica version 10.2 to version 10.5 version project. As a secondary objective, the candidate will help with Tibco Data Virtualization (TDV) version 7 to version 8.3 upgrade. This role requires extensive experience on deploying data middleware solutions and is quick with issue/bottleneck analysis and diagnosis. The ideal candidate is one who has experience building ETL, data federation, data reporting infrastructure solutions and is proficient with multiple database platforms, and programming/scripting language such as JAVA, Perl on Linux.

QUALIFICATIONS Experience- 7+ years 

Required Skills:-

3+ years of experience in design, development, implementation, unit testing, troubleshooting and support of either ETL processing with Informatica Powercenter or data federation/virtualization solution with Tibco Data Virtualization. 3+ years working experience with at least three major DBMS products (e.g. Sybase ASE, DB2 UDB, MSSQL, Oracle, Hadoop, Greenplum, MongoDB, and/or Postgres) with knowledge of internals and implementation details of databases. Hands on 1+ years of experience with software development using either JAVA or Python on Linux. Strong fundamentals in distributed system design, development and deployment using agile/devops practices. Excellent skill in verbal and written communication . Experience building RESTful APIs. Experience in shell scripting . Experience with tools such as GIT, Jira and Bitbucket . A self-starter with the ability to work effectively in teams

Desired Skills:-

Strong experience with system performance tuning on Linux. Experience with other ETL tooling such as TalenD, SSIS. Experience with other data pipeline tooling such as Luigi, Nifi, Airflow. Experience with data discovery and visual analytical tools such as PowerBI, Tableau. Experience with public cloud services, terminology and security/control requirement. Deep knowledge of JVM internals. Python Knowledge. Contributor/Committer to open source projects. Experience working and managing software on a large distributed environment. Experience working with Docker & Kubernetes