ETL Developer Sr

United Global Technologies
United States
2 days ago
Apply on www.wayup.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Working hours
Shift work
Job source

Tech stack

Application Programming Interfaces (APIs) User Authentication Unit Testing Batch Processing Continuous Integration Data Validation Information Engineering Extract Transform Load (ETL) Data Mining Data Warehousing Relational Databases Database Queries
+20 more
IBM InfoSphere DataStage JSON Job Scheduling Python (Programming Language) Cloud Services SQL Stored Procedures SQL Databases SQL Server Integration Services Talend Extensible Markup Language (XML) Data Logging Data Server Interface File Transfer Protocol (FTP) Informatica Powercenter Software Troubleshooting Git Enterprise Integration Restful APIs Pagination Data Pipelines

Job description

US Citizen or GC only that represents yourself Seeking a hands-on Developer Sr to support the Claimscore modernization project. This contractor will maintain legacy claims data integrations while building new Claimscore feeds that run in parallel. The role will transform, reconcile, and consolidate data from both platforms into existing enterprise data models, preserving continuity for downstream applications and reporting. Work will follow established architecture and guidance from technical leads., + Maintain and troubleshoot legacy ETL jobs, batch processes, files, and data interfaces.

  • Develop, test, and deploy new Claimscore data feeds using SQL, ETL tools, Python, APIs, and file-based integration methods.
  • Support parallel operation of legacy and Claimscore feeds without disrupting downstream systems.
  • Map and transform claims, provider, beneficiary, and related data into existing enterprise models.
  • Implement reconciliation, duplicate detection, data quality checks, logging, error handling, and monitoring.
  • Analyze source files, schemas, and existing transformation logic to address mapping gaps and data discrepancies.
  • Build or maintain REST API integrations, including authentication, JSON/XML processing, pagination, and retries.
  • Write SQL queries, stored procedures, and scripts to automate data extraction and transformation.
  • Perform unit and integration testing, validate source-to-target results, and resolve defects.
  • Document mappings, technical designs, job dependencies, and support procedures; assist with deployment and production support.
  • Collaborate with Developer Advisors, architects, business teams, and vendors to deliver assigned integrations.

Requirements

  • 3-5+ years of hands-on ETL, data engineering, or enterprise integration experience.
  • Strong SQL skills, including joins, stored procedures, transformations, and performance troubleshooting.
  • Experience with Python or a comparable scripting/programming language.
  • Experience consuming REST APIs and working with JSON/XML, relational databases, and flat files.
  • Experience with Informatica, SSIS, DataStage, Talend, or similar ETL technology.
  • Experience maintaining production batch/data pipelines, testing data quality, and reconciling multiple sources.
  • Understanding of data warehousing, source-to-target mappings, and relational data models.
  • Ability to complete assigned development work independently within established designs and standards., + Healthcare or Medicare claims data experience. Exposure to mainframe/legacy modernization and parallel-system transitions. Familiarity with enterprise job scheduling, SFTP, Git, CI/CD, and cloud data platforms. Expected Outcome

  • Keep legacy integrations stable while delivering accurate, supportable Claimscore feeds and consolidated data in existing enterprise models, with minimal impact to downstream consumers. Standard business hours and for those working within EST/CST time zones Monday through Friday. Typically 7am-6pm time range to ensure good working relationships and coordination of deliverables within a team setting

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.wayup.com
Prepare application

Good distractions

Loading talks and stories from around this role…