Job Title : ETL Administrator
Duration : 12+ Months
Location : 100% Remote
Job Description:
Extensive experience with Informatica PowerCenter. Administration experience preferred.
Primary areas of focus in order of importance:
- PowerCenter with experience configuring various data sources (Oracle, SQL Server, Teradata, Power Exchange, etc.
- LDAP/Active Directory Security Model
- OS Profiles
- Power Exchange for VSAM
- Power Exchange CDC for Oracle
- Informatica Intelligent Cloud Services (IICS) Salesforce and MySQL
- Informatica Developer Tool
- Informatica Test Data Management
Nice to have
- Data Integration (Big Data Management/Edition), DVO, Informatica Analyst and Informatica Metadata Manager
- Extensive experience with Linux OS and shell scripting. Focus on automation is a plus.
- Experience with Oracle Databases. Other areas of focus could include SQL Server, Teradata, MySQL
- Ability to troubleshoot, identify, and correct issues within application code, the platform or general environment
- Solid oral and written communication skills
- Proven ability to multitask and prioritize
- Customer service skills
Experience that is nice to have:
- ITSM Working Experience (ServiceNow or Incident/Change Management)
- Automated Scheduling Experience (CA7 Preferred)
- Mainframe (z/OS) Experience
- Configuration of third-party ODBC connections within Informatica
- IBM's Connect: Direct (NDM) configuration and scripting knowledge
- Windows Server Administration/Automation
- SequeLink for MS Access/Excel data sources within Informatica PowerCenter
- Experience with API development/scripting