ETL Developer in Eagan, MN at APEX Systems

Date Posted: 7/17/2019

Job Snapshot

Job Description

Job #:  970831

ETL Developer
Location: 2900 Ames Crossing Road Eagan, MN 55121
Duration: projected through 5/27/20
VMS: PRMJP00005462
The ETL Developer is responsible for investigating, identifying, and implementing application system changes and developing new applications.Analyzing and evaluating existing or proposed application systems to process data. Designing, coding, testing, debugging, and documenting programs and collaborating with other team members by providing technical advice and training
Specific Duties include items such as:
  • Analyze source data/file structures, technical metadata, profile source data and develop data mapping and transformation rules and detail ETL specifications based on business requirements
  • Assist in the collection of technical metadata supporting the implementation
  • Utilize automation tools to schedule, execute, and monitor ETL jobs
  • Design, test, and debug data flow plans to populated databases
  • Design of ETL Applications
  • Performance tune the application to meet operational production requirements
  • Develop and execute, in conjunction with the ETL Architect, Quality and Release, and Process Analyst system and integration test plans
  • Implement audit, balance and controls per business requirements
  • Design and code functions of the application in accordance with the ETL standards and architectural guidelines
  • Execute test plans and document results and discrepancies
  • Assist in researching and resolving data issues uncovered during development and testing

Daily Responsibilities:
  • Ongoing support for existing applications (apps within tech requirements)

Operating Rhythm / Interaction level with Management and other Team Members:
  • Day to day, highly interactive group of 7 team members 

  • Degree – Bachelors (tech degree) or Equivalent Experience

Must Haves:
  1.  4-6 years of IBM datastage
  2.  Knowledge of job scheduling
  3. DB2 & Teradata exp

Technology Requirements/Depth:
  • DataStage Scale 1 to 5 need 4.0
  • DB2 Scale 1 to 5 need 3.5
  • UNIX Sript Scale 1 to 5 need 2.5
  • Strong Data Warehouse fundamentals need a 2
  • Teradata in SQL, Stored Procedures need a 2

EEO Employer
Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178-6178.