Match score not available

ETL Informatica Consultant - DHS Experience required

unlimited holidays - extra holidays - extra parental leave - long remote period allowed
Remote: 
Full Remote
Salary: 
110 - 146K yearly
Experience: 
Senior (5-10 years)
Work from: 
United States

Offer summary

Qualifications:

Bachelor's Degree in Technology, Business, or related field and 6+ years of consulting or IT experience, Experience with Informatica tools such as Extract, Transform, Load (ETL) architecture.

Key responsabilities:

  • Maintain and administer data sources for the ETL environment
  • Collaborate with stakeholders on workload prioritization and expectations for deliverables
  • Document ETL workflows and update reports and dashboards with automated data sets
  • Monitor ETL environment health, troubleshoot, and perform corrective actions as needed
TAA Solutions, LLC logo
TAA Solutions, LLC Information Technology & Services TPE https://www.taasolutions.net/
2 - 10 Employees
See more TAA Solutions, LLC offers

Job description

US CITIZENSHIP IS REQUIRED

DoD or DHS EXPERIENCE REQUIRED

REMOTE POSITION

We are seeking an Informatica Developer who can support one of our DHS clients in the greater Washington, DC area. We are looking for a highly skilled individual to join our fast-growing small business and help lead delivery for our client by providing day-to-day consulting services and business analysis subject matter expertise in support of software implementation.

We are seeking candidates with a mix of technical and business experience in mission-oriented environments. Candidates will provide technical expertise with the Informatica suite of tools that are currently in implementation at ICE, and will utilize Informatica to integrate data utilizing the Extract, Transform, Load (ETL) architecture to move data from one source to another.

We are especially looking for candidates that have worked in DHS and have an active EOD/DHS clearance. US Immigration and Customs Enforcement (ICE) experience is a plus. This role will be responsible for supporting a wide range of project activities spanning business and technology environments.

Your future duties and responsibilities

  • Work with the Database Administrator (DBA) to maintain all relevant sources of data, ensure they are properly stored, maintained, monitored, backed- up, and recovered for the ETL environment.
  • Regularly report on the health and performance of the ETL environment and jobs and troubleshoot, debug, and perform corrective actions when needed.
  • Establish and assist with documenting direct data connections (or exports when direct data connection is not the agreed to solution) As new data sources are identified and needed to ensure data sets are available to update reports and dashboards on an automated basis.
  • Complete the loading of the data within the next business day after receiving the data.
  • Perform manual data loading onto the database as needed.
  • Assist with maintaining up-to-date documentation on ETL workflow using tools/software/applications approved by the government (i.e. Confluence).
  • Track, monitor, and update work received with ICE standard tools such as Jira.
  • Meet regularly with the stakeholders on prioritization of work including communicating expectations for deliverables.
  • Work with any support requirements as requested.
  • Provide a report on all activities as requested.
  • Demonstrate exceptional oral and written communication skills.
  • Commensurate experience in IT and in new and related older technology that directly relates to the required area of expertise.
  • Works independently or under general supervision.
  • Experience with Federal financials data a plus

Required qualifications to be successful in this role

  • Bachelor’s Degree in Technology, Business, or other related discipline AND 6+ years consulting or IT experience. Can substitute an Associates degree AND 9+ years of additional experience for Bachelor’s.
  • Exceptional interpersonal skills and proven experience supporting executive leadership and high-visibility project

Additional preferred qualifications

  • Experience working in a Federal environment, preferably DHS
  • Experience working at DHS ICE
  • Existing and active DHS EOD/clearance

Job Types: Contract, Full-time

Pay: $110,422.94 - $145,982.47 per year

Benefits:

  • 401(k)
  • Dental insurance
  • Health insurance

Experience level:

  • 6 years

Schedule:

  • 8 hour shift

Application Question(s):

  • Are you a U.S. Citizen?
  • Do you have DoD or DHS experience?
  • What is the salary you are looking for?

Education:

  • Bachelor's (Preferred)

Experience:

  • Informatica: 5 years (Preferred)

Work Location: Remote

Required profile

Experience

Level of experience: Senior (5-10 years)
Industry :
Information Technology & Services
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Social Skills

IT Consultant Related jobs