Data Pipeline Engineer (ETL/Data Migration) IRS Program
We re hiring a Data Pipeline Engineer to support the planning, development, and maintenance of ETL workflows and data pipelines for migrating legacy application data from MS SQL Server and Oracle into the Pega platform. In this role, you ll handle end-to-end migration activities including data assessment, source-to-target mapping, transformations, data cleansing, trial migrations, validation, reconciliation, cutover support, and post-migration issue resolution, aligned with IRS business rules and PGLD/RIM requirements. You ll partner closely with developers, testers, business stakeholders, and IRS teams to execute migrations in parallel with application development/testing, and you ll document migration strategies, mappings, scripts, and results.
Required Qualifications
- Active IRS MBI clearance
- Bachelor s degree
- 3+ years of relevant experience (data engineering, ETL, and/or data migration)
- U.S. Citizenship required
- Strong SQL skills and solid experience with relational databases
- Comfortable working in a deadline-driven contract environment
Preferred Skills / Tools
- Informatica (including Informatica S3 Connector)
- AWS / Cloud: AWS, AWS CLI
- CI/CD: CloudBees Jenkins
- Collaboration / version control: Jira, Confluence, GitLab
- Databases: PostgreSQL, Oracle, SQL Server
- Reporting/BI: Tableau
- Utilities: TOAD
- Linux
Never miss an opportunity! Create an alert based on the job you applied for.
