Pre sales Trainee

Key Responsibilities:

● Analyze and translate legacy MSSQL stored procedures into Snowflake Scripting (SQL) or JavaScript-based stored procedures.

● Rebuild and optimize data pipelines and transformation logic in Snowflake.

● Implement performance-tuning techniques such as query pruning, clustering keys, appropriate warehouse sizing, and materialized views.

● Monitor query performance using the Snowflake Query Profile and resolve bottlenecks.

● Ensure procedures are idempotent, efficient, and scalable for high-volume workloads.

● Collaborate with architects and data teams to ensure accurate and performant data migration.

● Write test cases to validate functional correctness and performance.

● Document changes and follow version control best practices (e.g., Git, CI/CD).

Required Skills:

● 4+ years of SQL development experience, including strong T-SQL proficiency.

● 2+ years of hands-on experience with Snowflake, including stored procedure development.

● Deep knowledge of query optimization and performance tuning in Snowflake.

● Familiarity with Snowflake internals: automatic clustering, micro-partitioning, result caching, and warehouse scaling.

● Solid understanding of ETL/ELT processes, preferably with tools like DBT, Informatica, or Airflow.

● Experience with CI/CD pipelines and Git-based version control

Note : One face-to-face (F2F) round is mandatory, and as per the process, you will need to visit the office for this.

Company: Torrent Power 

Experience: 3 - 8 Years (Relevant)

Location: Ahmedabad (WFO)

Type: Permanent Position (Full Time)

Position: PHP Devops (AM – PHP/Devops)

Skills: Jenkins , GitLab , Sonarqube

CTC: 12 LPA

Notice: 1 Month or less

Job Descriptions-

• Web developer ( PHP - Android / DevOps )
• Must have 3 years of PHP team lead experience
• Must have good experience in PHP and its MVC frameworks
• Experience in MySQL(5.6+) tuning and management
• Experience in developing Continuous Integration/ Continuous Delivery pipelines (CI/ CD). Must have good knowledge and experience of DevOps tools like Jenkins , GitLab , Sonarqube  etc
• Knowledge of Low Code & No code  Mobile Application Development Platform for rapid development , testing & deployment for enterprise mobile application will be an added advantage.
• Good knowledge in web and mobile cybersecurity will be preferred.
• Awareness of various automated testing tools like selenium, j Meter, Unit Testing will be of added advantage
• Should have worked on large scale enterprise application
• Experience in Linux web server management
• Required to have excellent business analysis and system design skills with UI/UX
• Experience in Project and team management

Company- Accionlabs Technologies[www.accionlabs.com]

Location- Bengluru

Work Type- Permanent

Salary- Open

Its work from office job

Key Aspects of Role



 Leverage deep knowledge of the full technology stack to help achieve business objectives and

customer outcomes

 Collaborate with Product Management to validate the technical feasibility of and establish non-

functional requirements

 Collaborate with Architecture to evolve architecture to solve technical challenges, support

future requirements, scale effectively, continually meet/exceed SLAs and resolve tech debt

 Technical advisor to internal or external stakeholders on complex technical components

 Technical leader working with the team to help remove blockers and act as a tie breaker

 Adjust the team processes, listening to feedback and guiding the team through change and

driving continuous improvement

 Guide, teach, and mentor team, providing feedback and moderating discussions

 Represent the interests of the team in cross functional meetings

 Maintain and proactively share knowledge of current technology and industry trends

 Work closely with peers to ensure the team is aligning with cloud native, lean/Agile/DevOps &

12 Factor Application best practices ensuring rapid value delivery and with quality

 Collaborate with other Principal Engineer’s to drive engineering best practices around testing,

CI/CD, GitOps, TDD, architectural alignment, and relentless automation

 Excellent understanding and familiarity with Cloud Native and 12 Factor Principles,

Microservices, Lean Principles, DevOps, Test Driven Development (TDD), Extreme Programming

(XP), Observability / Monitoring

Required Skills

Coding experience in Java

 Extensive hands-on experience working with AWS cloud products and services

 Experience with popular open-source software such as Postgres, RabbitMQ, Elasticsearch, Redis

and Couchbase

 Experience working with NodeJS, React/Redux, Docker Swarm, Kubernetes

 Experience with development frameworks such as the Spring/Spring Boot framework, Hibernate

and knowledge of advanced SQL

 Proficiency with modern object-oriented languages/frameworks, Terraform, Kubernetes, AWS,

Data Streaming

 Knowledge of containers and container orchestration platforms, preferably Kubernetes

 Experience delivering services using distributed architectures: Microservices, SOA, RESTful APIs

and data integration architectures

 Knowledge of containers and container orchestration platforms, preferably Kubernetes

 Advanced Architecture and system design skills and principles

 Excellent organizational skills and can drive a cross-team strategic project or initiative

 Solid coaching, mentorship and technical leadership to help others grow

 Able to drive consensus/commitment within and across teams and departments

 Advanced critical thinking and problem solving on complex issues and customer concerns.

 Strategic thinker beyond immediate needs, considering the longer-term

 Excellent communication skills, with ability to communicate highly complex technical concepts

 Demonstrate high level of empathy with internal colleagues, stakeholders and customers

Roles and Responsibilities

• Ability to create solution prototype and conduct proof of concept of new tools.

• Work in research and understanding of new tools and areas.

• Clearly articulate pros and cons of various technologies/platforms and perform

detailed analysis of business problems and technical environments to derive a

solution.

• Optimisation of the application for maximum speed and scalability.

• Work on feature development and bug fixing.

Technical skills

• Must have knowledge of the networking in Linux, and basics of computer networks in

general.

• Must have intermediate/advanced knowledge of one programming language,

preferably Python.

• Must have experience of writing shell scripts and configuration files.

• Should be proficient in bash.

• Should have excellent Linux administration capabilities.

• Working experience of SCM. Git is preferred.

• Knowledge of build and CI-CD tools, like Jenkins, Bamboo etc is a plus.

• Understanding of Architecture of OpenStack/Kubernetes is a plus.

• Code contributed to OpenStack/Kubernetes community will be a plus.

• Data Center network troubleshooting will be a plus.

• Understanding of NFV and SDN domain will be a plus.

Soft skills

• Excellent verbal and written communications skills.

• Highly driven, positive attitude, team player, self-learning, self motivating and flexibility

• Strong customer focus - Decent Networking and relationship management

• Flair for creativity and innovation

• Strategic thinking This is an individual contributor role and will need client interaction on technical side.

Must have Skill - Linux, Networking, Python, Cloud

Additional Skills-OpenStack, Kubernetes, Shell, Java, Development

Responsibilities

• Mentoring Team of Juniors, Code Reviews, and System Design Understanding
• Design and develop APIs using NodeJs, TypeScript, and deployment using the CICD pipeline.
• Apply code reviews and development quality reviews to make sure best practices are implemented
• Expertise with MySQL including the design of schemas and development for these databases
• Understanding of System Architectures, Design Patterns, and SOLID Principles
• Knowledge of git-based workflows such as git-flow, Proficient with code editors & linting tools

Requirements

• 2+ years of development experience with NodeJS, and Javascript frameworks related to the web stack
• Understanding the nature of asynchronous programming and its quirks and workarounds
• Excellent communication skills, verbal and written

Good to have

• Experience with AWS Microservices
• Experience with payment gateways
• Exposure to AWS Services, policies, and the DevOps pipeline is a plus.
• Expertise with React, Redux, Hooks, and its core principles

Job Summary:

• Willingness to work on highly scalable cloud-native solutions based on microservices.
• Quickly learn the technologies and deliver using the same.
• Take complete ownership of the customer requirements.
• Motivated to deliver world-class quality.
• Inclined to bring new ways of thinking, working and providing solutions.
• Drive the concept of quality into everybody and have a zero-tolerance towards bad quality.

• Understand requirements from product management, customer and able to comprehensively break this down to manageable tasks.

Experience:

● 3-9 years of development experience.

Technical Skills:

Mandatory:

• Java - Advanced concepts concurrency, reflection, lambda, Java Springboot, Spring security,
• Actuator/Prometheus/Grafana/Servo (metrics),
• EFK/ELK stack (log analysis)
• OpenAPI/Swagger (documentation)
• RDBMS (PostgreSQL, MySQL, Maria or any other)
• NoSQL (Anyone of Mongo DB, Redis, Cassandra, Neo4J or other DBs)
• Automated unit tests/e2e tests (JUnit, TestNG, RestAssured etc)
• CI/CD pipelines (Jenkins, Sonar, Maven/Gradle etc)

Optional: (But highly recommended)

• NewSQL DB (TiDB, CockroachDB)
• AMQP/RabbitMQ
• Kafka
• Docker
• Kubernetes