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