WhereScape Developer

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

• Bachelors 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.
• Strong 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.