Job Description :
Title::: Sr. ETL with Java Developer
Location:::::100% remote
Position:::Contract
The ideal is a candidate who is currently working with ETL AND Java/J2EE in their current role, JDCB, and has done some work on Apache products (Airflow/Nifi/Minifi), SQL Dev/Querying, DAG files, etc.
However…
If they don’t have the Apache tools as listed above, they will take some one with STRONG ETL AND JDBC experience w/ Java Development (and the mentioned SQL skills
Our client in partnership with a renowned VC firm is growing both their portfolio of clients and service
offerings, they currently combining 3 distinct companies into one entity. With current annual revenues of
15+ million and projections of $100 million in the next 3 years there will be considerable headcount
growth over the next few years and significant projects that will require both contingent and FTE labor.
We have worked closely with both the CEO and CTO for the better part of 15 years and are trusted HCM
partners.
Our client is looking to hire multiple mid-to senior level contract ETL Developers (Java, SQL, Airflow) to
design and fill a bespoke data warehousing environment that services their clients who leverage 70+
different ERP systems. The duties will include consulting with the data management team, reviewing the
data structures and model of the ERP, creating a refined data warehousing environment, defining SQL
queries or API integrations for extracting data from the ERP systems, filling the new warehousing system,
and testing the environment upon completion.
Currently there is 3-5 months of work with the possibility of extension or potential conversion.
ETL Developer Responsibilities:
Setting up Nifi and MiNiFi to enable the pull of data from the ERP
Create JAVA Application Code within Nifi
Create JDBC connections
Setting up Data Lake scheme for new ERP
Conducting preliminary testing of the warehousing environment before data is extracted.
Writing AirFlow DAG files and SQL Queries for the transformation of data from Data Lake to
normalized Data Warehouse
Testing the ETL transformation to the data warehouse
Troubleshooting any issues that may arise.
Providing maintenance support.
ETL Developer Requirements:
Knowledge of coding languages including JAVA, Python and SQL.
Experience with JDBC connections, stack overflow
Experience with Apache Airflow, NiFi and MiNiFi
Proven work experience as an ETL Developer, ERP knowledge is a plus.
Clear communication skills.
Ability to troubleshoot and solve complex technical problems.