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 :- 14th Sep 2021
Complete Description:
BWC 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)