Provide periodic on-call production support for on-premises and cloud environments, averaging 25% of weeks
Integration of new technologies and workflows
Work with Business and Data Analysts, Data Modelers, and potentially Business Customers, to verify requirements
Follow design documents involving source and destination databases
Interpret design documents to understand mapping and transformational requirements
Design, develop and test ETL/ELT processes using DBT/SQL/Python to move data to/from relational and star-schema based data structures
Optimize ETL/ELT processes to fit in a desired time frame
Build batch flows with an Enterprise Batch Scheduler (e.g. Automic)
10 or more years of experience in design, development, modification and testing of ETL processes
10 or more years of experience developing with SQL
10 or more years of experience building ETL processes using SQL/Python and/or ETL tool experience (such as DBT, Informatica, IBM InfoSphere, DataStage, Abenicio, Talend)
5 or more years of software development experience with Relational databases (i.e. Oracle, SQL Server, DB2, Vertica)
5 or more years of experience developing ETL processes against dimensional/star-schema based data structures including fact tables (commonly referred to as Kimball)
Experience developing and modifying ETL/ELT processes
Experience with MPP Databases (Snowflake, RedShift, etc.) - preferred
Experience with AWS Cloud Technologies
Experience with development in Python
Experience scheduling ETL processes
Experience with Cognos/Tableau business intelligence tools - preferred
Experience developing against normalized data structures (commonly referred to as Inmon)
Knowledge of property and casualty insurance systems and/or Medical industry processing - preferred
Experience using SQL development tools
Experience with Red Hat Enterprise Linux
Experience developing and modifying scripts in a Windows environment
Experience in measuring/tuning performance of batch systems in a Windows environment
Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, MS Teams)