Informatica Administrator & ETL Ops Lead
Share
Job Location:
Monthly Salary:
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
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 :
- Bachelors Degree in IT or related field required.
- 5 years of relevant experience
- Hands-on experience with Informatica PowerCenter and PowerExchange.
- Familiarity with both Windows and Linux environments including making basic to advanced configuration changes.
- Strong troubleshooting and analytical skills for resolving ETL and integration issues.
- Familiarity with data warehousing concepts and integration patterns.
- Overall good hands-on experience in managing and troubleshooting the Informatica environment with a recent assignment as an Informatica Administrator.
- Excellent documentation and communication skills.
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
About Company
BETSOL is a cloud-first digital transformation and data management company offering products and IT services to enterprises in over 40 countries. BETSOL team holds several engineering patents, is recognized with industry awards, and BETSOL maintains a net promoter score that is 2x the ... View more
