Previous Job
Previous
Datastage/ETL
Ref No.: 19-02818
Location: Princeton, New Jersey
Position Type:Contract
Develop and enhance Datastage ETL jobs for Data warehouse (EDW) applications.
· Gathering business requirements by interacting with business users and work with business team in identifying the business rules and documenting them.
· Analyzing the existing Data warehouse applications and documenting the data flow.
· Analyzing the data in different Data warehouse tables which is in DB2 database and understand the business relations.
· Create Technical Design document, and Functional Requirement document.
· Development of Datastage Parallel Jobs, Sequence Jobs, Unix Shell Scripts, and scheduling jobs.
· Design different interfaces for EDW to receive/send data from/to various systems.
· Performance tuning of Datastage Jobs by choosing best partitions, stages, and table indexes.
· Development and performance tuning of DB2 SQL queries for moving data through different EDW layers.
· Unit Testing of components and documenting results
· Migrate code to different environments and coordinate with Scheduling team, DBA team and other teams for production deployment.
· Work with business users in new enhancement/Defect fixing.
· Support system testing and UAT testing.
· Coordination between different application teams.
· Support business users in UAT and create reports for business users.
· Production support and job monitoring.