Production Support Engineer

Dicetek LLC

3 - 5 years

0 Lacs

bengaluru karnataka india

Posted:6 days ago| Platform: Foundit logo

Apply

Skills Required

oracle database management systems incident ticketing systems etl processes bi frameworks dwh environments control-m

Work Mode

On-site

Job Type

Full Time

Job Description

Bachelor's degree in computer science, Information Systems, Engineering, or a related field

3+ years of experience in Production Support or a related role, with hands-on exposure to DWH environments
Knowledge in VAT and GST
Perform root cause analysis and resolve incidents related to DWH jobs, ETL processes, and SQL queries
Understanding of operating systems (Linux, Unix)
Knowledge of Oracle database management systems
Support scheduled batch jobs (e.g., Control-M, ODI, OBIEE) and ensure successful data transfers between source systems and DWH environments
Strong technical skills in SQL (including writing, tuning, and troubleshooting queries), UNIX/Linux, and scripting languages (Perl/Shell)
Familiarity with ETL tools (e.g., ODI, Informatica), batch scheduling (e.g., Control-M), and BI/reporting platforms (e.g., OBIEE, Power BI)
Familiarity with incident and change management processes
Monitor and troubleshoot production issues for Data Warehouse systems and related applications, ensuring high availability and performance
Exposure to incident ticketing systems (e.g., ServiceNow), documentation, and reporting for production support activities
Ability to work in a fast-paced environment and handle multiple tasks simultaneously
Maintain documentation for production issues, resolutions, and standard operating procedures related to DWH and SQL operations
Collaborate with development and infrastructure teams to deploy software updates, optimize DWH performance, and implement best practices
Ability to work independently and as part of a team
Coordinate downtime and patching activities for production DWH servers, communicating with stakeholders and ensuring business continuity
Participate in on-call rotation and respond to production issues after business hours as required
Generate and review reports on system performance, job status, and incident trends for management and audit purposes
Ability to provide technical training and support to users
Proven track record of root cause analysis and implementing long-term solutions
Experience with data warehouse architecture, data modeling, and BI frameworks
Understanding of ITIL processes and incident management best practices
Capacity planning and performance tuning experience
Excellent communication and interpersonal skills

More Jobs at Dicetek LLC

Senior Engineer – Infrastructure Systems & Data Center

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Test Engineer (Functional)

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Program Manager

Chennai, Tamil Nadu, India

8.0 - 9.0 yrs

Salary: Not disclosed

Engineer - SSIS and T-SQL Developer

Chennai, Tamil Nadu, India

6.0 - 6.0 yrs

Salary: Not disclosed

Oracle E-Business Payroll Consultant(Techno functional)

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific 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.