Total 13 job vacancies by TECH MAHINDRA LIMITED

Designation / Job title : Developer Programmer - 261312

Primary or Mandatory skills :-
• Oracle (RAC & Single Instance)
• Red Hat OCP (Both AWS and On-Prem)
• PostgreSQL (RAC & Single Instance)
• MySQL (RAC & Single Instance)
• SQL Server (RAC & Single Instance)
• Database Performance Tunning
• Database Monitoring configuration and management
• Database Backup and Recovery
• Database User Management and Security
• Database and Oracle Engineered System Patch Management

Good to have skills :
LINUX, AIX, SOLARIS, HP-UNIX, WINDOWS, SQL LANGUAGUE, TSQL, Exa-CC , Exa-Data , DELL EMC Net Backup , NAGIOS , DYNATRACE , IT ASSIST , OEM , AWS EC2 , DB2

Detailed Job description : -
• Manage and Maintain databases like Oracle, PostgreSQL, MySQL and SQL Server, along with RAC for each of the database types.
• Perform Quarterly and Monthly patching for all the databases including Oracle, PostgreSQL, MySQL and SQL Server, hosted on any of the platform like AWS (EC2) , Red hat OCP , Exa-CC , Unix , AIX and Solaris.
• Work with business analysts and stakeholders to define and understand data requirements, including storage, access, and retrieval needs.
• Perform database/schema backup or restore as per requirement from the business or the application.
• Assess the feasibility of database-related requirements, identifying which DBMS features (e.g., PL/SQL for Oracle or T-SQL for SQL Server) best suit the project’s needs.
• Collaborate to define data structures and specifications, considering business rules, relationships, and constraints for optimal performance and integrity.
• Design database schemas, including tables, views, indexes, and relationships, following best practices for normalization and performance optimization.
• Leverage database-specific features like Oracle’s partitioning, SQL Server’s clustered indexes, or PostgreSQL’s JSONB support to ensure performance and scalability.
• Develop optimized SQL queries, stored procedures, functions, and triggers to handle data-related logic efficiently.
• Use database-specific query languages (e.g., PL/pgSQL in PostgreSQL, PL/SQL in Oracle, T-SQL in SQL Server) to achieve complex data operations.
• Design and implement data access layers in the application code, following best practices for connecting to and interacting with databases securely and efficiently.
• Test complex queries and stored procedures for accuracy and performance, using tools like EXPLAIN plans or profiling to optimize execution paths.
• Perform integrity checks, ensuring data is consistent across tables and complies with business rules and constraints.
• Troubleshoot data-related issues such as slow queries, deadlocks, or inconsistent data, using diagnostic tools like SQL Profiler for SQL Server or pgAdmin for PostgreSQL.
• Regularly optimize database performance by adjusting indexes, rewriting queries, and archiving data as needed.
• Address incidents involving data access, data integrity, or performance issues, resolving them within the specified SLA.
• Implement and test schema changes or updates, coordinating with DBAs to minimize downtime and disruption to applications.
• Follow best practices for secure data handling, such as using parameterized queries to prevent SQL injection, encrypting sensitive data, and following access control protocols.
• Ensure database structures and queries comply with data protection and privacy regulations (e.g., GDPR, HIPAA), and apply role-based access controls where needed.
• Set up audit trails, where required, to monitor data access and modifications, particularly in systems with sensitive data.
• Seek ways to improve data workflows and processes, introducing automation or improved query patterns to streamline performance.
• Coordinate database changes across development, testing, and production environments
• Monitor database performance post-deployment, quickly addressing any issues that arise from new code or schema changes.

Designation / Job title : 261312-Developer Programmer

Primary or Mandatory skills :-
1. MS SQL Server, MSBI (SSIS, SSAS, SSRS)
2. DevOps, GIT

Good to have skills :
1. Azure Data Factory
2. PowerBI
3. Data Modelling/Data Profiling

Detailed Job description : -
Role: Developer
Responsibilities:
1. Working with business users to gather, clarify requirements and business rules by running workshops with stakeholders.
2. Design and implement guidelines for Data Platforms, including sourcing, loading, transformation, storage and extraction of data
3. Develop, maintain, and upgrade existing data workflows, deployment pipelines through all stages of application life cycle management
4. Design and implement data schema for data marts and pipelines for existing/new products
5. Ability to perform performance tuning and optimization on new and/or existing datawarehouse solutions.
6. Assist the Team in troubleshooting and supporting what they build, including support for production tickets resolution and root cause fixes.
7. Creating and maintaining documentation of data architecture, data flow, and data quality standards
8. Work individually or as part of a wider team on other development tasks as directed by the Manager/Head of IT
Skill and Experience:
1. Solid experience in EDW design and implementation
2. Strong experience in ETL architecting and design
3. Advanced skills in Microsoft BI Stack
4. Strong technical skills using the technologies in use (SQL Server, SSIS, SSRS)
5. Good understanding of CI/CD pipeline (DevOps) including GIT, Code Deployment/Build and experience working with CloudFormation templates
6. Knowledge of SDLC & Agile methodologies with the ability to document business requirements and liaise with stakeholders
7. Good to have experience in Azure Data Factory, Azure Databricks and PowerBI
8. Self-motivated, capable of taking the initiative and contributing to the team

Designation / Job title : 261312-Developer Programmer

Primary or Mandatory skills :-
• Oracle Spatial
• FME
• Geoservers
• PLSQL
• Shell Scripting
• Incident Management
• Control-M and CAWA

Good to have skills :
• Knowledge on Incident Management ,change, pager,Maveen, Microsoft System Centre Configuration Manager, VMware Power CLI., Puppet Bolt and Ansible,
• ITIL framework

Detailed Job description : -
• Gather the requirements from Solution designer/system engineers to write scripts, stored procedures and functions for database system.
• Prepare technical design document based on the requirement.
• Perform scheduling of scripts using Control-M and CAWA on midrange environments (Prod/Dev/QA) ensuring naming and quality standards are maintained.
• Perform batch job maintenance as per request from solution designer by writing Unix shell script, PowerShell, Python and other scripting language.
• Develop RPA process to automate repetitive task using UiPath and other RPA tools.
• Analyse the application and provide automated recovery wherever possible. Also optimize/Fine tune the workflows for efficiencies; Also design and Implement process improvements for client transitions.
• Create standard operating procedures, policies and other relevant documentation to support external applications like Informatica, Databases etc.
• Write server-side SQL statements or Java subprograms and client-side procedural code that use SQL statements.
• Set up conventional/Periodic calendars to be used by job workflows and maintain them on a yearly basis by taking inputs from customer.
• Work with relevant parties to prevent repetitive failures by recommending them solutions using latest features/capabilities of the tools.
• Prepare test plan, test cases to cover testing for all the Application workflow created.
• Prepare Test summary report to share it with stakeholders for approvals.
• Responsible for automating the tasks by scripting which will help to reduce tedious/ repetitive tasks.
• Conduct proof of concept for various applications to automate.
• Develop scripts which will keep the systems clean and ensure health checks.
• Communicate best practices and methods to effectively support customer Application env.

Designation / Job title : Developer Programmer - 261312

Primary or Mandatory skills :-
Datastage
Datawarehousing
Tableau

Good to have skills :
Banking Datastage Expertise

Detailed Job description : -
· Worked as Technical Lead in area of Data Warehousing/Business Intelligence for 3 + years
· Very hands on heavy on quickly learning Data Application, Data Analysis, Scripting, Data Transformation and Reconciliation.
· Data Migration experience if possible
· Must have experience working as DWH modelling, developer, or analyst for 8+ years
· AWS Redshift, Netezza working knowledge and Data Modelling is a MUST
· Must have led a team for minimum 5 people
· Must have good collaboration and communication skills
· Performance optimization skill and code review skill is a must
· Good to have reporting skills like Cognos, Tableau , ThoughtSpot etc.
· Should have experience in working on various detail designs (HLD and LLD).
· Good to have Unix Shell Scripting Knowledge
· Additional Skills Control M, Bit bucket/ Source Tree, Jenkins
· Should have experience in Cost estimates for development and technical tasks break down
· Should have good exposure to DBFit like ETL testing tools for test driven development
· Should have experience in DataStage and DB2 flex

Designation / Job title : Developer Programmer - 261312

Primary or Mandatory skills :-
• 8-10 years of experience as a Software Developer with a focus on .NET technologies (C#, .NET Framework, .NET Core)
• Extensive experience in web development using ASP.NET MVC/Core, RESTful APIs, and front-end technologies (JavaScript, Angular, ReactJS).
• Strong understanding of database design and optimization, including experience with SQL Server and SQL/LINQ.

Good to have skills :
Understanding of the Energy & Utilities Domain with a focus on geospatial data management.
Experience with cloud platforms (Azure, AWS) and cloud-native development principles.
Proficiency in DevOps tools and methodologies.

Detailed Job description : -
• 8-10 years of experience as a Software Developer with a focus on .NET technologies (C#, .NET Framework, .NET Core).
• Extensive experience in web development using ASP.NET MVC/Core, RESTful APIs, and front-end technologies (JavaScript, Angular, ReactJS).
• Strong understanding of database design and optimization, including experience with SQL Server and SQL/LINQ.
• Proven ability to lead the design, development, and deployment of software solutions from conception to implementation.
• Demonstrated experience in collaborating with cross-functional teams to understand business needs and translate them into technical specifications.
• Proficiency in implementing solutions using various technologies including C#, .NET Framework, .NET Core, ASP.NET MVC/Core, RESTful APIs, web development frameworks (Angular, ReactJS), and database technologies (SQL Server, SQL/LINQ).
• Experience working in an Agile development environment is a plus.
• Understanding of cloud platforms (Azure, AWS) and cloud-native development principles
• Experience with version control systems (e.g., Git) and DevOps tools
• Understanding of the Energy & Utilities Domain with a focus on geospatial data management (Preferred).
• Strong problem-solving and analytical skills with the ability to troubleshoot complex technical challenges.
• Excellent communication and interpersonal skills to collaborate effectively with stakeholders at all levels.
• Ability to work independently and manage competing priorities in a fast-paced environment.

Designation / Job title : Developer Programmer - 261312

Primary or Mandatory skills :-
• AWS Redshift, AWS S3, AWS DMS, IBM Netezza, IBM DB2, IBM MDM, Oracle, IBM Infosphere CDC, Unix.

Good to have skills :
• Python
• Data Bricks

Detailed Job description : -
• 11+ Years of total experience, 6 years in Business Analysis.
• Support process of Business context and Requirements gathering.
• Undertake technical analysis; define and document business logic; mapping and governance and success criteria.
• Develop and test the code based on understanding of requirements.
• Support defining of MVPs; features/stories and benefits, Estimates, development of flight plans.
• Attend and contribute to Agile ceremonies – Iteration Planning/Stand-up meetings/Retrospectives/Showcases.
• Facilitate elaborations sessions; attend and facilitate other workshops as necessary.
• Work collaboratively maintaining ongoing dialogue and relationships with Stakeholders as part of continued solution development and support.
• Data/ETL experience and adding Project lifecycle experience.
• Track record of working in a fast-paced collaborative cross-functional environment.
• Proficiency in working with distributed teams.
• Advanced problem solving & troubleshooting skills; business research and analytical skills.
• Strong in SQL, Data Analysis and Data Profiling skills.
• Familiarity with Data Modelling and Data Warehouse concepts.
• Knowledge of a variety of database platforms, e.g. Netezza, Oracle, DB2, etc.
• Knowledge of applications support and development.
• Good Presentation and Communication skills.

Designation / Job title : System Engineer_263111 – Computer Network and Systems Engineer

Primary or Mandatory skills :-
• Providing specialist skills in Designing and implementing network systems including switches, routers, firewalls, and other networking equipment.
• Maintaining documentation of network design, configuration, and procedures.
• Developing network disaster recovery and business continuity plans.
• Providing technical support to clients and internal teams as needed.
• Proficiency in various distributions such as Red Hat, Ubuntu, CentOS, AIX, etc.
• Shell scripting in Bash, PowerShell, or Python for automation.
• Understanding of networking protocols, IP addressing, and subnetting.
• Experience with routers, switches, VLANs, and firewalls.
• Management of DNS and DHCP servers.
• Configuration and management of Virtual Private Networks.

Good to have skills :
• Knowledge of networking in containerized environments, especially with Docker and Kubernetes.
• Proficiency in Python, PowerShell, or Perl for complex automation tasks.

Detailed Job description : -
• Design and deploy LANs, WANs, and wireless networks, including routers, switches, firewalls, and VPNs.
• Develop and implement network policies, standards, and best practices.
• Configure and manage network hardware and software, ensuring they meet organizational needs and performance benchmarks.
• Administer and maintain servers (both physical and virtual), including installation, configuration, and troubleshooting.
• Manage operating systems (Windows, Linux, Unix) and related software, ensuring they are up-to-date and secure.
• Implement and manage system backups, disaster recovery plans, and business continuity strategies.
• Design and manage cloud-based network infrastructure on platforms such as AWS, Azure, or Google Cloud.
• Implement hybrid cloud solutions, ensuring seamless integration between on-premises and cloud environments.
• Manage cloud security, including access control, data encryption, and compliance with regulatory requirements.

Designation / Job title : Developer Programmer-261312

Primary or Mandatory skills :-
• Proficiency in one or more programming languages (Java, C#, Python, JavaScript).
• Experience with software development frameworks and tools.
• Strong understanding of software development life cycle (SDLC) methodologies.
• Database administration. (Oracle SQL developer)

Good to have skills :
• Telecom Billing, Rating & Proforma invoicing
• Selenium, Cucumber, GIThub, Maven, Jenkins (CI-CD), TestNG, JUNIT, BDD.
• SOAP UI, Postman, Salesforce, Netcracker Networks(Helix), Single.eView, ALM, Jira.

Detailed Job description : -
• Design, develop, and implement software applications based on project requirements.
• Write clean, scalable, and efficient code using appropriate programming languages and frameworks.
• Maintain and improve the performance of existing software.
• Analyze user needs and software requirements to determine feasibility and cost.
• Conduct system analysis and development to keep systems current with changing technologies.
• Develop and execute unit and integration tests to ensure software quality and functionality.
• Debug and resolve technical issues and software defects.
• Ensure the software operates within performance standards.
• Collaborate with cross-functional teams, including designers, product managers, and other developers, to develop software solutions.
• Participate in code reviews to maintain code quality and share knowledge with the team.
• Communicate project status, issues, and progress to stakeholders.
• Prepare and maintain documentation for software applications, including user manuals and technical specifications.
• Document development processes, coding standards, and project-related information.
• Stay updated with emerging technologies and industry trends to incorporate new techniques and tools.
• Suggest and implement improvements in software development processes and practices.
• Assist in project planning, including task estimation and scheduling.
• Track and report on project progress, ensuring timely completion of tasks.
• Ensure software security by following best practices and adhering to security policies.
• Comply with software licensing and data protection regulations.
• Mentor junior developers and provide guidance to improve their skills.
• Conduct training sessions to share knowledge and promote best practices within the team.

Designation / Job title : Software Engineer - 261313 - Data Engineer

Primary or Mandatory skills :-
• Azure Databricks
• Data Migration

Good to have skills :
• Scala
• SQL
• Cloudera

Detailed Job description : -
• Demonstrated Experience in Py-Spark SQL, SQL, Databricks, Teradata/ Cloudera, DevOps, Python
• Familiarity working with large systems
• Experience of having worked/ support Data migration
• Strong oral and written communication skills
• Self-motivated with the ability to work in a team or independently
• Capable of working under tight deadlines

Designation / Job title : Developer Programmer - 261312/ Developer (Other)
Primary or Mandatory skills :-
• Big Data
• Cloudera Hadoop
• Spark, Scala
• Databricks
• Azure
Good to have skills :
Data lake, Azure, Telecom Domain Knowledge.
Detailed Job description :
• Minimum 11 years of experience in Enterprise Data Warehouse solutioning, Exposure of Big Data technology stacks like Cloudera, HBase, Hive, Impala Kafka and Spark, Analytics tools like Python, R
• In depth knowledge of Teradata Utilities, Macros
• Data lake, Azure
• Strong SQL analytical skills
• Knowledge in Unix system
• Good to have knowledge in Control M scheduling
• Involve in Business requirement gatherings, Analysis of requirements, Design, solution walkthrough, Workshops & Identify gap’s in solution & Business requirement with Business & IT team.
• Create detailed technical design document based on the requirements and High-Level Solution Design.
• Basic knowledge in Spark leveraging Scala or Python and Optimize the performance of the built Spark applications in Big data Platform.
• Strong analytical mindset and ability to work independently and in fast-paced and quickly changing environment
• Work and continuously improve the DevOps pipeline and tooling to provide active management of the continuous integration/continuous deployment processes
• Good to have experience in any ETL tools
• Experience in Teradata, Informatica, Linux, Hadoop Spark, Control-M
• Experience working in an Agile delivery model
• Preparing implementation plans, reports, manuals and other documentation on the status, operation and maintenance of Data ware housing Applications.
• Designing, developing and unit testing of Data Ingestion, transformation using bigdata, Hadoop and Databricks.

Designation / Job title : Developer Programmer - 261312/ Application Support

Primary or Mandatory skills :-
• Big Data
• Azure Databricks
• Teradata

Good to have skills :
• Data lake, Azure, Telecom Domain Knowledge

Detailed Job description : -
• Minimum 8 years of experience in Enterprise Data Warehouse solutioning, Exposure of Big Data technology stacks like Cloudera, HBase, Hive, Impala Kafka and Spark, Analytics tools like Python, R
• In depth knowledge of Teradata Utilities, Macros
• Strong SQL analytical skills
• Knowledge in Unix system
• Having working experience in Telecommunications.
• Having experience in Hadoop stack, HDFS, MapR, Sqoop, Hive and Spark.
• Good in designing and architecting Hadoop applications and recommending the right solutions and technologies for the applications.
• Hands-on experience with importing and exporting data from Relational databases to HDFS, Hive and HBase using Sqoop.
• Analysed large amounts of data sets writing Hive queries.
• Having good knowledge on Linux, shell scripting and core Java.
• Having experience in DataBricks and Azure platform.
• Having good experience on spark streaming process for various streaming sources like kafka.
• Involve in Business requirement gatherings, Analysis of requirements, Design, solution walkthrough, Workshops & Identify gap’s in solution & Business requirement with Business & IT team.
• Create detailed technical design document based on the requirements and High-Level Solution Design.
• Basic knowledge in Spark leveraging Scala or Python and Optimize the performance of the built Spark applications in Big data Platform.
• Strong analytical mindset and ability to work independently and in fast-paced and quickly changing environment
• Work and continuously improve the DevOps pipeline and tooling to provide active management of the continuous integration/continuous deployment processes
• Experience in Teradata, Informatica, Linux, Hadoop Spark, Control-M
• Experience working in an Agile delivery model
• Preparing implementation plans, reports, manuals and other documentation on the status, operation and maintenance of Data ware housing Applications.

Designation / Job title : Developer Programmer- 261312 / Database Programmer / Developer

Number of Positions : 10

Primary or Mandatory skills:-
1. Datawarehouse solutioning
2. Azure - Databricks
3. Big Data Platform - Cloudera
4. Teradata Tools and utilities
5. Linux
6. Hadoop Spark

Good to have skills:- Data lake, Azure, Telecom Domain Knowledge

Detailed Job description:-

Minimum 10 years of experience in Enterprise Data Warehouse solutioning, Exposure of Big Data technology stacks like Cloudera, HBase, Hive, Impala Kafka and Spark, Analytics tools like Python, R.

• In depth knowledge of Teradata Utilities, Macros
• Data lake, Azure
• Strong SQL analytical skills
• Knowledge in Unix system
• Good to have knowledge in Control M scheduling
• Involve in Business requirement gatherings, Analysis of requirements, Design, solution walkthrough, Workshops & Identify gap’s in solution & Business requirement with Business & IT team.
• Create detailed technical design document based on the requirements and High-Level Solution Design.
• Basic knowledge in Spark leveraging Scala or Python and Optimize the performance of the built Spark applications in Big data Platform.
• Strong analytical mindset and ability to work independently and in fast-paced and quickly changing environment
• Work and continuously improve the DevOps pipeline and tooling to provide active management of the continuous integration/continuous deployment processes
• Good to have experience in any ETL tools
• Experience in Teradata, Informatica, Linux, Hadoop Spark, Control-M
• Experience working in an Agile delivery model
• Preparing implementation plans, reports, manuals and other documentation on the status, operation and maintenance of Data ware housing Applications.

Designation / Job title : Developer Programmer- 261312 / Database Programmer / Developer

Number of Positions : 10

Primary or Mandatory skills:-
1. Datawarehouse solutioning
2. Azure - Databricks
3. Big Data Platform - Cloudera
4. Teradata Tools and utilities
5. Linux
6. Hadoop Spark

Good to have skills:- Data lake, Azure, Telecom Domain Knowledge

Detailed Job description:-

Minimum 10 years of experience in Enterprise Data Warehouse solutioning, Exposure of Big Data technology stacks like Cloudera, HBase, Hive, Impala Kafka and Spark, Analytics tools like Python, R
• In depth knowledge of Teradata Utilities, Macros
• Data lake, Azure
• Strong SQL analytical skills
• Knowledge in Unix system
• Good to have knowledge in Control M scheduling
• Involve in Business requirement gatherings, Analysis of requirements, Design, solution walkthrough, Workshops & Identify gap’s in solution & Business requirement with Business & IT team.
• Create detailed technical design document based on the requirements and High-Level Solution Design.
• Basic knowledge in Spark leveraging Scala or Python and Optimize the performance of the built Spark applications in Big data Platform.
• Strong analytical mindset and ability to work independently and in fast-paced and quickly changing environment
• Work and continuously improve the DevOps pipeline and tooling to provide active management of the continuous integration/continuous deployment processes
• Good to have experience in any ETL tools
• Experience in Teradata, Informatica, Linux, Hadoop Spark, Control-M
• Experience working in an Agile delivery model
• Preparing implementation plans, reports, manuals and other documentation on the status, operation and maintenance of Data ware housing Applications.