Design and develop Datastage, Quality Stage, Information Analyzer v 11 client and server components
Develop code that promotes reusability, maintainability and good, scalable performance.
Build and execute repeatable unit & regression test cases Conduct code reviews.
Support application development through system testing and user acceptance testing, bridging the gap between business rules and technical implementation when necessary
Create production support manuals and Support production deployment.
Creates and develops ETL jobs as well as data quality and cleansing routines
Provides the Quality Assurance team with all documentation necessary for
May assist in one or more components of the overall architecture of the data warehouse system
Conduct performance analysis and optimization of Data Services jobs
5 - 10 years of DataStage design and development experience in a complex EDW environment.
7+ years working in a DataStage Developer capacity.
5+ years working Datastage in a Linux environment
5+ years shell scripts and CMD statements for invoking and sequencing DS Jobs
7+ years and/or experience with real-time development is a plus.
Experience with Infosphere CDC, balanced optimization is a plus.
Ability to write shell scripts and CMD statements for invoking and sequencing DS Jobs
Experience with Grid technology is a plus.
Moderate in performance & tuning of data integration process. UNIX shell scripting experience is required.
Strong RDBM skills (Oracle, SQL Server 2008, 2012).
Strong English written and verbal communication skills.
Strong understanding of BI Data Modeling (Star Schema) and how it is designed.