ETL Developer - Columbus, OH

Company: Comtech Global Inc
Your Application: You have not applied yet
Location: Columbus, OH, USA

Role: ETL Developer 

Location: Columbus, OH

Is your candidate local to Columbus, OH? If not, can they relocate by day 1 of the assignment?


If outside of Columbus, will your candidate be able to relocate by day 1 of assignment?


Short Description:

TS3 - ETL Position


Complete Description:

Client is looking for a TS3 to support implementing a Data Lake, Operational Data Store and Data Marts for Business Reporting. Data sources will include a variety of Relational Databases and Semi-structured data. Both ETL and ELT jobs will be designed, developed and tested to move data from these sources into the analytical database Snowflake. These jobs will be built with a combination of technologies (Python, SQL, and DBT). Experience with Snowflake and DBT is a plus but not required.


The positions would be for the rest of the FY with possible continuation into FY23. (expectation if for 2+ years of engagement).


 During a given day, this position will be expected to:

• Work with Business Analysts 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


Mandatory Skills:

• 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, Pentaho, Informatica, IBM InfoSphere, DataStage, Talend)

• 5 or more years of software development experience with Relational databases (i.e. Oracle, SQL Server, DB2)

• 5 or more years of experience developing ETL processes against dimensional/star-schema based data structures including fact tables (commonly referred to as Kimball)


Desired Skills

• Experience developing and modifying ETL/ELT processes

• Experience with MPP Databases (Snowflake, RedShift, etc.)

• Experience with AWS Cloud Technologies

• Experience with development in Python

• Experience scheduling ETL processes

• Experience with Cognos/Tableau business intelligence tools

• Experience developing against normalized data structures (commonly referred to as Inmon)

• Knowledge of property and casualty insurance systems

• Knowledge of Ohio business model and processes

• Experience using SQL Development Tools

• Experience with Red Hat Enterprise Linux

• Experience developing and modifying scripts in a Windows environment

• Experience in measuring and tuning the performance of batch systems in a Windows environment

• Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, MS Teams)


Work Day: Full Time
Employment type: Permanent Job
Salary: Negotiable

Minimal experience: No experience

Jobs you may be interested in

    Tips You May Be Interested In