Data Analytics Engineer


Strategic Staffing Solutions

Data Analytics Engineer – ETL Informatica

Charlotte NC or Summit NJ- 2 days in office/3 days remote

12+ months

Seeking a data engineer who can assist with transitioning and building new process/enhancements of current state as well as development.

Will be responsible for the following on a daily basis

  • 60% of this role is initially assisting in the identification of process changes/enhancements and the documentation/requirement definition within the data engineering team.
  • Must have a strong background in data analytics delivery and data warehousing
  • Must be strong in SQL queries, stored procedures, query optimization and performance tuning
  • Data engineering background to include: analyzing current state, document the use of tools, primarily SSIS, adopt any ETL tool, create documentation, process and test.
  • Assessing current state/process and documenting current issues and willing to learn/adapt to other ETL tools outside of SSIS
  • Documentation and building of new technical documents based on review of trouble tickets
  • Must be able to help understand and define current state and ensure new enhancements as well as assist in implementing changes

Required experience:

  • 8+ years of data engineering experience within ETL/Informatica, SQL and SSIS
  • Strong background working within Agile
  • 8+ years of data management experience including data modeling, data integrity and data quality
  • 6+ years RDBMS such as SQL Server, Oracle or MySQL
  • 6+ years of experience writing relational database queries (SQL) for stored procedures, query optimization and performance tuning
  • 6+ years of experience with ETL Tools (SSIS)
  • 6+ years of experience with large data and analytic environments
  • 2+ years of experience with Agile practices
  • Experience with Autosys or other automation/scheduling tools

Job ID: JOB-225217
Publish Date: 25 Apr 2023

Tagged as: Data Analytics Engineer