Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by o9 Solutions Team. If you also belong to the team, you can get access from here

o9 Solutions

Compare button icon Compare button icon Compare
filter salaries All Filters

76 o9 Solutions Jobs

Senior ETL Consultant

3-5 years

Bangalore / Bengaluru

1 vacancy

Senior ETL Consultant

o9 Solutions

posted 4mon ago

Job Role Insights

Flexible timing

Job Description

We are looking for a skilled 3- 5 years experienced Senior Technical Consultant with expertise in SQL, SSIS, Python and PySpark to join our team The ideal candidate will have proficiency in building scalable Interfaces, performance tuning, data cleansing and validation strategies by leveraging the defined tech stack for data processing and data movement
What you ll do:
  • Advanced Execution & Data Management: Oversee and manage intricate project tasks, providing insights and directions related to advanced data ingestion, transformation, validation, and publishing
  • Review and analyse the data provided by the customer along with its technical/functional intent and interdependencies
  • Engage proactively with functional teams, ensuring a thorough understanding of end-toend data flows as related to the technical integration
  • Build data Ingress or Egress pipelines , handling of huge volume of data and developing data transformation functions using languages such as SSIS, Python, Pyspark, SQL etc
  • Integration of various data sources definitions like Teradata, SAP ERP, SQL Server, Oracle, Sybase, ODBC connectors & Flat Files through API or Batch
  • Production Deployment and Hypercare : Assist with Production Deployment tasks; Assists with triage of issues, testing and identifying root cause; Carry out timely response and resolution of batch automation disruptions, in order to meet customer SLA s with accurate and on-time results
  • Technical Leadership & Coding Oversight : Guide and review the code developed by junior consultants, ensuring alignment with best practices
  • Incorporate o9 ways of working and embed the industry standards for smoother project executions
What you should have:
  • 3+ years experience in Data architecture, Data engineering, or a related field, with a strong focus on data modelling, ETL processes, and cloud-based data platforms
  • Hands-on experience with SSIS Packages, Python, PySpark, SQL languages
  • along with workflow management tools like Airflow, SSIS
  • Experience working with Parquet, JSON, Restful APIs, HDFS, Delta Lake and query frameworks like Hive, Presto
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
  • Working experience with version control platforms, eg GitHub, Azure DevOps
  • Familiarity with Agile methodology
  • Proactive mindset and the right attitude to embrace the agility of learning
  • Excellent verbal and written communication skills
Good to have
  • Hands-on Experience with Delta Lake
  • Experience with Supply chain planning applications
  • Experience with Amazon Web Services (AWS), AZURE, Google Cloud Infrastructures
What we ll do for you
  • Competitive salary with stock options to eligible candidates
  • Stock options to eligible candidates
  • Flat organization: With a very strong entrepreneurial culture (and no corporate politics)
  • Great people and unlimited fun at work
  • Possibility to make a difference in a scale-up environment
  • Opportunity to travel onsite in specific phases depending on project requirements
  • Support network: Work with a team you can learn from every day
  • Diversity: We pride ourselves on our international working environment
  • Work-Life Balance: https: / / youtube / IHSZeUPATBA?feature=shared
  • Feel part of A team: https: / / youtube / QbjtgaCyhes?feature=shared
How the process works:
  • Apply by clicking the button below
  • You ll be contacted by our recruiter - Reddy Babu, who ll fill you in on all things at o9, give you some background about the role and get to know you They ll contact you either via video call or phone call - whatever you prefer
  • During the interview phase, you will meet with technical panels for 60 minutes The recruiter will contact you after the interview to let you know if we d like to progress your application
  • We will have 2 rounds of Technical interview followed by Hiring Manager interview
  • Our recruiter will let you know if you re a successful candidate Good luck!

Employment Type: Full Time, Permanent

Read full job description

o9 Solutions Interview Questions & Tips

Prepare for o9 Solutions roles with real interview advice

Top o9 Solutions Senior ETL Consultant Interview Questions

Q1. Angle between hour hand and minute hand at 3:15
Q2. Factorial code using recursion
Q3. What is Supply Chain from your point of view?
View all 19 questions

What people at o9 Solutions are saying

What o9 Solutions employees are saying about work life

based on 234 employees
92%
95%
74%
86%
Flexible timing
Monday to Friday
No travel
Day Shift
View more insights

o9 Solutions Benefits

Submitted by Company
Social Impact initiatives
Vacation time and holidays
Parental leave
10x your future at :o9
Work life integration
Submitted by Employees
Work From Home
Health Insurance
Job Training
Free Food
Team Outings
Cafeteria +6 more
View more benefits

Compare o9 Solutions with

Thomson Reuters

4.1
Compare

Oracle Cerner

3.7
Compare

Chetu

3.3
Compare

R Systems International

3.3
Compare

EbixCash Limited

4.0
Compare

Temenos

3.1
Compare

UKG

3.1
Compare

Amadeus

3.9
Compare

Visteon

3.6
Compare

Blue Yonder

3.9
Compare

Infor Global Solution

4.0
Compare

AVEVA

4.2
Compare

PTC

4.2
Compare

Wolters Kluwer

3.9
Compare

Cvent

3.4
Compare

Sapiens

3.4
Compare

Zycus Infotech

2.9
Compare

Red Hat

4.3
Compare

AVAYA

3.2
Compare

ServiceNow

4.1
Compare

Similar Jobs for you

Senior Technical Consultant at Keste Software

Kolkata, Mumbai + 5

5-8 Yrs

₹ 7-10 LPA

ETL Engineer at Grazitti Interactive

Mohali

4-8 Yrs

₹ 6-10 LPA

Senior SQL Developer at Luxoft

Bangalore / Bengaluru

6-7 Yrs

₹ 8-9 LPA

Senior SQL Developer at Luxoft

Gurgaon / Gurugram

6-7 Yrs

₹ 11-13 LPA

Senior SQL Developer at Luxoft

Chennai

6-7 Yrs

₹ 8-9 LPA

SQL Server Database Administrator at Surtel Technologies Pvt. Ltd

Indore

3-8 Yrs

₹ 6-10 LPA

Testing at Fusion Plus Solutions Inc

Hyderabad / Secunderabad

2-5 Yrs

₹ 3-6 LPA

Senior Technical Consultant at o9 SOLUTIONS, INC.

Bangalore / Bengaluru

1-6 Yrs

₹ 7-11 LPA

Backend Developer at NICE CXone

Pune

4-7 Yrs

₹ 6-9 LPA

Integrator at Coders Brain Pvt Ltd

Remote

3-5 Yrs

₹ 5-8 LPA

Senior ETL Consultant

3-5 Yrs

Bangalore / Bengaluru

4mon ago·via naukri.com

Senior Software Engineer II

6-11 Yrs

Bangalore / Bengaluru

5d ago·via naukri.com

QA Architect

10-15 Yrs

Bangalore / Bengaluru

5d ago·via naukri.com

Associate Solution Architect - Demand Planning

5-10 Yrs

Bangalore / Bengaluru

5d ago·via naukri.com

Solution Architect

7-9 Yrs

Bangalore / Bengaluru

8d ago·via naukri.com

Solution Architect - Retail

7-12 Yrs

Bangalore / Bengaluru

8d ago·via naukri.com

Site Reliability Engineer

6-11 Yrs

Bangalore / Bengaluru

13d ago·via naukri.com

UI Architect

10-15 Yrs

Bangalore / Bengaluru

13d ago·via naukri.com

Senior Software Engineer II

6-11 Yrs

Bangalore / Bengaluru

13d ago·via naukri.com

Senior Software Engineer II

6-11 Yrs

Bangalore / Bengaluru

13d ago·via naukri.com
write
Share an Interview