MDM Informatica Engineer at General Dynamics Information Technology in Raleigh, North Carolina

Job Description:

Type of Requisition:

Pipeline

Clearance Level Must Currently Possess:

None

Clearance Level Must Be Able to Obtain:

None

Suitability:

No Suitability Required

Public Trust/Other Required:

Other

Job Family:

Systems Engineering

Job Description:

GDIT is looking for an Informatica Developer to join our team supporting the United States Postal Service (USPS) in St. Louis, MO or Raleigh, NC.

Please note: This position is a pipeline requisition and not fully funded by the customer; this may result in delayed responses from the GDIT recruiting team.

Thank you for your interest and we encourage you to continue applying for positions you are interested in at GDIT.

The MDM tool works by:

• Performing ETL from staging tables (which are populated by the DQ tool) to base object tables, bases on the configured columns for each attribute


• Performing match and merge rules on various criteria to join the systems and establish single unique golden record for each row of data


• Apply various trust rules, per system, in order to accept best version of truth for each attribute that contributes to the golden record


• Has the ability to identify exceptions, apply match and merge rules automatically, and queue records for manual review


• Ability to create a full view of golden records and has API abilities to access the golden records.


• Scheduling the above listed tasks for automation purposes

The security clearance for this program requires the selected candidate to have resided in the US for the past five years. The selected candidate cannot have left the country for longer than 90 consecutive days and no more than 180 cumulative days.

Required:

• Ten (10) years or more of experience


• Bachelor's Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience


• Experience with Red Hat Linux and Informatica product(s)


• Strong database experience in any or all: Oracle, SQL Server, Teradata, DB2


• Strong in Informatica ETL coding, shell scripting and have Linux/Red Hat experience


• Exposure in installing Informatica or other off the shelf products


• Ability to research tool and platform related problems and document/articulate appropriate resolutions


• Perform operational administrative functions including supporting


• Perform job related tasks in support of primary duties including submission of Change requests, follow up procedures to open up ports, and verify database connectivity, etc. 

Preferred:   

• Experience in any or all of the following is a plus:
  
  
  • Spark
  
  
  • Map Reduce
  
  
  • Hive
  
  
  • Scala
  
  
  • Cassandra
  
  
  • Other open source technologies
  
  
  
  

#USPSTSS

#OPPORTUNITYOWNED

#GDITCAREERS

#WEAREGDIT

#GDITLIFE

#Informatica

#stlouis

#Raliegh

Scheduled Weekly Hours:

40

Travel Required:

None

Telecommuting Options:

Telecommuting Not Allowed

Work Location:

USA NC Raleigh

Additional Work Locations:

USA MO St. Louis

We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.

Apply Now