ETL Developer
Job Duties and Skills:
- 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.
- Responsible for pulling data from the database and transforming that data into comprehensive reports using Informatica.
- Develop Informatica ETL code consistent with departmental standards and practices.
- Analyze and validate data load using SQL.
- Develop Oracle & Teradata SQL scripts to load and transform data as necessary.
- Develop Linux shell scripts as necessary.
- Deploy/Migrate ETL code, DDL and Shell scripts to Production.
Required Education: Bachelor’s degree in Computer Science, Computer Information Systems, Information Technology, or a closely related field or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.
