DataStage ETL Developer

ETL Developer Responsibilities:IBM DataStage ETL Developer on this project will work as part of a product development team and be involved in the design, build, unit testing, and deployment of ETL jobs and sequences built using the IBM DataStage 11.7. These ETL jobs support pulling client source data into a data warehouse to support report development. The developer should expect to pull multiple formats of source data, including SharePoint list XML, web services, delimited flat files, and other sources. The developer is responsible for translating functional ETL requirements into a technical design document, building the DataStage jobs and sequences to pull data from the source into staging tables, from staging tables into historical tables using Change Data Capture methodologies, and then from historical tables into dimensional data marts for reporting. The developer should ideally have a strong understanding of dimensional modeling concepts and the ability to write complex queries against a Microsoft SQL Server database and Oracle database.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.Thanks,Alex Prem | 469.639.2502alex.prem(at)OrbITpeople.com | www.OrbITpeople.com