Remote ETL Developer

Apex Systems
Westdesmoines, IA
09 Aug 2024

Vacancy expired!

Job#: 1283841

Job Description: Apex Systems is looking for a REMOTE ETL Developer. If you want to learn more, please reach out to

Job Title: ETL Developer

Location: Remote

What you can expect as an ETL Developer:
  • As an ETL Developer you would be responsible for developing ETL and ELT processes for the Enterprise ODS and Analytics Warehouse, leveraging technology such as Informatica and Snowflake.
  • Test ETL processes developed as per the Specs to ensure quality of the processes and data.
  • Provide inputs to continuously improve ETL process discipline and resulting output quality.
  • Ensure ETL processes are tuned for optimal performance.
  • Collaborate with the Architects on POC of new tools and technologies.
Experience Requirements:
  • 5+ years of experience in designing and delivering Data Warehouses and reporting solutions.
  • High Level of SQL experience is must.
  • Experience with Database technologies such as Oracle, DB2, SQL server a must.
  • Experience with Extract, Transform and Load and ELT development is required.
  • 5+ years of hands on experience with Informatica Power Center.
  • Exposure to cloud based DW Snowflake highly preferred.
  • Experience of working in Agile Environment.
  • Understanding of Life Insurance or Annuities business is preferred.

Job Summary:

Under general direction, formulates and defines system scope and objectives. Creates or modifies ETL/ELT processes to solve highly complex problems considering computer equipment capacity and limitations, operating time and form of desired results. Prepares detailed specifications to write programs. Designs, codes, tests, debugs, documents and maintains those programs. Competent to work on and responsible for nearly all phases of applications systems analysis and programming projects. Regularly provides guidance and training to less experienced analysts/programmers.

Essential Functions:
  • Develop or enhance code to update the Enterprise ODS and Enterprise Data Warehouses in support of Enterprise data needs.
  • Collaborate with analysts, designers, and programmers in conceptualizing and development of new software programs, applications and automated test scripts.
  • Perform technical tasks, detailed analyses, and interpretation of technical problems requiring expertise and/or specialized knowledge in a systematic manner; apply subject matter expertise unique to the discipline.
  • Exhibit expert understanding of the organizations Systems Development Life Cycle.
  • Play a leading role in the definition, development, and documentation of software requirements, objectives, deliverables, and specifications on a project-by-project basis in collaboration with internal users and departments.
  • Play a leading role in defining software development project plans, including scoping, scheduling, and implementation.
  • Prepare and/or interpret business, functional, and non-functional requirements; create and maintain user-oriented applications and design specifications.
  • Develop, test, document and implement applications according to standards and methodologies.
  • Design, develop and test automation scripts. Follow automated test script guidelines and research issues in software through testing.
  • Design, implement and maintain databases. Follow database standards and integrity controls, analyze information requirements, and develop database specifications.
  • Plan, coordinate, and implement security measures to safeguard information resources against accidental or unauthorized modification, destruction, or disclosure.
  • Design, run and monitor software functional and performance tests on new and existing programs for the purposes of correcting errors, isolating areas for improvement, and general debugging; administer critical analysis of test results and deliver solutions to problem areas.
  • Recommend, schedule, and perform software improvements and upgrades.
  • May be on call during scheduled times and may be required to work for extended periods at night and on weekends in support of conversion or testing a new program.
  • Maintain currency of professional, technical and business skills.
  • Utilize established status report, time accounting and collaborative process to provide data for management.
  • Exhibit expert understanding of application, data, and integration, plus deep understanding of security, operational, and systems management architectural and design domains.

Qualifications:
  • College Degree in the field of computer science, information science, management information systems preferred
  • Minimum 8 years' IT development experience or equivalent preferred
  • Able to effectively direct and coordinate the work of other team members on a project without having HR management responsibility for them
  • Knowledge of computer programming languages as required for the system
  • $75,248 - $156,766
EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, 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 or .
  • ID: #44722252
  • State: Iowa Westdesmoines 50265 Westdesmoines USA
  • City: Westdesmoines
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2022-08-09
  • Deadline: 2022-10-07
  • Category: Et cetera