Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 16th Dec 2020
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.