27 days old
2017-11-142017-12-14

Software Engineer II - ETL

Reliance Steel & Aluminum Co.
Cypress, California 90630
  • Job Code
    Div. 98 #563
  • Job Type
    Employee
  • Job Status
    Full Time
  • Shift
    1st Shift

The Software Engineer II will be an integral member of the Reliance Technology Solutions (RTS) Technical team and will assist with developing scalable technical ETL solutions across the Reliance Family of Companies (FOCs). The individual is responsible for supporting the deployment, testing, operations, and maintenance of new and existing developments in the technical environment. The Software Engineer II role will be required to contribute to the technical design, development tasks, estimates, and execution to completion. The Software Engineer II must also ensure that developed code meets the technical and functional specifications through unit testing and validation. In addition, the Software Engineer II will identify, cleanse and transform data to enable timely and data-driven decision making.

Essential Functions

Technical Design- Able to identify, analyze, specify, design, and translate functional design to technical design.

  • Create and document technical designs for medium to high complexity solutions that may include integrations with external systems
  • Participate in peer technical design review
  • Design systems that span multiple technologies/platforms
  • Apply design standards across all applications
  • Design solutions to meet performance requirements and scalability expectations

Application Development - Able to write, test, debug, and maintain applications for end-user adoption, productivity improvement and efficiency.

  • Research, analyze, and produce high quality source code for medium to high complexity solutions
  • Create, modify, and enhance medium to high complexity programs
  • Assist with technical design
  • Troubleshoot and resolve technical issues
  • Participate in peer code reviews
  • Collaborate with cross functional teams to identify and solve software defects
  • Anticipate risks and implement contingency plans to resolve issues impacting applications
  • Design operational support systems like monitoring, reporting, fail over, error handling etc.
  • Proactively enhances systems for stability, efficiency, scalability and robustness  
  • Perform file level verification tasks via UNIX Shell scripts and command-line utilities.
  • Provide support to all ETL applications and perform root cause analysis on all processes to resolve all production issues.

Unit Testing and Validation - Ensures developed code meets the technical and functional specifications.

  • Develop and document effective unit test cases to test solution and validate results are as expected
  • Modify code if unit test fails
  • Document all test procedures for systems and processes and coordinate with business analysts and users to resolve all requirement issues and maintain quality for same.
  • Ensure the application operates according to functional and technical specifications
  • Troubleshooting and resolve software bugs, data, and system configuration issues
  • Develops reusable unit test case suite

Provide Accurate Project Effort Estimates - Ability to quantify and meet individual and project phase level efforts.

  • Manage ambiguity, meet and create accurate project effort estimates for their assigned tasks
  • Understand, consider and communicate interdependencies for project estimates  
  • Adhere to RTS project methodology throughout project lifecycle

Adherence to Standards - Ability to create solutions that adhere to and incorporate RTS standards.

  • Apply and use information and technology standards in solution design.
  • Obtain key inputs from Enterprise Architecture to ensure compliance and exception management
  • Identify commonalities and suggest a consistent approach across projects

Supplemental Duties & Responsibilities

  • Pursues training and development opportunities; Strives to continuously build knowledge and skills
  • Assist personnel in other RTS departments to resolve technical and/or application issues
  • Other duties as requested
  • Participate in gap-fit analysis
  • Occasionally may require an adjusted work schedule - evening/weekend hours in order to meet project deadlines or to access the computer system to support 2nd/3rd shift users

Core Competencies

Problem Solving - Ability to problem solve through problem identification (what is the problem), solution assessment (what can be done), problem documentation (document for future) and problem response (implementing a solution).

     Able to:

  • Frame problems before trying to solve them
  • Break down medium to high complexity problems and identify all of their components
  • Provide insight into the root-causes of problems      
  • Seek advice from those who have solved similar problems
  • Anticipate problems and is proactive in addressing them
  • Follow up to ensure that the problem has been resolved
  • Ask perceptive questions to seek optimal solutions
  • Explore various sources for answers, and think "outside the box" to find options
  • Be open to others' ideas to help develop solutions
  • Generate a range of solutions and courses of action with benefits, costs, and risks associated with each
  • Evaluate the chosen course of action to determine its worth and impacts

Decision making - Makes sound, well-informed, and objective decisions; perceives the impact and implications of decisions; commits to action, even in uncertain situations, to accomplish organizational goals.

     Able to:

  • Gather data and others' input when making decisions
  • Escalate decisions when appropriate
  • Weigh pros and cons of each option before making a decision and moving forward
  • Balance analysis, insight, experience, and perspective when making decisions
  • Explain the rationale for a decision
  • Find solutions that are acceptable to diverse groups with conflicting interests and needs
  • Willing to make decisions in difficult situations in a timely manner

Customer Service - Ability to develop and maintain strong relationships with others by listening, understanding and responding to their needs.

     Able to:

  • Provide service to internal and external customers to satisfy their needs and expectations
  • Listen to concerns and resolve reported issues effectively and promptly
  • Ensure and comply to customer response timeline (SLAs) based on the severity of reported issues including documenting concise and accurate status information in the ServiceNow ticketing system
  • Deliver high quality products and services
  • Commit to continuous improvement                                                                                                                                        
  • Anticipate others’ needs and move to effectively address issues
  • Establish proactive relationship with others
  • Elicit feedback from others
  • Deliver high quality solutions that meet the organization’s needs

Company Business Knowledge - Understands the company, its products and the business processes.

     Able to:

  • Develop understanding of common business processes within Reliance
  • Apply broad (two or more areas) Reliance business knowledge to technology solutions

Accountability - Holds self-accountable for measurable high-quality, timely, and cost-effective results.

     Able to:

  • Proactively collaborate between own functional area and areas below or above in the project stream as needed
  • Set well-defined and realistic personal goals
  • Comply with established policies and procedures
  • Accept responsibility for mistakes
  • Display a high level of initiative, effort, and commitment towards completing assignments
  • Minimize re-work
  • Seek out learning opportunities
  • Identify training needs and take action to obtain knowledge  
  • Anticipate and adjust for problems and roadblocks
  • Be enthusiastic for the things he/she sees as challenging
  • Be proactive throughout work assignments /projects
  • Persistently push self and others for results
  • Help others learn
  • Make good decisions on behalf of the company (profitability, compliance)
  • Provide consistency between projects

Communication - Communicates effectively across all levels to support departmental and organizational objectives.

   Able to:

  • Establish rapport with co-workers easily
  • Clearly express information taking into account audience and nature of the information (for example, non-technical, sensitive, and controversial)
  • Ask questions and summarize what was heard to prevent miscommunication
  • Present information in a concise and focused manner
  • Listen to others
  • Communicate written information (for example, facts, ideas, or messages) in a succinct and organized manner
  • Produce written information, which may include technical material that is appropriate for the intended audience
  • Share ideas and perspectives and encourage others to do the same
  • Inform others involved in a project of new developments
  • Ensure written messages have the desired effect on the target audience

Building Collaborative Relationships - Develops, maintains, and strengthens partnerships with others inside and/or outside the organization.

     Able to:

  • Establish rapport with co-workers easily
  • Encourage and facilitate cooperation, pride, trust and group identity
  • Foster commitment and team spirit
  • Work with others to achieve goals
  • Listen and respond constructively to other team members' ideas
  • Offer support for others' ideas and proposals
  • Be open with other team members about his/her concerns
  • Share his/her expertise with others
  • Acknowledge team members for their contributions
  • Provide assistance to others when they need it
  • Work for solutions that all team members can support
  • Effectively persuades and influences team members to achieve goals
  • Effectively collaborate with geographically distributed teams

Leadership – Displays effort and commitment in carrying out the department’s goals and objectives.

     Able to:

  • Act in a proactive and achievement-oriented manner
  • Treat co-workers in a fair and equitable manner
  • Empower others by sharing information
  • Actively listen and clarify information as needed
  • Foster an atmosphere of open communication
  • Behave in a tactful, compassionate, and sensitive manner
  • Consider and respond appropriately to the needs, feelings, and capabilities of different people in different situations
  • Share best practices and processes

Requirements

  • Bachelor's Degree or equivalent work experience in a related field required.
  • Must be self-motivated and able to work independently, with minimal supervision and as part of a team
  • Detail oriented with excellent interpersonal communication skills
  • Excellent customer service skills
  • 2+ years’ experience developing data integration processes using Informatica Powercenter 9.0 and above required
  • 2+ years’ experience developing data integration processes for retail and/or distribution-based businesses desired
  • Strong experience dealing with disparate data sources, data cleansing, and conformance required
  • Strong experience developing database applications using Oracle and SQLServer required
  • Working knowledge of data warehousing concepts and techniques required
  • Ability to effectively communicate at all levels including customers, peers, business stakeholders, and management
  • Working Knowledge of Shell Scripting
  • Prior experience developing applications using a waterfall or agile methodology preferred
  • Working knowledge of database design and PL/SQL (Query Language)
We are an Equal Opportunity/Affirmative Action Employer. All persons shall have the opportunity to be considered for employment without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable federal, state or local law. 

We will endeavor to make a reasonable accommodation to the known physical or mental limitations of a qualified applicant with a disability unless the accommodation would impose an undue hardship on the operation of our business. If you believe you require such assistance to apply for the position or to participate in an interview, please let us know. 


Reliance Steel & Aluminum Co. provides reasonable accommodation for individuals protected by Section 503 of the Rehabilitation Act of 1973, the Vietnam Era Veterans' Readjustment Assistance Act of 1974 and Title I of the Americans with Disabilities Act of 1990.  Applicants who need accommodation in the job application process should contact Gabe Muñoz at (213) 576-2426 or e-mail  Gabriel.munoz@rsac.com to request an accommodation.

Categories

  • Information Technology

Share this job:

Software Engineer II - ETL

Reliance Steel & Aluminum Co.
Cypress, California 90630

Share this job

Software Engineer II - ETL

Reliance Steel & Aluminum Co.
Cypress, California

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast