Source description
About the role
Role:Data Engineer/ETL Developer
Hybrid: 3 days per week onsite in Richmond, VA, 2 days remote Duration:12+ months
Requirements
ETL: experience with Informatica OR SSIS as a second option SQL: strong SQL experience with stored procedures, views, functions Python: experience with ETL, data transformations, pre-processing Data Warehousing: experience with Oracle, SQL Server database, or SQL Server warehouse SQL: stored procedures, views, functions ETL and data warehousing--sources are Oracle, SQL Server database, leveraging all relational SQL Server warehouse ETL is Informatica, Control M for scheduling Routing back-end data from source systems, pulling into staging areas, will have slowly changing dimensions as applications are migrated Largely maintenance, monitoring of pipelines, job schedules, but potential for new ETL work as the source systems migrate, reconfiguration of data pipelines, structured data changes, etc. Python for data pre-processing, not using any frameworks, just functional Python programming Using Tableau for reporting/visualization, nice to have but less important than the core SQL and ETL skillset
Must Have: SQL (stored procedures, views, functions, complex querying) Informatica Python Relational Database experience and warehousing concepts (SQL Server, Oracle)
Nice to Have: Tableau Control M
More at Thoughtwave Software and Solutions