Job Description :

IDA (Informatica Data Archival) Engineer

Location: Atlanta GA (Remote to start)

Duration: 1 year

The Data Archive Engineer will be part of a team that will be responsible for maturing client's capabilities around programmatically archiving and purging data, to align with security and privacy requirements as well as opportunities to optimize business processes and infrastructure usage by using Informatica Data Archival tool.

Manage the Platform Availability for Production and Lower environments for Informatica Data Archival (IDA)

Work with Build team to setup IDC platform for Lower and Production environment

Provide required support along with Build team to on-board applications data to IDC platform

Incident Management with respect to defects reported as part of Archival for the identified Business entities of the Application
Support Development teams in testing of the data in the staging area prior to Production Archival
Verify transactions are ready to Archive & move transactions out of Production Instance
Manage the reporting of the Application Life cycle Data from the Compliance Manager of IDA tool as per the defined Data Governance & Privacy standards
Assist in the Business Request on the Data Discovery process by executing run/copy/delete Data Visualization reports or applying user access per the defined process to Users
Assist in the execution of Data Masking queries as per the provided instructions from the Development team
Provide support in the setup of the Monitoring of the Business entities which are identified for Archival
Monthly Remediate application specific vulnerability
Create & maintain Knowledge Articles in ServiceNow
Triage with the product vendor team on the Application Software patches.
Work with application SMEs and business stakeholders to identify entities for archival and any dependencies to be considered when defining archive and purge rules
Configure Informatica ILM to connect to legacy application databases
Build retirement and reporting entities per requirements for each application database
Set up corporate retention rules, per the security and privacy policies and application retention rules, per the business requirements
Work with the application teams to create and manage schedule/calendar for archive and purge jobs, and work with those teams to execute the jobs
Create reports from Informatica ILM to provide visibility to application teams, business stakeholders, and executive leadership.
Play a supportive role working with the Infrastructure team for general Informatica ILM administration activities, including to ensure environments are maintained, software upgrades are completed as required, and ILM application issues/tickets get resolved.

Essential Skill Requirements:

  • Experience in Informatica Data Archival tool
  • Experience in building and managing IDA platform
  • Experience in building archival solution for large databases and file systems
  • Database Platform Experience: SQL, DB2, DB2 LUW and Oracle Databases
  • Database Scripting/Development: SQL, PL/SQL
  • Experience gathering/validating technical and functional requirements with customer, reviewing data/testing results with customer, data modeling or reverse engineering data models
  • Understand Dev and Test process E2E, BI/Data Analytics Experience

Desirable Requirements:

  • Bachelor of Engineering or Master of Computer Applications
  • Experience in Banking domain

Similar Jobs you may be interested in ..