Overall experience of 2 - 8 years

• Experience in AWS Cloud services & solutions

• Experience working with enterprise data warehouse

• Experience as an ETL/ELT Developer using various ETL/ELT tools

• Experience on SnowFlake

• Experience in SQL/NoSQL/DWH databases across SQL DB, Managed instance & Data warehouse

• Experience in AWS platform services such as S3, EMR, Glue, Kinesis, OpenSearch, Athena, QuickSight

• Experience in Apache Spark, PySpark

• Experience in creating data structures optimized for storage and various query patterns like Parquet

• Experience in working in an Agile SDLC methodology

• Experience in DevOps Services using Git Repos, deployment artifacts and release packages for Test & production environment

• Experience in building end-end scalable data solutions, from sourcing raw data, and transforming data to producing analytics reports

• Should have experience in developing a complete DWH ETL lifecycle

• Experience in Data Analysis, Data Modelling and Data Mart design

• Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. - using ETL tools.

• Experience in Data Integrator Scripts, workflows, Dataflow, Data stores, Transforms, and Functions.

• Should have worked on at least 2 end-to-end implementations

• Worked on Change Data Capture on both SOURCE and TARGET levels and a good understanding of Slowly changing Dimension (SCD)