This site uses cookies. To find out more, see our Cookies Policy

ETL Systems Analyst III in Littleton, CO at APEX Systems

Date Posted: 5/11/2019

Job Snapshot

Job Description

Job #:  946495

Job Functions:
  • Manage quality and timely deliverables produced by the offshore development team in accordance with project plans and service request promise dates.
  • Monitor production processes, review reports and monitoring tools daily for data quality, performance and on time completion of processes.
  • In some instances, respond to escalations during off hours.
  • Design, develop, modify, test, implement, and document application changes/upgrades to meet business needs in partnership with our hosting Partner.
  • Contribute to the overall planning of projects and issue resolution by recommending approaches, identifying resources, and developing timelines.
  • Follow documented procedures for configuring, maintaining, upgrading, testing, and coding the application/custom interface routines.
  • Ensure best technical practices are followed for all enterprise software development.
  • Effectively communicate of project plans, priorities, and program status within the team.
  • Perform detailed tests and review developers work to ensure a high level of data quality.
  • Direct and effectively teach effective coding techniques and best practices to other developers.
  • Provide technical assistance in identifying, evaluating and developing systems and procedures.
  • Develop, coordinate and implement plans to test business and functional processes during system development and quality assurance testing.
  • Monitor and document post-implementation problems revision requests.
    • In this effort, raise issues to our hosting partner and work with them through issue resolution.
  • Maps software functionality to business processes.
  • Assist in making decisions on the utilization of software programming resources.
  • Provide technical development and analytical support for Informatica ETL (cloud and power center).
  • Review and test code and results developed by offshore resources.
  • Assist in providing technical direction for future projects.
  • Team Education and hosting partner cross training on ETL development as required.
  • Assist the business team with BI reporting in conjunction with ETL workload.
  • Ensure standard documentation requirements are met.

  • Bachelor’s Degree in Computer Science, Information Systems or related field/equivalent experience.
  • 8+ years of development experience with 5-7 years of that experience in designing, developing and supporting technical solutions for Informatica ETL Applications or equivalent Data Warehouse ETL applications.
  • Must be proficient with the Informatica Power Center, as well as SQL, Unix, and Process Scheduler.
  • Must have at least 3 years of experience with BI reporting tools.
  • Must have worked in environments using SDLC methodologies and standards.
  • Must have strong analytic and problem solving skills.
  • Must be willing to be on call for night/weekend production support.
  • Must have solid SQL development skills.

Nice to Have:
  • Agile preferred.
  • Experience in Linux environment preferred.
  • Prior experience with Manufacturing systems preferred.
  • Experience on Oracle 10g/11g databases preferred.
  • Cloud experience - preferred

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.