r details required for submission to *n...@apetan.com <n...@apetan.com>.*
*ETL DataStage Developer* *Client: HealthPartners* *Location: Bloomington, MN 55425* *Local candidates only. Must be able to interview in-person.* Contract opportunity for an ETL DataStage Developer consultant to work at our Bloomington headquarters location with our IS&T Enterprise Information Management (EIM) team. The ETL DataStage Developer builds, tests, implements and supports HealthPartners enterprise DataStage ETL for Health Plan and Care Delivery data environments. This position follows standard concepts, practices, and procedures that meet the technical specifications as designed by IS&T EIM Business Data Design Analysts. The ETL DataStage Developer makes use of the IBM DataStage ETL Tool and utilizes ETL standard processes and procedures to move data, manage metadata, and ensure the integrity, validity, security and auditability of HealthPartners critical information assets. This role follows standard development life-cycle processes (Agile/Lean, Waterfall, Hybrid) and follows the technical coding specifications for production, testing, QA and implementation processes. The candidate will have hands on experience with large scale enterprise ETL development of data warehouses with technologies appropriate for the platform where development occurs (Oracle, DataStage, AIX, etc.). Actual experience with migration of ETL code from DataStage 8.x to DataStage 11.x will be favorable. *ACCOUNTABILITIES:* · Collaborate with IS&T EIM team members, business liaisons, and end-users to deliver enterprise data integration DataStage ETL solutions · Develop, implement, and optimize DataStage ETL workflows and transformations · Implement standards and procedures for DataStage ETL development and tool configurations · Triage the resolution of complex data integration DataStage ETL issues in a timely manner · Contributes as needed to the design and development of exception handling, data standardization procedures and Quality Assurance controls · Develop the DataStage ETL packages to design specifications · Participates in DataStage ETL code reviews · Update DataStage ETL Technical specifications with changes as code is updated *REQUIRED QUALIFICATIONS:* · Bachelor’s degree or equivalent experience · 4+ years’ experience with DataStage ETL development and support; preferably with healthcare data delivery and data warehouse development roles · 4+ years’ experience using IBM DataStage Tools; preferable version 11+ and Parallel jobs · Demonstrated experience with PL/SQL and knowledge of Oracle RDBMS (features, functions utilities)Ability to estimate data development efforts · Ability to manage tasks, work independently and be a team player · Strong documentation and diagramming skills · Excellent verbal and written communication skills · Demonstrated experience performing data integration utilizing DataStage ETL tools to develop, implement, and optimize DataStage ETL workflows and transformations *PREFERRED QUALIFICATIONS*: · Healthcare (payer, provider, and/or pharmacy benefit management) experience · Experience with migration of DataStage ETL code from DataStage 8.x to DataStage 11.x · Experience using IBM QualityStage and Change Data Capture (CDC) tools · Experience with AIX 5.x or equivalent UNIX operating system · Experience with AutoSys or equivalent job scheduling tool experience · Familiarity with SDLC (systems development life cycle) such as Agile/Lean and data modeling tools such as Erwin or Embarcadero · Practical experience using commonly accepted data warehouse methods such as the Kimball or Inmon models Understanding of data models, staging, landing and data cohorts, ODS, OLAP, multi-dimensional analysis, and various data schemas -- *Nick G.* |* Technical Recruiter **| **Apetan Consulting LLC |* *Tel: 201-620-9700 * 141 **| **15 Union Avenue, office # 6, Rutherford, New Jersey 07070 | * *Mail :-** n...@apetan.com <n...@apetan.com> **| **www.apetan.com* <http://www.apetan.com/> | https://www.linkedin.com/in/nick-g-a4637391 -- You received this message because you are subscribed to the Google Groups "Oracle Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to oradev+unsubscr...@googlegroups.com. To post to this group, send email to oradev@googlegroups.com. Visit this group at https://groups.google.com/group/oradev. For more options, visit https://groups.google.com/d/optout.