What Database Architects do at SCA ?
The Data Architect will have an end-to-end vision of all SCA's solutions for Supply Chain cost analysis and optimization products, and to see how a logical design will translate into one or more physical Databases, and how the Data will flow through the successive Stages involved.
The Data Architect will need to be able to address issues of Data Migration(Validation, Clean-up and Mapping), and will need to understand the importance of Data Dictionaries.
• Develop and document database architectures. Create and enforce database development standards.
• Develop data models for applications, metadata tables, views or related database structures.
• Develop load-balancing processes to eliminate down time for backup processes.
• Develop or maintain archived procedures, procedural codes, or queries for applications.
• Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements.
• Develops and delivers long-term strategic goals for data architecture vision and standards by collaborating with Solution architects, Software architects, design analysts, and others.
• Demonstrate database technical functionality, such as performance, security and reliability.
• Design data transfer mechanisms like ETL and improve data cleansing, data quality issues as they arise
• Establishes methods and procedures for tracking data quality, completeness, redundancy, and improvement
• Define technical dependencies and dependency management strategy, and align solutions with enterprise architecture strategy
• Defining functional design and technical design for data management and integration
• Creates short-term tactical solutions to achieve long-term objectives and an overall data management roadmap
• Selects and implements the appropriate tools, software, applications, and systems to support data technology goals
• Provides coaching and mentoring to all members of the department
What skills do we expect from Database Architect at SCA :
• Minimum of 5-8 years in Database design and development.
• Demonstrated ability to design and develop complex database load and maintenance processes
• 4+ years Hands-on experience designing RDBMS databases for web applications
• 2+ years of experience with star schema and dimensional data modeling.
About SCA Technologies
Similar jobs
Design, develop and maintain web-based services and applications using .Net Core/ASP.Net, C#, REST Web API, MS SQL Server, Entity Framework, and Dapper. Developing highly optimized cross-browser and responsive web applications using HTML5, and CSS. Manage the full technical life-cycle of web applications during each development phase including functional & technical design, implementation, testing, deployment and maintenance. Developing high standard Web Applications based on functional requirements, UI/UX requirements, business logic and Web APIs. Designing database tables, views, stored procedures, and functions to store and retrieve data most efficiently from SQL database. Writing bug-free code with the highest coding standard. Developing high-performance, highly secure and highly scalable Web Application. Perform unit testing, troubleshooting, debugging and code reviews for robustness, including edge cases, usability, and reliability of the software. Manage source code check-in, checkout, and merging code. Taking accountability and the ability to work under pressure
Hands-on experience o of using Angular with version 7 or later o in consuming complex nested API. o in using state management (e.g. NGRX, RXJS). o in using caching. o of using component library framework integration (e.g. Angular Material). o in integrating with REST web services from the application. Knowing JSON is a must. o with Git compatible source control and working with a CI/CD pipeline. Experience on AWS services will be added advantage. Good experience in Standard Project Development Life Cycle. Experience on Devextreme tools will be added advantage. Ability/ready to work on advanced technologies like Node JS is an added advantage. Knowledge / Experience of agile development methodologies. Very good logical skills and problem-solving ability. Quick learner and a good team player. Should be able to work independently and with the team.
We are looking for a senior developer to produce and implement functional software/web solutions. You will work with upper management to define software requirements and take the lead on operational and technical projects.
In this role, you should be able to work independently with little supervision. You should have excellent organization and problem-solving skills. Your goal will be to develop high-quality software/websites that is aligned with user needs and business goals.
Description:
- Migrating legacy applications to new technologies
- Maintaining applications and troubleshooting
- Designing new software programs, websites, and applications
- Managing project timelines and tasks
Skills & Experience:
- Proven experience as Senior Developer
- Must know - asp.net, MVC Architecture, AJAX, REACTJS, HTML/CSS, MS SQL, JAVASCRIPT
- Python and/or NODEJS, JAVA is added bonus
- Well versed with SSO, Shibboleth and SAML
- Creating and integrating API's
- Should have good knowledge about networking
- Previous experience with applications based on SAML, SSO and CDN's.
- Must have basic knowledge about Identity Providers, access gateways and integration with SSO's
The ideal candidate will be familiar with the full software design life cycle. They should have experience in designing, coding, testing and consistently managing applications They should be comfortable coding in a number of languages and have the ability to test code in order to maintain high-quality code.
Responsibilities
- Design, code, test and manage various applications, Product Development
- Collaborate with the engineering team and product team to establish the best products
- Follow outlined standards of quality related to code and systems
- Develop automated tests and conduct performance tuning
Qualifications
- Bachelor's degree in Computer Science or relevant field
- 6 to 10 years of experience working with .NET or relevant experience
- Must have experience in Product Development
- Experience developing web-based applications in C#, HTML, JavaScript, VBScript/ASP, or .NET, Angular 8+
- Experience working with MS SQL Server and MySQL Knowledge of practices and procedures for full software design life cycle
- Experience working in an agile development environment
- Developing and implementing custom design, features, and functionality.
- Designing informative structure within an application or website.
- Optimizing websites to ensure they render consistently in cross-browser environments, with best SEO principles, caching mechanics etc.
- Understanding CSS changes and their ramifications to ensure consistent style across platforms and browsers.
- Updating Current Websites to Meet Modern Web Standards.
What you need to have:
- Strong experience in WooCommerce – Able to create easy and complex plugins, shortcodes, and widgets
- Exposure to a minimum of 3 e-commerce projects (starting with requirement gathering).
- Expert in WordPress, and other CMS platforms.
- Should have experience of working on large projects involving 10,000+ products.
- Experience in developing E-Commerce websites.
- Strong knowledge in WordPress Plugin, and PHP.
- Must have experience of building User Interfaces and Prototypes.
- Experience designing and developing responsive design websites.
- Comfortable working with debugging tools like Firebug, Chrome inspector, etc.
- Good with third-party integrations to CRM, ERP, etc.
- Knowledge of code versioning tools including Git and Bitbucket.
- Strong Experience in MySQL and Database Queries.
- Ability to lead the team and handle pressure and demands.
- Sound knowledge of IT concepts and the latest trends.
- Ability to work independently and multi-task in a fast-paced environment.
- Strong verbal and written communication and interpersonal skills.
- Highly organized and detail-oriented.
Experience: 2 to 5 years
Annual CTC: Rupees 4,00,000 to 6,00,000
About our Client:
Our Client is founded in 2012, provides a modern solutions for wide range of industries such as Retail, Food &
Beverages, Distribution, Airlines, Banks and Govt. Tax collection. In-house innovation of block-chain enabled multi-level
retailing platform called Just Billing enables companies to optimize and redefine their business processes. The platform
is being used by more than 90,000 happy customers including Fortune 500, Governments and Banks. Effiasoft is based
out of India, Singapore and US and expanding
Technology Stack: ASP.NET FULL STACK (ASP.NET, C#, SQL SERVER)
Experience Level: 2 – 7 years
Job Description
Looking for ASP.net Developer who possesses a passion for technologies to the limits and excited to work with our
team of talented engineers based out of our Hyderabad office to design and build highly scalable cloud based
Enterprise Web Applications.
In this role, you will have to maintain high coding standards through good design, documentation, unit testing along
with excellent problem solving and strategic thinking. Good decision making and sound communication skills are
necessary as candidate will have to communicate with stakeholders to collect requirements, describe software product
features and technical designs.
Roles and Responsibilities
1. Design, develop and maintain web based services and applications using ASP. Net, C#, MVC, Web
API, MS SQL Server and Service Oriented Architecture.
2. Developing highly optimized cross browser and responsive web application using HTML5, Java
Script, CSS and jQuery.
3. Manage the full technical life-cycle of web applications during each development phase including
functional & technical design, implementation, testing, deployment and maintenance.
4. Developing heights standard Web Application based on functional requirements, UI/UX
requirements, business logic and Web APIs.
5. Designing database tables, views, stored procedure, functions to store and retrieve data most
efficiently from SQL database.
6. Writing bug-free code with highest coding standard.
7. Developing high-performance, highly-secure and highly scalable ASP.net Web Application.
8. Perform unit testing, trouble shooting, debugging and code reviews for robustness, including edge
cases, usability, and reliability of the software.
9. Working closely with quality assurance team to ensure delivery of quality and reliable applications.
Diagnose functional issues and fix bugs to meet highest industry quality standard.
10. Collaborate with team members to brainstorm about technical challenges and help each other. –
Gathering and clear understanding on requirements from product managers, customers, end-users,
sales and support team members.
11. Describe and document technical design, specifications of software product features.
12. Manage source code checkin, checkout, merging code.
13. Delivering tasks and assignments on time.
14. Taking accountability and ability to work under pressure.
Requirements
Passionate about technology and developing Web Applications to solve real-word challenges.
Any Bachelor or Master Degree in Computer Science, Engineering or a related subject.
Minimum 2 years hand-on experience in ASP. Net MVC, C#, Web API, MS SQL Server and Service
Oriented Architecture.
Extensive hands-on experience in HTML5, Java Script, CSS and jQuery.
Hands-on experience with 3rd party API integration.
Hands-on experience in performance optimization and application security.
Experience in implementing secure, transactional applications integrated with web-based services.
Familiarity with SVN source code management system.
Experience in deploying applications in IIS, optimizations and IIS configurations.
Excellent problem-solving and analytical skills.
Excellent communication, presentation and team working skills.
Ready to take responsibilities, ownership and ability to work under pressure.
Added advantage for candidates recognized in Coding contest or Hackathons.
Candidates with any certification, award or work recognition from any credible sources are given preference.
Regards
Team Merito
- Observe, strategize, develop and design required software solutions.
- Designing Client-Side and Server-Side Architecture and Rendering and Static Site Generation.
- To confer with users - by studying systems flow, data usage & work related bottlenecks.
- Design and implement Back End and Front End code
- Interact with the production team, understand their workflow and find new ways to automate their workflow.
- Write effective APIs as well as Integrate third-party APIs.
- Test software to ensure responsiveness and efficiency
- Troubleshoot, debug and upgrade software
- Create security and data protection settings
- Build features and applications with a mobile responsive design
- Write technical documentation
- Work with data scientists and analysts to improve software
- Manage huge data sets including structured and unstructured data sources.
- Machine learning tools for workflow automation.
- Knowledge of Spark and Map Reduce.
General Expectations:
- Strong Knowledge of and C#, .NET
- Strong knowledge of client-side dynamic and rich UI applications development.
- Hands-on experience on HTML, CSS, bootstrap, JavaScript, AJAX, jQuery and Prototyping.
- Strong hands-on experience in popular frameworks and JavaScript ecosystem – JS, Node, Angular, Jquery.
- Experience in Spark, Hadoop, Scala, and Elastic Search is a plus point.
- Experienced in building applications that meet enterprise needs – secure, scalable, loosely coupled design
- Exceptional design, coding, and problem-solving skills, with a bias for architecting at scale.
- Experience using NPM, Web-Pack, Gulp.
- Familiarity with performance testing and optimization’s.
- Strong knowledge of computer science, algorithms, and design patterns
- Write robust modular code for the full stack using the latest technologies, test and optimize it to work for high performance and scale and deploy it to the UiPath cloud platform.
- Work with various horizontal teams such as Structure, Electrical, Mechanical, Accessibility, Legal, and Finance and also interact with other core teams across locations at UiPath
- Own the smooth running of your cloud service or docker service, and respond to live site issues.
- Strong oral and written communication, and other soft skills critical to collaborating and engage with teams
- Proven experience as a .NET Developer in at least one of the .NET languages (e.g. C#) and HTML5/CSS3
- Working experience with SQL Server or other RDBMS
- Working experience on entity Framework.
- Has designed large and complex enterprise web application and RESTful services (Web API) using the .Net technology stack.
- Must possess strong understanding on OOPS concepts
- Write functional code with a sharp eye for spotting defects.
- A team player and excellent communicator.
- Work with internal teams to design, develop and maintain software.
- Participate in requirements analysis
- Collaborate with internal teams to produce software design and architecture
- Write clean, scalable code using .NET programming languages, W3C standard complaint, cross border compatible HTML pages
- Test and deploy applications and systems
- Revise, update, refactor and debug code
- Develop documentation throughout the software development life cycle (SDLC)
We’re looking for an experienced (2+ years) full stack developer to build web applications and API's, who will be responsible in handling various B2B clients, developing new API's working with business and product teams and, building data pipelines and storage systems for large amounts of data.
Your responsibilities will include:
• Build a framework for handling large volumes of data.
• Scaling API's with lowest response times.
• Onboarding client data in a B2B tech integration.
• Cross-team communication and translating into products.
• Develop and deploy new features to facilitate related procedures and tools if necessary
• Write “clean”, well-designed code
• Contribute in all phases of the development lifecycle
• Passion for best design and coding practices and a desire to develop new bold ideas.
• Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality
• Follow industry best practices
Job Skills
• Good python scripting and hands-on experience with Django framework
• Experience managing full stack, multi-language, multi-framework software development
• Back-end: Proficient in developing APIs across different platforms of web application servers. Experience in web server technologies in Django/Python is necessary.
• Database: Able to understand RDBMS schema and develop software to access data via SQL queries or DB mapper. Familiarity with SQL/NoSQL (MySQL, MongoDB) databases and their declarative query languages
• Front-End: Good understanding of front-end technologies, such as Object Oriented JavaScript, HTML5, and CSS3. Should have knowledge of Angular JS, Bootstrap, Express JS, Node JS etc.
• Understanding of MVC design patterns and other industry standard design patterns.
• Understanding fundamental design principles behind a scalable application
• Excellent analytical, problem-solving skills and programming skills
• Demonstrated ability to define and drive adoption of software development best practices, standards, processes, methodologies
• Strong communication skills, both verbal and written, and the ability to listen effectively
• Proficient understanding of code versioning tools, such as Git