Sr. Informatica Developer

Snowflake SRE JD

Your Role Accountabilities

• Primarily responsible for administrating Snowflake environments on AWS
• Identify, tune, and fix the performance issues on priority.
• Diagnose and troubleshoot Snowflake related errors and work with team to raise support tickets, follow ups and help to resolve them.
• Implement security, roles, users and privileges using the best practices.
• Provide database/objects recovery as need on basis.
• Design, identify and implement high performing and highly available data warehouse solutions.
• Create database, schema, tables, views, data sharing
• Create Snowflake utilization and capacity/cost plans, identifies, and provide solution for abnormalities.
• Proactively identify, design, and implement process improvements like automating manual processes
• Stay up-to-date with the latest features and best practices in Snowflake administration
• Follow existing database runbooks, create and maintain new runbooks for new and improved processes
• Provide 24X7 On-call support by participating in rotation schedule.

Qualifications & Experiences

• Bachelor's degree in computer science, information systems, or information technology.
• 10+ years of experience as a database administrator.
• Minimum 5+ years of hands-on administration experience, from setting up the Snowflake environments to successfully administering it (AWS preferred)
• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting, Python etc.
• Some experience with AWS with knowledge of S3, EC2, VPC, IAM, Security, Networking etc.
• Ability and experience with the development of processes and procedures to standardize Database configuration
• Extensive experience with implementation and maintenance of Disaster Recovery and High availability.
• Ability to work on unusually complex technical problems and provide solutions that are highly innovative and ingenious.
• Ability to provide technical documentation and project plans for technical staff members.
• Excellent communication, presentation, and customer relationship skills.
• Excellent organizational and time management skills to handle multiple tasks simultaneously
• Ability to provide 24/7 support.

Dear Candidates,

Greetings from AxionConnect.

This is Shweta from the recruitment team of AxionConnect.

As per your profile on the job portal, currently, we have openings for SAS professionals.

• Experience in SAS development.
•   Should have strong experience on Base SAS.
•   Should have strong experience in SQL.
•   Should have experience in Data Integration Studio (must have).
•   Should have strong experience in Enterprise guide.
•   Should have good communication skills.
•   Exposure to BASE SAS, SAS MACROS, SAS Advance, and SAS Enterprise Guide.
•   Banking or financial reporting experience.

Primary Skills

• SAS DI Studio (SAS Data Integration Studio) (Mandatory)

• SAS Eg (Enterprise Guide)

Experience: 3-5yrs

Location: Mumbai (onsite)

Job Description

Company Background

Workplace Fabric (WF) is focused on using Technology to create the most efficient and effective working environments. Using patented sensor technology, data analytics and innovative displays WF helps office users get the best out of their workspace while enabling a business to fully understand the utilisation of an office building.

Most customers are seeing how >20% savings can be achieved as well as creating a much improved working environment for staff and reduced service cost. The business has installations in 50 cities around the world with major blue-chip companies as customers. The business has a cash generative business model and is set for accelerated growth; a very exciting time to join a rapidly growing company.

Overview

The exciting opportunity has become available as a result of company growth and opportunities. The Technical Customer Service position will be working with a friendly professional team and the ideal candidate will provide technical support to clients located worldwide.

To provide training and support for clients who experience issues with equipment, compile clear guides for client and review data trends from the system, carry out root cause analysis when technical issues arise and provide necessary guidance to achieve resolution.

Supporting clients with their requests in relation to their Freespace products and solutions, carry out training sessions on products and analytics dashboard along with return to work solutions.

The Role

• Training clients on products, services, applications, maintenance & analytics dashboard
• Understand client requirements/issues & presents solutions as necessary
• To action ticket requests within Service Level Agreement & clearly articulate updates to clients
• Always looking at ways to improve internal systems and processes
• Prepare client quotes for additional services or products & issue invoices
• Review information and act upon findings
• To be involved in technical discussions in relation to Routers, Access Points, Wifi & Internet connectivity issues
• Interpret and manipulate data
• Prepare documentation to share with clients following site visit
• Facilitate client meetings, sharing information and training
• To understand the functionality of all the Freespace products to support client with their needs
• Carry out any reasonable ad-hoc requests

Working Hours

2: 30AM to 10:30AM IST – Monday to Friday

On call support (only for critical issues) – Alternate weekend

The Person

• Positive can-do attitude, good manner with initiative
• Technical understanding in relation PCs, Networking, Displays, Wireless
• Customer focused & excellent communication skills are essential
• Ability to make decisions, compile reports based on data analytics
• Able to work fast and solve problems under pressure at times of high workload and competing priorities
• Remain focused, composed, optimistic and flexible in difficult situations; resilient and bounces back from failures or disappointments
• Focuses on results and desired outcomes and how best to achieve them
• Comfortable working with ambiguity & to question to gain full understanding
• Displays an ongoing commitment to learning and self-improvement
• A willing and helpful person who thrives on providing support for the team to achieve their goals

Qualification/skills

• Basic knowledge of PCs, Networking, Displays, Wireless
• Validating analytics data
• Discretion with confidential client information
• 3+ years customer service experience within a technical industry
• To have an interest in the build environment or architecture
• A Financial background is desirable
• Proficient in Microsoft Excel & Word is essential
• Excellent communication skills – presentation, written and verbal
• Ability to prioritise workload and problem solve
• Good research skills and attention to detail

Job Description:

Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:

• Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
• Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
• Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
• SQL Query tuning and performance tuning.
• Develop/migrate existing scripts to SSIS.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
• Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
• Importing and exporting the data from different sources using tools, writing required scripts.
• Works closely with other members of the team to accomplish the projects.
• Assists project teams to design and develop core business components utilizing  industry-accepted analysis and design standards.
• Provides and/or assists with, project management and project leadership.
• Create and maintain documentation for all the projects.
• Working with NOSQL databases (Mostly on MongoDB) .

PRIMARY SKILLS: 

TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.

SECONDARY SKILLS:

Database Administration

REQUIRED SKILLS:

• 3+ years of professional experience in working with MSSQL Server 2008 and above.
• 3+ years of professional experience in writing TSQL scripts.
• Thorough experience in SQL query tuning and performance tuning.
• Experience in developing and maintaining SSIS packages.
• Experience in working with NoSQL databases. MongoDB would be preferable.
• Fluent knowledge of MSSQL server DBA.
• Should be a good team player and should possess good attitude and work ethics.
• Should possess excellent communication and written skills.

PREFERRED SKILLS:

• MSSQL DBA.
• SSIS.
• NOSQL, MongoDB

Designation- L1 Tech Support 

Location – Kharghar

Experience -  2 to 5 years

L1 Tech Support: BE/Btech only.

• Must have minimum 2-3 years of support Experience on Financial transactions system
• Monitor and verify program execution, identification and communication of processing variances(e.g. run time, record counts, etc.) and potential issues
• Manage Production alerts and take necessary action as per the run-book
• Creation of incident tickets, and follow-up until closure as per Standard Operational Procedure
• Maintain and adhere production schedules to include ad-hoc requests
• Stopping and starting system processes
• Troubleshoot failures and determine best course of action
• Internal Stakeholder communications with respect to the daily production cycles
• Documenting all Operational activities (Known Error Database, reports, Troubleshooting steps, Operation manual, important mail communications)
• SLA Adherence.
• Good Understanding of SQL and scheduling.
• Familiarity/Experience with UNIX, LINUX, Windows environments
• Familiarity with scheduling and job monitoring tools
• Must be able to do work in all 3 shifts (morning/afternoon/night

If interested, kindly share updated resume, current CTC and Expected CTC.

• 5 to 8 years of hands on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA 
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts 
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas 
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team 
• Experience in requirements gathering, effort estimate, designing and implementation and creating mock-up screens 
• Experience in databases like MS SQL Server (2005 to 2012,2014), MySQL and MS Access 
• Must have strong database concepts and DB designing skills 
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates 
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# 

• VBA, SQL 

• Strong analytical and problem-solving skills 
• Excellent interpersonal and communication skills 
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance 
• Should be able to work independently 
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail 
• Effective time management skills 
• Customer Focus, Willing to learn and self- teach any new technology 
• Strong business and collaboration skills, and responsive to service needs and operational demands.