59 Sql Optimization Jobs - Page 2

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : Microsoft SQL Server Analysis Services (SSAS) Good to have skills : Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services, No Function Specialty Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will analyze, design, code, and test multiple components of application code across one or more clients. You will perform maintenance, enhancements, and/or development work. Your typical day will involve analyzing requirements, designing solutions, writing code, and conducting testing to ensure the quality of the application. You will collaborate with team members, participate in code reviews, and contribute to the overall success of the project. Roles & Responsibilities: Expected to be an SME, collaborate and manage the team to perform. Responsible for team decisions. Engage with multiple teams and contribute on key decisions. Provide solutions to problems for their immediate team and across multiple teams. Analyze requirements and design solutions for application components. Write high-quality code following coding standards and best practices. Conduct unit testing and participate in code reviews to ensure code quality. Collaborate with team members to troubleshoot and resolve issues. Contribute to the overall success of the project by meeting project milestones and deliverables. Professional & Technical Skills: Must To Have Skills:Proficiency in Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services. Strong understanding of database concepts and SQL query optimization. Experience in designing and developing data models using Microsoft SQL Server Analysis Services (SSAS). Hands-on experience in writing complex SQL queries and stored procedures. Experience in performance tuning and optimization of SQL queries. Good To Have Skills:Experience with data visualization tools such as Tableau or Power BI. Solid grasp of data munging techniques, including data cleaning, transformation, and normalization to ensure data quality and integrity. Additional Information: The candidate should have a minimum of 5 years of experience in Microsoft SQL Server Analysis Services (SSAS). This position is based in Mumbai. A 15 years full-time education is required. Qualifications 15 years full time education

Overview Deputy Director - Data Engineering PepsiCo operates in an environment undergoing immense and rapid change. Big-data and digital technologies are driving business transformation that is unlocking new capabilities and business innovations in areas like eCommerce, mobile experiences and IoT. The key to winning in these areas is being able to leverage enterprise data foundations built on PepsiCos global business scale to enable business insights, advanced analytics, and new product development. PepsiCos Data Management and Operations team is tasked with the responsibility of developing quality data collection processes, maintaining the integrity of our data foundations, and enabling business leaders and data scientists across the company to have rapid access to the data they need for decision-making and innovation. What PepsiCo Data Management and Operations does: Maintain a predictable, transparent, global operating rhythm that ensures always-on access to high-quality data for stakeholders across the company. Responsible for day-to-day data collection, transportation, maintenance/curation, and access to the PepsiCo corporate data asset Work cross-functionally across the enterprise to centralize data and standardize it for use by business, data science or other stakeholders. Increase awareness about available data and democratize access to it across the company. As a data engineering lead, you will be the key technical expert overseeing PepsiCo's data product build & operations and drive a strong vision for how data engineering can proactively create a positive impact on the business. You'll be empowered to create & lead a strong team of data engineers who build data pipelines into various source systems, rest data on the PepsiCo Data Lake, and enable exploration and access for analytics, visualization, machine learning, and product development efforts across the company. As a member of the data engineering team, you will help lead the development of very large and complex data applications into public cloud environments directly impacting the design, architecture, and implementation of PepsiCo's flagship data products around topics like revenue management, supply chain, manufacturing, and logistics. You will work closely with process owners, product owners and business users. You'll be working in a hybrid environment with in-house, on-premises data sources as well as cloud and remote systems. Responsibilities Data engineering lead role for D&Ai data modernization (MDIP) Ideally Candidate must be flexible to work an alternative schedule either on tradition work week from Monday to Friday; or Tuesday to Saturday or Sunday to Thursday depending upon coverage requirements of the job. The can didate can work with immediate supervisor to change the work schedule on rotational basis depending on the product and project requirements. Responsibilities Manage a team of data engineers and data analysts by delegating project responsibilities and managing their flow of work as well as empowering them to realize their full potential. Design, structure and store data into unified data models and link them together to make the data reusable for downstream products. Manage and scale data pipelines from internal and external data sources to support new product launches and drive data quality across data products. Create reusable accelerators and solutions to migrate data from legacy data warehouse platforms such as Teradata to Azure Databricks and Azure SQL. Enable and accelerate standards-based development prioritizing reuse of code, adopt test-driven development, unit testing and test automation with end-to-end observability of data Build and own the automation and monitoring frameworks that captures metrics and operational KPIs for data pipeline quality, performance and cost. Collaborate with internal clients (product teams, sector leads, data science teams) and external partners (SI partners/data providers) to drive solutioning and clarify solution requirements. Evolve the architectural capabilities and maturity of the data platform by engaging with enterprise architects to build and support the right domain architecture for each application following well-architected design standards. Define and manage SLAs for data products and processes running in production. Create documentation for learnings and knowledge transfer to internal associates. Qualifications 12+ years of engineering and data management experience Qualifications 12+ years of overall technology experience that includes at least 5+ years of hands-on software development, data engineering, and systems architecture. 8+ years of experience with Data Lakehouse, Data Warehousing, and Data Analytics tools. 6+ years of experience in SQL optimization and performance tuning on MS SQL Server, Azure SQL or any other popular RDBMS 6+ years of experience in Python/Pyspark/Scala programming on big data platforms like Databricks 4+ years in cloud data engineering experience in Azure or AWS. Fluent with Azure cloud services. Azure Data Engineering certification is a plus. Experience with integration of multi cloud services with on-premises technologies. Experience with data modelling, data warehousing, and building high-volume ETL/ELT pipelines. Experience with data profiling and data quality tools like Great Expectations. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets. Experience with at least one business intelligence tool such as Power BI or Tableau Experience with running and scaling applications on the cloud infrastructure and containerized services like Kubernetes. Experience with version control systems like ADO, Github and CI/CD tools for DevOps automation and deployments. Experience with Azure Data Factory, Azure Databricks and Azure Machine learning tools. Experience with Statistical/ML techniques is a plus. Experience with building solutions in the retail or in the supply chain space is a plus. Understanding of metadata management, data lineage, and data glossaries is a plus. BA/BS in Computer Science, Math, Physics, or other technical fields. Candidate must be flexible to work an alternative work schedule either on tradition work week from Monday to Friday; or Tuesday to Saturday or Sunday to Thursday depending upon product and project coverage requirements of the job. Candidates are expected to be in the office at the assigned location at least 3 days a week and the days at work needs to be coordinated with immediate supervisor Skills, Abilities, Knowledge: Excellent communication skills, both verbal and written, along with the ability to influence and demonstrate confidence in communications with senior level management. Proven track record of leading, mentoring data teams. Strong change manager. Comfortable with change, especially that which arises through company growth. Ability to understand and translate business requirements into data and technical requirements. High degree of organization and ability to manage multiple, competing projects and priorities simultaneously. Positive and flexible attitude to enable adjusting to different needs in an ever-changing environment. Strong leadership, organizational and interpersonal skills; comfortable managing trade-offs. Foster a team culture of accountability, communication, and self-management. Proactively drives impact and engagement while bringing others along. Consistently attain/exceed individual and team goals. Ability to lead others without direct authority in a matrixed environment. Comfortable working in a hybrid environment with teams consisting of contractors as well as FTEs spread across multiple PepsiCo locations. Domain Knowledge in CPG industry with Supply chain/GTM background is preferred.

POSITION INFORMATION SUMMARY: The Senior Database Engineer (MS SQL) role is to perform job functions that support the advanced use of data and data structures within the organization, including development, maintenance, and basic DBA activities for all corporate databases. It is expected that the individual in this role use strong SQL skills to synthesize complex FineLine data structures for report writing, data warehouse development, and data transformations. Additionally, a key focus for this role is to ensure that databases are running optimally and to ensure high data availability to the end user. ESSENTIAL FUNCTIONS, DUTIES, & RESPONSIBILITIES: Database Design & Development: Design and develop database structures, including tables, views, indexes, and schemas. Write, debug, and maintain complex stored procedures, functions, and triggers. Create scalable database architectures to meet business and application needs. SQL Development & Optimization: Develop high-quality SQL queries and scripts to support application functionality and reporting needs. Optimize SQL code and stored procedures for speed and efficiency, particularly for large tables with millions of records. Monitor database code delivery to ensure performance and adherence to best practices. Performance Optimization: Perform query performance tuning, index optimization, and data model refinement. Utilize tools such as SQL Profiler, Execution Plans, etc. to troubleshoot performance issues. Data Warehousing & ETL: Design and implement data warehousing solutions using Star Schema and other methodologies. Develop, deploy, and maintain ETL/SSIS packages for data integration and transformation workflows. Best Practices & Security Standards: Implement and enforce coding best practices for SQL development. Ensure compliance with security standards to protect sensitive data and prevent vulnerabilities. Database Administration: Ensure database security, backups, and disaster recovery readiness. Set up and manage replication and high-availability solutions for critical databases. Collaboration & Troubleshooting: Collaborate with application development teams to integrate database solutions seamlessly. Diagnose and resolve database issues, ensuring system reliability and uptime. Delivers solutions in an agile, fast-moving work environment. Other duties and responsibilities as assigned POSITION TYPE/REQUIRED HOURS OF WORK: Full-time; provide 3 hours of coverage overlap with US EST time zone M-F Office Time: 12 PM to 9 PM IST Location: Perungudi, Chennai, India QUALIFICATIONS: Required: B. E/ B. Tech - Computer Major, M. E/ M. Tech - Computer Major, MCA 9 to 14 years of experience in MS SQL Server database development and administration. Proficiency in SQL programming, including writing and optimizing complex queries, stored procedures, and triggers. Hands-on experience in Data Warehousing and designing solutions using Star Schema. Proficient in ETL processes and SSIS package development. Solid experience in query performance tuning and database optimization techniques. Ability to monitor and optimize database code for large-scale data tables. Knowledge of database replication, high-availability setups, and disaster recovery planning. Familiarity with SQL Profiler, Execution Plans, and other performance analysis tools. Expertise in implementing coding standards and ensuring compliance with security best practices. Preferred: Experience in using source code control such as Subversion, GitHub Experience in Power BI report writing, managing data models, and user access Experience with designing and using Multi-Dimensional Data Models Technical Skills: MS SQL Server, Complex SQL Queries, Stored Procedures, Triggers, SQL Profiler, Execution Plans, Data Warehousing, Star Schema, ETL, SSIS Packages, Index Optimization, Database Replication, High-Availability Solutions, Performance Tuning, Database Security, T-SQL Scripting, PowerShell, Azure SQL, SSRS, Agile

Seeking experience in C#, .NET, MVC, SQL, and reporting tools (SSRS, Tableau). Develop scalable reports, optimize SQL queries, and enhance business processes with digital solutions.

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : Microsoft SQL Server Analysis Services (SSAS) Good to have skills : Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services, No Function Specialty Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will analyze, design, code, and test multiple components of application code across one or more clients. You will perform maintenance, enhancements, and/or development work. Your typical day will involve analyzing requirements, designing solutions, writing code, and conducting testing to ensure the quality of the application. You will collaborate with team members, participate in code reviews, and contribute to the overall success of the project. Roles & Responsibilities: Expected to be an SME, collaborate and manage the team to perform. Responsible for team decisions. Engage with multiple teams and contribute on key decisions. Provide solutions to problems for their immediate team and across multiple teams. Analyze requirements and design solutions for application components. Write high-quality code following coding standards and best practices. Conduct unit testing and participate in code reviews to ensure code quality. Collaborate with team members to troubleshoot and resolve issues. Contribute to the overall success of the project by meeting project milestones and deliverables. Professional & Technical Skills: Must To Have Skills:Proficiency in Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services. Strong understanding of database concepts and SQL query optimization. Experience in designing and developing data models using Microsoft SQL Server Analysis Services (SSAS). Hands-on experience in writing complex SQL queries and stored procedures. Experience in performance tuning and optimization of SQL queries. Good To Have Skills:Experience with data visualization tools such as Tableau or Power BI. Solid grasp of data munging techniques, including data cleaning, transformation, and normalization to ensure data quality and integrity. Additional Information: The candidate should have a minimum of 5 years of experience in Microsoft SQL Server Analysis Services (SSAS). This position is based in Mumbai. A 15 years full-time education is required. Qualifications 15 years full time education

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Oracle Procedural Language Extensions to SQL (PLSQL) Good to have skills : NA Minimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will be responsible for designing, building, and configuring applications to meet business process and application requirements. Your typical day will involve collaborating with team members to develop innovative solutions and ensure seamless application functionality. Roles & Responsibilities: Expected to perform independently and become an SME. Required active participation/contribution in team discussions. Contribute in providing solutions to work related problems. Develop and implement efficient PLSQL code for application functionalities. Collaborate with cross-functional teams to analyze and address application requirements. Optimize application performance through effective PLSQL coding practices. Conduct thorough testing and debugging of PLSQL code to ensure application reliability. Provide technical guidance and support to junior team members. Professional & Technical Skills: Must To Have Skills:Proficiency in Oracle Procedural Language Extensions to SQL (PLSQL). Strong understanding of database concepts and SQL optimization techniques. Experience in performance tuning and query optimization. Hands-on experience in developing complex PLSQL procedures, functions, and triggers. Knowledge of Oracle database architecture and data modeling. Additional Information: The candidate should have a minimum of 3 years of experience in Oracle Procedural Language Extensions to SQL (PLSQL). This position is based at our Coimbatore office. A 15 years full time education is required. Qualifications 15 years full time education

Overview We are PepsiCo PepsiCo is one of the world's leading food and beverage companies with more than $79 Billion in Net Revenue and a global portfolio of diverse and beloved brands. We have a complementary food and beverage portfolio that includes 22 brands that each generate more than $1 Billion in annual retail sales. PepsiCo's products are sold in more than 200 countries and territories around the world. PepsiCo's strength is its people. We are over 250,000 game changers, mountain movers and history makers, located around the world, and united by a shared set of values and goals. We believe that acting ethically and responsibly is not only the right thing to do, but also the right thing to do for our business. At PepsiCo, we aim to deliver top-tier financial performance over the long term by integrating sustainability into our business strategy, leaving a positive imprint on society and the environment. We call this Winning with Purpose . For more information on PepsiCo and the opportunities it holds, visit . What Data Engineers in PepsiCo Data and AI team do: Maintain a predictable, transparent, global operating rhythm that ensures always-on access to high-quality data for stakeholders across the company Responsible for day-to-day data extraction, load and transformation of PepsiCos corporate data assets Work cross-functionally across the enterprise to centralize data and standardize it for use by business, data science or other stakeholders Increase awareness about available data and democratize access to it across the company Senior Data Engineer: As a Senior Data Engineer, you will be the key technical expert developing and overseeing PepsiCo's data product build & operations and drive a strong vision for how data engineering can proactively create a positive impact on the business. You will be an empowered member of a team of data engineers who build data pipelines, ingest data into the PepsiCo Data Lake, and enable exploration and access for analytics, visualization, machine learning, and product development efforts across the company. Responsibilities Active contributor to code development in projects and services Manage and scale data pipelines from internal and external data sources to support new product launches and drive data quality across data products Build and own the automation and monitoring frameworks that captures metrics and operational KPIs for data pipeline quality and performance Responsible for implementing best practices around systems integration, security, performance and data management Empower the business by creating value through the increased adoption of data, data science and business intelligence landscape Collaborate with internal clients (data science and product teams) to drive solutioning and PoC discussions Evolve the architectural capabilities and maturity of the data platform by engaging with enterprise architects and strategic internal and external partners Define and manage SLAs for data products and processes running in production Support large-scale experimentation done by data scientists Develop and optimize procedures to productionalize data science models Prototype new approaches and build solutions at scale Research in state-of-the-art methodologies Create documentation for learnings and knowledge transfer Create and audit reusable packages or libraries Preferred exp working with Master data. Qualifications 10+ years of overall technology experience that includes at least 4+ years of hands-on software development, data engineering, and systems architecture 4+ years of experience with Data Lake Infrastructure, Data Warehousing, and Data Analytics tools 4+ years of experience in SQL optimization and performance tuning , and development experience in programming languages like Python, PySpark etc.) 2+ years in cloud data engineering experience in Azure Experience with Azure Data Factory, Azure Databricks and Azure Machine learning tools Fluent with Azure cloud services. Azure Certification is a plus Experience with integration of multi cloud services with on-premises technologies Experience with data modeling, data warehousing, and building high-volume ETL/ELT pipelines Experience with data profiling and data quality tools like Apache Griffin, Deequ, and Great Expectations Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets Experience with at least one MPP database technology such as Databricks, Redshift or SnowFlake Experience with running and scaling applications on the cloud infrastructure and containerized services like Kubernetes Experience with version control systems like Github and deployment & CI tools Proven track record of leading, mentoring data teams.

SAP HANA DB Modeler/Developer" is responsible for designing, developing, and maintaining data models within the SAP HANA database, utilizing advanced modeling techniques to optimize data access and analysis for reporting and applications, often collaborating with business analysts to translate requirements into efficient database structures while ensuring data integrity and performance within the HANA platform. Must have skills should includeHana Views( Analytical, Calculation etc.) , SAP HANA XS JavaScript and XS OData services, Advanced DB Modelling for Hana, SAP HANA Data Services ETL based Replication amongst others. Minimum 2 3 end to end implementations. Key responsibilities may include Data Modeling Designing and creating complex data models in SAP HANA Studio using analytical views, attribute views, calculation views, and hierarchies to represent business data effectively. Implementing data transformations, calculations, and data cleansing logic within the HANA model. Optimizing data structures for fast query performance and efficient data access. Development Writing SQL scripts and stored procedures to manipulate and retrieve data from the HANA database. Developing custom HANA functions (CE functions) for advanced data processing and calculations. Implementing data loading and ETL processes to populate the HANA database. Performance Tuning Analyzing query performance and identifying bottlenecks to optimize data access and query execution. Implementing indexing strategies and data partitioning for improved query performance. Collaboration Working closely with business analysts to understand data requirements and translate them into technical data models. Collaborating with application developers to integrate HANA data models into applications. Security and Governance Implementing data security measures within the HANA database, defining user roles and permissions. Maintaining data quality and consistency by defining data validation rules. Required Skills: Technical Skills: Strong understanding of relational database concepts and data modeling principles. Expertise in SAP HANA modeling tools and features (HANA Studio, Calculation Views, Analytical Views) Proficiency in SQL and SQL optimization techniques Knowledge of data warehousing concepts and best practices Soft Skills: Excellent analytical and problem solving abilities Strong communication skills to collaborate with business users and technical teams Ability to work independently and as part of a team

3 years professional application development experience on PLSQL - Strong skills in Oracle PLSQL. - Good understanding of RDBMS Concepts, SQL optimization. - Good understanding of the Linux/Unix OS commands. - Strong verbal and written communication skills - Passion for technology Nice to have (would be given preference) : - Work experience in an Investment Bank or Financial Services domain. - Exposure to Python, C++ - Work experience on LINUX.

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : SAP Native HANA SQL Modeling & Development Good to have skills : NA Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will design, build, and configure applications to meet business process and application requirements. Your day will involve creating innovative solutions to address complex business challenges and collaborating with cross-functional teams to deliver high-quality applications. Roles & Responsibilities: Expected to be an SME Collaborate and manage the team to perform Responsible for team decisions Engage with multiple teams and contribute on key decisions Provide solutions to problems for their immediate team and across multiple teams Lead the development and implementation of SAP Native HANA SQL models Optimize and enhance existing SQL models for improved performance Conduct code reviews and ensure adherence to best practices Professional & Technical Skills: Must To Have Skills:Proficiency in SAP Native HANA SQL Modeling & Development Strong understanding of database concepts and SQL optimization Experience in data modeling and designing complex data structures Hands-on experience with SAP HANA Studio and SAP HANA Cloud Platform Knowledge of performance tuning and query optimization techniques Additional Information: The candidate should have a minimum of 5 years of experience in SAP Native HANA SQL Modeling & Development This position is based at our Pune office A 15 years full-time education is required Qualifications 15 years full time education

Role & Responsibilities: Experience: 5+ years in ETL development using Informatica and SQL . Design, develop, and maintain ETL workflows using Informatica PowerCenter . Perform data extraction, transformation, and loading (ETL) from various sources into data warehouses. Develop and optimize SQL queries, stored procedures, views, and indexing for performance tuning. Ensure data integrity, consistency, and accuracy in all ETL processes. Collaborate with business analysts, data engineers, and stakeholders to define project requirements. Monitor, debug, and troubleshoot ETL failures and performance bottlenecks . Document all ETL processes, data flows, and technical specifications . Primary Skills: Informatica PowerCenter ETL Development & Data Integration SQL Development – Queries, Stored Procedures, Performance Optimization Data Warehousing & Data Modeling Talend (Good to Have) ETL Performance Tuning & Debugging Preferred Candidate Profile: Experience: 5+ years in ETL development using Informatica and SQL . Education: Bachelor’s or Master’s degree in Computer Science, IT, or related fields . Candidate Skills: Strong communication skills and ability to work in a collaborative team environment . Availability: Immediate joiners preferred . Perks and Benefits: Competitive salary package. Opportunity to work on challenging and innovative data projects . Career growth in a fast-growing technology-driven organization . Work from Office environment in Vijayawada .

The Senior Postgre SQL DBA would need to have at least 3 years of experience with development and customer support, providing technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, and optimizing. PostgreSQL database cloning by using Pg_dump and Pg_Restore. Review all PostgreSQL logs and problems. Experience with Postgres Connection Pooling (PgBouncer). Hands-on operational DBA expertise in the areas of Replication, High Availability and Backup/Recovery. Advanced performance-tuning skills to review performance data and prepare reports. SQL and Linux scripting skills are required skills. Strong communication skills are a requirement for this position. Ability to manage customer or in-house escalation calls is required Experience working on an Application/Development team or experience as an Application DBA. Responsible for managing Development, QA, Staging and Production databases and applications and implementing future enhancements to meet the business needs of the end users. Monitor database health - availability, reliability, performance, capacity planning. Upgrading PostgreSQL Databases. Responsible for the monitoring and uptime of all production databases. Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage. Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime. Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release. Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving). Responsible for pro-active remediation of database operational problems. Participate in a 247 support rotation. Support complex web-based applications. Automatic Switchover & Failover.

Job Title: Finacle Developer Location: Bangalore Employment Type: Full-time Experience: 3+ years Job Summary: We are looking for a skilled Finacle Developer to join our team. The ideal candidate should have expertise in Finacle customization, scripting, integration, and troubleshooting to enhance banking applications. The role involves working closely with business stakeholders and technical teams to implement and support Finacle solutions. Key Responsibilities: Develop, customize, and enhance Finacle core banking solutions. Work on Finacle scripting, customization, and integration with other banking applications. Design, develop, and maintain Finacle reports, menus, and scripts using Finacle Scripting (IFS, TBA, CRM, Extensibility). Support and troubleshoot issues related to Finacle applications, databases, and related integrations. Develop and optimize PL/SQL procedures, triggers, and functions in Oracle databases. Collaborate with business analysts and stakeholders to gather requirements and implement changes. Ensure compliance with banking security, risk, and compliance policies while developing Finacle solutions. Provide post-implementation support, performance tuning, and enhancements for Finacle applications. Work with APIs and middleware for third-party integrations. Document technical specifications, solutions, and troubleshooting guidelines Required Skills & Qualifications: Experience in Finacle 10.x / Finacle 11.x versions with customization and implementation. Strong knowledge of Finacle scripting (IFS, TBA, CRM, Extensibility Framework). Proficiency in PL/SQL, Oracle SQL, and database management. Experience in API development and integration (REST/SOAP). Hands-on experience with Unix/Linux shell scripting. Strong debugging and troubleshooting skills in Finacle application issues. Experience with handling EOD/BOD (End of Day/Beginning of Day) batch processes. Understanding of banking domain processes and compliance. Good problem-solving skills and ability to work under pressure. Education: Bachelor's or Master's degree in Computer Science, Information Technology, or related fields.

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : Microsoft SQL Server Analysis Services (SSAS) Good to have skills : Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services, No Function Specialty Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will analyze, design, code, and test multiple components of application code across one or more clients. You will perform maintenance, enhancements, and/or development work. Your typical day will involve analyzing requirements, designing solutions, writing code, and conducting testing to ensure the quality of the application. You will collaborate with team members, participate in code reviews, and contribute to the overall success of the project. Roles & Responsibilities: Expected to be an SME, collaborate and manage the team to perform. Responsible for team decisions. Engage with multiple teams and contribute on key decisions. Provide solutions to problems for their immediate team and across multiple teams. Analyze requirements and design solutions for application components. Write high-quality code following coding standards and best practices. Conduct unit testing and participate in code reviews to ensure code quality. Collaborate with team members to troubleshoot and resolve issues. Contribute to the overall success of the project by meeting project milestones and deliverables. Professional & Technical Skills: Must To Have Skills:Proficiency in Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services. Strong understanding of database concepts and SQL query optimization. Experience in designing and developing data models using Microsoft SQL Server Analysis Services (SSAS). Hands-on experience in writing complex SQL queries and stored procedures. Experience in performance tuning and optimization of SQL queries. Good To Have Skills:Experience with data visualization tools such as Tableau or Power BI. Solid grasp of data munging techniques, including data cleaning, transformation, and normalization to ensure data quality and integrity. Additional Information: The candidate should have a minimum of 5 years of experience in Microsoft SQL Server Analysis Services (SSAS). This position is based in Mumbai. A 15 years full-time education is required. Qualifications 15 years full time education