Experienced in snowflake – Snowpark, SnowSQL, Database and Datawarehouse concepts
Extensive experience with complex SQL queries, performance tuning, and stored procs /functions
Perform ELT/ETL development involving complex data transformation, pivot tables, and complex calculators
Exposure to DBT, Airflow, Astronomer and Qlik
Experienced in Python programming language
Exposure to Agile development methodology and a great team player in scrum teams
Experience delivering, and supporting a Snowflake based data warehouse application in production is a plus
Assist the Investment Data Platform team in building various Data Marts sourced from Data Lakes. Familiarity with multiple cloud platforms is a plus, as source data could originate from AWS, Azure, or FIS cloud environments
Thoroughly test all programming work, and any changes introduced to the Production environment, ensuring Data Quality. Coordinate with Product Managers/QA and perform integration testing as needed
Provide production support by resolving technical or functional issues, in line with the procedures defined by FIS
Provide advice and guidance on data movement across platforms and environments
Create relevant documents around database objects and all development activities
implement innovative changes that improve dataflow and bring efficiency. These initiatives may be either requested or self-initiated as part of continuous improvement
The Developer should also keep his/her own skills up to date with the latest development software, platforms, and best practices
Knowledge of financial industry practices, regulations, and operations
Fluency in sequence diagrams, class models is a plus