MS SQL Facets Developer

Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients’ most complex digital transformation needs. Leveraging our holistic portfolio of capabilities in consulting, design, engineering, and operations, we help clients realize their boldest ambitions and build future-ready, sustainable businesses. With over 230,000 employees and business partners across 65 countries, we deliver on the promise of helping our customers, colleagues, and communities thrive in an ever-changing world. For additional information, visit us at www.wipro.com.

Job Description

Core Technical Skills (Must Have)

• Strong expertise in Oracle PL/SQL development:
  • Stored Procedures, Functions, Packages, Triggers
  • Cursors, Collections, Exception Handling
  • Performance tuning and query optimization
• Advanced SQL skills for complex joins, subqueries, and data analysis.
• Experience with Oracle Database (11g/12c/19c preferred).

FACETS Application Expertise (Must Have)

• Hands-on experience with TriZetto FACETS data model and schema.
• Strong understanding of FACETS modules:
  • Claims (Professional, Institutional, Dental)
  • Membership & Enrollment
• Experience developing and supporting FACETS batch jobs, extracts, and reports.
• Knowledge of FACETS tables, workflows, and business rules.

Healthcare Domain Knowledge (Must Have)

• Solid understanding of US Healthcare Payer operations.
• Strong exposure to:
  • Claims adjudication lifecycle
  • Eligibility & Enrollment (834)
• Familiarity with HIPAA regulations and healthcare data standards.

EDI & Integration Skills (Good to Have)

• Working knowledge of HIPAA EDI transactions:
  • 837 (Claims)
  • 835 (Remittance Advice)
  • 834 (Enrollment)
  • 270/271 (Eligibility)
  • 820 (Premium Payment)
• Experience supporting FACETS inbound/outbound interfaces.
• Exposure to EDI engines (Rhapsody, Mirth, or similar) is a plus.

Data & Reporting (Must have)

• Experience creating custom extracts, data feeds, and reports from FACETS.
• Ability to perform data validation, reconciliation, and root cause analysis.
• Knowledge of reporting tools or downstream data warehouses is an advantage.

SDLC & Support (Must Have)

• Experience working in Agile and/or Waterfall environments.
• Ability to:
  • Analyze functional requirements and translate them into technical solutions
  • Support UAT, production deployments, and post-production issues
  • Perform defect analysis and resolution
• Experience with production support, including incident and change management.

Tools & Environment (Must Have)

• Proficiency with:
  • SQL Developer / TOAD
  • Version control tools (Git, SVN)
  • Ticketing and tracking tools (JIRA, ServiceNow, Azure DevOps)
• Experience working in onsite-offshore delivery models.

Soft Skills (Must Have)

• Strong analytical and problem-solving abilities.
• Excellent communication and documentation skills.
• Ability to work independently and collaborate with cross-functional teams.

͏

Do

Consulting Execution

An ambassador for the Wipro tenets and values, secures great feedback from multiple clients

Consulting project Manager or equivalent coordinates teams of consultants, responsible for assuring quality of deliverables

Flexible in approach, ability to coordinate resource with expertise in various areas

Decisive and directive delivery focus with a can do attitude, demonstrates both hard and soft skills

Coaches, mentors and motivates team and client staff, build trust and confidence through focus on quality and delivery

Effective at engaging with clients, extracting information, e.g., developing facilitation and communication skills

Responsible for ensuring project administration is up to date e.g., SoW, tagging, etc.,

Business development

Ensures high levels of individual utilisation achievement in line with the levels expected as part of the goal setting process

Consistently agrees personal extensions with client

Demonstrates developing network of relationships with clients and provides required intelligence/insights to solve clients business problems

Builds relationships with client peers and provides required intelligence/insights to solve clients business problems

Leads smaller scale meetings with sales teams, leads proposal development to a high standard working with sales teams as appropriate

Anchors market research activities in chosen area of work

Consistently plays a major role in opportunity identification, raising potential pursuits to practice leadership team, helping them proactively in pursuits

͏

Thought Leadership

Develops insight into chosen industry and technology trends, ensures they are shared with the wider practice/GCG in one of the various channels

Contributes to team thought leadership

Ensures a track record is written up of own assignment and, where appropriate, ensures it is written up as a case study

Contribution to Practice/Wipro

Continually delivers all Wipro admin in a timely manner (timesheets, appraisals expenses, etc.,)

Demonstrates contribution to internal initiatives

Suggest ways to improve an engagement through leverage of tools, methods assets, information sources , IP available within the knowledge management platform

Organises the contribution of IP and knowledge assets to the central repository of Wipro and GCG and promotes reuse

Engages with other consulting and delivery teams to enhance collaboration and growth and is part of the Wipro 'Communities' activities

Proposes new service offerings/capabilities and demonstrates value through innovation and subject matter expertise

Provides on/off site training, demos to existing staff as needed. Develops process assets and other reusable artefacts based on learnings from projects

Routinely connects with SMEs to ensure delivery approach considers downstream requirements

Proactively participates in and suggests ideas for practice development initiatives

Actively shares knowledge and points of view within the team and within relevant communities of interest

͏

Deliver

Strategic Objectives

Parameter Description

Measure

(Select relevant measures/ modify measures after speaking to your Manager)

Deliver growth in consulting revenues

Support business performance for direct consulting against relevant quarterly/annual targets

Improve quality of consulting by flawless delivery of transformation engagements

% of Personal Utilisation Achievement (against target)

No. of RFI/RFPs responses supported

No. of transformation engagements delivered

No. of referenceable clients, testimonials

Average CSAT, PCSAT across projects

Generate Impact

Enable pull through business/ impact for Wipro through front end consulting engagements/deal pursuit/client relationships

Number and value of downstream opportunities identified for GCG and larger Wipro

Grow market positioning

Lead/actively contribute to the development of thought leadership/offerings/assets for the practice to support business growth

Eminence and thought leadership demonstrated through content, citations and testimonials

Contributions to white papers/POVs/assets such as Repeatable IP, Frameworks & Methods

Number of ideas generated and active contribution to the development of new consulting offerings/solutions/assets

͏

Provide consulting leadership to accounts

Generating growth and integration across the consulting services, growing client relationship profile and supporting the achievement of the Wipro-wide account objectives

Support GCG Account Lead/Account team to grow consulting service portfolio

Number & $ value of consulting deals in the account supported

Grow the consulting talent

Grow skills and capabilities to deliver consulting engagements in new industries, business themes, frameworks, technologies

Self Development - Min 32 hrs on training in a year. Combination of online and classroom on new industries, new business themes, new technologies, new frameworks, etc.

Build the consulting community

Individual contribution to People Development and Collaboration Effectiveness

Distinct participation in and demonstration of:

Collaboration across GCG - through the contribution to cross-practice offerings, sharing of best practices/industrial/technological expertise, consulting community initiatives

Knowledge Management - Number of Assets owned and contributed to Consulting Central

Mandatory Skills: HC - Payor

.Experience: 5-8 Years

.Reinvent your world. We are building a modern Wipro. We are an end-to-end digital transformation partner with the boldest ambitions. To realize them, we need people inspired by reinvention. Of yourself, your career, and your skills. We want to see the constant evolution of our business and our industry. It has always been in our DNA - as the world around us changes, so do we. Join a business powered by purpose and a place that empowers you to design your own reinvention.