Cloud technologies (AWS data services, AWS Glue, AWS Lambda, Integration with Active directory, masking and encryption, Governance activities – Lineage, Catalog, classifications. Infrastructure setup in Snowflake)
Experienced with multiple data-ingestion methods for loading data to Snowflake: Snowpipe, Glue, Copy Into for large volume of data as well as incremental data handling
Sound knowledge of Snowflake Architecture, Design and Performance considerations
Data lake and Data Warehouse Design and optimization
ETL, Data Analysis, CDC
Technical understanding of digital / customer experience layers:Been Leading and built AWS cloud with Snowflake
Strong experience in designing and building DWH, Data lake ETL based applications with scalability and performance
Experience with CDC and metadata driven based processing
Have build DWH models
Hands on experience of architecting RDBMS and Snowflake databases – transactional as well as data-warehouse
Strong knowledge of data structures, analytical algorithms, and designing for performance
Good to understand the security and access controls on AWS
Nice to understand Agile and Devops methodology for cloud deployment.
What You'll Do
Implement integrations requested by customers
Deploy updates and fixes
Build tools to reduce occurrences of errors and improve customer experience
Develop software to integrate with internal back-end systems
Perform root cause analysis for production errors
Investigate and resolve technical issues
Develop scripts to automate visualization
Design procedures for system troubleshooting and maintenance
Expertise You'll Bring
At least 12-15 years’ experience in DW and Snowflake
Experienced software professional with minimum 5 years of experience in Snowflake
Working experience to work with finance industry
Work with cross functional teams including QA, Platform Delivery and DevOps
Not afraid of refactoring existing system and guiding the team about same.
Able to plan and deliver project deliverable on time with quality.
Good Communication skills
Innovative Thinking
Organization Commitment (hard working)
Customer Focus/Orientation
Able to communicate effectively with both technical and non-technical project stakeholders.