Data Engineer jobs

Senior Informatica PowerCenter Migration Engineer

9th Way InsigniaWashington, DCHybrid

$98k–$120k/yr listed by the employer

Key facts

Experience
10+ years
Degree
Bachelor's degree
Clearance
Security clearance required

Looks real. 1 thing to check before you apply.

On 9th Way Insignia’s own careers site (Greenhouse), checked open today.

  • To check: Posted by the employer 2 months agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • Checked: On the company's own careers siteGreenhouse board
  • Checked: Checked open todayGreenhouse board
  • Checked: Pay listedJob posting
  • Checked: No reposts foundGreenhouse board
  • Trust score 95 / 100 · Strong
See all 6 checksShow fewer
How we check

What you’ll do

  • Assess Informatica PowerCenter workflows, repositories, dependencies, mappings, schedules, and operational procedures.
  • Configure and migrate PowerCenter workloads across development, test, UAT, and production environments in OCI.
  • Validate migrated data using repeatable reconciliation processes, investigate discrepancies, and resolve ETL defects and failures.
  • Tune ETL jobs and coordinate migration dependencies, cutover readiness, deployment, rollback, and post-implementation activities.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Licenses and certifications

  • OCI and/or Informatica certifications (preferred)

Experience

  • Minimum 10 years of hands-on experience administering, configuring, developing, and troubleshooting Informatica PowerCenter ETL workloads
  • Experience migrating or upgrading a large-scale ETL platform, including testing and data validation
  • Experience with Unix/Linux shell scripting and production ETL scheduling or operations
  • Experience developing test plans, executing data reconciliation, documenting results, and resolving ETL defects
  • Hands-on cloud implementation experience, including provisioning, configuration, or deployment activities
  • OCI experience (preferred)
  • Direct experience migrating Informatica PowerCenter from an on-premises environment to OCI or another enterprise cloud environment (preferred)
  • Experience with Oracle Database 19c and Oracle RAC (preferred)
  • Experience with Informatica Metadata Manager, data lineage, metadata repositories, and source-to-target mapping (preferred)
  • Experience with Oracle GoldenGate, enterprise data replication, or hybrid on-premises/cloud data-movement dependencies (preferred)
  • Experience with VA, VA Enterprise Cloud, federal programs, or other regulated enterprise environments (preferred)
  • Experience supporting ATO/A&A, POA&M, change control, or cloud operational-readiness activities (preferred)
  • Experience with high-volume data warehouses, automated validation, and performance optimization (preferred)

Education

  • Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Engineering, Mathematics, or another technical discipline; 8 years of additional relevant experience may be_sub=

Skills

  • Strong Oracle SQL and PL/SQL skills, including investigating and resolving source-to-target data discrepancies

Other requirements

  • Ability to obtain and maintain required VA suitability/access authorization
  • Must be authorized to work for any employer in the U.S.
  • Must be able to obtain and maintain the required security clearance

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Benefits

Health insurance
Medical insurance, Telehealth, FSA, and HSA
Dental & vision
Dental and vision insurance
Retirement plan
401(k)
Paid time off
PTO and paid holidays
Wellness & mental health
Employee Assistance Program (EAP)
Life & disability insurance
Voluntary Life Insurance and Basic Life A&D, Short-term disability (STD) and long-term disability (LTD)
Other
Traveling Assistance

Full job description

From 9th Way Insignia’s careers site

9th Way Insignia is a service-disabled, veteran-owned small business bringing transformative technology to our government customers so they can achieve their missions. Our specialties include cybersecurity, cloud modernization, software development, data analytics, enterprise architecture, enterprise IT, analytics, process automation, and artificial intelligence. Learn more about 9th Way Insignia at https://9thwayinsignia.com/.

Application password: Niner

Show full descriptionShow less

Team (Project) Introduction The Office of Performance Analysis and Integrity manages and enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW) which resides on one Oracle M8 Supercluster database and thirteen application servers.  Our team provides the technical services required to sustain EDW applications to include Project Management, Data Warehouse Management, Advanced Analytics, Tableau Server Administration/Tableau Desktop Administration, Technical Collaboration Support, Lessons Learned, Executive Orders and Special Projects, Architectural Enhancement, and Cloud Migration. We also provide management, enhancement, integration, implementation, maintenance, modernization, and infrastructure support for EDW applications as well as enhancement and maintenance of business intelligence capabilities and predictive analytics.

9th Way Insignia is looking for a Senior Informatica PowerCenter Migration Engineer to join and lead this team.

We are seeking a hands-on Senior Informatica PowerCenter Migration Engineer to support the migration of the VA Enterprise Data Warehouse (EDW) from an on-premises Oracle environment to Oracle Cloud Infrastructure (OCI) within the VA Enterprise Cloud environment. This role will be responsible for assessing, configuring, migrating, validating, and optimizing Informatica PowerCenter ETL workloads supporting a large, business-critical data warehouse. The successful candidate will bring practical experience configuring enterprise ETL environments, executing migration activities, validating large-scale data movement, and resolving production-grade ETL issues.

Responsibilities:

  • Assess existing Informatica PowerCenter ETL workflows, repositories, dependencies, source-to-target mappings, schedules, parameter files, and operational procedures.
  • Configure and support Informatica PowerCenter components in the OCI cloud environment.
  • Plan and execute migration of Informatica ETL processes across development, test, pre-production/UAT, and production environments.
  • Validate migrated ETL streams to confirm source-to-target requirements are fulfilled and data is not lost during the load process.
  • Develop and execute automated and repeatable data-reconciliation processes, including record counts, control totals, aggregate comparisons, exception reporting, and source-to-target validation.
  • Troubleshoot ETL failures, data discrepancies, performance bottlenecks, and connectivity issues.
  • Optimize and tune Informatica jobs to improve nightly-load performance and meet operational processing requirements.
  • Coordinate with Oracle database, GoldenGate, cloud infrastructure, networking, security, and EDW technical teams on migration dependencies and cutover readiness.
  • Support cloud setup, configuration, provisioning, account/privilege planning, migration readiness, deployment, rollback, and post-implementation activities.
  • Develop and maintain ETL design documentation, test plans, test-results reports, migration runbooks, restart/recovery procedures, and configuration-management artifacts.
  • Support defect tracking, root-cause analysis, change control, production-readiness reviews, and knowledge transfer.
  • Follow applicable VA security, architecture, configuration-management, and change-control processes.

Requirements:

  • Minimum 10 years of relevant experience in hands-on experience administering, configuring, developing, and troubleshooting Informatica PowerCenter ETL workloads.
  • Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Engineering, Mathematics, or other technical discipline. 8 years of additional relevant experience may be substituted for a degree consistent with position requirements.
  • Demonstrated experience migrating or upgrading a large-scale ETL platform, including execution of testing and data validation.
  • Strong Oracle SQL and PL/SQL skills, including the ability to investigate and resolve source-to-target data discrepancies.
  • Experience with Unix/Linux shell scripting and production ETL scheduling or operations.
  • Experience developing test plans, executing data reconciliation, documenting results, and resolving ETL defects.
  • Hands-on cloud implementation experience, including provisioning, configuration, or deployment activities; OCI experience is strongly preferred.
  • Strong written and verbal communication skills and the ability to work effectively with technical and non-technical stakeholders.
  • Ability to obtain and maintain required VA suitability/access authorization.
  • Must be authorized to work for any employer in the U.S.
  • Must be able to obtain and maintain the required security clearance.

Preferred Qualifications:

  • Direct experience migrating Informatica PowerCenter from an on-premises environment to OCI or another enterprise cloud environment.
  • Experience with Oracle Database 19c and Oracle RAC.
  • Experience with Informatica Metadata Manager, data lineage, metadata repositories, and source-to-target mapping.
  • Experience with Oracle GoldenGate, enterprise data replication, or hybrid on-premises/cloud data-movement dependencies.
  • Experience with VA, VA Enterprise Cloud, federal programs, or other regulated enterprise environments.
  • Experience supporting ATO/A&A, POA&M, change control, or cloud operational-readiness activities.
  • OCI and/or Informatica certifications.
  • Experience with high-volume data warehouses, automated validation, and performance optimization

Salary Range

$98,153.18—$120,000 USD

9th Way Insignia’s range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

Clearance/Background Investigation Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information.

Benefits Eligible employees will have access to our comprehensive benefits package which includes Medical, Dental, Vision, Voluntary Life Insurance, 401(k), Basic Life A&D, STD, LTD, PTO, Telehealth, paid holidays, FSA, HSA. Additional resources include our Employee Assistance Program (EAP) and Traveling Assistance.

Legal We’re an equal employment opportunity employer that empowers our people to fearlessly drive change – no matter their race, color, religion, sex (including pregnancy, childbirth, lactation, or related medical conditions), national origin, age, marital status, sexual orientation, gender identity, disability, veteran status, military or uniformed service member status, genetic information, or any other status protected by applicable federal, state, or local law.

Equal Employment Opportunity Notice Applicants have the right to be free from unlawful workplace discrimination. Please review the EEOC’s Know Your Rights: Workplace Discrimination is Illegal notice. Accessible formats and translations are also available from the EEOC.

Application Accommodations If you require a reasonable accommodation to complete this application or participate in the hiring process, please contact hr@insigniatechnology.com. Requests will be considered individually.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Senior SQL Data Engineer

OpenDataJobs · Washington, DC

$150k–$170k/yrFull-timeHybrid

StrongChecked open todayPosted 9 days ago

SQL Data Engineer

OpenDataJobs · Washington, DC

$120k–$140k/yrFull-timeHybrid

StrongChecked open todayPosted 9 days ago

Senior Analytics Engineer

BetterUp · Austin, TX +3 places

$158k–$220k/yrFull-timeHybrid

StrongChecked open todayPosted 1 month ago

See more like this