Informatica Subject Matter Expert with Federal Government Experience Job at Booker DiMaio, LLC, Columbia, MD

a0hLT0FnSkV2QnV3cVJyL2xyNFM5dmszaEE9PQ==
  • Booker DiMaio, LLC
  • Columbia, MD

Job Description

Experience with a federal government agency is mandatory.
Onsite in Columbia, MD
Multi-year engagement
US Citizenship or a Green Card is required

Position Overview

We are seeking an experienced Informatica Subject Matter Expert (SME) to support a federal client in designing, developing, and optimizing enterprise data integration solutions. This individual will serve as a technical leader, providing expertise across the Informatica platform while ensuring alignment with federal data standards, security requirements, and best practices.

The ideal candidate brings deep hands-on experience with Informatica tools, a strong understanding of data architecture, and prior experience supporting federal or government environments.

Key Responsibilities

  • Lead the design, development, and implementation of data integration solutions using Informatica (PowerCenter, IICS, or similar)
  • Serve as the primary SME for Informatica across multiple projects and stakeholders
  • Develop and optimize ETL/ELT workflows, mappings, and transformations
  • Provide guidance on data architecture, data governance, and data quality best practices
  • Collaborate with business analysts, data architects, and developers to translate requirements into scalable solutions
  • Troubleshoot and resolve complex data integration and performance issues
  • Ensure compliance with federal security, data handling, and regulatory requirements
  • Support system modernization and cloud migration efforts (as applicable)
  • Mentor junior developers and contribute to knowledge sharing across teams

Required Qualifications

  • Minimum 7+ years of experience with Informatica (PowerCenter, IICS, or related tools)
  • At least 2+ years of experience supporting federal government clients or projects
  • Strong expertise in ETL/ELT design, development, and performance tuning
  • Experience working with relational databases (Oracle, SQL Server, etc.)
  • Solid understanding of data warehousing concepts and data integration patterns
  • Experience with data quality, data governance, and metadata management
  • Strong problem-solving skills and ability to work independently in an onsite environment
  • Excellent communication skills with both technical and non-technical stakeholders

Preferred Qualifications

  • Experience with  Informatica Intelligent Cloud Services (IICS)or cloud-based data platforms
  • Familiarity with AWS, Azure, or other cloud environments
  • Experience with federal data standards, compliance frameworks, or secure environments
  • Prior experience supporting agencies such as DoD, DHS, HHS, or similar
  • Informatica certifications
  • Active or previous security clearance (nice to have)

Job Tags

Full time

Similar Jobs

The Chefs’ Warehouse

Sanitation Worker Job at The Chefs’ Warehouse

 ...and bathrooms and test kitchen, sweeping, vacuuming, and using a floor scrubber. What youll do: Use proper detergent and sanitizing chemicals following MSDS procedures. Ability to read labels for chemical identification. Maintenance include painting, pressure... 

Foot Locker

Leadership Recruiter Job at Foot Locker

Overview: The Executive Recruiter will partner and collaborate with Executives and Senior leaders to identify, hire and onboard senior-level talent into the organization. The Executive Recruiter will lead full-life cycle recruiting activities and proactively build relationships... 

Stream Realty

Junior Graphic Designer (Part-Time) Job at Stream Realty

 ...The Junior Graphic Designer will produce marketing materials to promote Streams property listings and other items in support of our sales professionals in the Dallas-Fort Worth market. We are looking for a dynamic individual who is experienced Adobe Creative Suite (InDesign... 

Little Hen

Hostess Job at Little Hen

 ...pastels, homely accents and luxurious touches. We need smiling, positive, skilled and hardworking individual to join our team. A hostesswho can ensure that our guests feel welcomed and valued from the moment they step through the door. Responsibilities: Greet... 

Stark Security Inc.

Unarmed Security Guard - Part Time #002SY Job at Stark Security Inc.

 ...Unarmed Security Guard (PT):~ Chicago, Illinois. ~ Part-time. ~$18 - $19 hourly. ~ Paid Uniforms. ~ Holiday Pay. ~ Retirement Program. STARK SECURITY INC. (***) ***-**** Ext 6. Position: Unarmed Security Guard. Job Description: FLSA Status...