27+ PL/SQL Jobs in Pune | PL/SQL Job openings in Pune

KEY RESPONSIBILITIES

·      Develop high-quality database solutions.

·      Use T-SQL to develop and implement procedures and functions.

·      Review and interpret ongoing business report requirements.

·      Research required data.

·      Build appropriate and useful reporting deliverables.

·      Analyze existing SQL queries for performance improvements.

·      Suggest new queries.

·      Develop procedures and scripts for data migration.

·      Provide timely scheduled management reporting.

·      Investigate exceptions with regard to asset movements.

MUST-HAVES FOR THIS GIG

T-SQL, Stored Procedure, Functions, Triggers, XML Operations, JSON support on SQL 2016 and above SSIS, SSRS, CTE, EAV Data structure, Integration with NoSQL(MongoDB), SQL Server Indexes, Bulk Insert, BCP, CMD Shell ,Memory Optimization, Performance Tunning, Query Optimization, Database Designing, Table Joins, SQL Server Job agent

Backup and Maintenance plan ,Data Migration, Good Communication

NICE-TO-HAVES FOR THIS GIG:

• Working knowledge of mobile development activity.
• Working knowledge of web hosting solution on IIS7.

Experience working with an offshore –onsite development process 

.NET C# developer provides custom web application development using the .NET Framework, C#, http://VB.NET">VB.NET, http://ASP.NET">ASP.NET, SQL Server and other advanced components of Microsoft technology and provide training to programmer analysts who support the web services manager' responsibilities.

Responsibilities:

 The tool development also involves working with SQL queries and web front end

Designing, developing, and testing web applications with .Net HTML, CSS and other technologies

Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office )

Manages the architecture, design, and coding of software for TFI from concept to finished product, in order to answer the needs of the Strategies, Sales, and Trading departments

Consults with end users within the Strategies, Sales, and Trading departments to identify where technology can automate current processes to enhance revenues and cut cost

Maintains currency in technical skills and all relevant fixed income industry sector factors

May lead the work of others and provide ideas which help to enhance TFI software applications

Software design & development principles such as SOLID, Domain-Driven-Design and Object-Oriented Development

ORM frameworks, particularly the Entity Framework

• Over all 2-4 years’ experience in Inventory Management System and customization with third party systems,
• Atleast 2  years of hands on experience in Cramer 8 or Above version and customisations using Cramer integrations.
• Java/PL SQL Development hands on experience.

• 4-15 year experience in Application Support
• Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
• Good to have knowledge in Agile, JIRA, Splunk, Service Now
• Good understanding and hands-on experience in Incident, Problem and Change Management
• Provide technical leadership to the team & contribute in the skill development within team
  Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities
• Good communications skills are necessary, must be team player and inquisitive.
• Strong customer service and support focus with a desire to deliver a high-quality service
• Ability to multi-task, work under pressure and to tight deadlines
• Flexible in working outside of office business hours at short notice (as required)
• Should be able to examine the system and identify the areas for Service Improvements & Value adds.

Job Description:
7+ years of experience as a Techno-Functional specialist supporting a finance organization with an emphasis on project management.

Must have 2-3 Project implementation and more than one support experience in Oracle EBS R12.

Expert level knowledge of Oracle Applications Framework, Oracle Workflow, Oracle Forms, Oracle Report, XML Report, PLSQL

Functional knowledge in financial module like, GL,AP, AR PO, Project is must Extensive use of oracle APIs and interfaces Experience in performance tuning of the code Experience in shell scripting.

Worked on Oracle Alert, AME, OAM ,DFF etc Good to have ADF experience Good to have ORDS experience Good to have exposure in cloud technology.

Responsibilities:
Act as a senior liaison between Business partners and IT communities Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, design, development, testing, training, and deployment.

Create technical designs to support business requirements.

Lead the development of technical solutions. Communicate project status and escalate issues to management. Develop and execute system test plans and scenarios.

Assist in preparing training materials for deployment of applications, modules, enhancements and bug fixes.

Assist in developing baseline datasets and reports to support testing of technical solutions.

Job Role : Associate Manager (Database Development)

Key Responsibilities:

• Optimizing performances of many stored procedures, SQL queries to deliver big amounts of data under a few seconds.
• Designing and developing numerous complex queries, views, functions, and stored procedures
• to work seamlessly with the Application/Development team’s data needs.
• Responsible for providing solutions to all data related needs to support existing and new
• applications.
• Creating scalable structures to cater to large user bases and manage high workloads
• Responsible in every step from the beginning stages of the projects from requirement gathering to implementation and maintenance.
• Developing custom stored procedures and packages to support new enhancement needs.
• Working with multiple teams to design, develop and deliver early warning systems.
• Reviewing query performance and optimizing code
• Writing queries used for front-end applications
• Designing and coding database tables to store the application data
• Data modelling to visualize database structure
• Working with application developers to create optimized queries
• Maintaining database performance by troubleshooting problems.
• Accomplishing platform upgrades and improvements by supervising system programming.
• Securing database by developing policies, procedures, and controls.
• Designing and managing deep statistical systems.

Desired Skills and Experience  :

• 7+ years of experience in database development
• Minimum 4+ years of experience in PostgreSQL is a must
• Experience and in-depth knowledge in PL/SQL
• Ability to come up with multiple possible ways of solving a problem and deciding on the most optimal approach for implementation that suits the work case the most
• Have knowledge of Database Administration and have the ability and experience of using the CLI tools for administration
• Experience in Big Data technologies is an added advantage
• Secondary platforms: MS SQL 2005/2008, Oracle, MySQL
• Ability to take ownership of tasks and flexibility to work individually or in team
• Ability to communicate with teams and clients across time zones and global regions
• Good communication and self-motivated
• Should have the ability to work under pressure
• Knowledge of NoSQL and Cloud Architecture will be an advantage

We at Datametica Solutions Private Limited are looking for SQL Engineers who have a passion for cloud with knowledge of different on-premise and cloud Data implementation in the field of Big Data and Analytics including and not limiting to Teradata, Netezza, Exadata, Oracle, Cloudera, Hortonworks and alike. 

Ideal candidates should have technical experience in migrations and the ability to help customers get value from Datametica's tools and accelerators.

Job Description

Experience : 4-10 years

Location : Pune

Mandatory Skills - 

• Strong in ETL/SQL development
• Strong Data Warehousing skills
• Hands-on experience working with Unix/Linux
• Development experience in Enterprise Data warehouse projects
• Good to have experience working with Python, shell scripting
•  

Opportunities -

• Selected candidates will be provided training opportunities on one or more of the following: Google Cloud, AWS, DevOps Tools, Big Data technologies like Hadoop, Pig, Hive, Spark, Sqoop, Flume and Kafka
• Would get chance to be part of the enterprise-grade implementation of Cloud and Big Data systems
• Will play an active role in setting up the Modern data platform based on Cloud and Big Data
• Would be part of teams with rich experience in various aspects of distributed systems and computing

About Us!

A global Leader in the Data Warehouse Migration and Modernization to the Cloud, we empower businesses by migrating their Data/Workload/ETL/Analytics to the Cloud by leveraging Automation.

We have expertise in transforming legacy Teradata, Oracle, Hadoop, Netezza, Vertica, Greenplum along with ETLs like Informatica, Datastage, AbInitio & others, to cloud-based data warehousing with other capabilities in data engineering, advanced analytics solutions, data management, data lake and cloud optimization.

Datametica is a key partner of the major cloud service providers - Google, Microsoft, Amazon, Snowflake.

We have our own products!

Eagle – Data warehouse Assessment & Migration Planning Product

Raven – Automated Workload Conversion Product

Pelican - Automated Data Validation Product, which helps automate and accelerate data migration to the cloud.

Why join us!

Datametica is a place to innovate, bring new ideas to live and learn new things. We believe in building a culture of innovation, growth and belonging. Our people and their dedication over these years are the key factors in achieving our success.

Benefits we Provide!

Working with Highly Technical and Passionate, mission-driven people

Subsidized Meals & Snacks

Flexible Schedule

Approachable leadership

Access to various learning tools and programs

Pet Friendly

Certification Reimbursement Policy

Check out more about us on our website below!

http://www.datametica.com/">www.datametica.com

Datametica is looking for talented SQL engineers who would get training & the opportunity to work on Cloud and Big Data Analytics.

Mandatory Skills:

• Strong in SQL development
• Hands-on at least one scripting language - preferably shell scripting
• Development experience in Data warehouse projects

Opportunities:

• Selected candidates will be provided training opportunities on one or more of the following: Google Cloud, AWS, DevOps Tools, Big Data technologies like Hadoop, Pig, Hive, Spark, Sqoop, Flume, and KafkaWould get a chance to be part of the enterprise-grade implementation of Cloud and Big Data systems
• Will play an active role in setting up the Modern data platform based on Cloud and Big Data
• Would be part of teams with rich experience in various aspects of distributed systems and computing

Required Skills Description

Experience Level:- 4 –7 Years of Experience

Mandatory Skills –

1. Good Coding Skills
2. Hands-on Experience Angular or React or Vue or Typescript
3. Sound knowledge on RESTFUL APIs
4. Should have executed projects where .Net and Microsoft technologies have been used and should have a good understanding of the same.

Secondary Skills

• Knowledge .Net Core, WEB API framework
• Knowledge of HTML and CSS
• SQL Server and PL/SQL
• Understanding of Design Patterns

Interpersonal Skills

1. Good in communications (Verbal and Written)
2. Should have worked individually or in team

Mandatory Skills:

1. Good Coding Skills
2. Hands on Experience on C#
3. Indexer
4. Object Oriented concepts using C#
5. Linq
6. Generics
7. Delegates
8. File IO
9. GAC concepts
10. MVC
11. Entity framework
12. .Net Core Concepts
13. Web-API
14. Sql Queries

Secondary Skills:

• Knowledge of Angular/React/Vue/Java Script/ Type Script
• Knowledge of HTML and CSS
• SQL Server and PL/SQL
• Understanding of Design Patterns

Interpersonal Skills:

1. Good in communications (Verbal and Written)
2. Should have worked individually or in team

Job Description:

Excellent knowledge with proven implementation experience of:  Axiom Controller View V9 / V10 (2+ years’ experience).  Building and configuring Axiom workflows to solve complex business problems and mapping to Axiom data dictionaries.   XBRL and template disclosure submission including taxonomy, data point model and validations experience.   Knowledge of EU regulatory reporting requirements (COREP/Statistical) with strong Capital knowledge.  Packaging, deploying, branching Axiom solution including upgrades as part of the software development lifecycle.   Oracle PL/SQL.

• Hands on Java experience with minimum 8 yrs. More experience is a plus but need to be hands on.
• Server side programming experience with technologies: Spring, Hibernate & Swing is a plus
• Good DB knowledge, hands on PL/SQL or T-SQL
• Experienced to work on Linux, git, IntelliJ, Eclipse
• Experience of designing and developing end-to-end solutions.

• You will work on long-term React Native mobile applications for innovative startups.
• Together with your colleagues and our clients you will analyse requirements and envision a qualitative solution. You will be responsible for the entire development - from architecture to implementation - and deliver user-friendly, performant and well-tested mobile applications.
• You will be part of our continuous improvement culture, hone your skills and share your experience with your colleagues.

• You have at least 3-year experience implementing and deploying React Native apps.
• You developed and published at least one React Native app on Google and Apple Store.
• You are familiar with Google and Apple Store guidelines and compliance.
• You can build pixel-perfect UIs for all mobile platforms.
• You have strong knowledge of Javascript ES6 and higher.
• You know how to make a solid relational data model and have a good knowledge of SQL.
• You have integrated a variety of web API's and understand HTTP.
• You know how to write clean and flexible object-oriented code.
• You have a good understanding of async programming concepts.
• You work daily with tools like Git, NPM and a proper IDE (Webstorm).
• You can deliver POCs, experiments and technology evaluations following design thinking practices.
• You will be contributing towards architecting and building React Native applications, as well as coordinating with the teams responsible for other layers of the product/project infrastructure.
• You write clean code and are a pragmatic programmer.

• You wish Typescript was the default language of the web.
• You stepped outside the Expo world and have experience with native iOS or Android development. You are familiar with XCode and Android studio, and leverage native APIs for deep integration with Android and iOS.
• You have experience with state management libraries like MobX and Redux.
• You write automated tests and perform end-to-end testing with Detox or Appium.
• You are familiar with functional programming concepts and apply it occasionally.
• You worked with other hybrid mobile platforms like Sencha, HTML5, PhoneGap, etc.
• You have experience with Scrum and Lean methodology