Informatica/ETL Administrator Consultant

Symantrix Inc
Fairfax, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Fairfax, United States of America

Tech stack

Confluence
Databases
Continuous Integration
Information Engineering
Data Governance
ETL
Data Mart
Data Warehousing
File Systems
Python
PostgreSQL
Microsoft SQL Server
Oracle Applications
Systems Development Life Cycle
Shell Script
Software Requirements Analysis
Systems Integration
Tableau
Snowflake
Informatica Cloud
Data Lake
Oracle Service Cloud
Tools for Reporting
REST
Software Version Control

Job description

The customer is seeking a talented Informatica/ETL Administrator Consultant. The person in this role works closely with clients to understand, install, configure, and making recommendations on best practices on Informatica Cloud (IDMC) and having Data Governance experience is a strong plus., Provide infrastructure and platform sizing for projects, including hardware and software requirements Configure secure agents and run time environments for IDMC/CDGC. Configure IICS security with SSO enablement and role management. Maintain detailed documentation in confluence up to date. Setup alert mechanism for long running processes and infrastructure related issues. Administer and support Infomatica code migrations and manage access and code migrations for enterprise data warehouse team. Experience with Implement/support multi node server installations and file system management. Work with teams to monitor, tune and optimize performance (system and application) Create best practice guides and work with development teams to implement them. Manage development, QA, User Acceptance Testing and product environments Participate in implementing application updates such as upgrades, patches, integrations and new releases.

Requirements

Experience with python programming for Data Engineering activities. Having knowledge on Python3 and usage of Data Engineering libraries. CI/CD and version control management experience. REST API integration experience in IDMC/CAI. Proficiency in Shell scripting. Knowledge in different databases like SQL Server, Oracle, PostgreSQL and Snowflake., Knowledge on Informatica DQ rules development, Catalog resources setup with different applications/Databases. Experience in working with Database administrators to troubleshoot any problems Experience in managing integrations with surrounding applications/systems. Understanding the concepts of Datawarehouse/Data Lake/Data Marts. Thorough knowledge of Systems Development Life Cycle (SDLC) and experience in working with release teams. Experience with reporting tools like Oracle analytics server and tableau is preferred. Tableau Prep knowledge is a plus for ETL activities.

Apply for this position