ETL Engineer — Data Warehousing & Informatica

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.
• 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.

Work location is McKinney, TX with required travel to client locations throughout the USA.