11+ SQL Query Analyzer Jobs in Chennai | SQL Query Analyzer Job openings in Chennai

• Proficient with SQL Server/T-SQL programming in creation and optimization of complex Stored Procedures, UDF, CTE and Triggers
• Overall Experience should be between 4 to 7 years
• Experience working in a data warehouse environment and a strong understanding of dimensional data modeling concepts. Experience in SQL server, DW principles and SSIS.
• Should have strong experience in building data transformations with SSIS including importing data from files, and moving data from source to destination.
• Creating new SSIS packages or modifying existing SSIS packages using SQL server
• Debug and fine-tune SSIS processes to ensure accurate and efficient movement of data. Experience with ETL testing & data validation.
• 1+ years of experience with Azure services like Azure Data Factory, Data flow, Azure blob Storage, etc.
• 1+ years of experience with developing Azure Data Factory Objects - ADF pipeline, configuration, parameters, variables, Integration services runtime.
• Must be able to build Business Intelligence solutions in a collaborative, agile development environment.
• Reporting experience with Power BI or SSRS is a plus.
• Experience working on an Agile/Scrum team preferred.
• Proven strong problem-solving skills, troubleshooting, and root cause analysis.
• Excellent written and verbal communication skills.

1. GCP - GCS, PubSub, Dataflow or DataProc, Bigquery, BQ optimization, Airflow/Composer, Python(preferred)/Java

2. ETL on GCP Cloud - Build pipelines (Python/Java) + Scripting, Best Practices, Challenges

3. Knowledge of Batch and Streaming data ingestion, build End to Data pipelines on GCP

4. Knowledge of Databases (SQL, NoSQL), On-Premise and On-Cloud, SQL vs No SQL, Types of No-SQL DB (At Least 2 databases)

5. Data Warehouse concepts - Beginner to Intermediate level

6.Data Modeling, GCP Databases, DB Schema(or similar)

7.Hands-on data modelling for OLTP and OLAP systems

8.In-depth knowledge of Conceptual, Logical and Physical data modelling

9.Strong understanding of Indexing, partitioning, data sharding, with practical experience of having done the same

10.Strong understanding of variables impacting database performance for near-real-time reporting and application interaction.

11.Should have working experience on at least one data modelling tool,

preferably DBSchema, Erwin

12Good understanding of GCP databases like AlloyDB, CloudSQL, and

BigQuery.

13.People with functional knowledge of the mutual fund industry will be a plus Should be willing to work from Chennai, office presence is mandatory

Role & Responsibilities:

● Work with business users and other stakeholders to understand business processes.

● Ability to design and implement Dimensional and Fact tables

● Identify and implement data transformation/cleansing requirements

● Develop a highly scalable, reliable, and high-performance data processing pipeline to extract, transform and load data from various systems to the Enterprise Data Warehouse

● Develop conceptual, logical, and physical data models with associated metadata including data lineage and technical data definitions

● Design, develop and maintain ETL workflows and mappings using the appropriate data load technique

● Provide research, high-level design, and estimates for data transformation and data integration from source applications to end-user BI solutions.

● Provide production support of ETL processes to ensure timely completion and availability of data in the data warehouse for reporting use.

● Analyze and resolve problems and provide technical assistance as necessary. Partner with the BI team to evaluate, design, develop BI reports and dashboards according to functional specifications while maintaining data integrity and data quality.

● Work collaboratively with key stakeholders to translate business information needs into well-defined data requirements to implement the BI solutions.

● Leverage transactional information, data from ERP, CRM, HRIS applications to model, extract and transform into reporting & analytics.

● Define and document the use of BI through user experience/use cases, prototypes, test, and deploy BI solutions.

● Develop and support data governance processes, analyze data to identify and articulate trends, patterns, outliers, quality issues, and continuously validate reports, dashboards and suggest improvements.

● Train business end-users, IT analysts, and developers.

Job Title: iOS Developer

Experience: 1–4 Years

Location: Indore (On-site)

Employment Type: Full-time

Requirements:

• 1 to 4 years of experience in iOS app development
• Strong knowledge of Swift, SwiftUI, and UIKit
• Experience working with RESTful APIs and third-party libraries
• Familiarity with Apple’s design principles and interface guidelines

Key Responsibilities:

• Design, develop, and maintain iOS applications using Swift and SwiftUI
• Collaborate with cross-functional teams to define, design, and ship new features
• Ensure the performance, quality, and responsiveness of applications

Wissen Technology is hiring for Devops engineer

Required:

-4 to 10 years of relevant experience in Devops

-Must have hands on experience on AWS, Kubernetes, CI/CD pipeline

-Good to have exposure on Github or Gitlab

-Open to work from hashtag Chennai

-Work mode will be Hybrid

Company profile:

Company Name : Wissen Technology

Group of companies in India : Wissen Technology & Wissen Infotech

Work Location - Chennai

Website : www.wissen.com

Wissen Thought leadership : https://lnkd.in/gvH6VBaU

LinkedIn: https://lnkd.in/gnK-vXjF

• Bachelor's degree in computer science or equivalent experience
• 2+ years of experience in software engineering.
• Experience with building B2B and consumer quality products, enabling business capability and objectives through technology.
• Strong cloud infrastructure experience with AWS.
• Experience in engineering practices such as code refactoring, design patterns, design driven development, continuous integration, building highly scalable applications and application security.
• Experience working with a development team using Agile methodology.
• Experience in container technologies like Docker/Kubernetes a plus.
• Hands-on skills working with SQL and No-SQL databases
  Broad experience across the following application development technologies and in depth skills with at least one: NodeJS, React, GraphQL,Python, R, Java/C++ and/or other open source application development frameworks.
• Ability to strategically balance test coverage, documentation and timelines (API/ Unit testing).
• Strong analytical and problem-solving skills paired with the ability to develop creative and efficient solutions.
• Able to work under competing priorities, manage expectations effectively and support the team under pressure; distinct user focus and quality mindset.

• Writing well-designed, testable and efficient code.
• Gathering and evaluating user feedback.
• Working as a part of a dynamic team to deliver winning products.
• Providing code documentation and other inputs to technical documents.
• Supporting continuous improvement by investigating alternatives and new technologies and presenting these for architectural review.
• Troubleshooting and debugging to optimise performance.

• You possess a Degree/Diploma in Computer Science, Engineering or related field.
• You have at least 1-3 year experience, ideally within a Software Engineer role with some inhand experience with Flutter or dart.
• You pay strong attention to detail and deliver work that is of a high standard.
• You are adaptable and thrive in changing environments.
• You are highly goal driven and work well in fast paced environments.

•  JAVA/J2EE (Mandatory)
• HTML/CSS – Basics would suffice
• JavaScript, JQuery, JQWidgets – Must be proficient and core skill requirement

•  .NET Framework (v4.5 and above) + C# (v5 and above) programming language: Core skill set and mandatory
• Windows WCF (SOAP) /Web-API (REST using JSON): Must be proficient
• Windows Server knowledge – IIS + Windows services: Basics from deployment perspective
• MS SQL server: Must be proficient with queries and database objects

• Minimum 3 years as a technical lead
• Experience in Business, Data, Technical Architecture and leveraging tools
• Ability to triage complex problems into smaller units that are amenable to being solved.
• Inquisitive and analytical mind
• Proven ability to manage non-direct reports to achieve results and to work in a multi-cultural multi-functional environment where consensus is critical for success
• Customer and end-user focused and have excellent oral and written communications skills