HGS - Hinduja Global Solutions | PL/SQL Architect | bangalore

3 weeks ago


bangalore, India HGS - Hinduja Global Solutions Full time
Role Title: Software Architect Analytics (PL/SQL)
Location: Bangalore, India. Should be willing to travel domestic and international
Responsibilities include:
Project delivery: Working as a team lead to deliver projects
Database objects: Creating database objects like tables, indexes, views, sequences, and packages
Process design and development: Designing and developing processes like loading data from internal and external systems
ETL code: Extracting, transforming, and loading data
Design and implement ETL processes for data transformation and preparation
Deploy machine learning models to production environments
Manage data pipelines for analytics and operational use
Ensure data accuracy and integrity across multiple sources and systems
SQL query tuning: Using Explain Plan and hints to reduce response time
Program development: Designing, developing, testing, and deploying complex PL/SQL programs using PostgreSQL, MSSQL, MySQL
Stored procedures: Developing stored procedures, functions, packages, triggers, and scripts to automate business logic
Database performance optimization: Optimizing database performance by analyzing query execution plans and rewriting slow queries
Automated unit test packages: Writing automated unit test packages by creating test data for all test scenarios, writing asserts for the test case, and executing test cases
QA team coordination: Co-coordinating with the QA team for testing in QA Environment to get sign off
Code push in production: Getting code pushed in production
Technical support: Participating in 24x7 rotational technical support to solve business problems
Interfacing with teams: Interfacing with Functional team, Application Development Team and infrastructure teams
Education Qualification and Professional experience:
Bachelor’s Degree
8 to 10 years of relevant experience in the IT/ ITES sector
Mandatory experience required:
5+ years of experience in data engineering within a production environment
Advanced knowledge of Python and Linux shell scripting for data processing
Experience with SQL/NoSQL databases (e.g., Redshift, Postgres, MongoDB)
Familiarity with Docker, Kubernetes, and cloud services (AWS)

  • bangalore, India HGS - Hinduja Global Solutions Full time

    Role Title: Software Architect Analytics (PL/SQL) Location: Bangalore, India. Should be willing to travel domestic and international Responsibilities include: Project delivery: Working as a team lead to deliver projects Database objects: Creating database objects like tables, indexes, views, sequences, and packages Process design and development:...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    Role Title: Software Architect Analytics (PL/SQL)Location: Bangalore, India. Should be willing to travel domestic and internationalResponsibilities include:Project delivery: Working as a team lead to deliver projects Database objects: Creating database objects like tables, indexes, views, sequences, and packages Process design and development: Designing and...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    Job DescriptionAs a Senior Security Platform Engineer, you will manage the full lifecycle of SIEM and security solutions, including their design, deployment, and optimization. Your role will involve integrating diverse data sources, creating detection rules, and automating processes to enhance security operations. You'll collaborate with SOC teams and cloud...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    Job Description As a Senior Security Platform Engineer, you will manage the full lifecycle of SIEM and security solutions, including their design, deployment, and optimization. Your role will involve integrating diverse data sources, creating detection rules, and automating processes to enhance security operations. You'll collaborate with SOC teams and...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    Job DescriptionAs a Senior Security Platform Engineer, you will manage the full lifecycle of SIEM and security solutions, including their design, deployment, and optimization. Your role will involve integrating diverse data sources, creating detection rules, and automating processes to enhance security operations. You'll collaborate with SOC teams and cloud...

  • Pl/sql architect

    17 hours ago


    Bangalore, India HGS - Hinduja Global Solutions Full time

    Role Title: Software Architect Analytics (PL/SQL) Location: Bangalore, India. Should be willing to travel domestic and international Responsibilities include: Project delivery: Working as a team lead to deliver projects Database objects: Creating database objects like tables, indexes, views, sequences, and packages Process design and...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    TSYS Prime technical architectTravel: (Candidate needs to be onsite- client location for 1 year)Candidate Experience – 5+ years Work with the cards business vertical of customer, playing the role of TSYS prime technical architect, managing the architectural design, development, and integration of the TSYS Prime Card Management SystemDesign and develop...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    JOB DESCRIPTONPosition SummaryTechnical support executives are responsible for handling calls from new and existing customers from the US regarding a variety of broadband/OS-related queries. Using their knowledge of products or services as well as great customer service skills, these professionals address issues, provide technical support, and offer...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    JOB DESCRIPTON Position Summary Technical support executives are responsible for handling calls from new and existing customers from the US regarding a variety of broadband/OS-related queries. Using their knowledge of products or services as well as great customer service skills, these professionals address issues, provide technical support, and offer...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    Responsibility of / Expectations from the Role : Open to travel to client's location (Overseas) L3 Support activities on IBM MQ Implementing client requests and migrating to latest environments Work as L3 level to implement deas and tasks. Maintaining prod env with latest ifixes and fixpacks Develop and maintain server and database configurations Ensure...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    Job Title: Test EngineerWork Location: Bangalore (BLR)Experience: 10-12 yearsDomain: BankingOnsite Opportunity: Required to travel to client location overseas and work for min 1 yearJob Description:We are seeking an experienced End-to-End Test Engineer to join our team in Bangalore. The ideal candidate will have 8-12 years of experience in the banking domain...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    Job Title: Test Engineer Work Location: Bangalore (BLR) Experience: 10-12 years Domain: Banking Onsite Opportunity: Required to travel to client location overseas and work for min 1 year Job Description: We are seeking an experienced End-to-End Test Engineer to join our team in Bangalore. The ideal candidate will have 8-12 years of experience in the...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    We are seeking a Cypress Test Automation Lead with a minimum of 10 years of experience working with QA Automation, Functional automation using Cypress and JavaScript, along with expertise in Git/Bitbucket, Jenkins, AWS, SQL, and API testing. As a Cypress Test Automation Lead, you will be responsible for assessing the Automation needs, designing, developing,...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    We are seeking a Cypress Test Automation Lead with a minimum of 10 years of experience working with QA Automation, Functional automation using Cypress and JavaScript, along with expertise in Git/Bitbucket, Jenkins, AWS, SQL, and API testing. As a Cypress Test Automation Lead, you will be responsible for assessing the Automation needs, designing, developing,...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    1. Job DescriptionExp 10+YearsAs a Senior Security operations Engineer, you will typically focus on leading initiatives to significantly improve an organization's security operations capabilities, including enhancing threat detection, incident response, automation, and overall security posture by identifying gaps, implementing new technologies, optimizing...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    1. Job Description Exp 10+Years As a Senior Security operations Engineer, you will typically focus on leading initiatives to significantly improve an organization's security operations capabilities, including enhancing threat detection, incident response, automation, and overall security posture by identifying gaps, implementing new technologies, optimizing...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    1. Job DescriptionExp 10+YearsAs a Senior Security operations Engineer, you will typically focus on leading initiatives to significantly improve an organization's security operations capabilities, including enhancing threat detection, incident response, automation, and overall security posture by identifying gaps, implementing new technologies, optimizing...


  • bangalore, India HGS - Hinduja Global Solutions Full time

    About the CompanyHigh Level Roles & Responsibilities · Manage the delivery of complex business transformation projects defined within the customer focus · Identify opportunity areas using advance analytics, marketing research, technological advancement and industry best practices · Design and identify ways of delivering transformational projects....


  • bangalore, India HGS - Hinduja Global Solutions Full time

    About the Company High Level Roles & Responsibilities · Manage the delivery of complex business transformation projects defined within the customer focus · Identify opportunity areas using advance analytics, marketing research, technological advancement and industry best practices · Design and identify ways of delivering transformational projects....


  • bangalore, India HGS - Hinduja Global Solutions Full time

    About the CompanyHigh Level Roles & Responsibilities · Manage the delivery of complex business transformation projects defined within the customer focus · Identify opportunity areas using advance analytics, marketing research, technological advancement and industry best practices · Design and identify ways of delivering transformational projects....