Pl SQL with Etl and Dwh

2 days ago

Bangalore Urban District Karnataka, India Appsierra Full time

Job Location : Chennai, Pune, Bangalore, Mumbai

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

  • Data Lake/dwh/etl, SQL Cloud Migration

    6 days ago

    Bengaluru, Karnataka, India Her Second Innings Full time

    5-8 - Full Time 7 Hours ago - **Job description**: Bachelor's or Master's degree in Computer Science, Engineering, or a related field. 8+ years of overall experience and 5+ years of experience in GCP, Big query, Looker, Data lake/DWH/ETL, SQL Cloud Migration. Strong understanding and exp. of Data lake/DWH/ETL, SQL Cloud Migration. Excellent problem-solving...

  • Oracle Pl/SQL

    2 weeks ago

    Bengaluru, Karnataka, India Aliqan Technologies Full time

    Hiring **Oracle PL/SQL** for one of our client MNC. Experience: 6 to 7 years. Location - Bangalore (Hybrid). Job Type - Contract (6 months + extendable) **Immediate Joiners Only** **JD: - ** - Must have excellent working knowledge and experience of SQL, Oracle PL/SQL, Unix Shell (or Perl or Python) programming languages with a minimum of 6-7 years of...

  • Etl Testing

    2 weeks ago

    Bangalore Urban District, Karnataka, India Talent Deliver Full time

    ETL Testing with strong SQL Query experience and Bigdata. Experience : 6+ Years. Job Location: Mysore / Bangalore / Pune. **Must have**:strong SQL, strong ETL testing, strong Python, Agile. **Responsibilities** - As part of the delivery team, your primary role would be to ensure effective Design, Development, Validation and Support activities, to assure...

  • Talend Etl

    6 days ago

    Urban Estate Gurgaon, India 2COMs Full time

    Need experience in Talend ETL tool, Strong SQL, DWH, Data modelling experience. - Joins, Aggregations, Filtering. - Windows Functions. - Partitioning. - Duplicate record identification. - DDL & DML Operations. - Subqueries, Nested Queries. - Performance tuning aspects. **Job Information**: Salary **500000 - 1000000** *** Work

  • Pl SQL

    4 days ago

    Bengaluru, Karnataka, India Decision Minds Full time

    **Job Information**: Date Opened - 11/04/2024Industry - TechnologyJob Type - Full-timeWork Experience - 6-7City - BengaluruState/Province - KarnatakaCountry - IndiaZip/Postal Code - 560037**Key responsibilities and expected 'output'**:Senior PLSQL development with Banking Domain **'Required' tech stack and other related details**:SQL, PL SQL,...

  • Oracle Pl/SQL,modeling

    1 week ago

    Bengaluru, Karnataka, India PradeepIT Consulting Services Full time

    **About the job Oracle PL/SQL,Modeling**: Oracle Pl/SQL Developer **Mandatory experience**: Minimum 5+ years of experience in Oracle PL/SQL Minimum 2 life cycle implementations projects **Technical Skills**: Experience in RDBMS programming (Oracle) (addition MSSQL nice to have) Experience in data modelling & Data Vault 2.0 (Nice to have) Experience of...

  • Oracle Pl SQL

    1 week ago

    Bengaluru, Karnataka, India Virtusa Full time

    Oracle PL SQL Total Experience : 6+ Years Technical Skills: Mandatory: - Expertise in Oracle DB Versions - 11G, 12C,19C with hands on SQL, PLSQL - Experience in PostGreSQl Version - 12 and above with hands knowledge of PL/pgSQL - Additional tools: SQL*Plus/SQL Developer/PLSQL Developer/TOAD for Oracle (minimum two), pgAdmin, OmniDB etc. Added...

  • Experienced PL/SQL Developer

    2 weeks ago

    Hyderabad / Secunderabad, Telangana, Bengaluru / Bangalore, India beBeeDeveloper Full time ₹ 8,00,000 - ₹ 20,00,000

    Job Title: Experienced PL/SQL DeveloperWe are seeking an experienced and skilled PL/SQL developer to join our team. As a key member of our development team, you will be responsible for designing, developing, and maintaining complex database systems using PL/SQL.Key Responsibilities:Design and develop efficient and scalable PL/SQL procedures, functions,...

  • Expert PL/SQL Developer

    1 week ago

    Bengaluru / Bangalore, Hyderabad / Secunderabad, Telangana, India beBeeDatabaseAdministrator Full time ₹ 8,00,000 - ₹ 20,00,000

    Job OverviewWe are seeking a skilled professional to develop and maintain PL/SQL procedures, functions, packages, and triggers. Additionally, the ideal candidate will be proficient in writing and optimizing complex SQL queries for large datasets.Key Responsibilities:Design and implement efficient data processing solutions using Unix/Linux shell...

  • Pl/SQL

    6 days ago

    Bengaluru, Karnataka, India Tata Consultancy Services Full time

    Good hands on experience in Oracle SQL, PostGreSQL & PL/Sql and strong experience in writing complex Stored procedures, Packages, Functions and triggers. - Experience in handling large volume of data, along with good knowledge of cursors and advanced bulk collection concepts. -Good experience in writing SQL queries, with knowledge of performance tuning,...