Job Description :
Position Title: ETL Data Warehouse 
Location: Columbus, OH (Onsite)
Interview Process: Phone and Skype 
Visa: Any visa would work but no H1B 
Duration: 6+ Months 


Our Client is looking for an ETL Technical Specialist 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.

 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)

Client : ADITYA


Similar Jobs you may be interested in ..