Applications Development Consultant(Job Number:707891)
Applications Development Consultant
If you want to achieve more in your mission of health care, you have to be really smart about the business of health care. Challenge yourself, your peers and our industry by shaping what health care looks like and doing your life's best work.(sm)
We are seeking an Applications Development Consultant for our Minnetonka, MN location to be responsible for responsible for designing and developing systems to support products related to healthcare claims data and participating in Extract, Transform, Load (ETL) requirement gathering, analysis, design, development and implementation of ETL solutions using DataStage. Specific duties include: (1) design, develop, test and implement ETL processes using IBM DataStage 8.5 based on requirements gathered directly from business users or using ETL Functional Specifications; (2) documenting Design Specifications or Approach and Transformation Rules; (3) responsible for code review and unit testing; migrate code from development to UAT and production; (4) responsible for maintaining versions of code using subversion or equivalent version control tool; (5) responsible for schedule jobs using TWS (Tivili Work Scheduler); (6) loading data into Netezza and Teradata and verifying the loaded data; (7) utilizing problem solving and debugging skills with strong ability to quickly learn and understand business processes and problems in order to effectively develop technical solutions to their requirements; (8) making performance enhancements to processes based on analysis and statistics; (9) troubleshooting issues within ETL, UNIX, and Teradata environments; (10) analyzing data in source systems in the event of any issues with data; (11) writing control scripts, setting environment scripts and space management scripts, and archiving/retrieval scripts using UNIXing shell scripting; (12) archiving and restoring using Archive Utilities and executing change management responsibilities; (13) coordinating with offshore Teams for successful offshore delivery; (14) coordinating with the Testing team for validation and the BA team for Requirements; (15) coordinating with the Operations team for successful deployment of code and Knowledge Transfer; (16) working in the following technology environments: Teradata Aster, Teradata 13.0/12.0, Datastage 8.7, Netezza,SQL, Teradata SQL Assistant, Teradata Utilities, MS Visio, Tivoli Workload Scheduler, MS Office Suites, Sun Solaris UNIX, LINUX, HP Quality Centre 9.5 ALM; (17) performing data quality and integrity end-to-end testing and documenting technical specifications of ETL program codes; and (18) developing TWS jobs for the scheduling of ETL jobs.
Job Applications Development
Primary Location US-MN-Minnetonka
Organization S&T - Optum Data Mgmt
Number of Openings 1