802 Db2 Jobs - Page 9

Job Description Role: - Mid Senior Level- UAT & Life Asia Work location:- Aviva India (HO) 401A, 4th Floor, Dlf Cyber Park, Phase II, Block A, Sector 20, Gurugram, Haryana 122002 HR Spoc:- https://www.linkedin.com/in/aryan-raj-76247175/ Shift:- General (Mon-Fri, 09:30 to 6PM*) Employment type:- Permanent Company On-roll (Aviva India) Skills/ Knowledge: Good Knowledge of Life Insurance concepts, Products & LifeAsia or Ingenium, OPUS, NGIN, BANCS, Group Asia (Required) Expertise/Intermediate level of working on excel (Required) Worked at BA/Tester (Required) Basic/Intermediate knowledge of SQL/Oracle (Required) Understands SDLC & other IT terminology (Required) Prior experience of Production Support (Required) Stakeholder Management (Good to have) Any certification in Life Insurance (Good to have) Ability to establish credibility and trust with all stakeholders Excellent Stakeholder Management Strong communication skills across all levels Multi-Tasking ability Problem solving ability Eligibility Criteria: Graduate or above with 2 to 7 years work experience in Group Asia, Life Asia & UAT testing About Company: - Aviva plc is a 'British multinational insurance company' headquartered in London, England. It has about 18 million customers across its core markets of the United Kingdom, Ireland and Canada. And Aviva India, a subsidiary of the global Aviva group, is a dynamic and growing player in the Indian insurance market. We offer diverse insurance and financial solutions, emphasize innovation, and prioritize sustainability. What working at Aviva offers We offer a competitive compensation package where youll be rewarded based on your performance and recognized for the value you bring to our business. We also offer you: Support, coaching and feedback from some of the most engaging colleagues around Opportunities to develop new skills and progress your career The freedom and flexibility to handle your role in a way thats right for you Why Aviva Dynamic and collaborative team in a supportive and innovative work environment. Opportunities for professional growth and development. Competitive compensation and benefits package. Be a part of shaping the future of insurance in India Wikipedia link: - https://en.wikipedia.org/wiki/Aviva Aviva Fortune 500 Company:- https://fortune.com/company/aviva/global500/ Website: - https://www.avivaindia.com/ HR Spoc LinkedIn: - https://www.linkedin.com/in/aryan-raj-76247175/ Head office: - Aviva India (HO) 401A, 4th Floor, Dlf Cyber Park, Phase II, Block A, Sector 20, Gurugram, Haryana 122002

Skills : PL1 , IMS, COBOL, CICS, JCL, DB2,VSAM. Hands on development in PL1 is mandatory. IMS is preferred. Strong analytical skills and hands on development experience in above areas. Good communication skills

As a Lead Software Engineer at JPMorgan Chase within the Consumer Community Banking/Firmwide Core Deposits team you are part of an agile team that works to enhance, design, and deliver the software components of the firm s state-of-the-art technology products in a secure, stable, and scalable way. As an emerging member of a software engineering team, you execute software solutions through the design, development, and technical troubleshooting of multiple components within a technical product, application, or system, while gaining the skills and experience needed to grow within your role. Job responsibilities Lead and contribute to the development of server-side applications using Java and Spring Design and envelop scalable architecture, ensuring performance efficiency, and resiliency. Implement message and command driven framework, with a preference for Kafka Develop and execute automated testing strategies, including end-to-end testing. Collaborate effectively within an agile team setting and communicating with key stakeholders. Provide devOps production support to ensure application stability and address business queries. Mentor junior developers and drive design and code review sessions. Adds to team culture of diversity, equity, inclusion, and respect. Required qualifications, capabilities, and skills Formal training or certification on software engineering concepts and 5+ years applied experience Hands-on practical experience in system design, application development, testing, and operational stability Proficient in coding in one or more languages. Experience in Java/J2EE, Spring Boot Overall knowledge of the Software Development Lifecycle Solid understanding of Agile methodologies such as CI/CD, Application Resiliency, and Security Demonstrated knowledge of software applications and technical processes within a technical discipline (eg, cloud, artificial intelligence, machine learning, mobile, etc) Preferred qualifications, capabilities, and skills Familiarity with DB2, JCL, IBM WebSphere MQ messaging solution. Experience with Cloud (AWS) Experience with Application security, performance engineering, and integrations Familiar with (Python, Kafka, Maven, Git, RDBMS, and Docker/Kubernetes)

Key Mainframe technologies: Zos, COBOL, DB2, JCL, VSAM, CICS (must) Supporting tools like REXX, Endevor, SPUFI, File Manager, IDCAMS Minimum basic knowledge on, MQ, R2DS, GSI + Integrations pattern Experience in FSA technologies, particularly, Strong in Mainframe technology and also have atleast basic knowledge on Mule Soft, Cloud and SOA architecture, Mongo. Experience in implementing integration patterns. Basic understanding of JAVA technologies is an added advantage. Roles and Responsibilities: Understanding program strategy and ability to provide solutions to deliver that strategy. Excellent communication skills with ability to explain solutions and technical concepts to stake holders. Self-organized and self-starter to appropriately prioritize and plan his complex work in a rapidly changing environment. Results oriented with strong conceptual and analytical skill and problem solving aptitude. Team player with experience collaborating cross-team to ensure successful delivery of solutions. Keep the knowledge updated with the evolving technology and the organizational strategies. Gaining good knowledge quickly on various distributed systems globally while working on various projects. Work with stakeholders globally during different time zones depending on the project needs.

Tax Operations has the primary responsibility of calculating withholding and Tax liability for the clients across all business units in the firm. Additionally the team also handles client documentation and regulatory information reporting. Sedona is a high volume transaction processing application that centralizes the Tax logic and is responsible for calculating withholding tax in real time, in addition to facilitating the timely reporting of the millions of transactions to the various tax authorities, globally. Requirements Design and architecture systems for Tax functions (including client documentation, reporting and tax withholding) with high scalability, high throughput, and large amounts of data Contribute to the technical design of the strategic engine by evaluating and employing Distributed Caching implementations for Multi-threaded and Concurrent Highly-Scalable processing. Complex Matching Algorithms for highly flexible, optimized and extremely fast matching Organizations enterprise platforms including Forms Engine and Data Lake Design and Implement user workflows using BPMN notation Manage project deliverables and tasks during development, user acceptance (UAT) and production implementation phases Manage user requirements, testing cycles and perform change management duties Develop highly scalable, resilient distributed systems using service oriented paradigms Perform memory, thread and CPU profiling of all core features for high volume processing and preform process analysis using JProfiler and VisualVM, jMap, jStack, jConsole Manage regulatory deliverables within a fast changing environment Work closely with the global counterparts (both technology user teams) and other technology communities in the firm as part of team charged with managing global tax requirements for GS clients Qualifications: 3+ years of Java development 1+ years of service oriented architecture development Knowledge of Web UI technologies like React and Angular Familiarity with Spring Frameworks Strong skill in databases like DB2, Sybase IQ, MongoDB Knowledge of BPMN modelling and designing 1+ years of experience implementing systems with automated testing using junit, fitnesse, karate, etc Preferred Experience in Financial Services/Industry Messaging related technologies such as JMS, Apache Kafka

Strong Mainframe Development Experience with Mainframe IMS CICS , COBOL, JCL/Proc, VSAM, DB2, Experience of setting up test data for mainframe applications, executing batches, triaging defects, applying fixes. Experience of creating batch schedules Experience of creating integrations Experience of creating Batch Schedules in Control-M Experience of creating Integrations in MIA Dell-Boomi Experience of testing/debugging tools including Abend-aid and Expediter. Experience of database viewing tools including Datavantage and Fileaid/FileaidDB2 Knowledge of Jira/ Agile Knowledge of Changeman as a source control Experience of creating Batch Schedules in Control-M Experience of creating Integrations in MIA Dell-Boomi 1. Serve as an expert on applications and provide technical support 2. Excellent problem solving and analytical skills. 3. Ability to execute methodically while also thinking strategically.

We are looking forward to hire DB2 Professionals in the following areas : Experience required: 5-7 years Database performance issue troubleshooting, RCA and related monitoring. System replication setup and troubleshooting Routine admin tasks like, data volume space mgmt, license mgmt, Database start/stop. DB backup restore Good to have knowledge on either of the below DB technologies MS SQL Server / DB2 / Oracle Our Hyperlearning workplace is grounded upon four principles Flexible work arrangements, Free spirit, and emotional positivity Agile self-determination, trust, transparency, and open collaboration All Support needed for the realization of business goals, Stable employment with a great atmosphere and ethical corporate culture

We are looking forward to hire AWS Glue Professionals in the following areas : 4 or more years experience in AWS Glue + Redshift + Python 4+ years of experience in engineering with experience in ETL type work with cloud databases Data management / data structures Must be proficient in technical data management tasks, i.e. writing code to read, transform and store data Spark Experience in launching spark jobs in client mode and cluster mode. Familiarity with the property settings of spark jobs and their implications to performance. SCC/Git Must be experienced in the use of source code control systems such as Git ETL Experience with developing ELT/ETL processes with experience in loading data from enterprise sized RDBMS systems such as Oracle, DB2, MySQL, etc. Programming Must be at able to code in Python or expert in at least one high level language such as Java, C, Scala. Must have experience in using REST APIs SQL Must be an expert in manipulating database data using SQL. Familiarity with views, functions, stored procedures and exception handling. AWS General knowledge of AWS Stack (EC2, S3, EBS, ) IT Process Compliance SDLC experience and formalized change controls Working in DevOps teams, based on Agile principles (e.g. Scrum) ITIL knowledge (especially incident, problem and change management) IT Process Compliance SDLC experience and formalized change controls Proficiency in PySpark for distributed computation Familiarity with Postgres and ElasticSearch Our Hyperlearning workplace is grounded upon four principles Flexible work arrangements, Free spirit, and emotional positivity Agile self-determination, trust, transparency, and open collaboration All Support needed for the realization of business goals, Stable employment with a great atmosphere and ethical corporate culture

Principal Lead-Identity Management and Governance Key Responsibilities Principal Lead-Identity Management and Governance is a high-visibility role responsible for leading Privileged Account Management (PAM) and governance initiatives in an Independent Contributor level, with a strong focus on cloud governance, including securing credential/key management tools. This individual will drive governance activities that ensure appropriate access controls and safeguard the confidentiality, integrity, and availability of enterprise systems and data through effective security controls. The role also includes validating compliance with information security policies and standards and raising awareness among stakeholders to help maintain a secure application and infrastructure environment. Key Responsibilities: Major Areas of accountability: Information Security Governance Identity & Access Governance Privileged Account Governance Policy/Procedure Management and Enforcement Reporting/Metrics Incident Management Education of Security Standards Provide timely and effective governance for the firms information security tools, processes and practices in the Identity space. Use standard technology monitoring tools to monitor assigned environments and/or technical assets and identify/detect behavior outside of established standards. Escalate key security issues to the appropriate team to be addressed. Assist with security assurance testing activities. Monitor compliance with information security and identity policies and practices and any applicable laws. Assist with internal and external security risk assessments, risk analysis and application or system-level access reviews and attestations. Coordinate / Facilitate reviews for different platforms across the enterprise on a periodic basis. Assist with the research, development, continuous improvement and implementation of identity policies, procedures, standards, and processes based on compliance requirements and industry best practices. Document the identity governance requirements, processes and procedures with focus on continuous improvement using Automation [script / process based]. Enforce information security and identity policies and procedures by reviewing violation reports, investigating possible exceptions, and documenting controls. Prepare status reports on identity and access matters that are used for a variety of purposes - tracking and monitoring security breaches, investigative activities, remediation plan management and risk management & compliance reporting. Location: Noida/Hyderabad Shift Timings: 2:00 -10:30 pm Cab Provided: Yes Required Qualifications: Bachelor s degree in Computer Science, Management Information Systems, or related technical field; or equivalent work experience. 10+ years of experience in Information Security Services or related technical field. Work experience that spans the Identity & Access Management or Governance, Risk, and Compliance security domains. Working knowledge of information security and computer network/system access technologies. Experience working in the financial services industry or other highly regulated/compliance-oriented environments. Effective verbal and written communication skills that include the ability to describe highly technical concepts in non-technical terms. Very good understanding of security controls, monitoring systems and regulatory/business drivers that impact security policies and practices. Working with business users on platform related questions/issues The successful candidate will need to demonstrate proficiency in atleast one of below verticals: Privileged Account Management Capabilities, Services and Processes using tools such as CyberArk and / or Competitor tools like Delinea, Arcon, BeyondTrust, Hashicorp. At least one of the following Cloud Governance technologies: AWS, Azure, GCP with experience in securing key services such as AWS Secrets Manager or Azure KeyVault. In addition, the successful candidate will need to meet below requirements: Interested in gaining broad experience in Information Security Services [must have] First level knowledge and/or demonstrated technical ability to understand code and technology infrastructure in multiple environments with experience in the below languages [Powershell, Python, Regular expressions-based programming] Demonstrated basic understanding of the Software Development Lifecycle (SDLC) and programming/development procedures. Effective oral and written communication skills along with logical, analytical, and abstract thinking skills. Strong attention to detail, follow-through, and time management skills. Demonstrated aptitude to quickly learn and apply new tools and processes Defining business, user, and systems requirements Developing user acceptance test plans Developing, document, test and modify new and existing code Developing working knowledge of systems and processes Business Analysis Building Process Flows Presentations (Creating and Delivering) Risk Identification and Remediation Project Management Project Coordination Reporting (SQL queries to databases) / Correlation ITIL (Change, Problem, Incident, Configuration) Management Preferred Qualifications: Basic knowledge and experience with: Operating Systems (Windows, UNIX, Mainframe, etc. ) Directories/LDAP Constructs (Active Directory, Oracle, etc. ) Databases/RDBMS Constructs (Oracle, SQL, DB2, MS SQL Server etc. ) Authentication / Authorization Constructs (Directory, Hybrid, Native Source) Data Formats (XML, CSV, etc. ) Identity & Access Governance Capabilities: o Role Based Access Controls (RBAC) o Provision / De-Provisioning o Access Request Privileged Access/Credential Management Privileged Access Management Suites o CyberArk Development / Programming / Scripting o SQL for Oracle or MS SQL o Java EE Compliance Types (GLBA, HIPAA, IT Compliance, NERC, PCI, SOX, etc. ) Service Organization Controls (SOC1, SOC2) Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U. S. based financial planning company headquartered in Minneapolis with a global presence. The firm s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection. Be part of an inclusive, collaborative culture that rewards you for your contributions and work with other talented individuals who share your passion for doing great work. You ll also have plenty of opportunities to make your mark at the office and a difference in your community. So if youre talented, driven and want to work for a strong ethical company that cares, take the next step and create a career at Ameriprise India LLP. Full-Time/Part-Time Timings (4:45p-1:15a) India Business Unit AWMPO AWMP&S Presidents Office Job Family Group Technology

Duration: 12Months Work Type: Onsite Position Description: We are looking for a highly motivated individual with at least 10 years of experience in Mainframe COBOL, JCL, DB2, ZoS APIs and IMS-DB. Experience with IMS DC is a plus. As a member of our team, you will develop, maintain, and enhance our core legacy applications. This position requires a deep understanding of mainframe technologies and a demonstrated history of delivering high-quality software solutions Skills Required: Mainframe COBOL JCL DB2 ZoS API IMS DB Skills Preferred: IMS DC Experience Required: 10+ Education Required: Any Degree Education Preferred: B-Tech

Duration: 12Months Work Type: Onsite Job Description: The resource should have knowledge to identify the Mainframe data points, volume, and frequency of update, and to come-up with a design to consume the data from alternate source which is GCP Big Query. Should be able to establish the connectivity with GCP Big Query to fetch the data, create the logic to extract and transform the data, create new schema, and table structure in GCP Big Query and populate the data for SAVE Downstreams. Resource to ensure a smooth extracting of the database from GCP Big Query while ensuring the data integrity (SAVE is SOX) and post extract validation. Ensure the delivery of high-quality code through strict standards, continuous integration, development, and testing. Must be capable of developing new Mainframe solutions for various requirements, enhancements, features for existing and new applications. Develop detailed plans and accurate estimates for completion of build, system testing and implementation phases of project. Transform business function requirements into technical program specifications to Code, Test and Debug programs. Knowledge of Performing performance tuning to improve the performance over multiple functions. Foster collaboration and clear communication with Product Managers, Product Owners, Anchor, Software engineers as well as Business Customers throughout the development and support of application features Skills Required: Strong technical skills in Mainframe Technologies i,e COBOL, JCL, DB2, IMS-DB is must. Must have experience in Endeavor. Resource should have hands-on"Coding experience in mainframe technologies" and should be able to provide quick break fix and provide solutions. Must have hands on knowledge on SQL Database. Good understanding about Solutions Architect Framework & Security and Controls. Good knowledge of Agile Central/Rally Backlog will be a plus. Skills Preferred: Must have good communication skills, A team player with can doattitude. Should be fluent in English communication skills and Experience Required: 7 Years Education Required: BE/BTECH/MCA

The Solution Architect Data Engineer will design, implement, and manage data solutions for the insurance business, leveraging expertise in Cognos, DB2, Azure Databricks, ETL processes, and SQL. The role involves working with cross-functional teams to design scalable data architectures and enable advanced analytics and reporting, supporting the company's finance, underwriting, claims, and customer service operations. Key Responsibilities: Data Architecture & Design: Design and implement robust, scalable data architectures and solutions in the insurance domain using Azure Databricks, DB2, and other data platforms. Data Integration & ETL Processes: Lead the development and optimization of ETL pipelines to extract, transform, and load data from multiple sources, ensuring data integrity and performance. Cognos Reporting: Oversee the design and maintenance of Cognos reporting systems, developing custom reports and dashboards to support business users in finance, claims, underwriting, and operations. Data Engineering: Design, build, and maintain data models, data pipelines, and databases to enable business intelligence and advanced analytics across the organization. Cloud Infrastructure: Develop and manage data solutions on Azure, including Databricks for data processing, ensuring seamless integration with existing systems (e.g., DB2, legacy platforms). SQL Development: Write and optimize complex SQL queries for data extraction, manipulation, and reporting purposes, with a focus on performance and scalability. Data Governance & Quality: Ensure data quality, consistency, and governance across all data solutions, implementing best practices and adhering to industry standards (e.g., GDPR, insurance regulations). Collaboration: Work closely with business stakeholders, data scientists, and analysts to understand business needs and translate them into technical solutions that drive actionable insights. Solution Architecture: Provide architectural leadership in designing data platforms, ensuring that solutions meet business requirements, are cost-effective, and can scale for future growth. Performance Optimization: Continuously monitor and tune the performance of databases, ETL processes, and reporting tools to meet service level agreements (SLAs). Documentation: Create and maintain comprehensive technical documentation including architecture diagrams, ETL process flows, and data dictionaries. Required Qualifications: Bachelors or Masters degree in Computer Science, Information Systems, or a related field. Proven experience as a Solution Architect or Data Engineer in the insurance industry, with a strong focus on data solutions. Hands-on experience with Cognos (for reporting and dashboarding) and DB2 (for database management). Proficiency in Azure Databricks for data processing, machine learning, and real-time analytics. Extensive experience in ETL development, data integration, and data transformation processes. Strong knowledge of Python, SQL (advanced query writing, optimization, and troubleshooting). Experience with cloud platforms (Azure preferred) and hybrid data environments (on-premises and cloud). Familiarity with data governance and regulatory requirements in the insurance industry (e.g., Solvency II, IFRS 17). Strong problem-solving skills, with the ability to troubleshoot and resolve complex technical issues related to data architecture and performance. Excellent verbal and written communication skills, with the ability to work effectively with both technical and non-technical stakeholders. Preferred Qualifications: Experience with other cloud-based data platforms (e.g., Azure Data Lake, Azure Synapse, AWS Redshift). Knowledge of machine learning workflows, leveraging Databricks for model training and deployment. Familiarity with insurance-specific data models and their use in finance, claims, and underwriting operations. Certifications in Azure Databricks, Microsoft Azure, DB2, or related technologies. Knowledge of additional reporting tools (e.g., Power BI, Tableau) is a plus. Key Competencies: Technical Leadership: Ability to guide and mentor development teams in implementing best practices for data architecture and engineering. Analytical Skills: Strong analytical and problem-solving skills, with a focus on optimizing data systems for performance and scalability. Collaborative Mindset: Ability to work effectively in a cross-functional team, communicating complex technical solutions in simple terms to business stakeholders. Attention to Detail: Meticulous attention to detail, ensuring high-quality data output and system performance.

Duration: 24Months Position Description: Key skill required: IMS DB/DC ( Strict requirement ), DB2, JCL, COBOL Work as Mainframe Developer/ taking ownership on the assigned applications/ projects and support the team Work with business to understand functional and system requirements and deliver IT Solutions . Should deliver solutions strictly following the IT processes within the organization and always should adhere to security processes and support them Lead system maintenance work for assigned applications Able to work on the provide production support of the applications in the defined SLA or CSF/ CTQs Able to quickly act on the production incidents/ job abends and resolve them Able to monitor the daily/ weekly/ monthly jobs and support issues as required Able to work on the application documentation like SCM, DR Plan, Risk Assessment, Security Controls, etc. Co-ordinate with team for details on tasks and provides status to the Project Manager ( as required and applicable) Work as S4Hana Technical and Functional consultant with strong knowledge of P2P process in SAP S4Hana. Should have functional experience in handling all the P2P related screens and business functions like Materials Management, Vendor Management, ASN, Purchase requisition, Purchase orders, Receipt Handling, 3 way matching. Prior experience of integration of Legacy to SAP S4Hana will be an added advantage. Skills Required: Cobol, JCL, DB2, IMSDC, IMS DB Skills Preferred: IBM Debug tool, Endevor, CA7, QMF, SPUFI, Selcopy. Experience Required: 8+ years Education Required: BE/B.Tech/MCA

Duration: 12Months Position Description: 7+ years of Strong knowledge of mainframe technology, including z/OS, RACF, and security frameworks. Must have experience with mainframe modernization efforts and cloud integration. Possess technical expertise in areas like COBOL, CICS, DB2, MQ and VSAM. Expertise in IMS DC screens Expertise in JCL and utilities used in JCL Hands on knowledge in implementing API in mainframe. Hands on experience in Endevor, BMC , File Manager , Fault Analyzer tools. Collaborating with and across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies Experience in Creation of solution and architectural views (logical, development, execution, infrastructure & operation architecture) Skills Required: Mainframe Systems, Cloud Architecture, Application Architect Skills Preferred: Google Cloud Platform Experience Required: 10+ years Education Required: Bachelor's Degree.

The Database Patch Engineer is responsible for planning, coordinating, testing, and applying patches and updates to database systems to ensure security, stability, and compliance with cyber security standards. This role requires strong technical knowledge of database systems, patching best practices, and advanced troubleshooting skills. Key Deliverables (Duties and Responsibilities) Plan and implement database patches (security patches, bug fixes, and upgrades) across multiple environments (development, testing, QA, and production). Collaborate with DBAs, application teams, and system administrators to schedule and execute patching activities with minimal downtime. Perform impact analysis and risk assessments prior to patch deployments. Test patches in lower environments to ensure compatibility and performance. Monitor patch releases from vendors (e.g., Oracle, Microsoft, DB2) and maintain patch management schedules. Maintain detailed documentation of patching procedures, schedules, and post-patch validations. Automate patching processes where feasible using scripting or patch management tools. Troubleshoot and resolve patch-related issues promptly. Ensure compliance with cybersecurity standards and audit requirements. Assist in database upgrades, migrations, and disaster recovery exercises. Provide post-patching reports and status updates to leadership Skills and Qualification (Functional and Technical Skills) Bachelor s degree in computer science, Information Technology, or a related field, or equivalent experience. 7+ years of experience in database administration and patch management. Strong expertise with major RDBMS platforms (Oracle, SQL Server, DB2, etc.). Experience with database patching tools (e.g., Oracle OPatch, Microsoft Windows Update, Red Hat Satellite). Proficiency in SQL, scripting (Shell, PowerShell, Python), and automation frameworks. Knowledge of ITIL processes and change management. Good understanding of high availability (HA) cluster, ASM (Automated Storage Management) and disaster recovery (DR) strategies. Excellent troubleshooting and problem-solving skills. Experience in working with multiple operating system environment - Windows Server, RHEL and AIX Strong communication and collaboration skills. Preferred Qualifications: Certifications such as Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, or equivalent. Experience with cloud-based databases (AWS RDS, Azure SQL, Oracle Cloud). Experience in DevOps environments and with Infrastructure as a Code practice Relationships & Collaboration Ensure great Partnership with IT counterparts (India as well as US associates). Be available for team connects if any. Flexible to adjust work scheduled including evening, weekend; as per Org need. Collaborate with Business wherever necessary.

Requirements Analysis, Design, Coding, Reviews, Unit testing and enhancement. Strong understanding of SDLC methodologies (Agile, SCRUM). Strong experience on Mainframe Assembler (TPF) and DFSMS Working experience of TPF DF and IBM Toolkit/Debugger Experience on debugging and enhancing applications TPF Mainframe data manipulation, report creation, file creation, to/from TPF Experience on Rational Database (DB2) Development of JCL, PROCs DB2 Stored Procedures Maintenance of the relevant systems and applications Working along with development teams TPF Assembler, IBM 360 Assembler, VM/CMS, TPFDF, TPFC skills(Good to have) Proven work experience in TPF Assembler, IBM 390 Assembler, VM/CMS, TPFDF, TPFC skills(Good to have). Location - Anywhere In India, hyderabad,ahmedabad,pune,chennai,kolkata.

Some careers shine brighter than others. If you re looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further. HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions. We are currently seeking an experienced professional to join our team in the role of Senior Consultant Specialist. In this role, you will: High level requirement Analysis, Estimation Scheduling Engineering activities planning, monitoring, tracking, controlling and status reporting Prepare Technical design Conduct review of Technical design/code/test plan and test results Testing Support in system integration User acceptance testing. Release preparation Contribute in Non Functional requirement - Performance testing, Security testing Post implementation Support Represent Engineering team in project level meeting discussions with stakeholder other IT team Lead guide Engineering team (approx. 5 or more) to deliver as per agreed effort timeline Work on multiple projects (2-3 projects for small to medium size) Responsible for status reporting and metrics reporting Responsible for defect management Support and co-ordinate change management activities Support defect prevention activities Implement Engineering process improvements resulting from lessons learnt Requirements To be successful in this role, you should meet the following requirements: More than 10+ years of IT experience of which at least 2-3 years as Technical lead Must have worked as Technical lead with minimum team size 6 to 8. Knowledge of HSBC Core Banking systems and its interfaces, exposure to large upgrades, programmes or MnA projects preferred Software development maintenance using SDLC AGILE methodology Experience in carrying out Technical design for project Experience on iSeries platform using CLLE, RPGLE, DB2/400, SQL Worked on programming using SQL RPG and Free format RPG Worked on tools - JIRA, RDI (coding), RTC ARCAD (software change control), Jenkins, HP Quality Centre, GSD Worked on programming using MQ, Connect Direct, SFTP Strong Analytical skills Self-starter, take ownership and flexible Able to work under tight deadline and do multi-tasking Team player Good in interpersonal and communication skills Preferably have worked on Restful API development using IWS on iSeries platform Worked on test automation tools (RPGUnit, XFramework, TOSCA etc) Worked on Core Banking applications Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.

Responsibilities : - Must have knowledge of IT concepts such as DB design, DB layout, DB structures, DB stored procedures, DB tables, DB optimization, TCP/IP, IT security concepts and practices. - Must be an expert in SQL Server along with a very good understanding of Oracle and knowledge of Informix, DB2, MongoDB, DynamoDB and any other databases. - Must be a self-starter with a great attitude, not afraid to take the initiative, and work with little supervision. - Ability to analyze and write business and technical specifications and interact with IT and auditor teams. - A degree in information technology/computer information systems or related. - 6 + years of work experience in database support and management. - Clear understanding of IT Operations, Software Development and Release Management using GitHub. - Ability to work under pressure in a fast-paced environment. - Strong attention to detail with an analytical mind and outstanding problem-solving skills. - GitHub, ServiceNow, Jira, MS Office, SQL, etc. - Primary : Must be an expert in SQL Server along with a very good understanding of Oracle and knowledge of Informix, DB2, MongoDB, DynamoDB and any other databases.

Strong knowledge working with Informatica Power Center. Knowledge of Informatica MDM. Strong working Knowledge with Relational Databases like DB2, Oracle, SQL Server. Strong working Knowledge in SQL and PL/SQL. Perform source system data analysis to understand data relationships Investigate and resolve data quality and data loading failures . Identify the data Sources and works with Source System team and perform the data analysis to define data quality and extraction and transformation methods needed to be able to persist in the Target. Strong Knowledge in writing complex queries in DB2 and Store Procedures. Provide ad hoc query support for ad hoc query requests Create and Maintain Batch processing jobs and schedules and respond to critical prod issues. Highly Skilled with Data Analysis, Data Profiling, Root cause analysis. Should be able to work Independently, and work along with the team situated in various locations.

Works throughout the software development life cycle and performs in a utility capacity to create, design, code, debug, maintain, test, implement and validate applications with a broad understanding of a variety of languages and architectures. Analyzes existing applications or formulate logic for new applications, procedures, flowcharting, coding and debugging programs. Maintains and utilizes application and programming documents in the development of code. Creates appropriate deliverables and develops application implementation plans throughout the life cycle in a flexible development environment Analyzes, modifies, and develops moderately complex code/unit testing in order to develop concise application documentation.

Must have strong experience in Mainframe technology (COBOL, DB2, CICS, JCL, VSAM etc) to Involve in System Testing, SIT, Functional and Regression Testing Test Cases and its execution. Need to Create, Run & execute JCLs in Mainframe, Validate the job status in spool, and have problem solving skills to resolve JCL errors, experience in writing in complex SQL Queries run Mainframe DB post execution. Identify and escalate risks and issues to project management and managers, Daily status progress reporting to project stakeholders, senior management, attend project calls and meetings and support e2e SIT, UAT and Penny Test we'll versed with the different testing methodologies (waterfall, Scrum, Agile etc), techniques phases tools and can use the same as per the project requirement. Execute tests, track and monitor defects/Stories to closure and produce test metrics and test reports using GitHub / Jenkins / using Automation tool etc Must have excellent oral and written communications skills, ability to accept and deliver assistance to meet deadlines, self-directed, organized capable of multi-tasking. Should have good analytical and problem-solving skills. Should have experience in creating reports in JIRA, sharepoint and confluence etc Leadership and Guidance Must have experience in creating test estimation, test strategy and assisting associates to create Test Plan. Should be providing regular updates to management while managing day-to-day testing activities, such as test monitoring and status reporting at the end of the testing day. Nurture team members on mainframe and fucntional skills and expertise eg, REXX, JCL, COBOL, DB2, VSAM and CICS, Core Banking (Lending products, Product ledger management, Fees and interest etc) Assign tasks based on individual skills and workload, ensuring efficient use of resources Track team progress and individual contributions against goals and deadlines Requirements Consultant Specialist in Testing with extensive Mainframe development and Testing experience with 8 + Years minimum experience and should be an SME in Mainframe Testing (zSeries) JCL, DB2, COBOL, CICS, Endeavour, File Manager, Debugging the programs. Knowledge and usage of tools File Manager/File Aid, Xpeditor, Endevor and SPUFI Knowledge in Unsecured and secured lending area in Banking products eg Personal loans, Consumer loans, Mortgage, BACS (Direct Debit / Direct Credit) payments Should be able to view and read the JCLs to the testing environment using production JCLs. Should be able to analyze the COBOL, DB2 code when required and analyze abends from spool and usage of debugging tools. Able to create Test Scenarios, Test cases, Test Cases Execution using TOSCA, ALM JIRA and Quality Centre on mainframe-based systems and applications. Excellent Communication Skills TOSCA, GitHub, Jenkins, CICD Pipeline, ALM JIRA etc - experience good to have. Cloud, GCP, Performance Testing (Jmeter, Performance center, Appdynamics) Experience good to have Other Retail /wholesale Banking Experience good to have.

Must have strong experience in Mainframe technology (COBOL, DB2, CICS, JCL, VSAM etc) to Involve in System Testing, SIT, Functional and Regression Testing Test Cases and its execution. Need to Create, Run & execute JCLs in Mainframe, Validate the job status in spool, and have problem solving skills to resolve JCL errors, experience in writing in complex SQL Queries run Mainframe DB post execution. Identify and escalate risks and issues to project management and managers, Daily status progress reporting to project stakeholders, senior management, attend project calls and meetings and support e2e SIT, UAT and Penny Test we'll versed with the different testing methodologies (waterfall, Scrum, Agile etc), techniques phases tools and can use the same as per the project requirement. Execute tests, track and monitor defects/Stories to closure and produce test metrics and test reports using GitHub / Jenkins / using Automation tool etc Must have excellent oral and written communications skills, ability to accept and deliver assistance to meet deadlines, self-directed, organized capable of multi-tasking. Should have good analytical and problem-solving skills. Should have experience in creating reports in JIRA, sharepoint and confluence etc Leadership and Guidance Must have experience in creating test estimation, test strategy and assisting associates to create Test Plan. Should be providing regular updates to management while managing day-to-day testing activities, such as test monitoring and status reporting at the end of the testing day. Nurture team members on mainframe and fucntional skills and expertise eg, REXX, JCL, COBOL, DB2, VSAM and CICS, Core Banking (Lending products, Product ledger management, Fees and interest etc) Assign tasks based on individual skills and workload, ensuring efficient use of resources Track team progress and individual contributions against goals and deadlines Requirements Consultant Specialist in Testing with extensive Mainframe development and Testing experience with 8 + Years minimum experience and should be an SME in Mainframe Testing (zSeries) JCL, DB2, COBOL, CICS, Endeavour, File Manager, Debugging the programs. Knowledge and usage of tools File Manager/File Aid, Xpeditor, Endevor and SPUFI Knowledge in Unsecured and secured lending area in Banking products eg Personal loans, Consumer loans, Mortgage, BACS (Direct Debit / Direct Credit) payments Should be able to view and read the JCLs to the testing environment using production JCLs. Should be able to analyze the COBOL, DB2 code when required and analyze abends from spool and usage of debugging tools. Able to create Test Scenarios, Test cases, Test Cases Execution using TOSCA, ALM JIRA and Quality Centre on mainframe-based systems and applications. Excellent Communication Skills TOSCA, GitHub, Jenkins, CICD Pipeline, ALM JIRA etc - experience good to have. Cloud, GCP, Performance Testing (Jmeter, Performance center, Appdynamics) Experience good to have Other Retail /wholesale Banking Experience good to have.

High level requirement Analysis, Estimation & Scheduling Engineering activities planning, monitoring, tracking, controlling and status reporting Prepare Technical design Conduct review of Technical design/code/test plan and test results Testing Support in system integration & User acceptance testing. Release preparation Contribute in Non Functional requirement - Performance testing, Security testing Post implementation Support Represent Engineering team in project level meeting & discussions with stakeholder & other IT team Lead & guide Engineering team (approx. 5 or more) to deliver as per agreed effort & timeline Work on multiple projects (2-3 projects for small to medium size) Responsible for status reporting and metrics reporting Responsible for defect management Support and co-ordinate change management activities Support defect prevention activities Implement Engineering process improvements resulting from lessons learnt Requirements More than 10+ years of IT experience of which at least 2-3 years as Technical lead Must have worked as Technical lead with minimum team size 6 to 8. Knowledge of HSBC Core Banking systems and its interfaces, exposure to large upgrades, programmes or MnA projects preferred Software development & maintenance using SDLC & AGILE methodology Experience in carrying out Technical design for project Experience on iSeries platform using CLLE, RPGLE, DB2/400, SQL Worked on programming using SQL RPG and Free format RPG Worked on tools - JIRA, RDI (coding), RTC & ARCAD (software change control), Jenkins, HP Quality Centre, GSD Worked on programming using MQ, Connect Direct, SFTP Strong Analytical skills Self-starter, take ownership and flexible Able to work under tight deadline and do multi-tasking Team player Good in interpersonal and communication skills Preferably have worked on Restful API development using IWS on iSeries platform Worked on test automation tools (RPGUnit, XFramework, TOSCA etc) Worked on Core Banking applications

High level requirement Analysis, Estimation & Scheduling Engineering activities planning, monitoring, tracking, controlling and status reporting Prepare Technical design Conduct review of Technical design/code/test plan and test results Testing Support in system integration & User acceptance testing. Release preparation Contribute in Non Functional requirement - Performance testing, Security testing Post implementation Support Represent Engineering team in project level meeting & discussions with stakeholder & other IT team Lead & guide Engineering team (approx. 5 or more) to deliver as per agreed effort & timeline Work on multiple projects (2-3 projects for small to medium size) Responsible for status reporting and metrics reporting Responsible for defect management Support and co-ordinate change management activities Support defect prevention activities Implement Engineering process improvements resulting from lessons learnt Requirements More than 10+ years of IT experience of which at least 2-3 years as Technical lead Must have worked as Technical lead with minimum team size 6 to 8. Knowledge of HSBC Core Banking systems and its interfaces, exposure to large upgrades, programmes or MnA projects preferred Software development & maintenance using SDLC & AGILE methodology Experience in carrying out Technical design for project Experience on iSeries platform using CLLE, RPGLE, DB2/400, SQL Worked on programming using SQL RPG and Free format RPG Worked on tools - JIRA, RDI (coding), RTC & ARCAD (software change control), Jenkins, HP Quality Centre, GSD Worked on programming using MQ, Connect Direct, SFTP Strong Analytical skills Self-starter, take ownership and flexible Able to work under tight deadline and do multi-tasking Team player Good in interpersonal and communication skills Preferably have worked on Restful API development using IWS on iSeries platform Worked on test automation tools (RPGUnit, XFramework, TOSCA etc) Worked on Core Banking applications

As a Lead Database Administrator, you will work with other members of our DBA teams to develop and track key database measures and metrics. Your focus will be on evaluating runtime systems, building monitoring and incident response capabilities, and automating monitoring and automatic feedback systems for our development, staging, and production systems Key Qualifications: 9+ years of experience in a DBA role supporting 24/7 environment with on call duties as per team rotation. DBA will be responsible for supporting other database types (Postgres, DB2, aurora) in Saks environments. Demonstrated ability to mentor junior team members and develop internal experience in DBA best practices Experience with database migration from data center to Azure / AWS RDS. Managing Databases as IaaS, PaaS. Exposer to Azure VMs and /Azure SQL MI Experience with Automation of routine tasks and setup monitoring. Shell scripting, Powershell, PL/SQL for automation. Strongly desired : experience in the retail or fashion industries Appreciated: interest and curiosity for working in a variety of languages and frameworks with flexibility towards team and organizational adoption Role Description: Assist with issues relating to system performance: Diagnosis of SQL problems, Application Support and SQL Support Assist with the design and maintenance of systems, policies, and procedures for disaster recovery to ensure effective availability, protection, confidentiality of data, and integrity of data assets. Be a consultant in the review, planning, testing, and execution of business applications and database upgrades Develop and track key database measures and metric Good understanding of data models and assisting the application team providing recommendations for schema designs o Demonstrate extensive hands-on experience with SQL Server & Oracle with a particular emphasis on performance and tuning. Skills include, but are not limited to: Installations, migrations/upgrades, configuration, tuning and performance analysis, backup/restore/failover Ability to plan, scope and estimate work effort to produce high quality deliverables on time/on budget for Database project work Good understanding of Failover clustering and Log shipping Use quantitative and modeling techniques to forecast database capacity and growth trends On call duties per team rotation. Conduct research and make recommendations on database products, services, protocols, and standards in support of development efforts. Develop key automation, monitoring and performance tuning software Review and tune data access calls and stored procedures to ensure both individual database performance and overall system performance Provide technical leadership in the design, implementation and management of our database environments Your Life and Career at Saks: Exposure to rewarding career advancement opportunities A culture that promotes a healthy, fulfilling work/life balance Benefits package for all eligible full-time employees (including medical, vision and dental). An amazing employee discount