Position: Pega Consultant (Data Extraction Development Lead)
Location: Indianapolis, IN
PEGA professional with strong expertise in data extraction, integration, and reporting from PEGA applications.
The role focuses on extracting structured and unstructured data from PEGA systems for downstream systems, analytics, regulatory reporting, and data warehouses, ensuring accuracy, performance, and compliance.
Key Responsibilities:
Data Extraction & Integration Design and implement data extraction solutions from PEGA using: Report Definitions (RD)BIX (Business Intelligence Exchange) Data Pages (Declare Pages) REST/SOAP services Extract case data, history, audit trails, work objects, and reference data from PEGA.
Prepare data feeds for ETL tools, Data Lakes, Data Warehouses, and reporting platforms. PEGA Configuration; Development Configure and optimize: Class structures and properties Report Definitions and Indexes Data Pages (load strategies, refresh strategies) Build reusable rules for batch and near-real-time extraction. Implement data mappings between PEGA and external systems Performance & Optimization Optimize reports and data extracts for high-volume data. Analyze and resolve performance bottlenecks related to: Large case volumes Complex joins and filters BIX extractions and scheduled jobs Monitor and tune database interactions. Compliance; Data Governance Ensure data extraction aligns with: Security rules & Access Groups GDPR / Privacy / Retention policies Mask or filter sensitive data based on role and purpose. Maintain auditability and traceability of extracted data.
Desired skills: Experience with Oracle SQL and PL/SQL Kafka knowledge, including: Sending messages to Kafka Reading/consuming messages from Kafka through integration Basic Kafka maintenance and troubleshooting
Alchemy: Transforming Your Professional Vision into Reality
Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we ve positioned ourselves at the forefront of digitization and software modernization.
Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.
With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.
Alchemy Connecting Talent with Opportunities (Diversity, Equity and Inclusion)