ETL Developer III
Company: Disability Solutions
Location: Phoenix
Posted on: October 3, 2024
Job Description:
ABOUT THE COMPANYRepublic Services, Inc. (NYSE: RSG) is a leader
in the environmental services industry. We provide customers with
the most complete set of products and services, including
recycling, waste, special waste, hazardous waste and field
services.--Our industry-leading commitments to advance circularity
and support decarbonization are helping deliver on our vision to
partner with customers to create a more sustainable world.In 2023,
Republic's total company revenue was $14.9 billion, and adjusted
EBITDA was $4.4 billion. We serve 13 million customers and operate
more than 1,000 locations, including collection and transfer
stations, recycling and polymer centers, treatment facilities, and
landfills.Although we operate across North America, the collection,
recycling, treatment, or disposal of materials is a local business,
and the dynamics and opportunities differ in each market we serve.
By combining local operational management with standardized
business practices, we drive greater operating efficiencies across
the company while maintaining day-to-day operational decisions at
the local level, closest to the customer.Our customers, including
small businesses, major corporations and municipalities, want a
partner with the expertise and capabilities to effectively manage
their multiple recycling and waste streams. They choose Republic
Services because we are committed to exceeding their expectations
and helping them achieve their sustainability goals. Our 41,000
team members understand that it's not just what we do that matters,
but how we do it.Our company values guide our daily actions:
- Safe: We protect the livelihoods of our colleagues and
communities.
- Committed to Serve: We go above and beyond to exceed our
customers' expectations.
- Environmentally Responsible:--We take action to improve our
environment.
- Driven: We deliver results in the right way.
- Human-Centered:--We respect the dignity and unique potential of
every person.We are proud of our high employee engagement score of
86. We have an inclusive and diverse culture where every voice
counts. In addition, our team positively impacted 4.6 million
people in 2023 through the Republic Services Charitable Foundation
and local community grants. These projects are designed to meet the
specific needs of the communities we serve, with a focus on
building sustainable neighborhoods. ----STRATEGYRepublic Services'
strategy is designed to generate profitable growth. Through
acquisitions and industry advancements, we safely and sustainably
manage our customers' multiple waste streams through a North
American footprint of vertically integrated assets. --We focus on
three areas of growth to meet the increasing needs of our
customers: recycling and waste, environmental solutions and
sustainability innovation.With our integrated approach,
strengthening our position in one area advances other areas of our
business. For example, as we grow volume in recycling and waste, we
collect additional material to bolster our circularity
capabilities. And as we expand environmental solutions, we drive
additional opportunities to provide these services to our existing
recycling and waste customers.Recycling and WasteWe continue to
expand our recycling and waste business footprint throughout North
America through organic growth and targeted acquisitions. The 13
million customers we serve and our more than 5 million pick-ups per
day provide us with a distinct advantage. We aggregate materials at
scale, unlocking new opportunities for advanced recycling. In
addition, we are cross-selling new products and services to better
meet our customers' specific needs.Environmental SolutionsOur
comprehensive environmental solutions capabilities help customers
safely manage their most technical waste streams. We are expanding
both our capabilities and our geographic footprint. We see strong
growth opportunities for our offerings, including PFAS remediation,
an increasing customer need.--SUSTAINABILITY INNOVATIONRepublic's
recent innovations to advance circularity and decarbonization
demonstrate our unique ability to leverage sustainability as a
platform for growth.The Republic Services Polymer Center is the
nation's first integrated plastics recycling facility. This
innovative site processes rigid plastics from our recycling
centers, producing recycled materials that promote true
bottle-to-bottle circularity. We also formed Blue Polymers, a joint
venture with Ravago, to develop facilities that will further
process plastic material from our Polymer Centers to help meet the
growing demand for sustainable packaging. We are building a network
of Polymer Centers and Blue Polymer facilities across North
America.We continue to advance decarbonization at our landfills. As
demand for renewable energy continues to grow, we have 70 landfill
gas-to-energy projects in operation and plan to expand our
portfolio to 115 projects by 2028.RECENT RECOGNITION
- Barron's 100 Most Sustainable Companies
- CDP Discloser
- Dow Jones Sustainability Indices
- Ethisphere's World's Most Ethical Companies
- Fortune World's Most Admired Companies
- Great Place to Work
- Sustainability Yearbook S&P GlobalPOSITION SUMMARY:--The
ETL Developer/Engineer III position within the Enterprise Data
group is responsible for developing, configuring, coding, testing
and debugging new software solutions. The ETL Developer/Engineer
III serves as a lead technical resource in the development and
delivery of data-oriented solutions to support critical business
needs.PRINCIPLE RESPONSIBILITIES:--
- Develops, tests and implements enterprise data
movement/migration (ETL and CDC) solutions
- Addresses system defects and implements enhancements to
existing functionality
- Complies with Company policy and practices relating to the
System Development Life Cycle
- Develops effort estimates for assigned application software
implementation activities
- 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.
- Maintains productive working relationships with project
sponsors and key systems users
- Mentors junior developers in development techniques and
standards
- Participates in the definition of application scope and
objectives through research and fact finding
- Reviews and approves code of other developers
- Troubleshoots issues with negligible guidance, identifies
bottlenecks in existing data workflows and provides solutions for a
scalable, defect-free application
- Works with data architects and staff engineers to develop data
designs and standards
- Works with onshore/offshore team to analyze, develop and
improve ETL run times as well as produce accurate defect free
code
- Provides Tier 3 support and resolution of open IT issues
escalated by IT Customer Support
- Supports production environment in the event of issues
- Provides performance tuning insight to project team and creates
reusable objects and templates
- Performs other job-related duties as assigned or
apparentQUALIFICATIONS:--
- 5 years of experience working with dimensional database
modeling and Slowly Changing Dimensions
- Experience in the design and development of ETL workflows
- Experience working with job scheduler and monitoring tools
- Experience working with relational database technology
- Experience with SQL scripting languages (SSIS, PL/SQL,
etc.)
- Experience with large enterprise-grade data warehouse
solutions
- Extensive experience working with Informatica
- Experience working with Change Data Capture (CDC)
technology
- Experience with large database implementations (Oracle, SQL
server, Teradata, IBM, etc.)
- Experience with Big Data solutions including Hadoop
- Experience with Predictive Analytics and Forecasting
- Strong analytical skills and focus on bottom-line results
- Conduct root cause analysis and performance tuning for complex
business processes and functionality
- Interact with IT and business users across the organization to
resolve issues and provide solutions in a timely mannerMINIMUM
QUALIFICATIONS:--
- Bachelor's degree in Computer Science, Engineering or
Statistics (willing to accept foreign education equivalent).
- Minimum of 6 years of experience in IT operations and support
performing ETL using the Informatica tool set.
- Minimum of 5 years of experience working on large data
initiatives (> 5 terabytes).
- Minimum 3 years of experience with at least three of the
following: Oracle, DB2, SQL Server, Teradata, IBM, and Informatica
modules (IDQ, PowerCenter, MDM, and ETL)
- Minimum 3 years of experience with at least two of the
following: SQLServer, Oracle, DB2, MySQL, MarkLogic, Denodo,
AWS
- Minimum 3 year of experience with at least 2 of the following
Informatica modules:
- PowerCenter
- CDC
- ETL workflows
- IDQ
- MDM Hub: Configuration, Validation rules
- IDD: Configuration, Validation rulesRewarding Compensation and
BenefitsEligible 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.--- Retirement plan
with a generous company match.--- Employee Stock Purchase Plan
(ESPP).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.EEO STATEMENT: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, relationship or association with a protected veteran
(spouses or other family members), genetic information, or any
other characteristic protected by applicable law.
Keywords: Disability Solutions, Chandler , ETL Developer III, IT / Software / Systems , Phoenix, Arizona
Didn't find what you're looking for? Search again!
Loading more jobs...