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. 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. Qualifications 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. #J-18808-Ljbffr Techfuturiq