As the nation's oldest and largest family of health benefits companies, this well known company prides itself on being the most recognized brand in the health insurance industry! If you are interested in joining an amazing team and meet the following qualifications please contact us today! THIS INITIATIVE IS THE LARGEST HC DATA WAREHOUSE PROJECT IN THE COUNTRY with over 100 Terabytes of data involved.

It is the precedent for all other HC Insurance Companies.

Job Description: Provides design recommendations based on long-term IT organization strategy.

Develops enterprise level application and custom integration solutions including major enhancements and interfaces, functions and features.

Uses a variety of platforms to provide automated systems applications to customers.

Provides expertise regarding the integration of applications across the business.

Determines specifications, then plans, designs, and develops the most complex and business critical software solutions, utilizing appropriate software engineering processes, either individually or in concert with project team.

Will assist in the most difficult support problems.

Break down business problems and capabilities into projects, platforms, frameworks, applications, and services that when realized, produce software that solves business problems and/or creates new business capabilities Researches and maintains knowledge in emerging technologies and possible application to the business.

Bachelors Degree in Computer Science, Information Systems, Business Administration or equivalent work experience in similar work environment.

Typically has minimum of 15 years of IT work experience including application system design and implementation.

Experience integrating the components of the technology platform including DB2, J2EE, WebSphere, Oracle, SQL and Cognos.

In-depth knowledge of state-of-the-art programming languages and object oriented approaches in designing, coding, testing and debugging programsApplication Architect (ETL) Acts as the technical subject matter expert for ETL design patterns and implementation.


Provides ETL and technical direction for complex development tasks including application break-fix.


Provides senior level expertise as it relates to decision-making and priorities for the application technical architecture.


Works with Application DBAs, Development and Technical Leads, Data Architects, System and Design Analysts and Infrastructure Leads to design and develop high-performance E2E technical solutions.


Leads/oversees the construction and implementation during the life cycle of the solutions.

Provides the technical leadership to developers, systems analysts and other IT technicians to ensure the successful delivery of the solution.


Leads/oversees performance tuning activities to tune the E2E systems.


Reviews and approves all ETL Technical and Design Specifications.


Assists Development Leads in solving complex technical problems.


Assists team members with proper usage of Data Stage tools and ETL concepts.


Assist development resources with the proper usage of Data Stage and establish and enforce development guidelines and best practices in the use of Data Stage Assists Development Lead in creating estimates for development and unit-testing efforts.


Participates and contributes in detail technical requirements and code-reviews.


Supports Data Modeling activities so that resulting model/solution isAs the nation's oldest and largest family of health benefits companies, this well known company prides itself on being the most recognized brand in the health insurance industry! If you are interested in joining an amazing team and meet the following qualifications please contact us today! efficient and meets performance requirements.


Works with System and Design Analysts, Development Leads and Enterprise Architects to ensure final solution meets the business and organizational enterprise architecture standards.


Evaluates strengths and flaws in application designs for continuous improvements.


Develops and documents architectural impacts based upon outcomes of monitoring and evaluation activities.


Facilitates the development of standardized procedures to provide a common process to integrate the deployment of new tools, techniques and technologies to existing IT processes.

Knowledge and Experience:
Possesses demonstrable hands-on and deep DB2, SQL and ETL design and development experience.


Deep knowledge and extensive experience with Data Stage development tools/methodologies
Advanced demonstrated proficiency in creating, documenting and communicating application designs for multiple systems comprised of many sub-components.


Hands-on experience with Rational Unified Process (RUP) including use cases and UML.
Advanced demonstrated proficiency consulting/negotiating formally and informally with others.


Advanced demonstrated proficiency producing realistic and achievable deployment plans.


Extensive experience in the field of measurement of and performance tuning end-to-end ETL programs and Data Warehouse applications.


Understanding in J2EE, Portals, Cognos BI Platform, and DataStage ETL Platform are highly desired.


Excellent communication and negotiating skills.

Excellent analytical skills.


Results oriented problem solver with ability to make difficult decisions.


At least 10 years of relevant, demonstrable experience.

Deliverable: Functional Design documentsTechnical design documentsTechnical and System Architecture documentsTechnical requirementsTesting scenariosVariability matrixSpecification documentsBusiness rules and specifications documentationDatabase schema, physical and logical diagramsMeeting notesEnd-user documentationsTechnical support documentationsGantt Charts representing project timelinesTime-estimation, resource estimation, project deliverables definitions and requirementsResource models and allocation documentation Additional Skills: Possesses demonstrable hands-on and deep DB2, SQL and ETL design and development experience.

Deep knowledge and extensive experience with Data Stage development tools/methodologiesAdvanced demonstrated proficiency in creating, documenting and communicating application designs for multiple systems comprised of many sub-components.

Hands-on experience with Rational Unified Process (RUP) including use cases and UML.Advanced demonstrated proficiency consulting/negotiating formally and informally with others.

Advanced demonstrated proficiency producing realistic and achievable deployment plans.

Extensive experience in the field of measurement of and performance tuning end-to-end ETL programs and Data Warehouse applications.

Understanding in J2EE, Portals, Cognos BI Platform, and DataStage ETL Platform are highly desired.

Excellent communication and negotiating skills.

Excellent analytical skills.

Results oriented problem solver with ability to make difficult decisions.TO APPLY: Please e-mail your resume to chanin.wenz [at] arcus [dot] net .

Thank you for your interest in our ad! ABOUT ARCUS: Exceptional Talent.

Total Confidence.

® Thats our message and were sticking to it. At Arcus, we're talent finders.

We strive to keep businesses and organizations at the top of their game by providing excellence in technology staffing, recruiting and consulting.

We are looking for professionals who share our entrepreneurial spirit and are looking to land an outstanding position with a company who has consistently been recognized on the national level for their work in the staffing industry.

We work tirelessly to build solid relationships with well-recognized organizations across the nation to learn about projects and opportunities.

And, because we spend so much time getting to know each candidate and their skill set, we are able to represent them with a level of unmatched confidence.

« Apply for Software Architect (ETL using Datastage) Job in Chicago 60601, Illinois US