Talent.com
TriOptus LLC
Informatica DeveloperTriOptus LLC • McLean, VA, United States
No longer accepting applications
Informatica Developer

Informatica Developer

TriOptus LLC • McLean, VA, United States
5 days ago
Job type
  • Full-time
Job description
Please find the Job Position Details;
Job ID: Heads Up

Client: Freddie Mac (175330-BH)

Position: Informatica Developer

Location:Mclean, VA (Onsite)

Duration: 6+ Months (with possible extension)

Job Description:

Job Summary

Freddie Mac is seeking an experienced Informatica Developer to support enterprise data integration and analytics initiatives within the organization. The role involves building and maintaining scalable ETL pipelines, integrating multiple data sources, and enabling reliable data delivery across enterprise data platforms.

The ideal candidate will have strong experience in Informatica development, SQL-based data transformations, and modern cloud data platforms including Snowflake and AWS.

Key Responsibilities
  • Design, develop, and maintain ETL workflows and mappings using Informatica PowerCenter or Informatica Intelligent Cloud Services.
  • Build and optimize data integration pipelines to process large volumes of structured and semi-structured data.
  • Develop complex SQL queries and stored procedures for data transformation and validation.
  • Integrate enterprise data sources including relational databases, NoSQL systems, and cloud data platforms.
  • Support data ingestion and transformation into cloud-based data warehouses such as Snowflake.
  • Work with AWS data services such as Amazon S3, AWS Glue, and Amazon Redshift where applicable.
  • Implement data validation, error handling, and monitoring processes to ensure high data quality.
  • Develop integrations with NoSQL databases such as MongoDB.
  • Collaborate with data engineers, analysts, and business stakeholders to deliver reliable data solutions.
  • Troubleshoot ETL failures and optimize job performance.
Required Skills
  • Strong hands-on experience with Informatica PowerCenter or Informatica Intelligent Cloud Services.
  • Solid experience in ETL design, development, and optimization.
  • Advanced proficiency in SQL and relational databases.
  • Experience integrating data with cloud data platforms such as Snowflake.
  • Experience working with AWS data ecosystem (S3, Glue, Redshift, Lambda).
  • Experience working with NoSQL databases such as MongoDB.
  • Strong understanding of data warehousing concepts and data modeling.
  • Experience troubleshooting and optimizing ETL workflows.
Preferred Skills
  • Experience with cloud-based ETL and data integration.
  • Familiarity with CI/CD pipelines for data workflows.
  • Knowledge of data governance and metadata management tools.
  • Experience in financial services or enterprise-scale data environments.
Qualifications
  • Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
  • 6-8+ years of experience in data integration, ETL development, and data warehousing.
  • Experience working in large enterprise data environments.
Create a job alert for this search

Informatica Developer • McLean, VA, United States

Similar jobs

Senior iOS Lead - Swift, Fintech, Onsite VA

Tek SpikesMcLean, VA, United States
Full-time

A technology firm in McLean, VA is seeking a Senior iOS Developer with over 8 years of experience.The candidate will lead the design and development of iOS applications, optimize performance, and c... Show more

 • Promoted

Travel CT Tech - $2,486 per week in Salisbury, MD

AlliedTravelCareersGermantown, Maryland, US
$2,486.00 weekly
Full-time

AlliedTravelCareers is working with FlexCare to find a qualified CT Tech in Salisbury, Maryland, 21801!.Certs & Licenses BLS, ARRT.Call-off Policy Log in to view.First Offer = Best Offer Guaran... Show more

 • Promoted

Senior Microsoft Developer - GPS Digital Engineering

Ernst & Young Advisory Services Sdn BhdMcLean, VA, United States
Full-time

A leading consulting firm is seeking a Microsoft Senior Developer in McLean, Virginia.The role involves collaborating with clients, designing user interfaces, and developing software solutions.Cand... Show more

 • Promoted

Online Remote Work

Online Consumer Panels AmericaFrederick, Maryland, US
$15.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

Hybrid Mobile Developer

RP Pro ServicesSpringfield, Virginia, United States
Full-time

RP Professional Services, LLC (RP) is a rapidly growing government consulting firm headquartered in Ashburn, Virginia.We're an 8(a), Service-Disabled Veteran-Owned Small Business (SDVOSB) that excl... Show more

 • Promoted

ICAM Analyst: Agile Modernization & Stakeholder Liaison

Redport IA, LLCGaithersburg, MD, United States
Full-time

A technology consulting firm is seeking a highly skilled ICAM Analyst for their Cyber Modernization project.The ideal candidate will have exceptional communication and organizational skills, famili... Show more

 • Promoted

Data Center Technical Operations Engineer I

TEKsystemsAdamstown, Maryland, United States
Full-time

The Data Center Technical Operations Engineer Facility will be responsible for Data Center Engineering Operations within an Amazon Data Center including risk management and mitigation corrective an... Show more

 • Promoted

Informatica IICS Developer

Visionary Innovative Technology Solutions LLCMcLean, VA, United States
Full-time

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Visionary Innovative Technology Solutions LLC.Recruitement Consulta... Show more

 • Promoted

Remote - Full Time - Senior ETL Informatica Developer position

Trigent SolutionsChantilly, VA, United States
Remote
Full-time

Position :Senior ETL Informatica DeveloperLocation :100% RemoteDuration :Full TimeClient :FederalMust have skills :An active MBI clearance with the IRS is required and considered mandatory.At least... Show more

 • Promoted

Applications Developer-Senior

Greenfield Data SolutionsGermantown, MD, US
Full-time

Designing, developing, testing, and maintaining custom Jira solutions Software development, particularly with Java, JavaScript Relational databases (SQL and SQL Managed Instance) Experience with ve... Show more

 • Promoted

Information Technology Tech I

Fairfax County GovernmentFairfax, Virginia, United States
Full-time

Use your IT technology skills to help protect and improve the lives of children, adults, and families in our community! This position works onsite and handle computer hardware inventory, provide sy... Show more

 • Promoted

Remote Product Support Online - $25-$45 per hour

GLOCPAClarksburg, Maryland
$25.00 hourly
Remote
Part-time +1

Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more

 • Promoted

PeopleSoft Application Developer

Booz Allen HamiltonMcLean, VA, United States
Full-time

Your growth matters to us - explore our career development opportunities.Connect with others in our people-first culture and enhance our collective ingenuity.Learn how we’ll support you as you purs... Show more

 • Promoted

Software Developer - TS/SCI with Polygraph Required

LMI Consulting, LLCMcLean, Virginia, United States
Full-time

Software Developer - TS/SCI with Polygraph Required.Salaried High Fringe/Full-Time.LMI is seeking a skilled Forward Deployed Engineer in the Washington, DC region to join one of our M&S customer de... Show more

 • Promoted

Lead Data Warehouse Architect Informatica PowerCenter

AristonTek Inc.Herndon, VA, United States
Full-time

A prominent data solutions company in Herndon, Virginia is seeking an experienced Data Architect.The ideal candidate will have over 12 years of experience in the Data Warehouse arena with at least ... Show more

 • Promoted

Landscape Bid Install Business Developer

BrightView Landscapes, LLCWoodbridge, VA, United States
Full-time

Back to Search Results Previous Opportunity Next Opportunity Landscape Bid Install Business Developer Location: Woodbridge, VA, United States Date Posted: Mar 16, 2026 Req number: JR12885 Job... Show more

 • Promoted

Software/Systems Integration Engineer (RHEL/Clearance)

JobotManassas, VA, United States
Permanent

This Jobot Job is hosted by: Scott Dennis.Are you a fit? Easy Apply now by clicking the "Apply" button and sending us your resume.Salary: $85,000 - $110,000 per year.Our company is seeking a dynami... Show more

 • Promoted

Application Developer

MANTECHChantilly, VA, US
Full-time

Responsibilities include but are not limited to:.Designing, programming/developing, and modifying software systems, applications, and tools, both existing and potentially new in the future.Analyzin... Show more

 • Promoted

Business Automation Developer

George Mason UniversityFairfax, Virginia, United States
Full-time

Not eligible for visa sponsorship.Salary commensurate with education and experience.The primary purpose of the unit is to provide fiscal services to the university, promote financial best practices... Show more

 • Promoted

Technology Modernization Analyst

ThinkTek LLCQuantico, Virginia, United States
Full-time

Technology Modernization Analyst.ThinkTek LLC is a fast-growing Certified SBA 8(a) and Service-Disabled Veteran-Owned Small Business (SDVOSB) company.We specialize in providing management and techn... Show more