1827 Stored Procedures Jobs - Page 37

Skill-MSBI/ms sql SSIS Location-Bangalore Experince- 4 years to 9 Years JD with must have skill Must Have: TSQL, SSIS , SSRS or Informatica PC and Data warehousing Good to have : Snowflake Good knowledge of T-SQL, including the ability to write stored procedures, views, functions etc.. Good experience in designing ,developing, unit testing and implementation of data integration solutions using ETL in SSIS and SSRS reporting platform Experience with data warehousing concepts and enterprise data modeling techniques Good knowledge of relational and dimensional database structures, theories, principles and best practices Conduct thorough analysis of existing MSBI (Microsoft Business Intelligence) legacy applications and Informatica PC Identify and document the functionalities, workflows, and dependencies of legacy systems Create detailed mapping specifications for data integration and transformation processes Collaborate with business stakeholders/architects and data modelers to understand their needs and translate into technical documentation Ensure accurate documentation of data sources, targets, and transformation rules Perform data validation, cleansing, and analysis to ensure data accuracy and integrity Update the Design documents after successful code changes and testing Provide Deployment support Possess good knowledge of Agile and Waterfall methodologies Requirements: Bachelors degree in computer science, Engineering, or a related field Highly skilled at handling complex technical situations and have exceptional verbal and written communication skills 5+ years experience with understanding of data lifecycle, governance, and migration processes 5+ years experience with SSIS, SSRS (or Informatica PC) and MS SQL Server, TSQL 5+ years experience with Data Warehouse technologies 3+ years experience with Agile methodologies (Scrum, Kanban, JIRA) Nice to have experience in wealth management domain

Greetings from IDESLABS !!! This is U. Prabhu Teja IT Recruiter, As Discussed, I am processing your profile for Contract to HirePosition for CAPGEMINI. PAYROLLIDESLABS Roles and Responsibilities :- Design, develop, and optimize SQL Server databases, stored procedures, functions, and triggers. Ensure database performance optimization and troubleshoot performance issues. Analyse complex data sets to meet business requirements. Develop and maintain reports, dashboards, and data visualizations Support ETL processes to extract, transform, and load data across systems Maintain and improve existing ETL processes to ensure data integrity and accuracy. Collaborate with business analysts and stakeholders to gather and understand requirements. Document database processes, data flows, and architecture. Perform regular database maintenance, backups, and recovery procedures. Monitor and manage database performance and availability. Roster support during weekends to support ETL Runs. Generate Adhoc reports to support Incidents and Product teams analysis Interseted can share profile for prabhu@ideslabs.com Thanks & Regards -------------------------------------------------------------------------- | Prabhu Teja| Recruitment | IDESLABS (P) LTD | Hyderabad | | M+ 91 9949412703 | Email

Expert knowledge in T-SQL and SQL. Programming Writing scalable code using T-SQL and ability to run them on various platforms. Good to have Automation and T-SQL Performance optimization experience. Knowledge in Testing and debugging of T-SQL based applications. Hands-on experience on Python language etc. Assessing and prioritizing client feature requests. Coordinating with development teams to determine application requirements. Working independently and collaboratively. Also, provide status updates to stakeholders and escalates issues when necessary. Work with Agile methodology, representing the PoD in meetings and various forums. Providing scripted solutions to unique scenarios. To be successful in this role, you should meet the following requirementsMS-SQL (T-SQL, SQL) - need to have strong knowledge in writing Stored procedures, views, tables etc and good understanding of the same. Python with strong knowledge Interest in Learning new Technologies Proactive in identifying the issues and get ready with the fixes Exposure to the software development lifecycle and agile software practices from specification, development, Quality Assurance, release Strong work ethics and team player Good communication skills intersted can share CV to prabhu@ideslabs.com

Must have strong BY WMS Architecture knowledge to provide the best possible design to the customer. Must be well conversant with Oracle databases - SQLqueries, stored procedures Must be an expert in providing support for BY WMS Project estimations. Must be capable of training and mentoring team members to improve techno-functional capability of the team Must plan and build the environments for testing BY WMS and the interfaces of ERP. Building the Cloud test environments to match with on-premises file structure and making sure to use the same database names and supporting Business users. Validate the Control M jobs running to move the data between ERP and BY WMS and feeding the planned data from WMS to ERP. Manage the DB refreshes on Cloud environments with on-premises production database to continue SIT (system Integration testing) and UAT Set up the Virtual IP (VIP setup) for authentication and working with Network team for the setup and configuration for BY portal setup Work on Cutover plan for go live and support the users after go live during the Hypercare period Work with Application Managed Services team to support BY WMS application after go-live.

Looking for 4 to 6 years of extensive experience in informatica power center.Strong hands on experience in advance SQL and RDBMS conceptsGood hands on experience in Unix and shell scriptinggood understanding of data warehousing conceptsexcellent problem solving skillsgood communication skillsgood analytical skills.

Skills AS400 Developer Experience 5+ Years Location PAN INDIA Job type Contract to Hire Pay roll company Work Model Hybrid - 1.AS400 Developer , Cobol , Rpgle , SQLExperience. Must to Have 5 to 6 years Hands on Experaince in AS400 using the below skills - Programming Background in IBM iSeries (AS400), Cobol/400, RPG ILE, RPGLE & SQLRPG - Excellent Skills in DB2 SQL/query language and debugging - Have the knowledge of writing complex queries - Good analytical and communication skills - Must have strong team and interpersonal Skills and the ability to multi task when required - Adept at delivering high quality software documentation with high attention to detail required - High analytical Skills and a high degree of initiative and flexibility - High customer orientation and quality awareness - Excellent verbal and written communication skills Nice to Have Core Banking Experience

Job Details: Skill: SAP ABAP Notice Period: Immediate Joiners Employee type : C2H/FT Minimum 4 to 6 Years of SAP ABAP experience with both implementation and support knowledge. Good debugging knowledge and experience in advanced debugger is preferred. Interfaces (IN&OUT, file based interfaces) and interface file handling and IDOCS BAPIs and RFCs Jobs handling (scheduling, job failures handling) Reports, BDC & Session Failures Smartform & Scripts Enhancements and job scheduling and error handling knowledge Understanding of SAP SD MM process would be preferred Should be flexible to follow Singapore (working from Monday to Friday) & Middle EAST (working from Sunday to Thursday) working calendar. Where holidays will be in sync with the respective country calendars. Flexible to work in Morning shift General shifts Able to support Month end activity along with Functional member Experience in atleast one implementation project Should have good oral and written communication skills Should have working experience with overseas customer (If worked with any Eastern countries is a welcome) Should have good attitude and team bonding and a good team player Should have good analytical skills, taking ownership and self learning exploring capabilities to reduce dependency on others and working independently Should be able to take up on-call Support which will be given on rotational basis and as per roster As we are supporting East side and SG region and Dubai region, should be willing to work in any shift: 7:30 AM to 4:30 PM shift or 1:30 PM to 10:30 PM shift (all hours in IST) as per roster.

Job Details: Skill: Alteryx Notice Period: Immediate Joiners Employee type : C2H Technical skill requirements Hands-on experience in Axiom, Alteryx or equivalent reporting and automation tools Experience in regulatory reporting, especially in HKMA, is a strong advantage Experience working independently with business users in defining requirements, testing, and supporting UAT Experience in building finance BI reports is a plus Strong knowledge of SQL and ability to develop complex queries Job Qualification (education, years of experience and other soft skills) Information Technology-related Bachelor or Masters degree 5+ years experience in Banking and Financial Institution Good communication and interpersonal skills, ability to interact with users across APAC Strong analytical mindset and problem-solving skills Ability to multi-task, organize and prioritize work Main responsibilities and duties of the role To assist in the implementation of regulatory reporting tool (Axiom) for Hong Kong Branch To assist in the liaison with vendor and users on user requirements, data mapping, technical specifications, and documentations To assist in building different regulatory and BI reports for business users using multiple tools To automate and streamline existing reporting flows using multiple tools To work with strict deadlines on high priority regulatory reports To be responsible for IT testing and UAT support To assist with analysis of root cause if there are any incidents on the reports automation tools.

MS-SQL (T-SQL, SQL) who need to have strong knowledge in writing Stored procedures, views, tables etc and good understanding of the same Python with strong knowledge Interest in Learning new Technologies Proactive in identifying the issues and ready with the fixes Exposure to the software development lifecycle and agile software practices from specification, development, Quality Assurance, release Strong work ethic and team player Good communication skills

Must Have TSQL, SSIS , SSRS or Informatica PC and Data warehousing Good to have Snowflake Good knowledge of T-SQL, including the ability to write stored procedures, views, functions etc.. Good experience in designing ,developing, unit testing and implementation of data integration solutions using ETL in SSIS and SSRS reporting platform Experience with data warehousing concepts and enterprise data modeling techniques Good knowledge of relational and dimensional database structures, theories, principles and best practices Conduct thorough analysis of existing MSBI (Microsoft Business Intelligence) legacy applications and Informatica PC Identify and document the functionalities, workflows, and dependencies of legacy systems Create detailed mapping specifications for data integration and transformation processes Collaborate with business stakeholders/architects and data modelers to understand their needs and translate into technical documentation Ensure accurate documentation of data sources, targets, and transformation rules Perform data validation, cleansing, and analysis to ensure data accuracy and integrity Update the Design documents after successful code changes and testing Provide Deployment support Possess good knowledge of Agile and Waterfall methodologies Requirements Bachelors degree in computer science, Engineering, or a related field Highly skilled at handling complex technical situations and have exceptional verbal and written communication skills 5+ years experience with understanding of data lifecycle, governance, and migration processes 5+ years experience with SSIS, SSRS (or Informatica PC) and MS SQL Server, TSQL 5+ years experience with Data Warehouse technologies 3+ years experience with Agile methodologies (Scrum, Kanban, JIRA) Nice to have experience in wealth management domain

Technical Skills: Must have experience on Life Admin Systems/ Life Insurance, Annuity products Must have min 5 years of experience in Vantage/RPS Min 5 years of experience in development of policy administration system (COBOL) Min 5 years of experience in development/maintenance and Support projects of Mainframe preferably Cobol, VSAM and DB2 . Min 5 yrs of experience in SQL Must have good knowledge of Policy Administration System design and architecture Should be expert in COBOL-DB2, COBOL-VSAM programming Should be capable of working on stored procedures Should be capable of debugging complex scenarios Should be able to work and deliver independently Must be aware of new technologies and market updates with respect to Life and Annuity business Having Life insurance certifications such as LOMA will be added advantage Good to have CICS working knowledge

Select, Filter (WHERE), group Joins Aggregate, Qualify, Roll-up and Drill-down SQl to extract report by joining facts and dimension data Advance SQL Query Otimisation stored procedures, user-defined functions window functions for complex data manipulation Row_number, Rank,. Dense_Rank LEAD, LAG Snowflake features Snowflake Architecture Cloud Computing and Infrastructure (cloud platforms like AWS, Azure, and GCP, where Snowflake can be deployed.) Data Modeling Database Security and Access Control Metadata Management Time-travel Zero copy cloning Data Pipeline Automation - Snowpipe

Job Title: .NET Core Developer Experience: 5+ Years Location: Kochi (On-site/Hybrid based on company policy) Job Description: We are looking for a skilled .NET Core Developer with 5+ years of experience in building scalable web applications and APIs. The ideal candidate should have strong expertise in C#, .NET Core, Entity Framework, and SQL Server, with a solid understanding of RESTful services and design patterns. Key Skills: .NET Core, C#, ASP.NET MVC Entity Framework, LINQ SQL Server, Stored Procedures REST APIs, Web Services JavaScript, HTML, CSS (basic front-end knowledge) Git, Agile Methodologies Nice to Have: Experience with Azure or AWS Knowledge of Microservices architecture

Develop and maintain database applications using PL/SQL, focusing on stored procedures, triggers, and database performance optimization. Work with teams to integrate database solutions into broader application frameworks.

Develop and maintain Oracle PL/SQL code, including stored procedures, functions, and triggers. Work on data extraction, transformation, and optimization for large-scale Oracle database applications.

Develop and maintain Oracle databases, writing efficient SQL queries and PL/SQL scripts. Focus on performance tuning, data integrity, and ensuring seamless data integration within enterprise systems.

Design and develop database solutions using PL/SQL and MySQL. You will optimize queries, handle data manipulation, and ensure high performance of database operations. Expertise in PL/SQL and MySQL is required.

Develop and maintain SQL Server Reporting Services (SSRS) reports and ASP.NET web applications. You will manage data, create reports, and optimize performance. Expertise in SQL Server and ASP.NET is required.

Design, implement, and maintain Oracle SQL queries and database objects. Optimize database performance, conduct data analysis, and ensure data integrity in Oracle-based systems.

Job Summary We are seeking a skilled and experienced Hadoop, PL/SQL, SQL Database Developer to join our team. In this role, you will be responsible for developing and maintaining Hadoop-based solutions, writing PL/SQL code, and managing SQL, DB2 databases. You will work closely with cross-functional teams to design, develop, and optimize data processing pipelines and database systems JOB REQUIREMENT 5+ years of relevant professional experience. Strong experience in Hadoop ecosystem, including HDFS, MapReduce, Hive, and Spark. Proficiency in PL/SQL programming and SQL database development. Solid understanding of data modelling concepts and database design principles. Experience with performance tuning and optimization of SQL queries and database systems. Experience in Unix Scripting. Familiarity with data integration and ETL processes. Excellent problem-solving and analytical skills. Strong Communication and collaboration abilities.

3+ years of PLSQL Proficiency. A PLSQL Developer must have a strong command of PLSQL to write, optimize,troubleshoot queries. Must have an expertise in Database Design,Data Modeling,Performance Tuning,Stored Procedures,Security Management. Required Candidate profile Develop and maintain PLSQL databases & applications. Write and optimize PLSQL queries and scripts. Stay updated with the latest PLSQL technologies Conduct data analysis. Perks and benefits To be informed post interview

ob Title: - Dot net developer Gurgaon Job 5Days working Responsibilities:- IT experience in Microsoft .Net & MVC platform Candidate should be able to use technical skills (e.g. database techniques) and develop skills related to the .Net MVC platform End to end (Front end, APIs, and Database) Ability to leverage breadth of experience and knowledge and design solutions for the given requirement Familiar with scrum & agile development methodology Should have experience in one or more of the following development disciplines: estimation, analysis, programming, test and utilization of test tools, performance tools, change processes, and application architecture Ability to perform in programming, design, and documentation Ability to convert business requirements into a design Manages the technical rollout and post- deliverable technical strategy Participate in code review Experience in Integration patterns and associated best practices (e.g. Web Services, REST, Pub/Sub, MOM) .Net framework & MVC Database knowledge including writing stored procedure Hands-on experience on the following: C#, ASP.NET MS SQL Server or any other database JavaScript, Jquery, Jquery UI Angular JS , Rest API & Web API WCF TFS/ VSTS or other configuration tools HTML, CS

Dear Candidates We have Requirement Dot Net Team Lead Position Gurgaon Location Remote Work Exp. 5+ Years IT experience in Microsoft .Net & MVC platform Must have worked on Visual Studio, ASP.Net, My SQL database In-depth knowledge of MVC, Angular JS, Microsoft Technologies like WindowsService,WindowsForms,ASP.Net is preferred Familiar with scrum & agile development methodology Should have experience in one or more of the following development disciplines: estimation, analysis, programming, test and utilization of test tools, performance tools, change processes, and application architecture Ability to perform in programming, design, and documentation Ability to convert business requirements into a design Manages the technical rollout and post- deliverable technical strategy Participate in code review Experience of Integration patterns and associated best practices (e.g. Web Services, REST, Pub/Sub, MOM) .Net framework & MVC Database knowledge including writing stored procedure Hands-on experience on the following: C#, ASP.NET MS SQL Server or any other database JavaScript, Jquery, Jquery UI Angular JS , Rest API & Web API WCF Soft Skills good listening, verbal and non-verbal communication and written communication skills Cooperation and Coordination with Other Teams-Team Player Good observing, analyzing, logical reasoning, brainstorming and decision-taking skills Planning and Adhering to Timelines Persistent and Hard-Working Benefits: Work from Home option can be availed by Employee after discussing with Manager Medical Insurance provided to all employees OD Allowances provided in case of site-visits

Job Title: SQL Developer Location: Airoli, Navi Mumbai. Experience: 6+ Years Notice Period : 10 to 15 Days Job Description: We are seeking an experienced SQL Developer with strong expertise in Stored Procedures, SQL Tuning, and Database Design. The ideal candidate will have hands-on experience working with complex Joins, Functions, and Triggers, ensuring optimal performance and data integrity across systems. Key Responsibilities: Design, develop, and maintain Stored Procedures, Functions, and Triggers. Optimize SQL queries through effective SQL Tuning techniques. Work on complex Joins to support business logic and reporting needs. Contribute to logical and physical DB Design for new and existing applications. Collaborate with developers and analysts to understand requirements and deliver scalable database solutions. Ensure database performance, integrity, and security. Required Skills: Strong proficiency in SQL and relational database concepts. In-depth knowledge of Stored Procedures, Functions, and Triggers. Experience with SQL Tuning and performance optimization. Excellent understanding of Joins (Inner, Outer, Cross, etc.). Hands-on experience in DB Design, including normalization and indexing strategies. Thanks & Regards Chetna Gidde | HR Associate-Talent Acquisition | chetna.gidde@rigvedit.com |

We are looking for a highly motivated and skilled Dot Net Junior Developer to join our team at IDESLABS PRIVATE LIMITED. The ideal candidate will have 0 to 1 years of experience in the field. Roles and Responsibility Design, develop, and test software applications using .Net technologies. Collaborate with cross-functional teams to identify and prioritize project requirements. Develop high-quality, reliable, and scalable code. Troubleshoot and resolve technical issues efficiently. Participate in code reviews and contribute to improving overall code quality. Stay updated with industry trends and emerging technologies. Job Requirements Proficiency in .Net development frameworks and technologies. Strong understanding of software development principles, patterns, and practices. Excellent problem-solving skills and attention to detail. Ability to work collaboratively in a team environment. Strong communication and interpersonal skills. Familiarity with agile development methodologies and version control systems. For more information, please contact us at 6578430.