Current Openings
MSBI SQL Developer
Positions : 5
Experience : 2 - 4 yrs
Qualification : Graduate/Post Graduate in Computer/IT
Location : Pune
Posted On : 14th June 2019
Skills Required : MSBI (SSIS/SSAS/SSRS), Data Modelling / SQL
- Extensive database programming experience in writing T-SQL Stored procedures, Joins, Views
- Functions, Constraints and Indexes using various DDL and DML complex high level queries.
- Good Experience in writing Triggers, Dynamic SQL Queries, CTE, Pivot, Cursors, Temp tables,
- Table Variables and Table valued parameters using SQL Server.
- Hands on experience on creating SQL Jobs and scheduling through the SQL Server Agent.
- Expertise on Database designing / data modelling.
- Expertise in SSIS
- Good experience on Performance Tuning stored procedures.
- Expertise on taking the scheduled Backups and Restores databases and generating the scripts.
- Expertise on preparing the scripts and Client builds.
- Maintaining the Logs and Audit information in SQL tables, Experienced in providing Logging
- Error-Handling etc.
- Hands on experience in Extract, Transform & Load (ETL)
- Quick learner and good performer both in team and independent job environment.
- Expertise, knowledge on Production servers and maintenance database servers.
- Candidates should have extensive database experience with a good knowledge of Business Intelligence Data Warehousing Concepts.
Tableau Developer
Positions : 5
Experience : 2 - 4 yrs
Qualification : Graduate/Post Graduate in Computer/IT
Location : Pune
Posted On : 3rd Oct 2019
Skills Required : Knowledge of Databases, Tableau Dashboards & Performance Tuning.
- Develop Tableau dashboards, handling of huge data while developing report.
- Must understand the data structures, difference between Joins / Blending, filters, Row-level security implementation, reporting basics, advanced visualizations, parameters, Sets, Extracts, Incremental refreshes, Row-level and table calculations.
- Viz/Server: Advanced visualizations and dash boarding skills with interactivity and publishing Strong Data warehousing concepts.
- Develop ad-hoc SQL queries for analysis and studies to answer business questions.
- Understanding of Databases, difference between DBMS vs RDBMS, Normalization vs denormalization, Tables, views. Select, joins, aggregations, subqueries.
- To work closely with Data Warehouse and ETL Engineer to thoroughly understand all the relevant data sources to create Reports and Dashboard.
- Performance Monitoring, fine tuning and optimization.
- Good Communication Skills & Learning ability
System Admin
Position : 1
Experience : 4 - 5 yrs
Qualification : Graduate/Post Graduate in Computer/IT
Location : Pune
Posted On : 3rd Oct 2019
Skills Required : LINUX, Shell Scripting, AWS
- Experience in Shell Scripting is Mandatory.
- System Administration of large group of systems having Linux OS
- Installation and Configuration of Linux OS
- Resolving issues related to Infrastructure services, Application support, Cluster Management (HPC & HAC), License services System Monitoring Backup using tools rsync, tar & gzip
- Create scripts for automating tasks
- Administration and management of user account and access controls.
- File system and security Management (Patch/upgrade application and OS)
- File system and security Management (Patch/upgrade application and OS)
- Interacting with Hardware/ AMC Vendors for hardware related issues
- Exposure to Cloud Infrastructure, specifically AWS is preferred
- Administration, maintenance and management of LVM, NFS, samba based services, file system administration, user quota settings
- Crontab Scheduler Management
- Trouble shooting issues related to NIS server and clients
- Installation of Software and upgrades
- Handling memory and swap related issues
- Installation, configuration and maintaining different services / servers which includes infrastructure servers DNS, DHCP, FTP, NFS, SAMBA, sshd, etc
- Securing system and services using OS hardening firewall (Iptables), tcpwrappers, etc.
- Knowledge in Hadoop Administration is preferable.
DevOps Engineer
Position : 1
Experience : 2 - 4 yrs
Qualification : Graduate/Post Graduate in Computer/IT
Location : Pune
Posted On : 19th Feb 2020
Skills Required : Jenkins, Git, AWS CLI CloudWatch CloudTrail, Nagios, Puppet
- The DevOps Engineer will be required to work closely with multiple development teams to implement, manage and support multiple applications including the installation of updates as well as ongoing support.
- Primary Responsibilities:
- Implement / Maintain and Upgrade a full set of Development and Networking Tools
- Maintain desktop/laptop infrastructure; including resolving hardware issues and installing patches and updates
- Provide technical support; troubleshooting and complex problem resolution on escalated issues while monitoring and maintaining development environment stability
- Implement software tools, documentation and procedures to accurately monitor applications and servers daily with early warning indicators
- Generate ad hoc reporting and files (internal and external) upon request
- Work with multiple teams to ensure that all applications adhere to company standards including any Business Continuity
- Communicate with customers while investigating or providing problem resolution.
- Answer escalation questions for internal colleagues where appropriate
- Potential off-hours escalations that may require being available
- Working knowledge of database environment, utilities and SQL
- Must have
- Tool – Jenkins, Git, AWS CLI CloudWatch CloudTrail, Nagios, Puppet
- Scripting – BASH or Python
- Strong Linux knowledge and should also have worked on Windows Systems and Servers
- Any Build tool knowledge i.e. Maven, ANT
- Server – Tomcat 8/Apache, NGINX
- Knowledge of building Linux Package & including resolving hardware issues and installing patches and updates
- Good to have knowledge about
- Docker
- Ansible
- Virtualization Tools
- VPN
- AD/LDAP
Python Developer
Position : 2
Experience : 2 - 6 yrs
Qualification : Graduate/Post Graduate in Computer/IT
Location : Pune
Posted On : 19th Feb 2020
Skills Required : Numpy, Os, Spicy, Django
- Technical Knowledge :
- Standard python packages Numpy, scipy, os
- Strong analytical skills, grasp of data structures and algorithms
- Experience in designing highly scalable software applications
- Experience in building APIs, Multi-threading for tasks on Linux platform
- Experience with Docker and version control systems
- Database management: MySQL, Postgres
- Experience with integration with AWS environment and cloud based services
- Exposure to flow integration and development in machine learning
- Exposure to Frontend development: Django, HTML CSS
- Strong communication skills, client communication experience
- Team lead experience, ability to lead a team of 4 members, task management/assignment, reviews and deliverables
However, we are always keen to meet energetic and talented professionals who would like to join our team.
If you wish to be considered for any future positions, please send your CV and covering letter to : careers@xcaliberinfotech.com