Informatica Consultant Jobs

Botsford Associates is adding an Informatica Consultant/Engineer to assist our clients Capital Markets/Infrastructure Engineering, Middleware and BI Teams. The client is embarking on a slight move on-prem Informatica Power Center (IFPC 10.2 & 9.0) and are moving several functionalities to Intelligent Data Management Cloud (IDMC).

IDMC allows the client to utilize this cloud-based data management platform which is offered by Informatica as IDMC has various tools and services to manage data across sources as well as targets. This would be including on-premises systems, cloud-based systems and big data platforms.

Daily Responsibilities:

• You will develop automation scripts for Informatica security hardening and infrastructure management if required.
• You will adopt to Agile methodologies for projects deliverables and day to day activities
• Design and deploy Informatica secure agent and provide diagrams to illustrate the infrastructure plans.
• Provide operational support for incidents related to Informatica infrastructure, workflows and application performance on legacy platforms
• You will collaborate with multiple teams to provide Engineering support and to document the administrative tasks, best practices and any process level changes
• You will plan the capacity and disaster recovery for Informatica Platforms.
• You will plan and build the roadmap for the future Informatica platform, perform POC on new Informatica Products and suggest improvements.
• Ad Hoc requests as requested by Management, BAU, Operational Support that can come in as a specialized resource to assist during escalated production issues
• Provide technical design and guides for Informatica upgrade, patching, workflow migration and service continuity.
• Researching other tools to replace Informatica (DataStage for example)
• Adopt Agile methodologies for projects deliverables and day to day activities

Must Haves:

• Strong understanding of Unix/Linux Operating Systems: Red Hat Enterprise Linux
• 10+ years of experience in Infrastructure / Engineering
• Troubleshooting
• Automation scripting/Shell Scripting/Bash Scripting
• Creating both building as well as design documentations, test plans, test cases, etc.
• Ideally building with Informatica Infrastructure but if not could be DataStage, Talend, Microsoft Data Factory / Data Bricks, SaaS or ETL / BI related)
• Utilizing Ansible Tower
• If not any has to have experience building out Unix / Linux in clustered environment s
• Building out resiliencies

Nice to Haves:

• Linux Admin background
• Needs to understand the architecture of this environment
• Strong understanding of Windows Operating Systems: Windows Server
• Background in Architectural Design
• Banking/Financial/Capital Markets experience
• Client is on Informatica Power Center 10.2 & 9.0
• 9.x,10.x are also sufficient
• 1-2 years with IDMC: Informatica Data Management Cloud
• SSL Certificate
• Oracle Databases
• Develop automation scripts to migrate Informatica workflows from on prem to cloud
• Experience in Disaster Recovery Planning
• Experience with Bug Fixes
• Informatica migration experience
• Cloud experience (preferably Azure)
• Cobalt Scripting
• Solaris