This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/11868584

Design, develop, support and maintain ETL processes (Extract, Transform and Load) using Informatica Power Center. Design, Code, and unit test application code using Software Development Life Cycle (SDLC) best practices. Develop and deploy UNIX shell scripts and develop Informatica ETL mappings. Create technical system documentation, create Autosys jobs for scheduling and create database source-to-target mapping documents. Work on automations, enhancements and maintenance activities of the data warehouse including performance tuning and rewriting of functions for code enhancements. Build partnerships across the application, business, and infrastructure teams. Develop Abinitio graphs with Abinitio components such as Rollup, Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Lookup, etc. Develop complex SQL queries for querying data against data base. Involve in Unit, Integration, System and Performance testing. Prepare, review, and execute the test cases for data migration. Good knowledge in Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management. Skills /Technologies: ETL Informatica Power Center, HP ALM Tool, Abinitio, Unix, Shell scripting, SQL, PLSQL, Oracle RDBMS, Autosys, Perforce, Winmerge, WinSCP.\ \ Employer will accept a Bachelors degree in the Computer Science/Engineering (any), C.I.S. or equivalent, plus five years of experience in lieu of masters degree plus one-year\ experience.\ \ Various worksites. Employee might have to relocate to unanticipated client sites based on the requirement of the position. No National/International travel required.