Informatica Administrator & ETL Ops Lead

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 recycling and removal of old logs.
• Informatica Server maintenance including troubleshooting server issues and performance monitoring & tuning.
• Ensure all production-ready scheduled processes are in place after monthly Windows Server updates
• Set up the right connections to the right environment.
• 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 including driver installation software patch upgrades and troubleshooting any issues reported from the user community.
• Assisting users of SAS with the integration of code between DEV / TST and production
• 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 the Network team
• Assist with the 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 :

Additional Information :

Shift timings : 8 AM to 5 PM EST (5 : 30 PM to 4 : 30 AM IST) ( 8 - 9 hours falling within an 11-hour coverage window to ensure business needs are met)

Remote Work : No

Employment Type : Full-time

Key Skills

SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle

Experience : years

Vacancy : 1