ETL Developer in Chicago, IL

POSITION SUMMARY
Develops, encodes, tests, debugs, documents and installs programs to support of general business applications. Prepares program specifications and diagrams and develops coding logic flowcharts. Assess problems (user error, programming, data corruption, etc.) and design and implement solutions.

MAJOR ACTIVITIES AND RESPONSIBLITIES
Evaluates user request for new or modified computer program to determine feasibility, cost and time required, compatibility with current system, and computer capabilities.

Design project specifications and associated documentation. Formulates plan outlining steps required to develop program and submits plan to user for approval. Prepares flowcharts and diagrams to illustrate sequence of steps program must follow and to describe logical operations involved. Writes documentation to describe program development, logic, coding, and corrections

Resolve application/programming issues through research and analysis. Analyzes, reviews, and alters program to increase operating efficiency or adapt to new requirements. Consults with user to identify current operating procedures and clarify program objectives. Recreates steps taken by user to locate source of problem and rewrites program to correct errors.

Enters program codes into computer system. Converts project specifications into sequence of detailed instructions and logical steps for coding. Enters commands into computer to run and test program Replaces, deletes, or modifies codes to correct errors.

Test and debug business applications and programs Assists users to solve operating problems and provides alternatives for resolution. Recreates steps taken by user to locate source of problem and rewrites program to correct errors.

Supports users on all aspects of user reported problems. Responsible for training users on software, analyzes both the systems and users requirements/needs, and acts in a troubleshooting capacity.

QUALIFICATIONS
Education:
BA/BS degree in Computer Science or Business, or equivalent professional education/experience.

Experience:
1-3 years of solid job related experience using Cognos BI tools including:
o Working with end users to determine reporting needs.
o Creating/maintaining Impromptu Catalogs including security.
o Creating advanced Impromptu reports including datasets, sub-reports, crosstabs, and drill through reports.
o Creating/maintaining/monitoring of PowerPlay cubes.
o Administration of PowerPlay through the use of Upfront.
o Creating/maintaining/administration, and support of Framework Manager packages and ReportNet reporting.
Experience with one or more relational databases is required, including the writing of stored procedures. Experience with Oracle or SQL Server being preferred.
Strong working knowledge of data normalization techniques.
Experience using an ETL tool such as Informatica or Ascential is preferred.
Callidus or Actuate experience a big plus.
Knowledge of Sales Compensations systems a big plus.

SUPERVISORY RESPONSIBILITIES

No direct subordinates but may supply technical leadership to other staff members
Experience: Skills:
Ability to define problems, collect data, establish facts, and draw valid conclusions.
Trouble shoots complex problems and recommends appropriate action
Works beyond routine nature of tasks
Ability to write user documents and detailed technical documentation
Ability to conduct quality assurance testing on newly developed or modified applications
Ability to analyze existing applications
Ability to correct database corruption and program database queries
Ability to identify business challenges, provide alternatives, and recommend automated solutions To Apply to this job go to http://www.GadBall.com or click here

Oracle DBA in Chicago, IL

Please e-mail resumes positions, subsystem software/hardware platform decisions.
Assisting with designing and specifying key interfaces and data models.
Lead and facilitate group discussions to determine feature and functionality supported by the data architecture.

Experience: Requirements
Strong Oracle background (9i/10g) as DBA
Strong Java background
5-10 years experience in modeling and database management systems (Oracle preferred).
Experience with Erwin or Oracle Designer. To Apply to this job go to http://www.GadBall.com or click here

Technical Analyst / ETL Developer in Chicago, IL

This position is a unique opportunity for the right individual to get in on the ground floor of a new team being formed in Schaumburg to learn the CheckFree Recon Plus Frontier application and develop corporate expertise on this tool. This individual will be responsible for configuring the CheckFree tool for the Automated Reconciliation team. From a documented reconciliation design, this person will be responsible for reviewing and understanding the configuration design, updating design documentation, configuring the tool, unit testing the configuration, and training others on the details of the configuration.

They will have responsibility for reviewing existing business process documentation and artifacts for the data necessary to complete each reconciliation. From this data, they will reverse engineer the artifacts to identify and document the source systems, databases, tables, columns, and selection criteria. Responsibility will also include working with fellow team members to educate them on the data and data anomalies, addressing their questions, and researching and documenting answers. The person will also work closely with data quality areas across the company to promote and improve the corporations data quality.



Experience: Individual should have a minimum of 5 - 10 years experience in applications development, data analysis, database design/development, and/or equivalent industry experience. Knowledge of accounting, reconciliations, business operations, and technology development are helpful. Individual should be able to quickly understand and gain knowledge of the business areas for which they are researching and documenting data. Person will lead data research, working with BPS/OTS areas when appropriate, and document results of their research. Knowledge of Freddie Mac processes and/or mortgage, securities, and/or accounting industry experience is extremely helpful. Individual must have a strong desire to learn and understand the CheckFree Recon Plus Frontier COTS application.

A BS in Computer Science or equivalent experience is required. Web Methods and SQL is required. Sun Java Developer Certification and Unix Shell Scripting is preferred.

" Are you using a specific tool (Ab Initio, Informatica, etc)for this project or within your Data Warehouse? Web Methods"

"Are you writing/developing scripts in Korn, C, Borne shell? Not Sure"

"Oracle 9i? PL/SQL, triggers, stored procedures? Oracle and PL/SQL " To Apply to this job go to http://www.GadBall.com or click here

Oracle Application Developer/DBA in Chicago, IL

Description:

1. Responsible for playing a major role in analyzing, defining and documenting requirements for data, volume, conceptual process, aggregation and DB connectivity between internal and external systems.
2. Responsible for leading design meeting and reviews, developing and maintaining core database design, providing architectural leadership to cultivate teams and serving as the primary database architecture resource.
3. Assist in vendor and product evaluation related to database and/or data modeling needs.
4. Responsible for quality of the implemented database solution and adherence to database best practices and/or standards.
5. Identify and promote the definition and reuse of common business process/practices related to the integration points.
6. Assist with application business analysis and model prototyping sessions.
7. Assist in interpret business analysis documentation (including Use Cases and Software Requirement Specifications) to database design artifacts.
8. Assist with database (performance) test planning and execution.
9. Provide estimate models for developing deliverables and system deployment tasks.
10. Assist in developing capacity planning strategy.
11. Oversee the implementation of the system development methodology within the development cycle related to database triggers, stored procedures, SQL, capacity planning, archival, and database framework/foundation.
12. High proficiency with Oracle DB, flat and typical RDBMS solutions.
13. Perform 2nd-tier support.




Experience: Skills:

Excellent understanding of industry standard software development methodology (required).
2. Expert at data modeling, data optimization, transaction lifecycle and component based design (CDB) models (required).
3. Expert in modeling not limited to: ERWIN, flat file definitions, normalization, high data volume optimization, VLDBs and database tuning (required).
4. Very proficient in writing and tuning of procedures and packages (required).
5. Ability to architect high performing and scalable database solutions (required).
6. Strong leadership and mentoring skills (required).
7. Ability to work in a team environment (required).
8. Excellent organizational, modeling, oral and written communication skills (required).
9. Experience with management of database instances related to multiple concurrent projects (required).
10. Demonstrated experience in applying lg database (min 2 TB) design techniques to high volume data warehouse/mart environments, implementing data optimization, capacity management, and back-up procedures (Rman) (required).
11. Experience in developing in Linux with strong shell scripting skills (required).
12. Goal and deadline oriented (required).
13. Prior consulting experience (plus).
14. Experience working with DB2 (plus).

QUALIFICATIONS AND EDUCATION:

1. B.S. degree in Computer Sciences or equivalent work experience.
2. 8+ years overall technical experience in database administration and management (required).
3. 4+ years of enterprise level data modeling (required).
4. 4+ years data warehouse modeling direct experience (required).
5. 2+ years Rapid Application Development (RAD) (required).
6. 2+ years leading software development teams of at least 4 persons (plus).
7. 2+ years linux based database experience (required). To Apply to this job go to http://www.GadBall.com or click here

CRM Management Consultant in Chicago, IL

Description:

Tasks/ responsibilities: The intent is to bring in a consultant who will assess the internal CCS 'Customer Contact Strategy' systems and third party CRM tools on the market. The analysis will compare future functionality requested in the plan for the expansion of Customer Contact Strategy against internal systems capability and off the shelf CRM systems. The result will be a recommended strategic technical solution for CCS.


Assess Company's CCS systems ability to deliver future state of company's Customer Contact Strategy


Develop understanding of current and future state of company's Customer Contact Strategy
Determine company's applications teams to interview
Interface with every company application team currently involved and potentially to be involved in delivering the future state of company's CCS
Meet weekly with established contact to assess progress and provide feedback
Document and analyze company's systems capability to deliver future state of CCS


Assess third party CRM software to deliver future state of company's Customer Contact Strategy

Develop a list of CRM software providers
Narrow list to assess based on fit to CCS requirements, strength in market, experience within our industry and comparable sized companies, stability of company, etc.
Document and analyze each third party CRM software capability to deliver future state of CCS


Present a CRM/CCS systems recommendation
Written proposal shall include a single recommendation with additional options for the strategic technical solution responding to the requirements of the future functionality of company's Customer Contact Strategy. Recommendation(s) will include timing, and costs estimates.
Back up documentation shall include detailed analysis of company's current functionality, ability, effort, timing, and costs related to delivering future CCS functionality.
Back up documentation shall include detailed analysis of third party CRM software functionality, ability, effort, timing, and costs related to delivering current company's and future CCS functionality.


Experience: Skills Required:

Knowledge of Customer Relationship Management (CRM) theory
Knowledge of external market for CRM software
Technical background to be able to interpret and relate the company's system capabilities to compare and contrast against third party software
Experience writing proposal or recommendations to upper management
Strong verbal skills and communication skill to interface with various level of management (including upper management)
Highly developed written skills
MS PowerPoint / Word knowledge and skills To Apply to this job go to http://www.GadBall.com or click here

Visual C++ Developer & MFC in Chicago, IL

Currently looking for Visual C++ software engineers with skills in Sequel Server, Microsoft Foundation Class, etc.
Experience: Visual C++, Sequel Server, MFC, etc. To Apply to this job go to http://www.GadBall.com or click here

Red Hat Linux Guru in Chicago, IL

Network project design and integration.
Participates in Network consulting engagements.
Extensive IP subnetting. Troubleshoots and
resolves routing, switching and circuit problems.
Capacity

A subject Matter Expert level consultant has
10-15 years of experience in various size and
types of projects that are relevant to the role.
Assumes a high level, strategic role in the
design

As Linux is an emerging technology for Infrastructure, we have a need to bring in a consultant with enterprise class deployment and management discipline and methodology to share. This is to ensure that the current team is successful at managing this platform for the long term.

Experience:
Linux Intermediate 7-8
UNIX Intermediate 7-8
Network Intermediate 5-6

Red Hat Linux Enterprise 3.0 & 4.0 (32 & 64 bit); Satellite Server set-up; Standarizing Linux builds.

This req is for a Red Hat Linux guru who has
extensive experience with Red Hat Enterprise 3.0
and 4.0 (both 32 bit and 64 bit). Must also have
experience in setting up Satellite Server. Must
have demonstrated experience in standardizing the
Linux build process to maintain quality and
consistency. To Apply to this job go to http://www.GadBall.com or click here

Unix Server Support Engineer (2nd Shift) in Chicago, IL

Prestigious Fortune 500 Company located in Chicagos Loop is currently seeking a Unix Server Support Engineer who wants to work 2nd shift. The current environment consists of over 4,000 Sun, Linux, and AIX servers. Candidates will perform installs, upgrade, and support this vast environment. Candidates must have strong Sun Solaris experience. Candidates will also support the large SAN environment. Candidates must be willing to work from 12:00pm to 9:00pm Monday thru Friday.
Experience: See above. To Apply to this job go to http://www.GadBall.com or click here

GadBall | GadBall Blog