Senior Tableau Developer - JD
8+ years-experience implementing ETL for Data Warehouse and Business Intelligence Solution
- 8+ years-experience in RDBMS design, development and performance tuning
- 4+ years-experience with ETL/ELT on AWS or other cloud environments with working experience on Redshift or Snowflake
- 2+ years-experience using Tableau
- Experience with MS SQL Server 2014 database technologies and ETL best practices with MS SQL Server environment
- Experience using Business Intelligence Development Studio to build SSIS packages
- Excellent troubleshooting & optimization skills: interpreting ETL logs, performing data validation, dissecting SSIS code, understanding the benefits and drawbacks of parallelism, experience with change data capture, using expressions, scoping of variables, commonly used transforms, event handlers and logging providers, ability to understand and optimize the surrogate key generation and inconsistent data type handling.
- Experience in performance tuning of the SSIS packages, deploying and administering SSIS packages, proficient in utilizing scripting in SSIS, and replacing ActiveX script tasks in DTS with the script task in SSIS.
- Experience with NoSQL databases such as Mongo DB
- Experience with data manipulation languages such as Python and R