Key Responsibilities Production Support &

- Maintenance

- Provide L2/L3 support for WhereScape RED and/or WhereScape 3D environments.
- Monitor daily ETL batch execution and troubleshoot job failures.
- Perform root cause analysis (RCA) for incidents and recurring issues.
- Handle service requests, incidents, and problem management activities as per SLA.
- Coordinate with business users and stakeholders for issue resolution.

Development & • Enhancements
- Develop and maintain ETL processes using WhereScape RED.
- Implement change requests and enhancements in Data Warehouse solutions.
- Perform impact analysis and effort estimation for support activities.
- Create and modify data models, mappings, and workflows.
- Optimize ETL jobs for performance and reliability.

Data Warehouse Support
- Support enterprise Data Warehouse and Data Mart environments.
- Maintain data quality and perform data validation checks.
- Ensure data consistency across source and target systems.
- Support database objects such as tables, views, stored procedures, and scripts.

Monitoring & • Documentation
- Monitor ETL loads, schedules, and data reconciliation processes.
- Maintain operational runbooks and technical documentation.
- Participate in release deployments and post-deployment validation.
- Prepare support metrics and status reports.

Required Skills Technical Skills
- Strong experience with WhereScape RED and/or WhereScape 3D.
- Experience in Data Warehouse and ETL development/support.
- Strong SQL skills on databases such as:
- SQL Server
- Oracle
- Snowflake
- PostgreSQL
- Teradata (preferred)





- Understanding of Data Warehouse concepts including:

- Star Schema
- Snowflake Schema
- Fact & • Dimension Modeling

- SCD (Slowly Changing Dimensions)

- Experience with ETL troubleshooting and performance tuning.
- Knowledge of scheduling tools and batch monitoring.

Support Skills
- Incident Management
- Problem Management
- Change Management
- SLA Adherence
- Root Cause Analysis (RCA)

Preferred Skills
- Exposure to cloud platforms (Azure, AWS, GCP).
- Familiarity with ITIL processes.
- Experience with ticketing tools such as ServiceNow, Jira, or Remedy.
- Knowledge of Power BI, Tableau, or reporting platforms.

Qualifications
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 4+ years of experience in Data Warehouse/ETL support and development.
- Experience working in 24x7 support environments is preferred.

Soft Skills
- Excellent analytical and troubleshooting skills.
- Solid communication and stakeholder management.
- Ability to work independently in an offshore support model.
- Good documentation and reporting skills.
- Experience working with global teams and clients.

Nice to Have
- WhereScape certification.
- Experience supporting Snowflake-based Data Warehouse environments.




- Agile/Scrum project experience.

Shift Requirement: Flexible to work in overlap hours with client teams and provide support coverage as required. At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises.

We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

📌 WhereScape Developer (Pune)
🏢 Zensar
📍 Pune