Manage Informatica Pipelines in SQL Server and Oracle DB environments providing expert-level support and ensuring high availability and performance.
Responsibilities:
- Schedule and maintain various scripts for Informatica maintenance like backups update statistics for the Informatica repository regular recycles and removal of old logs.
- Informatica Server maintenance including trouble-shooting server issues and performance monitoring & tuning.
- Ensure all production ready scheduled processes are in place after monthly Windows Server updates
- Setup right connections to the right environments.
- Responsible for managing Informatica Services like the Repository Service and Integration Service.
- Responsible for importing all sources and targets.
- Extensively work with Repository Manager Designer Workflow Manager and Informatica Monitor.
- Apply Informatica PowerCenter software installation/upgrades and hot-fixes
- Maintain and support the servers the SAS application utilizes includes driver installation software patch upgrades and troubleshooting any issues reported from the user community.
- Keeping the quarterly address updates from USPS up to date on the Dataflux side
- Assisting users of SAS with integration of code between DEV/TST and production
- Assisting users of Dataflux with integration of code with Informatica Mappings
- Migrate code using various methods like folder copy deployment groups and XML files.
- Deployments to environments like TEST and PROD.
- Support to the ETL team of 10-12 developers
- Support the QA team of 4-6 testers
- Communicate often with DBAs and Network team
- Assist with design of mappings sessions mapplets worklets and workflows.
- Create and conduct formal internal training sessions for ETL developers
- Install and configure client components on users desktops
- Help conduct interviews for potentially new IT/ETL staff
- Responsible for creating and maintaining various documents like Mapping/Session naming standards Work assignments for reference and troubleshooting purposes
- Responsible for ensuring compliance with applicable laws regulations and company policies across areas of organizational responsibility
Qualifications :
- Bachelors Degree in IT or related field required.
- Five plus years related experience.
- Familiarity with data warehousing concepts and integration patterns.
- Strong troubleshooting and communication skills.
Remote Work :
No
Employment Type :
Full-time