Tableau Developer

Job Description: 

We are looking for an experienced SQL Developer to become a valued member of our dynamic team. In the role of SQL Developer, you will be tasked with creating top-notch database solutions, fine-tuning SQL databases, and providing support for our applications and systems. Your proficiency in SQL database design, development, and optimization will be instrumental in delivering efficient and dependable solutions to fulfil our business requirements.

Responsibilities:

 ● Create high-quality database solutions that align with the organization's requirements and standards.

● Design, manage, and fine-tune SQL databases, queries, and procedures to achieve optimal performance and scalability.

● Collaborate on the development of DBT pipelines to facilitate data transformation and modelling within our data warehouse.

● Evaluate and interpret ongoing business report requirements, gaining a clear understanding of the data necessary for insightful reporting.

● Conduct research to gather the essential data for constructing relevant and valuable reporting materials for stakeholders.

● Analyse existing SQL queries to identify areas for performance enhancements, implementing optimizations for greater efficiency.

● Propose new queries to extract meaningful insights from the data and enhance reporting capabilities.

● Develop procedures and scripts to ensure smooth data migration between systems, safeguarding data integrity.

● Deliver timely management reports on a scheduled basis to support decision-making processes.

● Investigate exceptions related to asset movements to maintain accurate and dependable data records.

Duties and Responsibilities: 

● A minimum of 3 years of hands-on experience in SQL development and administration, showcasing a strong proficiency in database management.

● A solid grasp of SQL database design, development, and optimization techniques.

● A Bachelor's degree in Computer Science, Information Technology, or a related field.

● An excellent understanding of DBT (Data Build Tool) and its practical application in data transformation and modelling.

● Proficiency in either Python or JavaScript, as these are commonly utilized for data-related tasks.

● Familiarity with NoSQL databases and their practical application in specific scenarios.

● Demonstrated commitment and pride in your work, with a focus on contributing to the company's overall success.

● Strong problem-solving skills and the ability to collaborate effectively within a team environment.

● Excellent interpersonal and communication skills that facilitate productive collaboration with colleagues and stakeholders.

● Familiarity with Agile development methodologies and tools that promote efficient project management and teamwork.

5+ years of experience designing, developing, validating, and automating ETL processes 3+ years of experience traditional ETL tools such as Visual Studio, SQL Server Management Studio, SSIS, SSAS and SSRS 2+ years of experience with cloud technologies and platforms, such as: Kubernetes, Spark, Kafka, Azure Data Factory, Snowflake, ML Flow, Databricks, Airflow or similar Must have experience with designing and implementing data access layers Must be an expert with SQL/T-SQL and Python Must have experience in Kafka Define and implement data models with various database technologies like MongoDB, CosmosDB, Neo4j, MariaDB and SQL Serve Ingest and publish data from sources and to destinations via an API Exposure to ETL/ELT with using Kafka or Azure Event Hubs with Spark or Databricks is a plus Exposure to healthcare technologies and integrations for FHIR API, HL7 or other HIE protocols is a plus

Skills Required :

Designing, Developing, ETL, Visual Studio, Python, Spark, Kubernetes, Kafka, Azure Data Factory, SQL Server, Airflow, Databricks, T-SQL, MongoDB, CosmosDB, Snowflake, SSIS, SSAS, SSRS, FHIR API, HL7, HIE Protocols

Require Someone skilled in python / C/C++ to work on new products and also support existing AI based products . 

Should be open to learning new frameworks

Key Responsibilities:

 Taking ownership of customer issues reported and seeing problems through to resolution

 Understand, interpret, reproduce, and diagnose issues reported by the customers.

 Researching, troubleshooting and identifying solutions to resolve product issues

 Should be able to handle voice calls, emails and online web sessions with the customer as part of technical troubleshooting

 Should exhibit patience and empathy while working with customer with an aim to drive positive customer experience

 Following standard procedures for proper escalation of unresolved issues to the appropriate internal teams

 Following standard procedures for submitting tickets to the engineering team for further investigation of unresolved issues

 Contributing actively towards knowledge base articles

 Adherence to strict SLA’s

 Ready to work in early morning, general and afternoon shifts, including weekends, on rotation basis

 Should demonstrate an aptitude and appetite for learning newer technologies while expanding on the core knowledge

 The engineer should be available to work in the late evening shift (4pm - 1am) if required.

Primary skills:

 3-8 years of relevant experience.

 Strong technical knowledge on:

• Cloud Technologies – AWS, Azure etc.
• Databases – SQL, Oracle, MySQL etc.
• Operating Systems – Linux, Windows etc
• Networking – Basic networking concepts and troubleshooting
•  Programming knowledge – Java, Python (Desirable, not a must has) o Prior experience with REST and SOAP calls.

 Excellent communication skills – English written and verbal

 HTTP technology and principles, including REST and SOAP principles (Required)

 JSON & XML Data formats (required)  Javascript Regular Expression (Good to have)

 Good understanding of networking protocols and applications (TCP/IP, proxies, load balancing, firewalls, etc.) (Required)

 Working knowledge of database technologies and SQL (Required)

 In-depth familiarity of Linux (Required) (advanced user; sysadmin experience a bonus, but not required)

 Strong analytical and logical reasoning for technical troubleshooting

 Ability to collaborate with cross-functional teams – Dev, QA, Infrastructure teams etc.

 Should be a team player who keeps team’s success before individual achievements

 Knowledge on data integration (Informatica/ Mulesoft)

Requirements

• 6-10 years of experience in technical customer support or network operations
• IP Networking basics: TCP/IP(ARP, IP, ICMP, TCP, UDP), Subnetting, IP Packet flow, OSI layers
• Routing technologies: OSPF, ISIS, BGP, MPLS (L2 & L3 VPN), RSVP, LDP, Multicast protocols (IGMP, PIM), Multicast VPN (MVPN)
• BNG protocols: PPPoE, DHCP, IPoE, L2TP
• Forwarding: Hierarchical QoS, uRPF, Firewalls, ACLs
• Switching and Data Center technologies: VLAN/Trunking, STP, RSTP, VSTP, VXLAN/EVPN, IP-Fabric as an added advantage
• Very Strong automation skills and experience with scripting languages like Python/Robot Framework
• Experience with traffic generators and network protocols analysis tools like IXIA, Spirent
• Any Open Source tools usage & certifications is an added advantage
• Knowledge of Linux, ONL infra and containers is an advantage

Responsibilities

• Proactively work with customers to enable them maximize usage of RtBrick products with least possible effort
• Understand customer usecases and help with qualification of RtBrick products & features
• Triage and resolve any issues customers face with products
• Work with engineering to resolve new defects
• Help engineering by collecting relevant information from live setup and reproduce the issue in LAB occasionally
• Understand in-house regression coverage and identify gaps in test case as per customer deployments
• Write and automate test cases related to customer usage and defect scenarios

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

• Collaborating across an agile team to continuously design, iterate, and develop big data systems.
• Extracting, transforming, and loading data into internal databases.
• Optimizing our new and existing data pipelines for speed and reliability. 
• Deploying new products and product improvements
• Documenting and managing multiple repositories of code.

• Experience with Pandas to process the data and Jupyter notebooks to keep it all together. 
• Familiar with pulling and pushing files from SFTP and AWS S3.  Familiarity with AWS Athena and Redshift is mandatory. 
• Familiarity with SQL programming to query and transform data from relational Databases. 
• Familiarities with AWS Cloud and Linux (and Linux work environment) are mandatory. 
• Excellent written and verbal communication skills.

• Excellent organizational skills, including attention to precise details. 
• Strong multitasking skills and ability to work in a fast-paced environment  Know your way around REST APIs (Able to integrate not necessary to publish)

• Python 
• Sql
• API 
• AWS 
• GCP 
• OCI 
• Azure 
• Redshift

• 5 years experience in database systems 
• 3 years experience with Python to develop scripts

Certified Ethical Hacker Requirements:

• Bachelor’s degree in Information Technology or Computer Science.
• CEH Certification.
• Proven work experience of at least 2-5 years as a Certified Ethical Hacker.
• Effective Programming Skills required but not limited to HTML, JavaScript, Python, PHP, SQL etc.
• Advanced knowledge of networking systems and security software.
• In-depth knowledge of parameter manipulation, session hijacking, and cross-site scripting.
• Technical knowledge of routers, firewalls, and server systems.
• Good written and verbal communication skills.
• Good troubleshooting skills.
• Ability to see big-picture system flaws.

• B.Tech/B.E.(IT/Computers), B.Sc( Computers), MSc (IT), BCA (Computer) or any equivalent graduation or post-graduation