MDM Informatica Engineer

Company: General Dynamics Information Technology
Location: Raleigh
Posted on: January 15, 2021

Job Description:

Type of Requisition:PipelineClearance Level Must Currently Possess:NoneClearance Level Must Be Able to Obtain:NoneSuitability:No Suitability RequiredPublic Trust/Other Required:OtherJob Family:Systems EngineeringJob 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 purposesThe 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#RalieghScheduled Weekly Hours:40Travel Required:NoneTelecommuting Options:Telecommuting Not AllowedWork Location:USA NC RaleighAdditional Work Locations:USA MO St. LouisWe 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.

Keywords: General Dynamics Information Technology, Raleigh , MDM Informatica Engineer, Engineering , Raleigh, North Carolina