Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

ETL SME

Lorven Technologies Private Limited

6 - 8 years

3 - 7 Lacs

Bengaluru

Posted:1 week ago| Platform:

Apply

Skills Required

data warehousing etl rdbms sql queries data warehousing concepts hive c++ sme dbms networking hibernate sql docker plsql spring java xml linux jenkins data structures hadoop perl rest python c performance tuning sql server linux shell aws sdlc unix

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Title:ETL SMEExperience6-8YearsLocation:Bangalore
:
Technical
Skills:

Sound Knowledge of Data warehousing concepts, terminology, and Architecture.

Excellent ETL (Including XML) Design and development Experience

Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator, sorter, expressions, transaction control, xml transformation, lookups etc

Ability to understand mapping document and translate the same to Informatica Mapping

Ability to create CDC, SCD, Fact loads and complex mappings with Informatica

Sound concepts of RDBMS with hands on with performance tuning of ETL / DB / SQL Queries

Good knowledge of UNIX with ability to create Unix/Linux shell scripts to run ETL jobs and trap any failures.

Skill in gathering and documenting user requirements and writing technical specifications

Good knowledge of SDLC for projects using DW concepts and Client/Server technologies.

Create detail mapping documents, module spec and unit test cases

Hand on with informatica development, Configuration and Performance tuning

Non-Technical Skill

Well-developed analytical & problem-solving skills

Strong oral and written communication skills

Excellent team player, able to work with virtual teams

Ability to learn quickly in a dynamic start-up environment

Able to talk to client directly and report to client/onsite

Flexibility to work on different Shifts and Stretch

Flexible to travel and relocate in India and Abroad

More Jobs at Lorven Technologies Private Limited

EWT / Portal - Full Stack - Java,Java, Spring Boot, Maven, Angular

Bengaluru

5.0 - 10.0 yrs

INR 5 - 9 Lacs

Artificial Intelligence Engineer

Bengaluru

8.0 - 12.0 yrs

INR 8 - 12 Lacs

SFMC Developer

Chennai, Tiruchirapalli

5.0 - 10.0 yrs

INR 1 - 4 Lacs

Delivery Module Lead

Pune

6.0 - 8.0 yrs

INR 7 - 12 Lacs

Sr AWS Data Engineer

Hyderabad, Pune, Gurugram

4.0 - 6.0 yrs

INR 2 - 6 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Java Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.