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.

Role: Python-Django Developer 

Location: Noida, India

Description:

• Develop web applications using Python and Django.
• Write clean and maintainable code following best practices and coding standards.
• Collaborate with other developers and stakeholders to design and implement new features.
• Participate in code reviews and maintain code quality.
• Troubleshoot and debug issues as they arise.
• Optimize applications for maximum speed and scalability.
• Stay up-to-date with emerging trends and technologies in web development.

Requirements:

• Bachelor's or Master's degree in Computer Science, Computer Engineering or a related field.
• 4+ years of experience in web development using Python and Django.
• Strong knowledge of object-oriented programming and design patterns.
• Experience with front-end technologies such as HTML, CSS, and JavaScript.
• Understanding of RESTful web services.
• Familiarity with database technologies such as PostgreSQL or MySQL.
• Experience with version control systems such as Git.
• Ability to work in a team environment and communicate effectively with team members.
• Strong problem-solving and analytical skills.

Skills:
Enterprise Asset Management/ Work Management
IBM Maximo,SAP IAM,Infor EAM

Job Responsibilities will include:

-----------------------------------------------

- Overall experience of 5-10 years

- Strong Functional knowledge in Enterprise Asset Management/ Work Management

- Hands on experience in IBM Maximo or SAP IAM or Infor EAM and its integration with supporting systems

- Experience in Utilities industry clients (Electricity or Gas or Water)

- Experience in Supply Chain Domain will be a plus

- Full time regular MBA

- A bachelor's degree in Engineering

A Business Architect is responsible for designing and aligning business strategies and operations with the organization's overall goals and objectives.

Roles and Responsibilities:

1.    Designing and implementing business strategies: Business Architects are responsible for developing and implementing business strategies that align with the organization's goals and objectives. They identify areas for improvement, design solutions, and work with stakeholders to implement changes.

2.    Aligning business processes: Business Architects ensure that business processes are aligned with the organization's overall goals and objectives. They identify areas for improvement and design processes that support efficient and effective operations.

3.    Developing and implementing business architecture: Business Architects develop and implement business architecture that aligns with the organization's goals and objectives. They define the organization's structure, systems, processes, and technology, ensuring that they are aligned with the business strategy.

4.    Analyzing business requirements: Business Architects analyze business requirements to identify opportunities for improvement. They work with stakeholders to define requirements and design solutions that meet those requirements.

5.    Leading cross-functional teams: Business Architects lead cross-functional teams, bringing together stakeholders from different departments to design and implement solutions that support the organization's goals and objectives.

6.    Communicating with stakeholders: Business Architects communicate with stakeholders to understand their needs and expectations, and to keep them informed of progress and changes. They work with stakeholders to ensure that solutions meet their requirements and expectations.

7.    Managing change: Business Architects manage change by identifying potential roadblocks and developing strategies to mitigate them. They work with stakeholders to implement changes and ensure that they are adopted effectively.

8.    Continuously improving processes: Business Architects are responsible for continuously improving processes to ensure that they remain aligned with the organization's goals and objectives. They identify areas for improvement, design solutions, and work with stakeholders to implement changes

Overall, a Business Architect plays a critical role in designing and implementing strategies, processes, and systems that support the organization's goals and objectives. They work closely with stakeholders across the organization, leading cross-functional teams and managing change to ensure that solutions are effective and efficient.

Total exp: 8-10 years

 Rel exp: 5 years (Business analysis, Management consulting)

 Location: Chennai

 Salary package: 22-25 LPA (on average)

What we are scouting for

• BS/MS in computer science or equivalent work experience in IT
• 2+ years’ experience designing and developing applications using Java EE platforms
• A strong hands-on programming knowledge in Core Java including Java 8. To solve the problem given in optimized way.
• Strong knowledge on the Data structure and algorithm.
• Experience developing and designing API integrations using SOAP/RESTful
• Should be able to understand the time complexity of the existing algorithm. Able to compare different algorithms available.
• Expert understanding of the object-oriented design and programming concepts
• Know the fundamentals of Object-Oriented Programming using Java;
• Used SQL & NoSQL solutions
• Experience in GIT/SVN, build tools such as Ant/Maven/Gradle
• Experience in JUnit, Sonarqube, Mockito, Jacoco, Maven & Jenkins

Technical Competency – Nice to have

• Experience in Dependency Injection, Annotation, Validations, Auto Wiring
• Good knowledge in internal working on Memory Management, Transaction management
• Knowledge on DevOps pipeline tools like Jenkins, tools for Code quality scan, tools for security scan
• Spring boot
• Spring MVC
• Any Java Certification

Behavioural Competency

• Strong interpersonal communication skills
• Ability to lead self and team toward common goals
• Excellent oral and written communication, presentation, and analytical skills
• Excellence in technical communication with peers and non-technical cohorts

What you will be doing

• As a self-motivated and enthusiastic member of our team, you will work with extremely talented peers in a fun environment building performance efficient payment authorization services that are highly scalable, configurable and available
• You’ll work in an Agile environment with a focus on problem solving and engineering excellence.
• Worked independently and as a member of a team, determined to make active contributions to the assigned Team
• Flexible and adaptable approach to the roles assigned to you
• Ability to coordinate and prioritize tasks, and work in a fast paced and challenging environment
• Deliver on time under dynamics with a high level of integrity and flexibility, sense of urgency, attention to detail and quality standards
• Make a large impact on the design, architecture, and implementation of cutting edge products
• Work with other team members to investigate design approaches, prototype new technology

and evaluate technical feasibility

• Work in an Agile/Scrum environment to deliver high quality software
• Establish architectural principles, select design patterns and then mentor team members on their appropriate application

We are now looking for,

Senior SW Developer – IoT Platform Development

to join the team of experts at the KONE Services & Solutions R&D. You will work together with other professionals to develop advanced KONE digital solutions that leverage the latest in cloud and connectivity technologies.

You are a cloud development expert who is passionate about designing and implementing solutions for our connectivity solutions. You are familiar with the software development patterns and can turn the architectural plans to concrete SW designs. You understand and appreciate the modern SW development practices. You work at your best when you are working with people, and you enjoy helping others.

You will work in a key role inside our Agile SW development team. Your closest colleagues will be other developers, test professionals and the PO of the team. You will be part of KONE Technology and Innovation unit’s IoT Tribe.

Main responsibilities include,

• Producing more efficient software designs for new features in our IoT platform tribe
• Developing clean and efficient code based on the specifications.
• Unit and Integration Testing for the developed code and integrate with code coverage tools.
• Verify and deploy programs and systems
• Recommend and execute improvement for the existing offerings from the IoT platform.
• Create technical documentation for reference and reporting.
• Participating in knowledge sharing and demos

To be successful in this role,

• Having a degree in Computer Science or equivalent with minimum 5+ years of relevant working experience.
• More than 3 years proven experience in developing high volume scalable cloud solutions utilizing platforms like Amazon AWS with IoT domain.
• Having hands on development experience with Java, Node JS and TypeScript.
• Experience working with MVC, WEB API, RESTful services with IoT domain

• Team player with capabilities to take the lead and develop own competencies around the core knowledge is a must.
• Understanding of React JS is an added advantage.

• Strong experience with Serverless Cloud Compute Services with AWS or Azure

• Experience in working with AWS platform and its core services like Lambda, CloudWatch, CloudFormation, CDK, SQS, S3 etc., or its equivalent Azure services
• Understanding of Serverless design, network security, cloud design patterns, high availability and secure systems.

• Hands on experience with both SQL and No-SQL databases.
• Experience on DevOps ways of working with good understanding on CI/CD