• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 7th Oct 2021

•          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.)

•          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 and/or Medical industry processing

•          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/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)