ETL Data stage, Python, SQL, Snowflake/DBT preferred but we are okay to train, if they are ready to go for certification in 3 months on Snowflake.
- 5+ years of strong (8.5 out of 10) ETL experience on either DataStage, Informatica, Ab-Initio, Talend etc. (Datastage is preferred)
- Experience in designing solutions for multiple large data warehouses with a good understanding of cluster and parallel architecture as well as high-scale or distributed RDBMS
- Excellent Proficiency in SQL coding, Strong database fundamentals including SQL, performance and schema design. (8.5 out of 10)
- Should have hands-on experience in Python scripting. (7 out of 10)
- Ability to interpret/write custom shell scripts. (7 out of 10)
- Experience with AWS platform and Snowflake CDW platform big plus. DBT knowledge will be a big plus too.
- Experience with Git.
- To be able to work in a fast-paced agile development environment.
- Design, develop & implement ETL/ELT processes for Cloud Datawarehouse platform Snowflake
- Ability to understand legacy DataStage ETL components and rewrite them into SQLs and DBT (Data Build Tool) components
- Work closely with other data engineering teams to ensure alignment of methodologies and best practices