Applications Development Senior Programmer Analyst - C12 - Pune

Key Responsibilities: ===================== **Technical Leadership & Architecture:** * Lead the design, development, and implementation of robust, scalable, and high-performance financial applications across the full development life cycle, from requirements analysis to deployment and ongoing support. * Define architectural patterns and best practices for Oracle-based solutions, Python microservices, and UI components, ensuring alignment with enterprise standards. * Drive technical decision-making and provide expert guidance on complex technical challenges. * Mentor and coach junior and mid-level developers, fostering a culture of technical excellence and continuous improvement. **Advanced Application Development:** * Develop and optimize solutions utilizing advanced Oracle SQL/PLSQL concepts,Snowflake, including performance tuning, database design, and large-scale data processing strategies. * Engineer sophisticated applications using Python or other enterprise application development technologies such as Java, focusing on modularity, scalability, and maintainability. * Lead the development of intuitive and responsive user interfaces using modern frameworks like Angular or ReactJS. * Contribute to projects involving Ab-Initio (ETL), Snowflake, and S3 Sonic Bucket integration, ensuring efficient data pipelines and storage solutions. **Cloud-Native & Data Platform Expertise:** * Design and implement cloud-native solutions leveraging various cloud technologies, with specific experience in containerization, OpenShift, and ECS migration strategies. * Utilize and integrate advanced data analytics platforms and tools such as Starburst and DataBricks to derive insights and build data-driven applications. * Drive the adoption of best practices for cloud deployments, monitoring, and security. **Team & Project Management:** * Manage project timelines, dependencies, and deliverables, ensuring successful project execution and on-time delivery. * Lead and coordinate efforts across multiple development teams (local, virtual/global), fostering effective collaboration and communication. * Act as a key liaison with business stakeholders, product owners, and other technology teams to gather requirements, manage expectations, and communicate progress. * Implement and improve team development processes to accelerate delivery, enhance quality, and reduce operational costs. **Operational Excellence & Tooling:** * Develop, modify, test, and migrate reports and applications using proprietary in-house tools like IFW, demonstrating strong command of its capabilities. * Support application builds, migrations, and continuous integration/continuous deployment (CI/CD) pipelines with new technologies and architectural patterns. * Actively participate in production support and troubleshoot complex issues, ensuring high availability and performance of critical systems. Knowledge/Experience: ===================== **Education:** Bachelor's degree in Computer Science, Engineering, or a related field. **Industry Experience:** 8+ years of progressive experience in software development, with at least 3+ years in a lead or architect role within financial reporting applications/warehouses. **Oracle Expertise:** * Advanced knowledge and hands-on experience with Oracle Database, including complex SQL/PLSQL, performance tuning, data modeling, partitioning, and advanced indexing strategies. * Experience with Oracle database administration concepts (e.g., RAC, Data Guard) is highly desirable. **Application Development:** * Expert-level proficiency in Python for application development, including experience with frameworks (e.g., Flask, Django) and data manipulation libraries. * Strong proficiency in at least one other major application development technology like Java (Spring Boot preferred). * Demonstrated experience in UI development with modern JavaScript frameworks such as Angular or ReactJS. **Cloud & Containerization:** * Extensive experience with cloud platforms (e.g., AWS, Azure, GCP) and cloud-native architectural patterns. * Proven experience with containerization technologies (Docker, Kubernetes) and orchestration platforms like OpenShift. * Direct experience with ECS migration projects is a significant advantage. **Data Platforms & Analytics:** * Hands-on experience with data warehousing solutions like Snowflake. * Proficiency in working with S3 Sonic Bucket for data storage and retrieval. * Exposure to and practical experience with data analytics tools such as Starburst and DataBricks. **In-House Tools:** * Prior working experience and deep knowledge of Citi's Inquiry Framework (IFW). * Experience with other Citi Financial systems (especially General Ledgers) is a significant plus. **Development Operations:** * Experience with CI/CD tools (Jenkins), version control (Bitbucket), and automated scheduling (Autosys). * Strong understanding of Unix Shell Scripting and Apache Spark. **Process Optimization:** Proven experience in process optimization related to SQL, ETL, and overall software development lifecycle. Skills: ======= **Technical Acumen:** * Exceptional command of advanced Oracle SQL and PL/SQL, including complex query optimization, stored procedures, functions, and database triggers. * Proficiency with multiple database concepts (RDBMS, OODB, ODS, Data Warehouse). * Hands-on expertise with Python, Snowflake, Ab-Initio, Autosys Scheduling, Bitbucket, Jenkins, RLM, Unix Shell Scripting, and Apache Spark. * Experience with data visualization tools like Tableau. * Exposure to GenAI tools for data intelligence and application enhancement. **Leadership & Management:** * Demonstrated ability to lead, motivate, and manage technical teams effectively. * Strong project management skills, capable of managing multiple concurrent projects and prioritizing tasks. * Excellent stakeholder management and communication skills, with the ability to articulate technical concepts to both technical and non-technical audiences. **Problem Solving & Innovation:** * Superior problem-solving and analytical capabilities, with a track record of resolving complex technical and architectural challenges. * Ability to quickly learn and adopt new technologies, frameworks, and methodologies. * Proactive approach to identifying areas for improvement and driving innovation within the team and across the organization. **Collaboration & Communication:** * Must be able to work independently with minimal supervision, as well as thrive in a collaborative team environment. * Exceptional verbal and written communication skills, capable of presenting to senior management and diverse teams. Competencies: ============= **Strategic Thinker:** Ability to think strategically and translate business requirements into technical solutions and architectural designs. **Leadership Presence:** Natural leader who can inspire and guide a team towards achieving common goals. **Adaptability:** Highly flexible and pragmatic, capable of adapting to a rapidly changing and fast-paced environment. **Results-Oriented:** Demonstrated ability to drive results, meet deadlines, and deliver high-quality solutions. **Interpersonal Skills:** Excellent communication and interpersonal skills, fostering strong relationships across all levels of the organization. \------------------------------------------------------ **Job Family Group:** --------------------- Technology \------------------------------------------------------ **Job Family:** --------------- Applications Development \------------------------------------------------------ **Time Type:** -------------- Full time \------------------------------------------------------ **Most Relevant Skills** ------------------------ Please see the requirements listed above. \------------------------------------------------------ **Other Relevant Skills** ------------------------- For complementary skills, please see above and/or contact the recruiter. \------------------------------------------------------ _Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law._ _If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review_ _[Accessibility at Citi](https://www.citigroup.com/citi/accessibility/application-accessibility.htm)._ _View Citi’s [EEO Policy Statement](https://www.citigroup.com/global/eeo-aa-policy) and the [Know Your Rights](https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf) poster._