5 Transactsql Jobs

The Applications Development Intermediate Programmer Analyst position at our organization involves working at an intermediate level to assist in the development and implementation of new or updated application systems and programs in collaboration with the Technology team. Your main responsibility will be to contribute to application systems analysis and programming activities. You will be expected to utilize your knowledge of applications development procedures and concepts, as well as basic knowledge of other technical areas, to identify and define necessary system enhancements. This includes using script tools, analyzing code, and consulting with users, clients, and other technology groups to recommend programming solutions. Additionally, you will be involved in installing and supporting customer exposure systems and applying programming languages for design specifications. As an Applications Development Intermediate Programmer Analyst, you will also be responsible for analyzing applications to identify vulnerabilities and security issues, conducting testing and debugging, and serving as an advisor or coach to new or lower-level analysts. You should be able to identify problems, analyze information, and make evaluative judgments to recommend and implement solutions with a limited level of direct supervision. Furthermore, you will play a key role in resolving issues by selecting solutions based on your technical experience and guided by precedents. You will have the opportunity to exercise independence of judgment and autonomy, act as a subject matter expert to senior stakeholders and team members, and appropriately assess risk when making business decisions. To qualify for this role, you should have 4-8 years of relevant experience in the Financial Service industry, intermediate level experience in an Applications Development role, clear and concise written and verbal communication skills, problem-solving and decision-making abilities, and the capacity to work under pressure and manage deadlines or unexpected changes in expectations or requirements. A Bachelor's degree or equivalent experience is required for this position. In addition to the responsibilities outlined above, the ideal candidate should possess expertise in various technical areas, including strong JAVA programming skills, object-oriented programming, data structures, design patterns, Spark frameworks like flask and Django, Big Data technologies such as Pyspark and Hadoop ecosystem components, and REST web services. Experience in Spark performance tuning, PL SQL, SQL, Transact-SQL, data processing in different file types, UI frameworks, source code management tools like git, Agile methodology, and issue trackers like Jira is highly desirable. This job description offers a comprehensive overview of the role's responsibilities and qualifications. Please note that other job-related duties may be assigned as necessary. If you require a reasonable accommodation due to a disability to use our search tools or apply for a career opportunity, please review our Accessibility at Citi. For additional information, you can view Cit's EEO Policy Statement and the Know Your Rights poster.,

You will collaborate closely with the development team to develop, implement, and manage database models for core product development. Your responsibilities will include writing SQL views, tables, and stored procedures to support product engineering. You will also design and maintain SSIS, T-SQL, and SQL jobs, as well as develop complex stored procedures to load data into staging tables from OLTP and intermediary systems. Additionally, you will be responsible for database analysis, design, implementation, and maintenance, including designing partitioning strategies for archiving data. It will be crucial for you to ensure adherence to best practices for tools like SQL Server, SSIS, SSRS, and Excel Power Pivot/View/Map in data analytics. Furthermore, documenting complex processes, business requirements, and technical specifications will be an essential part of your role. As for the required technical skills, you should be proficient in database design, query design, and performance tuning. Expertise in complex Transact-SQL code, stored procedures, functions, views, and triggers will be necessary. You should also be skilled in indexes, query execution plans, and database migration. Strong analytical, multitasking, and problem-solving abilities will also be beneficial for this role. In summary, the ideal candidate for this position should possess a strong background in SQL, indexes, stored procedures, Transact-SQL, SQL Server, performance tuning, SSRS, data analytics, database design, SSIS, functions, triggers, query execution plans, query design, and database migration.,

As a SAP BTP Developer, you will be responsible for developing in SAP BTP technology, leveraging your experience in SAP HANA, CAPM, MTA, XSA, Cloud Foundry, NodeJS, Modelling, and SQL. Your main focus will be analyzing the business problems of the company and designing elegant solutions in the backend to support front-end developers and the reporting team. Ensuring the best performance, quality, and responsiveness of applications will be key in this role. Your duties and responsibilities will include gathering and analyzing new requirements, providing analysis and requirement capture throughout development project lifecycles, migrating applications from XSC on premise to BTP, developing microservices based applications, understanding customer business requirements, proposing solutions, supporting existing applications based on SLAs, producing internal progress reports, fixing technical issues, debugging, tuning, and optimizing programs for performance, maintaining adherence to internal quality requirements, staying updated on current technologies, and collaborating with the team using Agile methodologies. To qualify for this role, you should hold a Bachelor's Degree in IT or have equivalent experience, along with a minimum of 5 years of experience in SAP. You must have proven knowledge of SAP HANA, CAPM, MTA, XSA, Cloud Foundry, NodeJS, Modelling, and SQL, as well as experience using business application studio and VScode. Ability to quickly adapt to new technologies, propositions, and business areas is essential, along with excellent English communication skills, both verbal and written. Your skills should include working effectively with a team of technical resources, attention to detail, ability to work independently and collaboratively on multiple projects, willingness to grow, team player mentality, producing readable high-quality code, advanced experience in SAP CDS and SQL, expertise in Stored Procedures, Triggers, Functions, Creating Tables and Views using SQL, proficiency in Transact-SQL (DDL, DML, DCL) and in the Design and Normalization of database tables, experience in Performance Tuning and Stress Testing, good understanding of software product development lifecycle, value for reliability, simplicity, and robustness in system building, clear communication, active listening, and being a self-starter comfortable with taking on various roles.,

The Applications Development Senior Programmer Analyst plays a crucial role in establishing and implementing new or revised application systems and programs in coordination with the Technology team. Your main objective will be to contribute to applications systems analysis and programming activities. Your responsibilities will include conducting tasks related to feasibility studies, time and cost estimates, IT planning, risk technology, applications development, model development, and establishing and implementing new or revised applications systems and programs to meet specific business needs or user areas. You will also be responsible for monitoring and controlling all phases of the development process, including analysis, design, construction, testing, and implementation, as well as providing user and operational support on applications to business users. Additionally, you will utilize your in-depth specialty knowledge of applications development to analyze complex problems/issues, evaluate business and system processes, and industry standards, and make evaluative judgments. It will be essential for you to recommend and develop security measures in post-implementation analysis of business usage to ensure successful system design and functionality. Furthermore, you will consult with users/clients and other technology groups on issues, recommend advanced programming solutions, and install and assist customer exposure systems. You will also ensure that essential procedures are followed, help define operating standards and processes, and serve as an advisor or coach to new or lower-level analysts. You should be able to operate with a limited level of direct supervision, exercise independence of judgment and autonomy, and act as a subject matter expert to senior stakeholders and/or other team members. As an Applications Development Senior Programmer Analyst, you will be expected to assess risk appropriately when making business decisions, with particular consideration for the firm's reputation and the protection of Citigroup, its clients, and assets. This includes driving compliance with applicable laws, rules, and regulations, adhering to policies, applying sound ethical judgment regarding personal behavior, conduct, and business practices, and escalating, managing, and reporting control issues with transparency. Qualifications: - 6-10 years of relevant experience - Experience in systems analysis and programming of software applications - Experience in managing and implementing successful projects - Working knowledge of consulting/project management techniques/methods - Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements Education: - Bachelor's degree/University degree or equivalent experience In addition to the general responsibilities and qualifications mentioned above, the ideal candidate should have: - Strong programming skills in Python - Proficiency in Object-Oriented Programming and Data Structures - Good knowledge of design patterns - Experience with Python frameworks such as Flask and Django - Strong technical skills in Big Data technologies like Pyspark and the Hadoop ecosystem components (HDFS, Hbase, Hive, Pig) - Strong experience in Pyspark - Solid understanding of REST web services - Familiarity with Spark performance tuning and optimization techniques - Knowledge of databases including PL SQL, SQL, and Transact-SQL, with Oracle being a plus - Experience in processing data in various file types such as flat files, XML, Parquet, CSV, and data frames - Good exposure to UI frameworks and the ability to understand UI architecture - Proficiency in source code management tools like Git - Experience in Agile methodology - Familiarity with issue tracking tools like Jira This job description provides a high-level overview of the responsibilities and qualifications for the Applications Development Senior Programmer Analyst role. Please note that other job-related duties may be assigned as required.,

The Data Analytics Senior Programmer Analyst role at our organization involves active participation in the establishment and implementation of new or revised application systems and programs in collaboration with the Technology team. Your primary objective will be to contribute to applications systems analysis and programming activities. Your responsibilities will include utilizing your knowledge of applications development procedures and concepts, along with basic knowledge of other technical areas, to identify and define necessary system enhancements. This may involve using script tools, analyzing code, and consulting with users, clients, and other technology groups on issues to recommend programming solutions. Additionally, you will be responsible for installing and supporting customer exposure systems and applying fundamental knowledge of programming languages for design specifications. As a Data Analytics Senior Programmer Analyst, you will also be expected to analyze applications to identify vulnerabilities and security issues, conduct testing and debugging, and serve as an advisor or coach to new or lower-level analysts. You will play a key role in problem identification, information analysis, and making evaluative judgments to recommend and implement solutions. Your ability to operate with a limited level of direct supervision, exercise independence of judgment and autonomy, and act as a subject matter expert to senior stakeholders and/or other team members will be crucial in this role. Furthermore, you will need to appropriately assess risk when making business decisions, ensuring compliance with applicable laws, rules, and regulations, safeguarding the firm's reputation, and protecting Citigroup, its clients, and assets. This involves applying sound ethical judgment, escalating control issues with transparency, and managing reporting effectively. Qualifications: - 8-12 years of experience in Python programming - Strong knowledge of Object-oriented programming & Data Structures - Good understanding of design patterns - Experience with Python frameworks such as Flask and Django - Strong technical skills in Big data Pyspark & Hadoop ecosystem components (HDFS, Hbase, Hive, Pig) - Proficiency in Spark performance tuning and optimization techniques - Databases knowledge extending to PL/SQL, SQL, and Transact-SQL, with Oracle experience as a plus - Processing data in various file types including flat files, XML, Parquet, CSV, data frames, etc. - Strong knowledge of REST web services - Exposure to UI frameworks and understanding of UI architecture - Experience with source code management tools like Git - Familiarity with Agile methodology - Proficiency in issue tracking tools like Jira Education: - Bachelors degree/University degree or equivalent experience Please note that this job description offers a high-level overview of the typical work performed. Additional job-related duties may be assigned as required.,