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