11+ OLTP Jobs in Chennai | OLTP Job openings in Chennai

1. GCP - GCS, PubSub, Dataflow or DataProc, Bigquery, BQ optimization, Airflow/Composer, Python(preferred)/Java

2. ETL on GCP Cloud - Build pipelines (Python/Java) + Scripting, Best Practices, Challenges

3. Knowledge of Batch and Streaming data ingestion, build End to Data pipelines on GCP

4. Knowledge of Databases (SQL, NoSQL), On-Premise and On-Cloud, SQL vs No SQL, Types of No-SQL DB (At Least 2 databases)

5. Data Warehouse concepts - Beginner to Intermediate level

6.Data Modeling, GCP Databases, DB Schema(or similar)

7.Hands-on data modelling for OLTP and OLAP systems

8.In-depth knowledge of Conceptual, Logical and Physical data modelling

9.Strong understanding of Indexing, partitioning, data sharding, with practical experience of having done the same

10.Strong understanding of variables impacting database performance for near-real-time reporting and application interaction.

11.Should have working experience on at least one data modelling tool,

preferably DBSchema, Erwin

12Good understanding of GCP databases like AlloyDB, CloudSQL, and

BigQuery.

13.People with functional knowledge of the mutual fund industry will be a plus Should be willing to work from Chennai, office presence is mandatory

Role & Responsibilities:

● Work with business users and other stakeholders to understand business processes.

● Ability to design and implement Dimensional and Fact tables

● Identify and implement data transformation/cleansing requirements

● Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse

● Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions

● Design, develop and maintain ETL workflows and mappings using the appropriate data load technique

● Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions.

● Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.

● Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team to evaluate, design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.

● Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.

● Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract and transform into reporting & analytics.

● Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI solutions.

● Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest improvements.

● Train business end-users, IT analysts, and developers.

We are looking "SAP SF EC" for Reputed Client @ Permanent Role.

• 3-6 years of Experience with SAP SF EC is must 1 End to End implementation Project experience is must 

• Knowledge in Activate Project Management Methodology 

• Knowledge on ITIL Process 

• Should have experience in Requirement Gathering and completing EC Workbooks 

• Should have experience in Configuration and customisation activities 

• Should have experience in Cut-over activities 

• Should manage customer expectations Person should be proactive 

• Should have drive to complete project deliverables and milestones.

Greetings!!

We are looking for an Oracle HCM Technical consultant for one of our premium clients for their Chennai and Bengaluru locations.

Requirements:



• Advise client on options, risks, and any impacts on other processes or systems.
• Assist the Oracle HCM Functional Team in making the changes to make sure the Application works in the Fusion Environment.
• Experience in HDL, Fast formulas, Extracts and BI Reports.
• Experience of Migrating data for Projects from legacy systems of the clients.
• Assist client in preparing validation scripts, testing scenarios and develop test scripts for Fusion HCM projects.
• Hands-on experience with Fusion Release 13.
• Expertise in RTF, Excel, E-Text Template.
• Strong knowledge required in SQL PL/SQL.
• Good hands on BIP & OTBI, Dashboard Report.
• Experience on Oracle Report Tool, Extract, OIC, Personalization & Customization.

Skills Required:

• 7+ years of experience as software engineer.
• Experience in Dot.Net technologies - Asp.Net MVC, WebAPI, .NetCore
• Experience in ORM like Entity Framework /Dapper
• Experience with Object-Oriented Design and SOLID principles
• Experience with Unit Testing, Mocking and Dependency Injection frameworks
• Experience with SQL Server, NoSQL or other database technology
• Experience with software quality, testing procedures and build automation tools
• Knowledge of the Principles & Patterns of Agile Software
• Ability to understand and troubleshoot existing code and maintain existing systems.
• Ability to identity performance bottlenecks.
• Experience working with version control tools such as GIT and CI/CD tools.

1. Knowledge of MERN Stack is mandatory.
2. Work with development teams and product managers to ideate software solutions.
3. Design client-side and server-side architecture.
4. Conduct Testing & Debugging, utilize script tools & write basic codes for design
5. specifications.
6. Build the front-end of applications through appealing visual design.
7. Develop and manage well-functioning databases and applications.
8. Write effective APIs.
9. Troubleshoot, debug and upgrade software.
10. Create security and data protection settings.
11. Build features and applications with a mobile responsive design.
12. Write technical documentation.
13. Work with data scientists and analysts to improve the software.

We are seeking extremely smart & independent senior developers who are gung ho about building large scale systems that are going to have a big impact on millions of customers. You will:

Responsibilities:

• Lead design and development of products working closely with business team.
• Independently own software components and co-own entire applications with a small group of fellow developers.
• Formally mentor junior software engineers on the team, reviewing design documents, (peer) reviewing code, providing design direction and guidance.
• Build performant, scalable, yet secure, enterprise ready back end architectures that can support millions of users in parallel.
• Establish strong engineering best practices and champion their adoption.

Requirements:

• 4+ years' experience in software product development and delivery.
• Bachelors or Masters degree in engineering (preferably computer science or sister branches) from a reputed institute (preferably IITs, NITs, or other top engineering institutes).
• Strong grasp of CS fundamentals, algorithms and excellent problem-solving abilities.
• All experience should be from good product development or e-commerce background.
• Able to take ownership of working with at least one of mobile or web app teams for complete integration with backend.
• Must have shown good stability in all your previous associations.
• Have strong backend knowledge and cloud development exposure.
• Proficiency in Java, Spring boot, Hibernate, REST API development.
• Worked with at least 1 RDBMS (Mysql preferred).
• NoSql is a plus.
• Have used or are very hands-on with Microservices, Docker, Kubernetes, Gradle/Ant, Kafka, GIT/bitbucket in a very agile work place.
• Writing high quality code which is made better by unit tests and integration tests is how you work.
• Comfortable with exploring proven open source tech stack like Grafana, Kibana, Jira, Prometheus, caches like Redis/Memcached, task queues like celery, to name a few.
• Knowledge of test driven development and AWS tech stack will be a good plus.

As a Power Apps Developer for PreludeSys, you will:

·       Understanding BRD and detail design documents and overall architecture of the application being worked on.

·       Creating, modifying and upgrading canvas, model and portal applications as per the specifications and needs of the customer within the timeframe specified.

·       Look at the defects, issues raised and fix it within the assigned SLA. Periodically review metrics to understand gaps and equip with training, Online courses.

·       Process Improvement, Suggestion of tools, Identifying automation, reusable opportunities. Support organizational initiatives and be an enthusiastic participant.

·       Keep all the stakeholders aware of the Update on Progress, Issues, Clarifications, Dependencies in a short but complete status update. Guiding the team on technical challenges.

You Are Great At:

·       Power Apps developer with 2+ years of work experience in Power Apps.

·       Experience in creating Canvas, Model and Portal applications.

In-Depth Knowledge of Power Automate.

·       Used dataverse, Approval flows, connectors.

              Created both basic, Advanced forms for Portal, Familiar with UI Customization, Liquid Code.

Must Have:

·       Bachelor’s degree in software engineering, computer science or similar program

·       5 to 7 Years of work experience

·       In-Depth Knowledge in Power Apps concepts

·       Experience with Power Apps,Power Automate

·       Knowledge on Agile concepts

·       Excellent Oral and Written Communication skills

Job Title: Java Developer
Experience: 1year to 5 years
Location: Chennai

Job Description :

• Design & development of Java applications using Java EE, Spring Boot, Database
•  Experience in designing, analyzing, coding and troubleshooting large-scale distributed systems
• Ensuring continuous professional self-development
• Strong core Java skills - Multithreading, Collections, Concurrent programming 
• Should have knowledge of OOPS, Design Patterns and data structure
• Should have strong understanding of databases and its core concept including stored procedure
• Ability to work in team and handle production environment, application maintenance.

*Must have experience in actionscript 3 for atleast 1 or 3 years

* Should possess good knowledge in OOPS concepts.

* Experience in starling framework is a plus and will be given priority.

* Basic knowledge of HTML , Javascript will be a added advantage.

* Able to handle projects induvidually and also as a team.

* Should have worked in real time projects.

* Should involve in team building activities.