Republic Services ETL Developer II in Scottsdale, Arizona

About Us

Republic Services is an industry leader in U.S. recycling and non-hazardous solid waste. Through our subsidiaries, Republic’s collection companies, recycling centers, transfer stations, and landfills focus on providing effective solutions to make proper waste disposal effortless for our 14 million customers. We’ll handle it from here., our brand promise, lets customers know they can count on Republic to provide a superior experience while fostering a sustainable Blue Planet for future generations to enjoy a cleaner, safer and healthier world.

Why Work with Us

Our Company cannot thrive without great people devoted to serving customers, the community, and the planet. We hire the best people to make Republic a great place to work. We are focused on attracting talented individuals across professions who are as committed to serving customers and the planet as we are. We strive to create a workplace that's meaningful and rewarding to our 33,000 employees. That's why we are proud to be recognized as Best Large Employer by Forbes, World’s Most Ethical Companies by Ethisphere, and One of the Most Meaningful Companies to Work for in America by Business Insider.

Job Description

The ETL Developer II develops, configures, codes, tests, and debugs complex new software, enhancements to existing proprietary software or purchased software packages. In conjunction with functional users and IT Business Systems personnel, the ETL Developer II also assists with the design and documentation of the Company’s application software environment.

Knowledge, Skills & Abilities

Preferred Qualifications

Principal Responsibilities

  • Prepares detailed technical specifications from which complex data integration programs will be written or configured using Informatica suite of products.

  • Writes high quality code using Informatica suite of products, and according to specifications.

  • Reviews and approves code of junior developers

  • Mentors junior developers in development techniques and standards.

  • Follows all required Company policies and practices relating to the System Development Life Cycle. Defines or may assist others in defining application system scope and objectives through research and fact finding.

  • Builds mechanisms and reports exception feedback loops into the data integration processes.

  • Works with data architects and staff engineers to develop data designs and standards.

  • Provides Tier 3 support and resolution of open IT issues escalated by IT Customer Support.

  • Develops project plans for application software implementation activities of low to medium level of complexity.

  • Develops strong software vendor and business partner relationships to resolve problems and coordinate the delivery of IT products and services.

  • Conducts appropriate functional and performance testing to identify bottlenecks and data quality issues.

  • Performs other job-related duties as assigned or apparent.The statements used herein are intended to describe the general nature and level of the work being performed by an employee in this position, and are not intended to be construed as an exhaustive list of responsibilities, duties and skills required by an incumbent so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the Company.

Qualifications

  • Bachelor’s degree in Computer Science, Engineering, or Statistics (willing to accept foreign education equivalent). (Required)

  • Minimum of 3 years of experience with ETL software development using Informatica to include installation, configuration, maintenance, enhancement, and support. (Required)

  • Minimum 3 years of experience working with dimensional database modeling and with SQL 2012 database technologies including stored procedures, trigger, schemas, and tables.

  • Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner.

  • Understands the need for and consistently practices effective teamwork with others.

  • Strong background in Software Development Lifecycle (SDLC) and Agile methodologies.

  • Experience prioritizing and managing assignments, tasks, and significant projects to completion with minimal supervision and supervising junior developers’ tasks

  • Excellent written and verbal communication skills.

  • Ability to maintain a detail oriented approach while multitasking in a fast paced environment.

  • Proficient in all currently supported application development standards in use at Republic Services.

  • Ability to provide assistance with creation and maintenance of development standards in use at Republic Services.

  • Ability to write reports, business correspondence and procedures manuals.

  • High level of proficiency in the programming language or other development tools used in specific area of responsibility.

Rewarding Compensation and Benefits

Eligible employees can elect to participate in:

  • Comprehensive medical benefits coverage, dental plans and vision coverage.

  • Health care and dependent care spending accounts.

  • Short- and long-term disability.

  • Life insurance and accidental death & dismemberment insurance.

  • Employee and Family Assistance Program (EAP).

  • Employee discount programs.

  • 401(k) plan with a generous company match.

  • Employee Stock Purchase Plan (ESPP).

Republic Services is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, protected veteran status, genetic information, or any other characteristic protected by applicable law.