This site uses cookies. To find out more, see our Cookies Policy

Let’s Connect Today!

NextGen Person

Data Integration Architect in St. Louis, MO at NextGen

Date Posted: 5/17/2019

Job Snapshot

Job Description

We are looking to augment our team with Data Platform Integration Admin - Consultant. This role will be responsible for our Cloud integration, maintain both On-Premise and SaaS platforms, and design/deployment of new components within the Business Intelligence/Data Science space. We are looking for a seasoned problem solver, who is not afraid to learn new technologies.

Overview

  • Support and Maintains On-Premise and SaaS based Data Platform
    • Off hour support and troubleshooting
    • Security and Application Patching
    • Capacity Planning
    • Performance and Operational Monitoring
  • Designs, Deploys and supports new components into the platform.
  • Key point on support of integration of Platform components to each other and Third-Party Data Sources
    • Determining Network Connectivity Requirements between platform endpoints
    • Develop and Deploy Security in accordance with Post Standards
    • Understand potential pitfalls of integrations and develop robust and supportable solutions to eliminate blockers
  • Ability to look at holistically at designing solutions or troubleshooting platform issues
  • All work must be solutioned, designed and build with perspective of best for Enterprise
  • Work collaboratively with Business, technical teams and resources in Post Operating Companies
  • Must be a problem solver with concern for building or applying the right solution
    • Some solutions require a Phased approach but eye must be on building a robust and supportable platform
  • Not afraid to become an expert or near expert in multiple applications and tools
    • Need to be able to understand the impacts and interactions of one tool with others.
  • Proactively looks to improve and secure the platform
  • Proactively looks to help other team members through
    • Automation
    • Process improvements
    • Taking advantage of tools they may not be aware are available to make their life easier

Experience Required

    • Understanding and support of cloud based SaaS platforms running in public clouds such as AWS and Azure
  • Windows Server & Linux Redhat
  • Although not expected to be windows admin you need to have an in-depth understanding of Windows and Linux Server OS
      • Should understand the use of the following platform tools
        • Linux Sudo
        • SSH, SCP, SFTP
        • Windows RDP
        • Symbolic Links
          • Linux
          • Windows
        • File Shares and UNC pathing
        • Linux Init and Windows Services
          • Troubleshooting
          • Stopping & starting
        • Tailing log files
        • Openssl
    • Scripting
      • PowerShell - is a must
      • Bash
      • Python
      • BAT
    • Authentication (Okta Preferred)
      • Federated Application integration with Identity Providers
        • SAML
        • OAuth
      • MFA
    • Troubleshooting
      • Proven ability to test and validate Network Connectivity from both windows and Linux
      • Proven ability to use application and OS logs to troubleshoot problems to root cause and remediation
      • TLS and SSL transport
        • SSL Handshake issues
        • Key and Certificate issues
      • Java and Java Application servers troubleshooting
  • Technologies
    • Good working knowledge of Tomcat Application Server
      • Secure installation and hardening
      • Configuration
      • Mod_JK (IIS)
      • Deployment as Windows Service
    • ETL platform (Informatica Intelligent Cloud Preferred)
      • Cloud Based
      • Support, securing and Troubleshooting of on-premise components
      • Basic understanding of ETL mappings and Orchestration of ETL
    • Data Visualization Platforms (Tableau Server preferred)
      • Support, securing and Troubleshooting
      • Ability to develop upgrade plans that minimize impact to users
      • Support development team in streamlining new report deployments
        • Scripting and Automation
    • Data Replication Platforms (Attunity Replicate preferred)
      • Support, securing and Troubleshooting
      • Basic understanding of Data Replication Approaches
        • CDC
    • Database platforms(Snowflake Preferred)
      • Cloud Based
      • Integration
        • Client Tools
        • Application Platforms
        • ETL
      • Securing
        • Transport
        • Authentication
        • Roles and Grants
      • General understanding of MPP Databases
    • Automation Scheduling (Automate Scheduler preferred)
      • Support, securing and Troubleshooting
      • Creating custom automation scripts or tools that can be run from schedule orchestrator
      • Protecting automation passwords
    • Database Connectivity
      • ODBC, JDBC, Native Drivers
      • Securing
      • troubleshooting
    • API Connectivity
      • SFTP, SCP File Downloads
      • Working understanding of Rest Api
        • JSON
        • XML
    • Working knowledge of Web technologies
      • HTML
      • JavaScript
      • HTTP protocol
      • Proxies
      • Web security

Expectations

  • Designs and Build Robust Platform
  • Creates and maintains platform technical and support documentation
  • Ability to multi-task and jump from one workstream to another as required
  • Philosophy needs to be "IT for Business Sake" not "IT for IT Sake"
  • Self-Directed and Self Learner
  • Willing to share knowledge with others

Additional Nice to Have's

  • Apache Web Server experience
    • Informatica Power Center experience
    • Postgresql database
    • Experience integrating with BOX
    • General Understanding of Machine Learning with Python
    • Docker and Kubernetes
    • Experience with Application development
      • .NET, Java, HTML5\JavaScript
  • Oracle Database Administration
  • Experience with Power BI

  • YELLOW = Nice to have but not required.