Associate Engineer - ETL / SQL (Relational Database Management System)

Philippines | Taguig City, Philippines
Job ID: 33191

Job Description

Position at Ingram Micro

C:\Users\usonrp00\AppData\Local\Microsoft\Windows\INetCache\Content.MSO\CC25BCD3.tmp

 

 

Job Description

 

 

Section 1:  Identifying Information

 

Position Title: 

Associate Engineer, Software Development

Job code:

 

Grade:

L1- Associate Professional

Date Prepared:

October 2019

Reports to:

Team Leader/Manager

Prepared by:

 

Department:

Global IT

Business line:

 

Positions reporting to this position

 

Target team size:

 

Country/City:

Philippines/Manila

 

 

 

Section 2:  Position Summary

 

The Associate Engineer writes programs, as well as maintains and modifies existing applications programs. He/she must also document and execute test plans according to the requirement and can be assigned to support.

 

The Associate Engineer is also responsible for creating solutions for issues identified in the course of testing and following the Ingram Micro chosen applications development standards and methodologies.

 

 

The Associate Engineer works primarily on an independent basis within the guidelines given for delivery of technical work assignments. He/she must have great communication and collaboration skills and must be team oriented. He/she must be able to clearly provide detail on their progress on tasks and must be able to raise issues that would impact the delivery in a timely manner.

 

Shifts are between morning, mid or night with weekends as off-days although members can be asked to report to work at night and/or during weekends and/or holidays.

 

 

Section 3:  Responsibilities, Supporting Actions & End-Results

 

Guidelines: List the essential responsibilities, functions and/or activities, provide the supporting actions to describe how the work will be accomplished and provide the desired end results. List the responsibilities in order of importance and the estimated percentage of time for the responsibility (no one responsibility should be greater than 60% of time or less than 10%).  The most important responsibility is not necessarily the one where the most amount of time is spent.             

 

 

Major Responsibility:

 

Build/Development & Production Support

 

Supporting Actions:

  • Can analyze the design/issue and translate the design into code
  • Can create detailed test plans that cover the critical scenarios that must be unit tested for the requirement/ticket
  • Escalates issues or gaps in the design/resolution approach
  • Able to set expectations with Users/DM and secure UAT approval.
  • Communicates with on-shore for approvals
  • Can investigate and determine the root cause of the issue. 

End Results:

  • Fully working modules with minimal defects and in accordance to design specifications and functionality

 

Percentage:     50%

 

 

Major Responsibility:

 

Unit Testing

 

Supporting Actions:

  • Can execute detailed test plans for unit testing
  • Can do bug fixing on builds he/she performed.

 

End Results:

  • Fully working modules with minimal defects

 

Percentage:     25%

 

 

Major Responsibility:

 

IST/UAT

 

Supporting Actions:

  • Can establish communication with users/DM to understand the issue.
  • Can provide a fix to the issues encountered during testing that is related to the requirement
  • Can do bug fixing on builds he/she performed.

 

End Results:

  • Fully working modules with minimal defects

 

Percentage:     15%­­­

 

 

Major Responsibility:

 

Admin Tasks

 

Supporting Actions:

  • Accurate clocking of worked hours in Kronos, SAP CATS and Plan Port
  • Compliance with company policies and mandatory training.
  • Responds to communications in a timely manner.

 

End Results:

  • Adherence to all company policies
  • Simple decision-making regarding other team members’ schedules and tasks.

 

Percentage:     10%­

 

 

Section 4:  Decision Making Authority Level

 

Guidelines: Describe the authority held by the position by listing the main decisions that the position is free to make and explain the decisions that depend on the position’s advice.

 

Decisions free to make:

       

      ...

     

     

 

Explain the decisions that depend on position’s advice:

      ...

      ...

      ...

      ...

 

Example decisions that depend on position’s advice:

      ...

      ...

 

Section 5:  Scope/Dimensions

 

Guidelines: List the main quantitative measures that define the size and scope of the position (headcount, budget, profit dollar target).             

 

      ...

     

      ...

      ...

 

Section 6:  Job Qualifications and Educational Requirement

 

Guidelines: Provide the education, experience, skills and competencies necessary to perform the position.

 

       Graduate of any IT Related 4- or 5-year course.

       1 to 2 years’ experience in related programming language

     Proficient of any of the following technology

  •      Background in RDBMS such as MSSQL or Oracle or Sybase
  •      Microsoft technology such as MS Visual Studio, .NET, MVC, MS SQL and Angular JS
  •      Mainframe Cobol/Microfocus Cobol
  •      JCL
  •      DB2
  •      IMS
  •      Oracle PL/SQL 
  •      Oracle DDL
  •      C/C++

      Experience in Informatica, Unix, Python and AWS is a plus

      Experience in Bootstrap and Angular JS is a plus.

       Experience in Oracle is a plus.

       Experience in Cobol is a plus.

      Good communication skills both written and verbal.

 

Section 7:  IM Competencies

 

Guidelines: Provide the IM Competencies necessary to perform the position.

 

COLLABORATION AND INFLUENCE: Interpersonal Savvy

  • Able to develop rapport with others and recognize their concerns and feelings
  • Build and maintain long-term associations based on trust

 

COLLABORATION AND INFLUENCE: Communicates Effectively

  • Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences.
  • Able to clearly present information through the spoken or written word
  • Listen well.

 

COLLABORATION AND INFLUENCE: Collaborates

  • Possesses business knowledge or experience that can facilitate understanding of cross-functional requirements to achieve the organization’s objectives
  • Able to utilize such knowledge to connect the right dots and helps each business unit assume responsibility on a collaborative undertaking.
  • Performs consistently regardless of environment complexity

 

COLLABORATION AND INFLUENCE: Builds Networks

  • Develop a network of contacts and target specific influential people to reach goals

 

RESULTS ORIENTED: Drives Results

  • Consistently achieving results, even under tough circumstances
  • Has an overall achievement mindset, a bias for action, an eagerness to take initiative.

 

 

RESULTS ORIENTED: Ensures Accountability

  • Taking responsibility, and owning up to commitment
  • Being answerable for your actions.
  • Able to take responsibility for actions and outcomes and persist despite obstacles
  • Be available around the clock in case of emergency
  • Give long hours to the job if need arise on assigned tasks/projects
  • Demonstrates dependability in difficult circumstances and show a sense of urgency about getting results.

 

 

RESULTS ORIENTED: Action Oriented

  • Taking on new opportunities and tough challenges with a sense of urgency, high energy and enthusiasm

 

 

CHANGE AGENT: Being Resilient

  • Able to maintain a solution-oriented approach while dealing with interpersonal conflict, hazardous conditions, personal rejection, or time demands

 

CHANGE AGENT: Manages Ambiguity

  • Able to withhold actions or speech in the absence of important information
  • Deal with unresolved situations, frequent change, delays, or unexpected events.

 

CHANGE AGENT: Self Development and Nimble Learning

  • Able to stay informed of current industry trends
  • Learn and apply new concepts and demonstrate career self-reliance
  • Identify own areas of opportunity and set and monitor self-development goals.

 

CHANGE AGENT: Situational Adaptability

  • Adapting approach and demeanor in real time to match the shifting demands of different situations.
  • Able to remain open-minded and change opinions on the basis of new information
  • Perform a wide variety of tasks and change focus quickly as demands change
  • Manage transitions effectively from task to task
  • Adapt to varying customer needs.

 

JUDGEMENT AND DECISION MAKING: Decision Quality

  • Able to take action in solving problems while exhibiting judgment and a realistic understanding of issues
  • Able to use reason, even when dealing with emotional topics
  • Review facts and weigh options.

 

Section 8:  Other Information

Guidelines: Indicate any information that would be helpful in understanding the nature, scope or purpose of the position, or any unusual or hazardous conditions associated with performing the position.                                                                                     

 

  • On-call
    •     May be asked to provide secondary or tertiary support during weekends / holidays
    •     Readiness to provide support to the team lead and primary support associate to address the overflow.

 

 

 

 

 

 

 

 

apply now

Share

Still looking?

Get updates about the latest job openings that match your skills.

sign up today