ETL Developer

Job description

If interested pls contact - 8369735129/david.whiteforce1@gmail.com

ETL Developer

Job Description
We are looking to hire a skilled ETL developer to design and fill a data warehousing environment
for our company. Your duties will include consulting with the data management team, reviewing
the storage needs of the company, creating a data warehouse, extracting data from company
servers, filling the new warehouse, and testing it upon completion.
To ensure success as an ETL developer, you should have extensive knowledge of coding
languages and warehouse architecture and be able to clearly communicate your ideas to the
company. Ultimately, a top-level ETL developer can create a highly efficient and customized
warehouse environment that perfectly suits the data storage needs of the company.
ETL Developer Responsibilities:
Consulting with data management teams to get a big-picture idea of the company’s data storage
needs.
Presenting the company with warehousing options based on their storage needs.
Designing and coding the data warehousing system to desired company specifications.
Conducting preliminary testing of the warehousing environment before data is extracted.
Extracting company data and transferring it into the new warehousing environment.
Testing the new storage system once all the data has been transferred.
Troubleshooting any issues that may arise.
Providing maintenance support.

ETL Developer Requirements:
Strong experience with ETL processes and using Python for ETL - Expert in SQL - Experience with
SQL database programming, SQL performance tuning, relational model analysis, queries, stored
procedures, views, functions and triggers - Experience using Pyspark for Data Engineering -
Strong knowledge on multiple databases including Postgres, SQL Server, Oracle, Sybase, etc -
Experience with other ETL tools (Pentaho, Datastage, Informatica, ect) - Strong experience with
Agile/SCRUM methodology

Tools -
Python ETL Tools
Petl
Pandas
Mara
Airflow
Pyspark
Bonobo
Luigi
Odo
Bubbles
mETL
Riko