Job Details

Mid-Level ETL/DataStage Developer (842) (02/24/2016)

Salt Lake City, UT

This position is for a mid-level ETL/DataStage Developer responsible for successful delivery of CNSI’s Midwest region’s conversion practices. Candidates for this role will be supporting the development and operations requirements, working cohesively with other database developers/leads/subject matter experts, database administrators, architects, data quality analysts, and other teams, as well as manage client relationships within the context of an individual role.


Job Duties/Responsibilities: 

  • Significant experience & demonstrated proficiency in all aspects of design and development using IBM InfoSpere DataStage.
  • Shell Script expertise.
  • Familiarity with the integration of the IBM InfoSphere tool suite (metadata, glossary, lineage, data quality, Information Analyzer)
  • Experience in database programming on Oracle SQL / PL/SQL and/or related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing
  • Solid facilitation skills to gather the necessary information to document and/or develop a plan - strategic/tactical
  • Participate in meetings and discussions with Functional/Technical Leads to understand the requirements and work out a design.
  • Participate in code reviews and ensure the code written complies with the company standards and policies
  • Interact with all levels of an organization in a professional, diplomatic, and tactful manner
  • Continue enhancing own ETL InfoSphere DataStage and PL/SQL skills on new practices, frameworks and standards
  • Prepare the Requirements and Design documents
  • Write/maintain SQL and PL/SQL stored program units/packages and maintain coding standards.
  • Write unit tests (document and code) for the PL/SQL stored program units/packages
  • Support Production Operations as necessary
  • Mentor other ETL/DataStage developers in enhancing their skills

Required Skill

Primary Skills

  • Minimum 5 years’ experience as an ETL/DataStage Developer
  • Oracle 10g, 11g experience
  • Strong PL/SQL programming skills
  • Proven record of accomplishment working in all aspects of the software development life cycle
  • Understanding of Extract/Transform/Load (ETL) processes to support Data Conversion / Migration / Consolidation
  • Should have good communication and writing skills
  • Candidates must be willing to work independently and/or as part of a team in an energetic, team-oriented environment managing systems of varying size/complexity with a fast turn-around time
  • Apply innovation, creativity, and improvement to the development/support processes
  • Ability to manage multiple priorities effectively is a necessity
  • TOAD experience is preferred
  • BS in Computer Science or related discipline

Secondary Skills

  • Experience in a healthcare/insurance domain is preferred
  • Experience with State government projects is preferred
Apply Now

Personal Information

Upload resumé

Additional Information