Java Snowflake Development

The Applications Development Senior Programmer Analyst position at our organization involves collaborating with the Technology team to establish and implement new or updated application systems and programs. Your primary goal in this role will be to contribute to applications systems analysis and programming activities. As an Applications Development Senior Programmer Analyst, your key responsibilities will include developing high-quality, scalable applications using Java and integrating them with Snowflake for efficient data processing and analytics. You will be tasked with building and optimizing ETL/ELT pipelines in Snowflake to ensure efficient data ingestion, transformation, and storage. Additionally, writing clean, maintainable, and efficient Java code while following best practices and coding standards will be essential. You will design and manage Snowflake schemas, tables, views, and stored procedures to support business applications. Integration of Java applications with Snowflake and other systems using APIs, JDBC, or Snowflake connectors will also be part of your responsibilities. Furthermore, optimizing Snowflake queries and Java application performance to handle large-scale data processing is a key aspect of this role. Collaboration with cross-functional teams, including data engineers, analysts, and business stakeholders, to deliver solutions aligned with business requirements will be crucial. You will be expected to debug and resolve issues in Java applications and Snowflake data workflows to ensure minimal downtime. Additionally, creating and maintaining technical documentation for code, data models, and system architecture will be necessary. The required qualifications for this role include having 8+ years of professional experience in software development, with a strong focus on Java and Snowflake. Proficiency in Java SE/EE, Spring Framework (Spring Boot, Spring MVC), RESTful APIs, microservices architecture, and multi-threading is essential. Familiarity with build tools like Maven or Gradle, version control systems like Git, and hands-on experience with the Snowflake cloud data platform are also required. Expertise in designing and optimizing Snowflake data models, writing complex SQL queries, and knowledge of Snowflake features like Snowpipe, tasks, and streams for real-time data processing is expected. Strong understanding of relational databases, data modeling, and performance optimization techniques is crucial. Strong analytical skills and excellent verbal and written communication skills are necessary to collaborate effectively with technical and non-technical stakeholders. This is a full-time position in the Applications Development job family within the Technology group. If you require a reasonable accommodation to use our search tools and/or apply for a career opportunity due to a disability, please review the Accessibility at Citi information. You can also view Citis EEO Policy Statement and the Know Your Rights poster for further details.,