Request Technology - Robyn Honquest
Looking for a candidate with 6 years hands on DataStage design and development of 8.5 higher. You will have type 2 SQL Query, performance tuning, shells Scripting, Autosys, Large enterprise experience, Agile development
You will be the Development Senior to do design, development, maintenance and production support for various Datamart applications within the corporation.
Work with initiative leads, business areas, technical leads, business architects, application architects, stakeholders, subject matter experts, developers, technical support groups and test teams to define and accomplish ETL responsibilities.
Review and accept software and interface design and requirements.
Refine and decompose requirements to the level of detail required to initiate development.
Design ETL and related components.
Deliver ETL and related components as specified in the design, functional and non-functional requirements, within established budget, time and quality standards.
Design, prototype, develop, test, and document existing and new ETLs, and related components; make recommendations for related functions that result in a more cost effective product delivery.
Perform unit testing of ETLs and related components and document test results.
Complete code reviews for ETLs and related components, and complete documentation of issues identified and action items.
Correct testing defects and support all testing, including but not limited to: Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing.
Analyze current ETLs and related components for performance, diagnosis and troubleshooting.
Identify application bottlenecks and opportunities to optimize performance.
College Degree or equivalent experience; advanced studies/degree preferred. Typically has 5 – 7 years related experience.
Minimum six (6) years of current and hands-on experience with DataStage (v 8.5 and higher) design, development and performance tuning for Multi-Dimensional DataMart’s (Star Schema).
Minimum three (3) years of current and hands-on experience with reading and loading high-volume Type 2 dimensions (Slowly Changing Dimensions) in Multi-Dimensional Datamarts (Star Schema).
Extremally proficient with SQL.
Minimum five (5) years of current and hands-on experience with complex SQL and high-volume Relational databases and SQL Query performance tuning.
Minimum four (4) years of current and hands-on UNIX Shell Scripting experience.
Minimum one (1) year of current and hands-on Autosys experience.
Minimum one (1) year of current and hands-on experience with code management tools
Agile development methodology experience
To apply for this job please visit the following URL: http://itjobpro.com/83453 →