Senior Data Engineer (Informatica & AWS)

Reston, VA, US • Posted 22 hours ago • Updated 10 hours ago

Full Time

On-site

USD 110.00 per hour

PTR Global

Fitment

Dice Job Match Score™

🔗 Matching skills to job...

Job Details

Skills

Financial Software
Finance
Software Development
Collaboration
Apache Airflow
Data Quality
Data Engineering
Data Management
Migration
Cloud Computing
Data Processing
Data Warehouse
Docker
Unit Testing
Integration Testing
Test Cases
Conflict Resolution
Problem Solving
Communication
Sprint
UPS
Production Support
Computer Science
Database
Build Tools
Apache Maven
Gradle
Generative Artificial Intelligence (AI)
Agile
JIRA
Defect Management
Workflow Management
Informatica PowerCenter
Informatica
Amazon Web Services
Electronic Health Record (EHR)
Amazon S3
Amazon SQS
Python
SQL
Amazon Redshift
PostgreSQL
Oracle
Orchestration
CA Workload Automation AE
Continuous Integration
Continuous Delivery
Jenkins
GitLab
GitHub
UCD
User-centered Design
Extract
Transform
Load
Workflow
Testing
Data Validation
Performance Testing
Regression Testing
Alteryx
Terraform
Training

Summary

Position Title: Informatica Developer
Location: Reston, VA (Hybrid 4 Days)
Duration: 12+ Months with possible extension up to 24 Months

Job Description:

Develop and maintain financial software applications.
Work closely with the finance team to understand their needs and translate them into functional software.
Test software to ensure responsiveness and efficiency.
Identify, prioritize and execute tasks in the software development life cycle.
Collaborate with internal teams and vendors to fix and improve products. 8-10 years

Role Summary:

Client is seeking a highly skilled Informatica Developer to join client's Enterprise Data team.
This role is focused on supporting and enhancing Data Warehouse applications, with Informatica PowerCenter as the core ETL tool.
The ideal candidate will also have strong experience in AWS development, Python programming, and containerization using Docker.
Familiarity with orchestration tools like Autosys and MWAA (Managed Workflows for Apache Airflow) is expected.
This position requires participation in an on-call rotation for production support and strong experience in testing ETL workflows, data validation, and ensuring data quality across large-scale pipelines.

Minimum Required Experience:

7 plus years of experience in data engineering or ETL development, with deep expertise in Informatica PowerCenter.
Experience in Informatica Intelligent Data Management Cloud (IDMC).
Experience in PowerCenter to IDMC migration is a plus.
Proven experience in AWS cloud services, including EMR, ECS, Glue, Redshift, SNS, SQS, Lambda, CloudWatch, and S3.
Strong proficiency in Python for data processing and automation.
Experience supporting Data Warehouse environments and large-scale data pipelines.
Hands-on experience with Docker for containerized development and deployment.
Experience in testing ETL workflows, including unit testing, integration testing, regression testing, and data reconciliation.
Ability to design and execute test cases for data validation, performance testing, and error handling in ETL processes.
Excellent problem-solving skills and strong verbal & written communication.
Ability to work independently and collaboratively in a fast-paced environment.
Experience working in Agile development environments, including participation in sprint planning, daily stand-ups, and retrospectives.
Willingness to participate in on-call rotation for production support. 24/7 for 1 week per month

Desired Experience:

Bachelor's degree in computer science, Engineering, or related field.
Experience with Redshift, Postgres, Oracle databases.
Exposure to CI/CD tools like Jenkins, GitLab, and build tools such as Maven or Gradle.
Experience with GitHub Copilot or other GenAI tools (preferred).
Experience with Alteryx is a plus.
Experience contributing to Agile ceremonies and using tools like Jira for story tracking and defect management.
Experience with Redwood orchestration and workflow management is a plus.

Technical Skills:

ETL: Informatica PowerCenter, Informatica IDMC
AWS Services: EMR, ECS, Glue, Redshift, S3, SNS, SQS, Lambda, CloudWatch
Languages: Python, SQL (Redshift, Postgres, Oracle)
Orchestration: Autosys, Redwood (Plus)
CI/CD: Jenkins, GitLab, GitHub, UCD
Testing: ETL workflow testing, data validation, performance testing, regression testing
Other Tools: Alteryx (plus), Terraform

Note:

Reston only
Hybrid, 4 days onsite 1 day offsite
Max Rate is $110/hr to client, unless your Rate Card is set below that, in which case you must adhere to your Rate Card.

Pay Range: $75-80/hr. on W2

The specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.

#LI-LS1

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: ptrtx
Position Id: 174415
Posted 22 hours ago

Company Info

About PTR Global

Pinnacle Group is a leading provider of information technology and workforce solutions. Pinnacle Group includes Pinnacle Technical Resources, Inc., its flagship information technology staffing and consulting services provider; Pinnacle MSP, a managed services provider; Pinnacle Payrolling, a payrolling and independent contractor compliance provider; Pinnacle Canada, which provides staffing, MSP and payrolling services in Canada.

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.