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