11+ Optimization Jobs in Hyderabad | Optimization Job openings in Hyderabad

Review Criteria:

• Strong Dremio / Lakehouse Data Architect profile
• 5+ years of experience in Data Architecture / Data Engineering, with minimum 3+ years hands-on in Dremio
• Strong expertise in SQL optimization, data modeling, query performance tuning, and designing analytical schemas for large-scale systems
• Deep experience with cloud object storage (S3 / ADLS / GCS) and file formats such as Parquet, Delta, Iceberg along with distributed query planning concepts
• Hands-on experience integrating data via APIs, JDBC, Delta/Parquet, object storage, and coordinating with data engineering pipelines (Airflow, DBT, Kafka, Spark, etc.)
• Proven experience designing and implementing lakehouse architecture including ingestion, curation, semantic modeling, reflections/caching optimization, and enabling governed analytics
• Strong understanding of data governance, lineage, RBAC-based access control, and enterprise security best practices
• Excellent communication skills with ability to work closely with BI, data science, and engineering teams; strong documentation discipline
• Candidates must come from enterprise data modernization, cloud-native, or analytics-driven companies

Preferred:

• Experience integrating Dremio with BI tools (Tableau, Power BI, Looker) or data catalogs (Collibra, Alation, Purview); familiarity with Snowflake, Databricks, or BigQuery environments

Role & Responsibilities:

You will be responsible for architecting, implementing, and optimizing Dremio-based data lakehouse environments integrated with cloud storage, BI, and data engineering ecosystems. The role requires a strong balance of architecture design, data modeling, query optimization, and governance enablement in large-scale analytical environments.

• Design and implement Dremio lakehouse architecture on cloud (AWS/Azure/Snowflake/Databricks ecosystem).
• Define data ingestion, curation, and semantic modeling strategies to support analytics and AI workloads.
• Optimize Dremio reflections, caching, and query performance for diverse data consumption patterns.
• Collaborate with data engineering teams to integrate data sources via APIs, JDBC, Delta/Parquet, and object storage layers (S3/ADLS).
• Establish best practices for data security, lineage, and access control aligned with enterprise governance policies.
• Support self-service analytics by enabling governed data products and semantic layers.
• Develop reusable design patterns, documentation, and standards for Dremio deployment, monitoring, and scaling.
• Work closely with BI and data science teams to ensure fast, reliable, and well-modeled access to enterprise data.

Ideal Candidate:

• Bachelor’s or Master’s in Computer Science, Information Systems, or related field.
• 5+ years in data architecture and engineering, with 3+ years in Dremio or modern lakehouse platforms.
• Strong expertise in SQL optimization, data modeling, and performance tuning within Dremio or similar query engines (Presto, Trino, Athena).
• Hands-on experience with cloud storage (S3, ADLS, GCS), Parquet/Delta/Iceberg formats, and distributed query planning.
• Knowledge of data integration tools and pipelines (Airflow, DBT, Kafka, Spark, etc.).
• Familiarity with enterprise data governance, metadata management, and role-based access control (RBAC).
• Excellent problem-solving, documentation, and stakeholder communication skills.

Preferred:

• Experience integrating Dremio with BI tools (Tableau, Power BI, Looker) and data catalogs (Collibra, Alation, Purview).
• Exposure to Snowflake, Databricks, or BigQuery environments.
• Experience in high-tech, manufacturing, or enterprise data modernization programs.

Job Overview

We are looking for an experienced QA Professional with 5–10 years of experience specializing in Pega Testing. In this role, you will design, execute, and manage testing strategies for complex, large-scale enterprise applications built on the Pegaplatform. You will ensure the seamless performance, integration, and functionality of workflows and case management systems.

Key Responsibilities

• Strategy & Planning: Define, design, and implement comprehensive test strategies, test plans, and test cases specifically tailored for Pega BPM applications.

• Functional & Rule Validation: Validate Pega rulesets, case management flows, data pages, routing logic, declarative expressions, and access groups.

• Automation Leadership: Design and maintain automated test frameworks for PegaUI and API layers using tools like Selenium, Cucumber, Tosca, or Pega Autotest.

• Defect & Defect Triaging: Track, analyze, and report defects using Jira, collaborating closely with Pega developers and Business Analysts to resolve complex issues.

• Regression & Integration Testing: Execute rigorous regression testing for Pegaplatform upgrades and test end-to-end integration with third-party APIs and databases.

• Mentorship & Quality Control: Lead a team of QA engineers, conduct test case reviews, and enforce industry-standard QA best practices.

Required Skills & Qualifications

• Pega Expertise: 4+ years of dedicated hands-on experience in testing Pega PRPC applications (Pega 8.x experience preferred).

• Certifications: Pega Certified Business Architect (PCBA), Certified System Architect (CSA), or Certified Pega QA is highly desirable.

• Testing Automation: Proven experience using automation tools (Selenium WebDriver, Tosca, Cucumber, or SoapUI/Postman for API testing) within a Pegaecosystem.

• Technical Proficiency: Strong understanding of SQL, XML, JSON, and Agile/Scrum methodologies.

• Analytical Skills: Exceptional ability to translate complex business requirements and user stories into structured test scenarios.

• 2+ years of .NET/ASP.NET (Win Forms, MVC, .NET Core, WEB API, SQL server)
• 2+ years using GIT source code repository.
• 2+ years working on Agile/Scrum teams.
• 2+ years’ experience with SQL within SQL Server Environment.
• Fast learner, self-sufficient, proactive and can work with little guidance.

• Assist in preparation of landscape masterplans and detailed drawings
• Develop layout plans, sections, and technical landscape drawings
• Work on podium landscapes, villa developments, and amenity spaces
• Coordinate with architects, consultants, and execution teams
• Prepare presentation drawings, concept visuals, and documentation
• Support site coordination and design implementation when required
• Contribute to design discussions and studio workflows

MUST-HAVES:

• LLM, AI, Prompt Engineering LLM Integration & Prompt Engineering
• Context & Knowledge Base Design.
• Context & Knowledge Base Design.
• Experience running LLM evals

NOTICE PERIOD: Immediate – 30 Days

SKILLS: LLM, AI, PROMPT ENGINEERING

NICE TO HAVES:

Data Literacy & Modelling Awareness Familiarity with Databricks, AWS, and ChatGPT Environments

ROLE PROFICIENCY:

Role Scope / Deliverables:

• Scope of Role Serve as the link between business intelligence, data engineering, and AI application teams, ensuring the Large Language Model (LLM) interacts effectively with the modeled dataset.
• Define and curate the context and knowledge base that enables GPT to provide accurate, relevant, and compliant business insights.
• Collaborate with Data Analysts and System SMEs to identify, structure, and tag data elements that feed the LLM environment.
• Design, test, and refine prompt strategies and context frameworks that align GPT outputs with business objectives.
• Conduct evaluation and performance testing (evals) to validate LLM responses for accuracy, completeness, and relevance.
• Partner with IT and governance stakeholders to ensure secure, ethical, and controlled AI behavior within enterprise boundaries.

KEY DELIVERABLES:

• LLM Interaction Design Framework: Documentation of how GPT connects to the modeled dataset, including context injection, prompt templates, and retrieval logic.
• Knowledge Base Configuration: Curated and structured domain knowledge to enable precise and useful GPT responses (e.g., commercial definitions, data context, business rules).
• Evaluation Scripts & Test Results: Defined eval sets, scoring criteria, and output analysis to measure GPT accuracy and quality over time.
• Prompt Library & Usage Guidelines: Standardized prompts and design patterns to ensure consistent business interactions and outcomes.
• AI Performance Dashboard / Reporting: Visualizations or reports summarizing GPT response quality, usage trends, and continuous improvement metrics.
• Governance & Compliance Documentation: Inputs to data security, bias prevention, and responsible AI practices in collaboration with IT and compliance teams.

KEY SKILLS:

Technical & Analytical Skills:

• LLM Integration & Prompt Engineering – Understanding of how GPT models interact with structured and unstructured data to generate business-relevant insights.
• Context & Knowledge Base Design – Skilled in curating, structuring, and managing contextual data to optimize GPT accuracy and reliability.
• Evaluation & Testing Methods – Experience running LLM evals, defining scoring criteria, and assessing model quality across use cases.
• Data Literacy & Modeling Awareness – Familiar with relational and analytical data models to ensure alignment between data structures and AI responses.
• Familiarity with Databricks, AWS, and ChatGPT Environments – Capable of working in cloud-based analytics and AI environments for development, testing, and deployment.
• Scripting & Query Skills (e.g., SQL, Python) – Ability to extract, transform, and validate data for model training and evaluation workflows.
• Business & Collaboration Skills Cross-Functional Collaboration – Works effectively with business, data, and IT teams to align GPT capabilities with business objectives.
• Analytical Thinking & Problem Solving – Evaluates LLM outputs critically, identifies improvement opportunities, and translates findings into actionable refinements.
• Commercial Context Awareness – Understands how sales and marketing intelligence data should be represented and leveraged by GPT.
• Governance & Responsible AI Mindset – Applies enterprise AI standards for data security, privacy, and ethical use.
• Communication & Documentation – Clearly articulates AI logic, context structures, and testing results for both technical and non-technical audiences.

We are seeking a motivated Data Analyst to support business operations by analyzing data, preparing reports, and delivering meaningful insights. The ideal candidate should be comfortable working with data, identifying patterns, and presenting findings in a clear and actionable way.

Key Responsibilities:

• Collect, clean, and organize data from internal and external sources
• Analyze large datasets to identify trends, patterns, and opportunities
• Prepare regular and ad-hoc reports for business stakeholders
• Create dashboards and visualizations using tools like Power BI or Tableau
• Work closely with cross-functional teams to understand data requirements
• Ensure data accuracy, consistency, and quality across reports
• Document data processes and analysis methods

About the Role

We are seeking a fast, creative, and technically skilled 3D Explainer Video Producer to transform daily incident briefs into short, high-impact explainers within hours. You will work across a blend of real-time 3D pipelines and AI-powered tools to deliver cinematic-quality videos that help the world understand fast-moving events — all while staying aligned to our visual brand.

Key Responsibilities

Translate incident briefs into concise visual storylines and scene concepts

• Create or AI-generate 3D assets using Blender, Maya, or 3ds Max
• 
  
• Animate scenes using real-time engines like Unreal Engine or Unity
• 
  
• Composite titles, graphics, and voiceovers using After Effects and Premiere (or Resolve)
• 
  
• Integrate AI tools like Runway, Pika, and ElevenLabs to accelerate production
• 
  
• Maintain a reusable library of templates, transitions, rigs, and sound design elements
• 
  
• Ensure brand consistency across color, fonts, resolution, aspect ratios, and platform-specific specs
• 
  
• Collaborate with writers, analysts, and social media teams to refine edits under tight timelines

Required Skills

1+ years of 3D/motion-graphics production experience

Proficiency in Blender, Maya, or 3ds Max

Experience with Unreal Engine or Unity for cinematic rendering

Advanced use of After Effects and Premiere Pro (or DaVinci Resolve)

Strong storyboard literacy and ability to convert briefs into visual sequences

Familiarity with AI tools for asset creation, animation, or TTS

Fast, efficient, and organized with excellent communication skills

Bonus Skills

Journalism, news, or media production experience

Python, C#, or scripting for pipeline automation

Experience with short-form video platforms (YouTube Shorts, Reels, LinkedIn)

Color grading expertise using DaVinci Resolve

*4 - 10 Years Experience

* Engineering Graduates

* Must have experience in Commercial complexes, Apartments, Hirise Building, and Gated Community.

* Position will be available or Closed by march or April Months.

Job description

The Purchase Manager will lead and oversee the procurement process for our real estate and construction projects. The ideal candidate should possess 8-15 years of procurement experience, with a strong focus on the construction and materials industry. We offer a competitive salary reflective of industry standards.

Responsibilities:

Procurement Planning:

• Collaborate with project managers to comprehend procurement requirements.
• Gain a thorough understanding of the requirements and technical requirements of the product or service.
• Develop procurement plans for timely and cost-effective material, equipment, and service procurement.
• Conduct market research to identify potential suppliers and maintain a robust supplier database.

Supplier Management:

• Evaluate suppliers based on quality, reliability, and cost-effectiveness.
• Negotiate and manage supplier contracts.
• Monitor supplier performance, resolving any issues promptly.
• Cultivate strong relationships with suppliers for material and service availability.
• Updating of supplier database with the latest entrants and the evolving technologies relevant to the industry

Purchase Order Management:

• Review and convert purchase requisitions into accurate and complete purchase orders.
• Monitor and track purchase orders to ensure on-time delivery.
• Coordinate with project teams and suppliers to resolve delivery or quality issues.

Cost Management:

• Analyze market trends, prices, and supplier performance for cost-saving opportunities.
• Implement cost control measures without compromising quality.
• Conduct periodic audits for compliance with procurement policies.
• Analyze every material or product to ensure the pricing is appropriate for the product procured.

Inventory Management:

• Manage inventory levels for optimal stock availability.
• Coordinate with warehouse and project teams to track and reconcile inventory.
• Implement inventory control measures to minimize stock-outs and excess inventory.

Compliance and Documentation:

• Ensure compliance with company policies, procurement regulations, and applicable laws.
• Maintain accurate procurement records and documentation.
• Prepare reports and provide updates on procurement activities to management.

Qualifications:

• 4 - 10 years of procurement experience in the real estate or construction industry.
• Residential purchase experience is essential.
• Strong Proficiency in MS Office (Excel, Word).
• Experience in preparing MIS reports as per management requirements.
• Strong knowledge of procurement processes, vendor management, and supply chain management.
• Excellent negotiation and communication skills.
• Proficient in procurement software (ERP) and other relevant tools.
• BE, BTech or Master's degree in Business Administration, Supply Chain Management, or a related field (preferred).
• Good Analytical skills to review the quotations and understand the intricacies.
• Financial acumen to grasp the impact of procurement decisions on the overall budget.
• Strategic thinking to develop and implement cost-effective procurement plans that align with the organization's goals.
• Maintaining ethical standards in procurement practices ensures transparency, fairness, and integrity, which is crucial for long-term success and cost management.
• Being adaptable to changes in the market, industry regulations, or organizational priorities allows for agility in adjusting procurement strategies for optimal cost management.
• Good understanding on National Building Code (NBC) of construction

As a Power BI and QlikView Developer, we expect the candidate to be a key contributor in the implementation of data analytics dashboards – from data preparation to dashboard development, unit testing and deployment. The primary work focus for the candidate is as under: 

• Understanding the database design. 

• Develop efficient SQL queries from simple to complex and test the data output as a part of data preparation activity 

• Development & Unit Testing – Dashboards & Data Visualizations using Power BI 

• Troubleshooting/debugging and rectifying issues 

• Review, feedback and mentoring the team 

• Adherence of standards and best practices as defined by the company at the individual level and as a team 

QUALIFICATIONS AND EXPERIENCE 

• Degree in BE/ BTech with at least 3 to 5 years of overall experience 

• Experience in working on multiple databases like MS SQL (Mandatory), PostgreSQL, Mongo DB, MySQL (would be a plus) etc. and data analytics projects (a minimum of 2 to 3).  

• Experience working on SQL Server: Writing queries of 1 to 2 years is mandatory.  

• Expertise in Power BI and knowledge of QlikView (1-2 years). 

• Understanding other tools like Tableau, Domo etc. would be a great plus 

• Experience in working on different types of visualizations, in addition to the generic ones – Scatter plots, Heat Maps, Geo maps, Gantt, Bubbles, Tree Maps etc. 

• Experience working on Trends, forecasting etc. would be a plus 

• Experience in working with projects teams and ensuring the successful delivery of the solution