Developer II (ETL & SSIS)

First Solar

First Solar

Software Engineering
Perrysburg, OH, USA
Posted on Tuesday, April 2, 2024

Job Description

First Solar reserves the right to offer you a role most applicable to your experience and skillset.

Basic Job Functions:

  • Responsible for gathering requirement, designing, developing, customizing, testing and integrating Oracle Fusion Cloud applications with other systems, report development and providing ongoing support and future enhancements of those solutions.

Education/Experience:

  • Bachelor’s degree in Information Technology or related field or equivalent work experience.
  • Minimum 5 years of work experience.
  • Proficient use of all Microsoft Office suite programs.

Required Skills/Competencies:

  • Must have experience in Oracle BI Publisher in Fusion
  • Knowledge in Supply Chain and Finance report development using Oracle tools OTBI – BI Publisher
  • Develop fast formulas, design ESS jobs, and optimize data models
  • Strong Oracle SQL skills with extensive experience in fine tuning of queries and fixing performance issues
  • Technical knowledge of Oracle Applications, Oracle SQL and PL-SQL development is required.
  • Some experience with RICE (Reports, Interfaces, Conversions, Extensions), Forms, BI Publisher Reports/XML Publisher, Workflow, OAF, SQLDeveloper and Linux Shell Scripting.
  • Techno functional experience in one or more modules: Financials, Projects, Procurement, Order Management, HCM, WMS and OTM
  • Proven ability and knowledge of computer technology.
  • Excellent communication and organization skills.
  • Demonstrated ability to create technical documentation and reports.
  • Proven interpersonal skills.
  • PLSQL Knowledge /Oracle EBS Technical Knowledge/OCI is a plus.
  • Functional Knowledge on SCM(Customer/Supplier/Inventory/Maintenance Modules) and GL/ProjectManagement/Tax Module is a plus.

Essential Responsibilities:

  • Execute on designs, specifications, and requirements for applications/system enhancement and data structures that meet customer processes.
  • Perform troubleshooting and problem solving for issues related to application, manufacturing, process data & system data.
  • Provide support for First Solar applications and participate in a rotation of on-call support outside of normal office hours as necessary during critical times.
  • Responsible for Incident/ Request management & Problem management.
  • Produce technical documentation for service transition to operation.
  • Train with subject matter experts to provide on call support, troubleshooting, and modifications to existing applications.
  • Interface with team members and stakeholders from other departments.
  • Exercise effective communications levels and foster team building.
  • Adhere to SDLC processes, standards, and compliance measures (SOx, etc.)
  • Adhere to all safety procedures and good housekeeping standards.
  • Adapt at creating business process models based on requirements
  • Adapt at mapping industry trends and best practices to the client unique requirements and process to determine applicable fit
  • Undertakes analytical activities and delivers analysis outputs, in accordance with customer needs and conforming to agreed standards.
  • Within given research goals, builds on and refines appropriate outline ideas for research, i.e. evaluation, development, demonstration and implementation. Uses available resources to gain an up-to-date knowledge of any relevant IT field. Reports on work carried out and may contribute sections of material of publication quality.
  • Applies data analysis and data modeling techniques to establish, modify or maintain a data structure and its associated components (entity descriptions, relationship descriptions, attribute definitions).
  • Undertakes complete design of simple applications using simple templates and tools. Assists as part of a team on design of components of larger systems. Produces detailed designs including for example: physical data flows, file layouts, common routines and utilities, program specifications or prototypes, and backup, recovery and restart procedures.
  • Translates and implements simple development project requirements into physical database structures. Assesses proposed changes to object and data structures and implements these changes in physical databases. Assists in database management system support activities for operational database systems.
  • Designs, codes, tests, correct, and documents simple programs, and assist in the implementation of software which forms part of a properly engineered information or communications system.
  • Applies tools and methods to identify the user experience, user’s characteristics and tasks, and the technical, organizational and physical environment in which the product or system will operate.
  • Defines the integration build and produces a build definition for generation of the software. Accepts software modules from software developers, and produces software builds for loading onto the target hardware from software source code. Configures the hardware environment, produces integration test specifications, conducts tests and records the details of any failures. Carries out and reports fault diagnosis relating to moderately complex problems.
  • Uses the tools and techniques for specific areas of release and deployment activities. Administers the recording of activities, logging of results and documents technical activity undertaken. May carry out early life support activities such as providing support advice to initial users.
  • Assists in the investigation and resolution of issues relating to applications. Assists with specified maintenance procedures.
  • Investigates problems in systems and services. Assists with the implementation of agreed remedies and preventative measures.
  • Uses appropriate methods and tools in the development, maintenance, control and distribution of quality and environmental standards. Makes technical changes to quality and environmental standards according to documented procedures. Distributes new and revised standards.
  • Other duties as assigned.
  • Job description subject to change at any time.

Reporting Relationships:

  • This position will report to the Manager I- IT

Travel:

  • 5% - 10%

Estimated Annual Salary Range:

  • $65,000 - $85,000 Estimated Annual Salary Range

US Physical Requirements:

All positions in our office require interaction with people and technology while either standing or sitting. To best service our customers, internal and external, all associates must be able to communicate face-to-face and on the phone with or without reasonable accommodation. First Solar is committed to compliance with its obligations under all applicable state and federal laws prohibiting employment discrimination. In keeping with this commitment, it attempts to reasonably accommodate applicants and employees in accordance with the requirements of the disability discrimination laws. It also invites individuals with disabilities to participate in a good faith, interactive process to identify reasonable accommodations that can be made without imposing an undue hardship.

Potential candidates will meet the education and experience requirements provided on the above job description and excel in completing the listed responsibilities for this role. All candidates receiving an offer of employment must successfully complete a background check and any other tests that may be required.

Equal Opportunity Employer Statement: First Solar is an Equal Opportunity Employer that values and respects the importance of a diverse and inclusive workforce. It is the policy of the company to recruit, hire, train and promote persons in all job titles without regard to race, color, religion, sex, age, national origin, veteran status, disability, sexual orientation, or gender identity. We recognize that diversity and inclusion is a driving force in the success of our company.