Mainframe Operator/ Mainframe Operations

Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please Note: This is not a pure Data Engineering role. We are looking for a true SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic with Python, ETL, Cloud. SQL mastery and database architecture are the absolute heart of this role.

If you are a database developer who loves diving into query execution plans, refactoring messy stored procedures for 10x performance, and building clean data models from scratch, this role is for you.

Key Responsibilities

1. Database Architecture & Schema Design

• Design, implement, and maintain robust relational database schemas.
• Architect optimal data models for both operational (OLTP) and analytical (OLAP/Data Warehousing) workloads.
• Implement Normalization (3NF) and dimensional modeling (Star/Snowflake schemas) as required.

2. Advanced Database Programmability

• Write, debug, and optimize highly complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Utilize advanced SQL techniques such as CTEs, Window Functions, and complex analytical queries to solve business problems.

3. Performance Tuning & Indexing

• Analyze query execution plans, identify performance bottlenecks, and implement advanced indexing strategies (B-Tree, Clustered/Non-Clustered, Partitioning).
• Refactor legacy SQL code and manage statistics, locking, and concurrency mechanisms to ensure sub-second response times.

4. Python & Cloud ETL/ELT Pipelines

• Develop, schedule, and maintain scalable data ingestion and transformation pipelines to connect disparate data sources.
• Leverage Cloud Data Platforms alongside modern Python libraries to build efficient data movement workflows.

5. Data Integrity & Governance

• Establish strict database constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing server-side logic (Stored Procedures/Functions) and complex queries in enterprise platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep, under-the-hood understanding of database engines, execution plans, indexing strategies, and concurrency/locking control.
• Python for Data Engineering (3+ Years): Proficient in writing clean, modular Python scripts for API integration, data manipulation, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Cloud Data Experience: Hands-on experience working with, migrating to, or developing within major cloud environments (AWS, Azure, GCP) and modern cloud data warehouses (Snowflake, BigQuery, or Redshift).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, handling Slowly Changing Dimensions (SCD), and balancing normalization vs. denormalization.

Remote & Soft Skills

• Legacy Refactoring Mindset: You genuinely enjoy opening up a massive, poorly optimized 500-line legacy stored procedure and refactoring it for maximum efficiency.
• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement in a fully remote setup.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.

Nice-to-Haves

• Experience migrating legacy on-premise infrastructure and stored procedures to modern cloud data warehouses.
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Hands-on experience with dbt (data build tool) for in-warehouse transformations.

Position: MEAN Stack Developer

Experience: 2-8 year

Location: Noida, Pune

Salary: Negotiable

Industry: IT

Qualification: Bachelor Degree in Computer Science, Computer Engineering or similar

Desired Candidate profile

• 2-6 years of experience in the specified skills.
• Should have hands-on experience in Angular 2+.
• Certification in Angular Development is a plus
• Knowledge of multiple front-end languages and libraries (e.g., HTML/ CSS, JavaScript, XML, jQuery).
• Experience with the following is a must: JavaScript (ES6) / TypeScript.
• Proficiency in code versioning tools such as Git.
• Proficiency in Development Tracking tools such as JIRA.
• Deep understanding of Server Side technologies like JAVA, Python, or JS.
• Working knowledge of databases (My SQL / Cassandra) and the rest APIs.
• Excellent verbal communication skills.
• Attention to detail.
• Critical thinker and good problem-solver.
• Ability to work independently and with team

Mail updated resume with below details- 

Current ctc-

Expected ctc-

Notice period-

Current location-

Email- satish.glanmc@ gmail.com

Satish- 8851O 18162

Website: http://www.glansolutions.com/">www.glansolutions.com

Business Development Associate

About Company - Creta Class is an educational product from Singapore, designed and 

developed for kids ages 3-8, which helps to develop their love for learning and cultivate 

their thinking ability, all while bringing them life-long benefits. 

Our professional teaching and research centre is led by graduates holding master’s and 

doctoral degrees from Ivy League Schools and other nations most prestigious 

universities. Scientifically and systematically staged lessons aligned with the Common 

Core State Standards (CCSS). 

A program backed by award-winning AI technology, developed by a top-notch AI 

laboratory. With Creta Approach, the immersive, interactive and fun-filled AI math 

courses motivating children’s intrinsic passion for learning. 

Position: Business Development Associate

Working Days: Monday to Saturday (6 days) 

Timing: 12 PM to 9 PM 

Salary: (4 to 6) LPA [4 Lakhs Fixed + 2 Lakhs Variable] 

Education: Graduation Mandatory 

Experience: 0-2 years, In Edtech Sales experience (Mandatory) 

Work Location: Bangalore (WFO) 

Languages: English and Hindi Must

Job description – A highly suitable individual for this position would possess 

experience in consultative selling or a deep passion for developing a career in sales. It 

is essential that you have the ability to effectively handle interactions with both parents 

and children within the age range of 3-8 years. Your role would involve nurturing these 

relationships over time and fostering a genuine desire for our products. It is important 

that you are comfortable in managing these relationships and have the capability to build 

rapport and trust with parents and children alike, instilling in them the motivation to 

purchase our offerings. 

Creta Class, No.293/154/172, Outer Ring Road,

 Kadubeesanahalli, Bengaluru, Karnataka 560103

What will you be doing?

• In this role, you will primarily serve as a mentor and guide for the customers, offering 

them support and assistance throughout their experience. This involves providing them 

with valuable insights, advice, and recommendations to help them make informed 

decisions.

• Additionally, you will be responsible for counselling parents, understanding their 

concerns, and addressing any questions or issues they may have. By offering your 

expertise and understanding, you will help parents navigate through the process and 

ensure their peace of mind.

• To ensure the success of the organization, meeting the required targets will be an 

important aspect of your responsibilities. This entails actively working towards specific 

goals and objectives set by the company.

• By effectively managing your time and resources, you will contribute to the overall 

growth and achievement of these targets. Furthermore, it will be essential for you to 

maintain a detailed database of all the interactions you have with leads on the Customer 

Relationship Management (CRM) system. This includes logging important information 

about each interaction, such as the nature of the conversation, key points discussed, and 

any follow-up actions required. By keeping a comprehensive record, you will help 

ensure effective communication and continuity of information within the organization. 

• Overall, as part of your role, you will serve as a mentor, guide, and counselor to 

customers and parents, meet designated targets, and maintain a meticulous CRM 

database of all interactions with leads.

What are we looking for?

• Individuals who possess excellent proficiency in both English and Hindi, along with 

the ability to communicate in other languages, will have an additional edge.

• Diligent individuals with a strong commitment and unwavering determination. 

Having prior experience in Edtech sales would be beneficial.

• Individuals who adopt a systematic approach to constructing sales funnels and 

successfully converting.

We have immediate requirements for Fresher in BPO Semi Voice Process @ Chennai

Interview Scheduled:

• Walk-in: Monday to Friday (10 AM to 4 PM)

Contact Details:

• Reference Name: PRAVALIKA- HR

Job Description:

• Process : International Semi Voice Process
• Designation: Customer Support Executive
• Qualification : Any graduation (Arts & Science, Engineering) / Diploma / ITI / 12th / Distance Education / Dropout ( 2017- 2021 passed outs only)
• Shift Timings: Night Shift (7.30PM - 5.30AM)
• Salary: 8,500 + Incentives Upto 3000(based on your performance) +Food & Refreshment
• Age limit : 18 - 26 Yrs.
• Work Location: Nungambakkam, Chennai.

What you will be working on:

• Apply strategic thinking to design and deliver aesthetically pleasing innovative user-centric design and experiences across web and mobile platforms and devices
• Produce user flows, wireframes, prototypes (for stakeholder discussions/approvals), user interface specifications, and final graphics with a strong visual design element
• Drive the development and communication of design guidelines, patterns, and libraries- Keep a keen eye for detail and a passion for - pixel-perfect- fit and finish

What makes a great Product Designer for University Living?

• 3-6 years of experience in Product (UI/UX) Design
• At least B.Tech. degree with a background in consumer internet products
• Proficiency in Adobe XD, Sketch, Photoshop, CorelDraw, Illustrator, OmniGraffle, or other visual design and wire-framing tools
• Demonstrable UI design skills with a strong portfolio
• Strong believer in mobile-first and responsive design
• Understands the latest in visual and interaction design trends.
• Understanding of HTML5, CSS4, JavaScript, Bootstrap 4
• Familiarity with development frameworks such as Angular, React

Why should you join us?

• Compensation is better than Market Standards
• ESOPs (for exceptional candidate)
• Exposure with advanced technology
• Free Healthcare
• Provident Fund Allowance
• Monthly Rewards & recognition Program
• Competitive Annual Appraisals & Internal Promotions

Summary
Our Kafka developer has a combination of technical skills, communication skills and business knowledge. The developer should be able to work on multiple medium to large projects. The successful candidate will have excellent technical skills of Apache/Confluent Kafka, Enterprise Data WareHouse preferable GCP BigQuery or any equivalent Cloud EDW and also will be able to take oral and written business requirements and develop efficient code to meet set deliverables.

Must Have Skills

• Participate in the development, enhancement and maintenance of data applications both as an individual contributor and as a lead.
• Leading in the identification, isolation, resolution and communication of problems within the production environment.
• Leading developer and applying technical skills Apache/Confluent Kafka (Preferred) AWS Kinesis (Optional), Cloud Enterprise Data Warehouse Google BigQuery (Preferred) or AWS RedShift or SnowFlakes (Optional)
• Design recommending best approach suited for data movement from different sources to Cloud EDW using Apache/Confluent Kafka
• Performs independent functional and technical analysis for major projects supporting several corporate initiatives.
• Communicate and Work with IT partners and user community with various levels from Sr Management to detailed developer to business SME for project definition .
• Works on multiple platforms and multiple projects concurrently.
• Performs code and unit testing for complex scope modules, and projects
• Provide expertise and hands on experience working on Kafka connect using schema registry in a very high volume environment (~900 Million messages)

• Provide expertise in Kafka brokers, zookeepers, KSQL, KStream and Kafka Control center.
• Provide expertise and hands on experience working on AvroConverters, JsonConverters, and StringConverters.
• Provide expertise and hands on experience working on Kafka connectors such as MQ connectors, Elastic Search connectors, JDBC connectors, File stream connector,  JMS source connectors, Tasks, Workers, converters, Transforms.
• Provide expertise and hands on experience on custom connectors using the Kafka core concepts and API.
• Working knowledge on Kafka Rest proxy.
• Ensure optimum performance, high availability and stability of solutions.
• Create topics, setup redundancy cluster, deploy monitoring tools, alerts and has good knowledge of best practices.
• Create stubs for producers, consumers and consumer groups for helping onboard applications from different languages/platforms.  Leverage Hadoop ecosystem knowledge to design, and develop capabilities to deliver our solutions using Spark, Scala, Python, Hive, Kafka and other things in the Hadoop ecosystem. 
• Use automation tools like provisioning using Jenkins, Udeploy or relevant technologies
• Ability to perform data related benchmarking, performance analysis and tuning.
• Strong skills in In-memory applications, Database Design, Data Integration.

Simultaneously develop app and target for both Android and iOS using third party SDKs and APIs

Required – React Native, Firebase Integration, Third Party SDK integrations