AI ETL Solutions Engineer in Palo Alto, CA at HUNTER Technical Resources

Date Posted: 4/27/2020

Job Snapshot

Job Description

AI ETL Solutions Engineer

Palo Alto, CA

Responsible for programming on specific application subsets of the company's application portfolio, participating in all phases of the development and maintenance life cycle, typically for an assigned business unit, client program, or corporate department and utilizing various customer technology platforms

Primary duties may include, but are not limited to:

  • Maintains active relationships with customers to determine business requirements and leads requirements gathering meetings.
  • Owns the change request process and may coordinate with other teams as necessary.
  • Develops and owns list of final enhancements.
  • Develops and defines application scope and objectives and prepares technical and/or functional specifications from with programs will be written.
  • Performs technical design reviews and code reviews.
  • Ensures unit test is completed and meets the test plan requirements, system testing is completed and system is implemented according to plan.
  • Assesses current status and supports data information planning.
  • Coordinates on-call support and ensures effective monitoring of system.
  • Maintains technical development environment.
  • Mentors others and may lead multiple or small to medium sized projects.
  • Facilitates group sessions to elicit complex information on requirements clarification, design sessions, code reviews and troubleshooting issues.
  • Supports vendor evaluation.


  • Requires BA/BS degree in related
  • 5 or more years related experience; multi-platform experience
  • Technical expertise with Python and PySpark
  • Ability to translate the busines requirements/user stories into technical solutions.
  • Proficient in Data Analysis, Data Modeling, Data profiling, ETL concepts and relational concepts.
  • Experience with design and development of SQL objects, writing complex SQL queries using Microsoft T-SQL and advanced functions.
  • Experience in design, development and implementation of complex ETL solutions
  • Have experience with generating JSON outputs or other file extracts in different formats
  • Agile Scrum methodology experience and use of JIRA

Preferred Skills:

  • Experience with automation and scheduling of components through scheduling tools
  • Experience with designing, development and deploy the solutions for small/medium scale projects.
  • Experience with performance tuning of complex SQL queries, Indexing strategies and Informatica solution.
  • Healthcare experience a plus.


  1. Software Engineer Jobs
  2. Project Engineer Jobs