SQL server Jobs in Bangalore (Bengaluru)

* 2-5 Years of experiece in UI path and AA tools.* Must have experience in creating solution design document. * Strong in stakeholder communication.* Experience using API services.* SQL Server knowledge.*JSON, C# and VB Experience.

Profile Summary: The Software Engineer - Full Stack is responsible for software development as a member of a project team. He/she works closely with subject matter experts, business analysts, quality analysts, and others to design, develop, and test software solutions to business problems.     Responsibilities: Solve problems of considerable scope and complexity. Designing, coding (at least 80%), debugging and optimizing both frontend and backend components as well as internal tools, such as configuration management and development/test environments. Help select and incorporate new tools and methods. Work closely with project, application, and enterprise architects to develop solutions. Drive the continuous evolution of best practices within the development team. Identify and recommend where increased automation, performance enhancements, application enhancements and quality enhancements may be incorporated. Balance customer and business needs to design, develop, test, and deliver against timelines. Contribute to architecture and code design, estimates, code reviews, and documentation to ensure top quality software. Keeps current with emerging technologies and technological developments within the industry. Monitors and evaluates competitive applications and products. Reviews current practices relevant to the solution of assigned projects. Remains flexible and responsive to changing priorities and multiple, concurrent responsibilities. Be a talent multiplier that motivates the team around them to excel and perform well. Other duties as assigned.   Requirements: Bachelor's Degree - Computer Science, Management Information Systems, or related field. 3-5 years of software development experience. Experience in lieu of education: Two years of experience for every year of formal education required. Application development experience using. NET, C#, . NET Core, SQL Server, CSS, and other web development technologies.

Candidate is responsible for design and development of small modules in ASP.Net MVC , C#, SQL Server and client side technology as react.js. Though react.js is used knowledge of javascript is absolutely necessary and react.js is an added advantageCandidate should be self motivated and proactive and should have worked in agile environments

Develop software solutions by studying information needs; conferring with users; studying systems flow, data usage and work processes; investigating problem areas; following the software development lifecycle Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code Prepare and install solutions by determining and designing system specifications, standards and programming Improve operations by conducting systems analysis; recommending changes in policies and procedures Protect operations by keeping information confidential Provide information by collecting, analyzing, and summarizing development and service issues Accomplish engineering and organization mission by completing related results as needed First and foremost, developing software our users need Mentor junior and mid-level engineers Collaborate with team to brainstorm and create new products Grow engineering teams by interviewing, recruiting, and hiring Make informed decisions quickly and taking ownership of services and applications at scale Work collaboratively with others to achieve goals Be a persistent, creative problem ­solver Remain cool and effective in a crisis Stay on the leading edge of development practices Passionate about great technologies, especially open source Understand business needs and know how to create the tools to manage them

Delivering a complete Front-end application Ensuring high performance on mobile and desktop Writing tested, idiomatic, and documented JavaScript, HTML and CSS Coordinating the workflow between the graphic designer, the HTML coder, and yourself Cooperating with the back-end developer in the process of building the web service/ application Communicating with external web services   Technical/Functional Skills: 3 to 5 yrs of experience working as an Angular Developer Experience in Angular 7,8,9 versions are mandated. Proficiency in CSS, HTML, javascript Experience on Multi-Language is preferable Knowledge on Arabic design is a plus Experience on Components based Architecture Experience on CSS Grids and Flex Layout mandatory Well versed with coding standards Be able to provide effort estimations based on the customer requirements Experience of implementing enterprise level Angular applications and the related Architecture Implementation knowledge on Agile, working experience on Continuous Integration (CI) process is required Experience of integration with SAP is highly desirable Working knowledge with databases ORACLE, SQL Server, mySQL Be hands-on technical and should work as either individual contributor or team member Must have knowledge in code version mechanism using tools like TeamCity, GitHub Knowledge on Agile scrum and waterfall methodology Optimizing performance of code and reviewing code of junior developers Work closely with the architecture team and provide architecture inputs Experience with understanding of mobile related frameworks like Cordova is a plus Comfortable dealing with APIs and utilizing oDATA/REST / JSON interfaces End-to-End experience - Discovery to Deployment of Angular applications Soft Skills Required Good communication and interpersonal skills Candidates should be independent thinkers, thought leaders, good presentation and communication skills and great at solving problems

Minimum of 4 years’ experience of working on DW/ETL projects and expert hands-on working knowledge of ETL tools. Experience with Data Management & data warehouse development Star schemas, Data Vaults, RDBMS, and ODS Change Data capture Slowly changing dimensions Data governance Data quality Partitioning and tuning Data Stewardship Survivorship Fuzzy Matching Concurrency Vertical and horizontal scaling ELT, ETL Spark, Hadoop, MPP, RDBMS Experience with Dev/OPS architecture, implementation and operation Hand's on working knowledge of Unix/Linux Building Complex SQL Queries. Expert SQL and data analysis skills, ability to debug and fix data issue. Complex ETL program design coding Experience in Shell Scripting, Batch Scripting. Good communication (oral & written) and inter-personal skills Expert SQL and data analysis skill, ability to debug and fix data issue Work closely with business teams to understand their business needs and participate in requirements gathering, while creating artifacts and seek business approval. Helping business define new requirements, Participating in End user meetings to derive and define the business requirement, propose cost effective solutions for data analytics and familiarize the team with the customer needs, specifications, design targets & techniques to support task performance and delivery. Propose good design & solutions and adherence to the best Design & Standard practices. Review & Propose industry best tools & technology for ever changing business rules and data set. Conduct Proof of Concepts (POC) with new tools & technologies to derive convincing benchmarks. Prepare the plan, design and document the architecture, High-Level Topology Design, Functional Design, and review the same with customer IT managers and provide detailed knowledge to the development team to familiarize them with customer requirements, specifications, design standards and techniques. Review code developed by other programmers, mentor, guide and monitor their work ensuring adherence to programming and documentation policies. Work with functional business analysts to ensure that application programs are functioning as defined.  Capture user-feedback/comments on the delivered systems and document it for the client and project manager’s review. Review all deliverables before final delivery to client for quality adherence. Technologies (Select based on requirement) Databases - Oracle, Teradata, Postgres, SQL Server, Big Data, Snowflake, or Redshift Tools – Talend, Informatica, SSIS, Matillion, Glue, or Azure Data Factory Utilities for bulk loading and extracting Languages – SQL, PL-SQL, T-SQL, Python, Java, or Scala J/ODBC, JSON Data Virtualization Data services development Service Delivery - REST, Web Services Data Virtualization Delivery – Denodo   ELT, ETL Cloud certification Azure Complex SQL Queries   Data Ingestion, Data Modeling (Domain), Consumption(RDMS)

1) "Azure Analysis services" Lead Developer with 7+ years of experience in AAS Data Model Development, AAS Data model Deployment in Azure, Querying data from AAS to build Reports. Experience in developing, optimizing and administering Tabular Models in 'Azure Analysis service'. 2) Design and Create AAS/OLAP/ Tabular cubes and automate processes for analytical needs. Expertise in developing OLAP cubes and developing complex calculations, Aggregations, implementing a dynamic security model using DAX functions in - Azure Analysis service 3) Writing optimized SQL queries for integration with other applications, Maintain data quality and overseeing database security, Partitions and Index. Extensively used performance monitor/SQL profiler/DMVs to solve deadlocks, to monitor long-running queries and trouble-shoot cubes SQL and T-SQL.4) Designing database tables and structures, creating views functions and stored procedures. 5) Exposure to PowerBI will be an added advantage.

Must Have : .Net with Angular 4                    Technical Skills :Angular 4+, WEB API 2.0,  .NET framework 4.0 +, C#, SQL Server, Front end technologies Requirement:•Minimum 1 years of expertise in Angular 4+.•Minimum 3 years of expertise in .NET•Strong expertise in advanced version of HTML, CSS, Javascript.•Strong in SQL and procedural Language•Experience in mandatory technical skills.•Experience with RESTful services•Experienced in using GIT,•Knowledge of Agile practices & process.•Good problem-solving skills•Good Analysis skills•Good Team player•Good communication skillsAs a Front and Backend Developer, understand varied technical problems and implement solutions that are secure, scalable, and easily maintainable to deliver sustainable solution to solve business problems. Must Have : .Net with Angular 4                    Technical Skills :Angular 4+, WEB API 2.0,  .NET framework 4.0 +, C#, SQL Server, Front end technologies Requirement:•Minimum 1 years of expertise in Angular 4+.•Minimum 3 years of expertise in .NET•Strong expertise in advanced version of HTML, CSS, Javascript.•Strong in SQL and procedural Language•Experience in mandatory technical skills.•Experience with RESTful services•Experienced in using GIT,•Knowledge of Agile practices & process.•Good problem-solving skills•Good Analysis skills•Good Team player•Good communication skillsAs a Front and Backend Developer, understand varied technical problems and implement solutions that are secure, scalable, and easily maintainable to deliver sustainable solution to solve business problems.

Coordinate and provide experience-based solution for teams deploying business intelligence, data platform, and big data solutions. Strong knowledge of data warehousing and big data / analytics platform solutions and how data architecture fits into larger data warehousing and database implementation projects as a major component of the effort. Ability to guide C-level executives/ chief architects at major clients (Fortune 500) in data architecture decisions. Experience mapping out enterprise architecture transformations over a 3 year period, and leading those implementations. Develop, implement and maintain data architecture best practices and standards Utilizing data architecture best practices and standards, define and implement technical solutions in the movement of data throughout an organization Provide leadership in related technical areas of importance such as Business Intelligence Reporting and Analytics Gather requirements for data architecture through the use of business and technical interviews and round-table discussions Evaluate and make decisions regarding the alternative processes that can be followed in data movement throughout an organization: ETL, SOA / Web Services, Bulk Load, Evaluate and make decisions regarding the alternative tools and platforms that can be used to perform activities around data collection, data distribution and reporting Show experience with the concepts of data modeling for both transaction based systems and reporting / data warehouse type systems Evaluate data related requirements around data quality and master data management and understand and articulate how these factors apply to data architecture Understand the concepts of data quality, data ownership, and data governance, and understand how they apply within a data architecture framework 15+ years experience in IT, 10+ years experience with data related positions and responsibilities Excellent knowledge of multiple toolsets: ETL tools, reporting tools, data quality, metadata management, multiple database management systems, cloud, security, MDM tools.  (Anything Insights & Data service line may support in future.) Bachelors degree or equivalent in Computer Science, Information Systems or related field Experience in architecting, designing, developing and implementing project work within highly-visible data-driven applications in very large data warehousing / data repository environments with complex processing requirements A proven track record in system design and performance Demonstrated experience integrating systems in multi-user, multi-platform, multitasking operating systems environments Working knowledge of relational databases such as Oracle, DB2, SQL Server, etc. Ability to advocate ideas and to objectively participate in design critique Ideally the candidate should also have: Superb team building skills with a predisposition to building consensus and achieving goals through collaboration rather than direct line authority A positive, results oriented style, evidenced by listening, motivating, delegating, influencing, and monitoring the work being done Strong interpersonal/communication skills with the professional staff, senior level executives, and the business community at large - Experience delivering enterprise architecture for data & analytics for Fortune 500 companies - Ability to lead client architect leadership (CIO, Chief Architect) - Broad understanding of data platforms and tools (Cloud Platforms, Infra, Security, Data Movement, Data Engineering, Visualization, MDM, DQ, Lineage) and proven experience deploying architectures for the largest clients globally - Strong communication and facilitation skills (ability to manage workshops with 20-30 client technical resources) Ability to interface with CIO Train client on cloud, Enterprise Data Platform, Capgemini POV for Data (Business DL, Perform AI, Factory Model etc.)

Extensive experience in development using Python 3.x (advanced level – lists, dictionaries, classes, packages, code repositories, schedule jobs) for enterprise data migration, conversion validation projects. Process optimization using multithreading and parallel processing python functions. Development experience using Python 3.x scripting with GIS environment using following: •ESRI ArcPy (manipulate map documents, read feature classes, use ESRI tools) •ESRI ArcGIS Server/Portal REST API (JSON requests, parse response) •Publish ESRI services, manage ESRI services, read log files. Experience working with ESRI platforms ArcGIS/ArcGIS Pro Desktop/ Data Interoperability/FME/Enterprise. Working experience on Geospatial modelling, Analysis and Data Migrations, parallel processing, performance optimization, .   Good To Have: Working experience on FME Working  Knowledge on MS Azure cloud platform Good knowledge of database management systems such as SQL-Server (Enterprise SQL geodatabase).

Job Description: Must have : WPF WCFC#, .net, WCF, WPF, MVVM, SQL Server, ADO.Net, LINQ, NHibernate, .Net Framework (3.5 and above)Job Description: Mandatory Skills:o In-depth understanding of the C#, .Net Framework (3.5 and above)o Good knowledge of building Desktop application using WPF with MVVM.o Good knowledge of TDDo Good knowledge of Design Patternso Experience in ADO.net, LINQ, Nhibernateo Hands on Experience in Database SQL server 2008 and above o Strong in TSQL and Implementation of SQL Server database objects.o Hands on experience on Web Service AND WCF and XML, consuming web services, understand serialization and deserialization model with web services.o Experience with unit testing using tools such as MSTest, NUnito Analytical and Problem Solving Skillso Hands ON Coding  Good to Have Technical Skills: o Knowledge in TFS (Source Control), Visual Studio Team System.o Knowledge of Middlewareo Knowledge on Enterprise Library Application Block. – Exception Handling & Logging, Cachingo Knowledge of requirements breakdown Mandatory Soft Skills: o Ability to perform as an Individual Contributoro Good Written and Verbal Communication skills.o Organized approach for driving activities and tasks associatedo Flexible to work in Maintenance as well as Development Projectso Team player

Must have experience with SQL Server 2012/2016 and T-SQL in both OLAP and OLTPenvironments Create and modify database schema, T-SQL scripts, stored procedures and other databaseobjects and SSIS packages in order to meet customer requirements. Must have strong working knowledge of MS SQL Management Studio Set up, maintenance and support jobs in SQL AgentRequired Skills: MS SQL Server 2012/2016 and T-SQL in OLAP and OLTP Operating Systems: Windows Server 2008/2012/2016 Database: MS SQL Server 2016/2019

Skill Set # 2 3 – 6 years hands experience profiles Hands-on Experience in .NET Core 2.1 and above, Asp.net, WebAPI, C# Sql Server 2012+  /DB Good working knowledge in Angular 7 and above Ajax / J-query / Bootstrap / LINQ / HTML 5.0 MVC / Entity Framework will be an added advantage. Key Responsibilities Design, build new applications using Framework 4.0 (/latest) / .NET Core. Enhance applications using C#.NET, Web Services / Web API, Entity Framework / ADO.NET. Strong coding knowledge on developing applications using Web APIs / REST APIs. Hands-on development experience in building Responsive Web Design user interfaces using HTML5, CSS3 Develop On-premise / Cloud (using Azure) hosting applications. Hands on experience in transactional databases, write Stored Procedures and Functions in SQL Server. Knowledge in full SDLC phases (Waterfall or Agile depending on the application) At least three years of Experience with Dot net, C#, Ajax, SQL, JavaScript, HTML, CSS Good written and communication skills.

What you’ll be doing: You will contribute to all aspects of an agile software development lifecycle including design, architecture, development, documentation, testing, and operations. You will build cutting-edge scalable systems by writing simple and efficient code. You will push your design and architecture limits for new product development. You will be designing and deploying scalable, highly available, and fault-tolerant systems on AWS You will collaborate with the CEO for successful execution projects. You will ensure compliance with the build/release and configuration management process. Skills & Attributes 0-5 years of hands-on experience designing available, cost-efficient, fault-tolerant, and scalable distributed systems  In-depth knowledge of at least one high-level programming language ( Node js and Go lang and PHP) Hands-on experience with deployment and management services Ability to identify which services meet a given technical requirement Knowledge of recommended best practices for building secure and reliable applications An understanding of the basic architectural principles of building on the AWS Cloud API optimization for rendering complex front-end data seamlessly   Qualifications B Tech/BE in Computer Science or equivalent from a reputed institution.

Must have Strong knowledge on OOPS (Object Oriented Programming Principles) in C# language   Hands on experience in Asp.Net ,MVC,Web API, WCF,Entity framework,HTML5 &CSS3 Experience knowledge in LINQ queries. Hands on experience with SQLServer(T-sql Queries, Stored procedurces,Triggers,Views,Functions). Must know jQuery,JavaScript client-side programming. Must know about basic with Version control system like Github Good knowledge in web applications and web services. Strong coding, troubleshooting and debugging skills, analytical skills.   If have experience in Xamarin,WPF etc would be added advantage

Strong experience require in C# coding & Concepts & Threads   Strong Experience require in SqlServer   Experience required in ASP.NET MVC   Expericend required in Restful services using WCF & WEB API   Expericend required in integration of thrid party services ( swiggy,zomato,RazorPay,..etc)   Strong experience using Entity Framework (Edmx,code first)   .        Experience require in ADO.NET   Familiarity with the client side framework  jQuery & Javacsript & reactjs   .        Familiarity with HTML & CSS   .        Familiarity with Microsoft Azure   Familiarity  with Git Repositories   .        Familiarity with Xamarin.Forms will be added advantage