Upload Button Icon Add office photos
filter salaries All Filters

73 Appsierra Group Jobs

PL SQL with ETL and DWH

5-7 years

Bangalore / Bengaluru

1 vacancy

PL SQL with ETL and DWH

Appsierra Group

posted 3+ weeks ago

Job Role Insights

Job Description

Mandatory Skills

  • Min 5+ years of hands-on experience in creating Pl/SQL functions, stored procedures, packages, views, triggers, collections, complex querying techniques, Query optimization/Performance tuning techniques, indexes( all are mandatory)
  • Real life troubleshooting skills also must
  • Min 3 years of experience in ETL (Extraction, Transformation and Loading) using Oracle custom scripts or an ETL tool
  • Min 1 year of experience in Unix commands and scripting
  • Flexibility to work in any RDBMS database tech like MSFT or Oracle
  • Should be well versed in RDBMS constructs and CAP Theory
  • Should be able to explain the redo and rollback functionalities in RDBMS
  • Should be able to explain performance by design constructs for different types of data stores like OLTP and OLAP
  • Should be aware of Bill Inmon Vs Ralph Kimball school of thoughts in data warehouse constructs and should be able to articulate the pros and cons of the design principles
  • Should be able to understand and articulate multiple data modelling design principles like Canonical data model, ER model , Start schema, Data lake, etc Good To Have
  • Agile Technique experience is highly desirable
  • Experience with NoSQL databases, such as HBase, Cassandra, MongoDB are highly desirable

Employment Type: Full Time, Permanent

Read full job description

Compare Appsierra Group with

TCS

3.6
Compare

Accenture

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare

HDFC Bank

3.8
Compare

Infosys

3.6
Compare

ICICI Bank

4.0
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.5
Compare

Genpact

3.7
Compare

Teleperformance

3.9
Compare

Concentrix Corporation

3.7
Compare

Axis Bank

3.7
Compare

Amazon

4.0
Compare

Jio

4.1
Compare

iEnergizer

4.7
Compare

Reliance Retail

3.9
Compare

IBM

3.9
Compare

LTIMindtree

3.7
Compare

Similar Jobs for you

Professional at Fusion Plus Solutions Inc

Hyderabad / Secunderabad

4-6 Yrs

Not Disclosed

Plsql Developer at Diverse Lynx

Bangalore / Bengaluru

2-6 Yrs

Not Disclosed

Plsql Developer at ANR Software Pvt. Ltd.

Noida

1-4 Yrs

Not Disclosed

SQL Lead at Infogain

Bangalore / Bengaluru

8-12 Yrs

Not Disclosed

Developer at In Solutions Global (ISG)

Mumbai

8-13 Yrs

₹ 15-30 LPA

Senior Plsql Developer at Extendo Technologies

Madurai, Chennai

6-11 Yrs

Not Disclosed

Plsql Developer at Saxon AI

Hyderabad / Secunderabad

5-8 Yrs

Not Disclosed

Plsql Developer at Fusion Plus Solutions Inc

Hyderabad / Secunderabad

6-8 Yrs

Not Disclosed

Plsql Developer at Fusion Plus Solutions Inc

Hyderabad / Secunderabad

2-5 Yrs

Not Disclosed

Plsql Developer at Fusion Plus Solutions Inc

Hyderabad / Secunderabad

6-8 Yrs

Not Disclosed

PL SQL with ETL and DWH

5-7 Yrs

Bangalore / Bengaluru

Venture Capital, Packaging, RDBMS

3+ weeks ago·via naukri.com

Technical Architect (D365 F&O)

6-9 Yrs

Hyderabad / Secunderabad

CD, Continuous Integration, Web Application Development +2 more

2 weeks ago·via naukri.com

Lead Generation Executive

0-2 Yrs

Noida

Sales, Recruitment, B2B Sales +4 more

2 weeks ago·via naukri.com

mainframe developer

1-4 Yrs

Bangalore / Bengaluru

Operations, DBMS, Mainframe Production Support +2 more

2 weeks ago·via naukri.com

Social Media Influencer Marketing trainee

0-1 Yrs

Noida

Digital Marketing, Writing, Social Media Marketing +4 more

2 weeks ago·via naukri.com

Technical architect ( App Dev)

2-6 Yrs

Hyderabad / Secunderabad

Angular, HTML, SQL Server +4 more

2 weeks ago·via naukri.com

Backend developer with Typescript and AWS

1-4 Yrs

Bangalore / Bengaluru

Digital Marketing, AWS, CD +12 more

3 weeks ago·via naukri.com

Servicenow QA

1-4 Yrs

Bangalore / Bengaluru

Servicenow, Incident Management, Change Management +4 more

3 weeks ago·via naukri.com

IT Recruiter

0-2 Yrs

Noida

Cyber Security, DevOps, Artificial Intelligence +4 more

3 weeks ago·via naukri.com

Testing Manager ( Playwright)

4-7 Yrs

Bangalore / Bengaluru

Manual Testing, Software Testing, Javascript +2 more

3 weeks ago·via naukri.com
write
Share an Interview