Senior Etl Developer

TEKsystems•Pittsburgh, PA
•$60 - $65•Onsite

About The Position

The Senior ETL Developer will support a strategic Total Rewards initiative focused on improving data integration and reporting across Compensation, Benefits, Payroll, and HR systems. The role designs, develops, and maintains enterprise ETL solutions using Informatica PowerCenter to enable accurate, timely, and scalable movement of workforce and rewards-related data. The developer will work with business and technical stakeholders to translate requirements into reliable data integration solutions, support data quality and governance, optimize ETL performance, and provide production troubleshooting. This is a contract-to-hire role based onsite in Pittsburgh, Pennsylvania. Candidates must be authorized to work in the United States permanently without current or future sponsorship.

Requirements

  • Hands-on ETL development experience.
  • Expertise in data warehousing.
  • Experience or skills in data warehouse development, ETL development, Oracle, DB2, SQL, and Informatica.
  • Ability to work with business and technical stakeholders to deliver data integration solutions.
  • Must be authorized to work in the United States on a permanent basis without current or future sponsorship requirements.

Nice To Haves

  • Experience supporting HR, Payroll, Benefits, Compensation, or Total Rewards data initiatives.
  • Banking or Financial Services industry experience.
  • Experience integrating Workday HCM data.
  • Informatica Data Quality (IDQ) experience.
  • Experience with cloud data platforms such as Snowflake.
  • Familiarity with scheduling tools such as Control-M or Autosys.
  • Experience working in Agile/Scrum environments.
  • Exposure to workforce analytics and HR reporting solutions.

Responsibilities

  • Design, develop, test, and deploy ETL processes using Informatica PowerCenter.
  • Build and maintain data integration pipelines for Total Rewards, Payroll, Benefits, Compensation, and HR reporting.
  • Analyze business and technical requirements and translate them into ETL design specifications.
  • Develop complex mappings, workflows, sessions, and reusable ETL components.
  • Integrate data from Workday HCM, payroll platforms, benefits administration systems, enterprise data warehouses, and third-party vendor data sources.
  • Perform data validation, reconciliation, and error handling to ensure data integrity and accuracy.
  • Optimize ETL jobs and SQL queries for performance and scalability.
  • Collaborate with Data Architects, Business Analysts, Reporting Teams, and HR Technology partners.
  • Support data quality initiatives and compliance with data governance standards.
  • Troubleshoot ETL failures and production support issues.
  • Participate in Agile development activities, sprint planning, and code reviews.
  • Create and maintain technical documentation, including source-to-target mappings and process flows.

Benefits

  • Medical, dental, and vision coverage, if eligible.
  • Critical illness, accident, and hospital coverage, if eligible.
  • 401(k) retirement plan with pre-tax and Roth post-tax contributions, if eligible.
  • Voluntary life insurance and AD&D coverage for the employee and dependents, if eligible.
  • Short- and long-term disability coverage, if eligible.
  • Health Spending Account (HSA), if eligible.
  • Transportation benefits, if eligible.
  • Employee Assistance Program, if eligible.
  • Time off or leave, including PTO, vacation, or sick leave, if eligible. Compensation is $60.00–$65.00 per hour.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service