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
Bachelor s 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.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse Architect / ConsultantEmployement Type: Full time