Python Developer Intern

Profile: AWS Data Engineer

Mode- Hybrid

Experience- 5+7 years

Locations - Bengaluru, Pune, Chennai, Mumbai, Gurugram

Roles and Responsibilities

• Design and maintain ETL pipelines using AWS Glue and Python/PySpark
• Optimize SQL queries for Redshift and Athena
• Develop Lambda functions for serverless data processing
• Configure AWS DMS for database migration and replication
• Implement infrastructure as code with CloudFormation
• Build optimized data models for performance
• Manage RDS databases and AWS service integrations
• Troubleshoot and improve data processing efficiency
• Gather requirements from business stakeholders
• Implement data quality checks and validation
• Document data pipelines and architecture
• Monitor workflows and implement alerting
• Keep current with AWS services and best practices

Required Technical Expertise:

• Python/PySpark for data processing
• AWS Glue for ETL operations
• Redshift and Athena for data querying
• AWS Lambda and serverless architecture
• AWS DMS and RDS management
• CloudFormation for infrastructure
• SQL optimization and performance tuning

Senior Software Engineer – SQL Server / T-SQL

Chennai | IIT Madras Research Park | Full-Time

About Novacis Digital

Novacis Digital is a product-first technology company building AI-driven platforms and large-scale data systems. Our products process complex, high-volume data to power real-time analytics and GenAI-driven experiences.

We don’t see SQL as “just a database layer” - we treat it as a core compute engine. If you love writing efficient SQL and solving performance problems, this is the role for you.

What You Will Do

·      Design and build complex T-SQL stored procedures involving Dynamic SQL, along with views, functions, and triggers

·      Implement flexible, metadata-driven query frameworks using sp_executesql and parameterized Dynamic SQL

·      Engineer high-performance, set-based queries using CTEs, window functions, temp tables and table variables

·      Optimize queries using execution plans, statistics and DMVs

·      Refactor inefficient queries and redesign schemas for performance and scalability

·      Solve real-world challenges related to locks, blocking, deadlocks and transaction isolation

·      Collaborate with application engineers to build reliable, high-performance data access layers

What We’re Looking For

We’re looking for true SQL engineers — people who think in execution flow, logic and data behavior rather than just syntax.

You should have:

·      4+ years of deep hands-on experience with Microsoft SQL Server & T-SQL

·      Strong expertise in:

o  Stored Procedures (with Dynamic SQL)

o  Views

o  Functions

o  Triggers

·      Strong experience with:

o  Dynamic SQL best practices and secure execution patterns

o  Indexing strategies and query plan optimization

o  Handling parameter sniffing and plan instability

·      Strong knowledge of:

o  Temp tables vs table variables

o  Cardinality estimation

o  Cost-based optimization concepts

Nice to Have

·      Exposure to GenAI data pipelines or analytical architectures

·      Exposure to Graph, Vector and No SQL Databases

How We Work

·      We write production-grade T-SQL

·      We value performance, clarity, and correctness

·      We invest heavily in query readability and maintainability

·      Engineering quality is non-negotiable

Apply Now

If you enjoy designing complex Dynamic SQL-powered stored procedures and tuning systems at scale, we’d like to talk.

Job Description:      

Min 2 to 4 Years of experience in C# and ASP.NET, Web application development.

Knowledge about cloud programming or migration to cloud is preferred.

 Mandatory skills:

• Proficient in Web Application development using ASP.NET, C# with .Net version 4.0/ 4.5.
• Experience with SQL Server or any other equivalent Database and know how to build efficient queries.
• Strong knowledge on jQuery, AJAX, JavaScript, HTML5, CSS3 and Bootstrap.
• Experience in debugging in multiple browsers.
• Strong understanding of object-oriented programming.
• Clear understanding of SVN or an equivalent VCS.
• Familiar with IIS and deploying code to Web Server.
• Should have excellent analytical and communication skills.

 Responsibilities:

• Good hands on designing, coding, debugging, technical problem solving, and writing Unit Test cases, etc.
• Translate use cases into functional applications
• Design, build, and maintain efficient, reusable, and reliable C# code
• Ensure the best possible performance, quality, and responsiveness of applications
• Help maintain code quality
• Able to work well in a team setting

 Academic Qualifications Required:

•  B.E. / B.Tech. /MSC in Computer Science or IT.

 Qualifications

M.C.A

B Tech

• Programming Language: Python (Strong knowledge)
• Concurrency & Parallelism: Multithreading, Multiprocessing, AsyncIO, ThreadPoolExecutor, Future, concurrent.futures
• Memory Management: Reference Counting, Global Interpreter Lock (GIL)
• Distributed Computing: Dask, Apache Spark (Preferred)
• Data Processing: NumPy
• Inter-Service Communication: GRPC, REST API
• Containerization & Orchestration: Docker, Kubernetes
• Software Development Practices: Code Optimization, Debugging, Performance Tuning
• Communication & Problem-Solving: Technical Documentation, Team Collaboration, Asking for Clarity When Needed

Skills And Expertise

• Python, 
• Multithreading, 
• Multiprocessing, 
• Dask, Apache Spark, 
• NumPy, 
• REST API, 
• Docker, 
• Kubernetes, 
• Code Optimization

As Back end developer, we expect you to be motivated in solving real-life complex problems and create compelling experiences for our Resellers. Being a small company we have a culture of creative problem solving, intellectual design, fast-paced development, and passionate product delivery. Enhance or build Restful web services for our mobile app.

Responsibilities:

• Develop server-side components, REST APIs
• Assume ownership for existing and new modules including design, development, and unit testing for enhancements of existing modules and development of new modules.
• Analyse problems logically and exercise sound judgment in defining, evaluating, and solving difficult technical and operational problems where solutions may be of a precedent-establishing nature.
• Lead the design and architectural improvements
• Participate and collaborate with team members in design discussions, determines areas of complexity, potential risks to successful implementation, suggest enhancements to architecture, implement POCs, and enhance application.
• Reduce technical debt with quality coding

Requirements:

• A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field) from IITs and Premier Engineering College.
• Excellent Object Orientation, coupled with excellent problem solving and debugging skills.
• Highly skilled at Java and related technologies, including Java Frameworks like Spring-boot or Drop wizard, RESTful web services, JSON, Servlet, JSP, MySQL, MongoDB, Kafka, AWS Solr.
• Must have hands-on experience in building scalable and secure back end systems.
• Have hands-on experience with systems that are asynchronous, RESTful and demand concurrency
• Good to have knowledge of best software engineering practices for all stages of the software development life cycle, including coding standards, code reviews, testing, deployment.

JD - Senior Dev with more than 5 years relevant experience

1. Working experience on web development using Python/Django
2. Comfortable with using Django framework.
3. Understanding of web servers
4. Knowledge in PostgreSQL, MySQL, and other database queries
5. Experience in using Redis cache.
6. Understanding of web technologies
7. Experience in REST API development using Django.
8. Strong hold on Apache
9. Integration of data storage solutions
10. Able to integrate multiple data sources and databases into one system
11. Understanding of JavaScript, and front-end JS frameworks like VueJS, React JS and Angular JS
12. Good communication skill
13. .net/.NET core will be an added advantage

• Utilize established development tools, guidelines and conventions including but not limited to ASP.NET, SQL Server, HTML, CSS, JavaScript, and C#/VB.NET
• Prepare and maintain code for various .Net applications and resolve any defects in systems.
• Prepare test-based applications for various .Net applications
• Enhance existing systems by analyzing business objectives, preparing an action plan and identifying areas for modification and improvement

• Manage defect tracking system and resolve all issues and prepare update for systems
• Investigate and develop skills in new technologies
• Create technical specifications and test plans
• Monitor everyday activities of system and provide require support

• Required experience in .Net Core 2.2 and above, Web API, EF, AWS or Azure Cloud
• Familiarity with the ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC))
• Knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3
• Familiarity with architecture styles/APIs (REST, RPC)
• Snaplogic (both ground and cloud plex ) or Biztalk ( basic administration , simple xlt translations, and Api management ) or any other similar tool
• Update to .net 50 and Microsoft CORE 30 general coding practices
• Visual Studio use for C#
• Shared library through Nugget
• Unit Test / Test driven methods (use of Xunit and MOCK )
• Concepts of “;” service threading, caching, injection, NTier and entity 
• GIT repository (Gitflow branching strategies )
• Azure DevOps pull requests, commitments and Task usage
• SQL artifact writing (sprocs, tables, triggers , indexes, FKs ,and PKs)
• SQL understanding of relational database models

• Should have good problem-solving abilities
• Should be able to troubleshoot issues and determine the cause of a plan’s success or failure
• Should keep up to date with changes in the market and technology that would affect
• Good interpersonal and communication skills
• Comfortable to work as per client requirements/time zones
• Should possess strong team handling experience