Back to Job Search

Informatica ETL Developer

Posted almost 2 years ago

Terrific Long-Term Contract Opportunity with a FULL suite of benefits!

Come work for this industry leader in U.S. recycling and waste services to help provide reliable environmental services and solutions for millions of commercial, industrial, municipal and residential customers, together making the world a better place.

Position: Informatica ETL Developer
Location: Scottsdale, AZ 85260
Term: 6-month contract
Rate: $80+/hourly, DOE

POSITION SUMMARY: The Informatica ETL Developer position within the Enterprise Data group is responsible for developing, configuring, coding, testing and debugging new software solutions. The Informatica ETL Developer as a lead technical resource in the development and delivery of data-oriented solutions to support critical business needs.

ROLE:

  • 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.
  • 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
  • Works with onshore/offshore team to analyze, develop and improve ETL run times as well as produce accurate defect free code
  • 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 apparent


QUALIFICATIONS:

  • 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
  • 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 manner

 

​

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer including disability and veteran and provides reasonable accommodations for all qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual you may request a reasonable accommodation under the American Disability Act (ADA). If you are a person with a disability needing assistance applying, or at any point in the hiring process, please email us at MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.

For hourly W2 contract roles MATRIX offers a highly competitive benefit package including Medical, Dental, Vision, Life, Disability, HSA, and 401(k) with pre and post-tax options.  Please see MatrixRes.com/Benefits for more information.

For direct hire placement with our clients, benefits would be offered in accordance with that particular client’s offerings. This may include PTO, Medical, Dental, Vision, 401K and other pre and post-tax options.