Featured Openings
IBM Information Server Architect:
PR3 Systems Inc. seeks Information Server Architect in Aurora, Illinois.
Duties: Perform Analysis, Design, Development, Testing, Installation and configuration tasks required for preparing Data Warehousing applications; Creation of ETL Mappings and Transformations using IBM DataStage to move data from multiple sources into a target area; Define complex source to target mappings using DataStage components such as the Sequential File, Dataset, Transformer, Copy, Aggregator, Filter, FTP, Funnel, Join, Merge, Lookup, Modify, Sort, and Surrogate Key Generator stages; Work with the DataStage connector stages such as DB2, Oracle, ODBC, and Teradata to retrieve the required data from source tables and load the data into a Data Warehouse / Data Mart; Write a UNIX shell script to support production and development activities; Provide production support for DataStage parallel and sequence jobs; Provide backup support for databases, applications, and the reporting environment; Generate code for database queries using SQL, Functions, Triggers, and Packages; Carry out database and SQL performance tuning for extractions and loads; Generate various reports using DataStage/Information Server utilities; and Working knowledge of QualityStage and Information Analyzer tools in order to cleanse and profile data.
Requires: Bachelor’s degree in Computer Science, Engineering, or related, plus 5 years of experience; 5 years experience with design and development of ETL processes using InfoSphere DataStage or Websphere DataStage; experience with Information Server Suite components and architect solutions leveraging suite’s entire capabilities, including metadata, data quality, and profiling; experience with business intelligence tools; experience documenting processes and requirements; and the ability to travel to client sites throughout the U.S. as needed.
Requires permanent work authorization inside the United States. Send resumes to info@pr3systems.com; Subject: Information Server Architect if interested in the position.
IBM Information Server Architect:
PR3 Systems, Inc. seeks IBM Information Server Architect in Aurora, IL (and other U.S. locations as needed).
This is a customer facing/interacting role that will involve technical pre-sales skills. Tasks may include but are limited to mentoring/training, providing technical support as needed, conduct an initial client assessment, product installation and configuration, and creating technical documentation and training materials. The ideal candidate will possess the following abilities:
• Perform Analysis, Design, Development, Testing, Installation and configuration tasks required for preparing Data Warehousing application
• Work on IBM QualityStage to cleanup and standardize the source data
• Creation of ETL Mapping and Transformations using WebSphere DataStage or Information Server to move data from multiple sources into target area
• Work with complex mapping using DataStage designer components like Sequential File, Dataset, Transformer, Copy, Aggregator, DB2, Filter, FTP, Funnel Join, Lookup, Modify, Surrogate and Sort Stages
• Work with Oracle, Table Partitions and Load data into Data Warehouse/ Data Mart
• Work with DataStage connector stages such as Teradata, DB2, Oracle and ODBC stages to retrieve the required data from source tables and load the data into a data warehouse / data mart
• Write UNIX shell scripts to support production and development activities
• Provide production support for DataStage parallel and sequence jobs
• Provide backup support for databases, applications, and reporting environment
• Generate code for database queries using SQL, functions, triggers, and packages
• Generate various reports using DataStage/Information Server utilities
• Generate various reports using DataStage utilities and Cognos
• Working knowledge of QualityStage and Information Analyzer tools in order to cleanse and profile data
Key Selection Criteria:
• 5+ years of IT experience and a Bachelor’s Degree in Science, Engineering, or a related analytic or scientific discipline
• Hands-on experience with design and development of ETL processes using InfoSphere DataStage (experience with WebSphere DataStage is also acceptable)
• Experience in two or more of the Information Server Suite components and architect solutions that leverage the suite’s entire capabilities (metadata, data quality & profiling)
• Energetic and highly motivated
• Excellent verbal/written communication skills
• Must be open to relocation based on project demand
• Strong customer services
• Ability to work independently
• The ability to connect and gain trust quickly
• The ability to regularly exercise discretion and independent judgment
• Experience documenting processes and requirements
In addition to the above skill-sets, we are looking for individuals with a strong can-do attitude, a desire to grow, and who will implement an ethical approach to their work. Interested applicants should email their resumes to info@pr3systems.com.
Comments are closed.