Hi ,
Edu: BE/B.tech/MCA
Notice Period : Immediate - 15 days
Permanent remote
Job Description :
Mandatory Skills : SQL Server & Database Architecture.
Description
• 10 years of database experience.
• 3-4 years previous experience as a database architect or in a data management role.
• Provide development and administration support for various databases, primarily SQL server
databases, in a client-server development environment including stored procedures and
SQL, and index performance tuning, and database design and file storage.
• Solid knowledge of relational database architecture and concepts.
• Excellent multitasking skills and task management strategies.
• Confident in decision making and the ability to explain processes.
• Develop, deploy, and maintain Extract-Transform-Load (ETL) scripts and schedules.
• Develop and implement all database indexing, maintenance, back-up, transformations, and
stored procedures.
• Assist Engineering Team in implementing appropriate data access permission schemas.
• Participate in the refinement and development of user stories, assessing the impact of new
development on current database implementation.
• Communicate with technical and product owner stakeholders to help them anticipate and
mitigate configuration management issues.
• Knowledge of developing analytic reports and dashboards using Microsoft Power BI or other
similar tools
• Excellent command of the SQL language with the ability to write and optimize complex
queries.
• Achieves organizational goals by defining, integrating, and upgrading a comprehensive
architecture to support applications, platforms, and databases.
• Maintains database by determining structural requirements and developing and installing
solutions.
• Ensures security of all information and computer systems and digital data
• Compare and analyze provided statistical information to identify patterns, relationships, and
problems.
• Ability to perform root cause analysis and produce the mitigation plan for the issues and
risks identified.
• Strong technical documentation skills, with requisite attention to detail.
Similar jobs
The Sr. Analytics Engineer would provide technical expertise in needs identification, data modeling, data movement, and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.
Understands and leverages best-fit technologies (e.g., traditional star schema structures, cloud, Hadoop, NoSQL, etc.) and approaches to address business and environmental challenges.
Provides data understanding and coordinates data-related activities with other data management groups such as master data management, data governance, and metadata management.
Actively participates with other consultants in problem-solving and approach development.
Responsibilities :
Provide a consultative approach with business users, asking questions to understand the business need and deriving the data flow, conceptual, logical, and physical data models based on those needs.
Perform data analysis to validate data models and to confirm the ability to meet business needs.
Assist with and support setting the data architecture direction, ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.
Coordinate and consult with the Data Architect, project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.
Work closely with Business Analysts and Solution Architects to design the data model satisfying the business needs and adhering to Enterprise Architecture.
Coordinate with Data Architects, Program Managers and participate in recurring meetings.
Help and mentor team members to understand the data model and subject areas.
Ensure that the team adheres to best practices and guidelines.
Requirements :
- Strong working knowledge of at least 3 years of Spark, Java/Scala/Pyspark, Kafka, Git, Unix / Linux, and ETL pipeline designing.
- Experience with Spark optimization/tuning/resource allocations
- Excellent understanding of IN memory distributed computing frameworks like Spark and its parameter tuning, writing optimized workflow sequences.
- Experience of relational databases (e.g., PostgreSQL, MySQL) and NoSQL databases (e.g., Redshift, Bigquery, Cassandra, etc).
- Familiarity with Docker, Kubernetes, Azure Data Lake/Blob storage, AWS S3, Google Cloud storage, etc.
- Have a deep understanding of the various stacks and components of the Big Data ecosystem.
- Hands-on experience with Python is a huge plus
Excellent web development experience in large scale applications
ASP.Net, C#, .NET, .Net Core, SQL, and Angular skills are must.
Strong experience with C#, .NET Core and relevant design patterns
Strong MS-SQL query skills.
Proficiency in frontend development with JavaScript and HTML
Service oriented development experience
Excellent Communication skills
Role & Responsibilities:
- Individuals are responsible for all traditional development activities analysis, design, coding, testing, and documentation.
- Add new features to existing Windows and Web-based applications in Visual Studio 2019. Interacting with internal team.
- Transform business and design needs into innovative products.
- Drive all projects to completion within deadlines.
- Perform thorough testing to find issues ahead of time.
- Engineering software needs more precise analysis & coding skillset
- Enhance skillset by working with fortune 500 clients
- Interacting with internal team.
Qualifications:
- B.E in computer science or related fields.
- Hand on development experience with web & database technologies (MS SQL).
- Excellent programming & communication skills Strong problem solving, judgmental, and decision-making skills.
- Ability to work at the tactical and strategic levels of IT initiatives.
- Impressive hands-on experience in .Net technologies.
- Impressive hands-on experience and knowledge with C#, SQL, JSON, XML, Win Forms & MVC, Angular, JavaScript, jQuery , HTML/CSS, .Net Core.
- Self-Motivated, flexible & Innovative.
.Net Core is preferred along with SQL or very strong .Net developer with SQL
The job requires the resource to do documentation, SQL support, development with .Net,integration,interaction with end user- mix of all activities
Job Description
- Designing system architecture, develop and maintain high performing & scalable services using Node.js frameworks.
- Extensively engage in iterative development model right from requirement analysis, estimation, development, testing & production support
- Mentor, groom junior developers and participate in code reviews
- Contribute towards building company’s coding culture
Requirements
- 3+ years of relevant industry experience in Node.js
- A deep understanding of JavaScript
- Experience working with SQL and NoSQL databases
- Experience with Unit and Integration tests
- Experience with CI/CD
- Experience with MathJax/Latex
- Experience with large scale video streaming
- Experience with ReactJS is a bonus
As an Associate Software Engineer, you will have the opportunity to collaborate on the creation and maintenance of scalable, high-quality software as we grow. You'll work closely with the CTO and quickly gain skills and responsibilities as the team and the technical requirements grow.
Primary Responsibilities
- Develop RESTful APIs leveraging Django classes, ORM and Postgres Database
- Develop solutions that meet business objectives while leveraging industry best practices
- Write high-quality source code to program complete applications within deadlines
- Troubleshoot and debug applications
Technical Competencies
- Expertise with Python language
- Experience with Django: maintaining APIs
- Familiarity using Git, code repositories, branching and merging strategies
- Ability to break down complex concepts, tasks, or problems into more simple, understandable language and action plans
- Excellent communication skills, and attention to detail
- Good Documentation skills
Perks
- Work from home
- Flexible work schedule
- Flexible standup meetings
Interview Process
- Two technical rounds with Senior Developer and CTO
- Cultural Fit interview with Project Manager
Please do not apply if you don't have professional Django work experience.
Responsibilities:
As a backend developer you would be responsible for:
- Executing full lifecycle software development
- Architect and conceptualise the solution from initiation to completion meeting client requirements
- Work with customer and their integration partners to ensure the product is well integrated
- Programming well-designed, testable and efficient code
- Develop flowcharts, layouts and documentation to identify requirements and solutions
- Work with cross-functional teams (Product, Engineering and ML team) to craft custom solutions
- Ensure clients change requests are addressed effectively in a timely manner
Requirements:
- 2+ years of experience in architecture and developing high performance web applications
- In-depth understanding of the entire web development process (design, development, and deployment)
- Strong NoSQL and/or SQL database design and query writing skills with a commitment to performance and efficiency
- Knowledge of RESTful API and SOAP Webservices paradigms
- Experience with CRM/ERPs like systems SAP, Oracle, SalesForce, Servicenow, Workday, etc. would be a huge plus
- Ability to operate in a highly ambiguous and fast-paced environment
- Superior verbal and written communication skills
Our Technology Stacks:
- Demonstrated experience in our tech stack will be a big plus as it lets you get up and running with our product that much sooner
- Node.js back-end with typescript
- MongoDB as database
- React to power our user interfaces (don't worry, we don't expect it for back-end)
- NGINX as our web server
- RabbitMQ
- Redis
- Elasticsearch
- Docker
MUST HAVE SKILLS
- CORE JAVA & SQL
Desired Skills
Designing, implementing and delivering high quality Software project in JAVA, SQL / Oracle, J2EE and other JAVA technologies.
Job Responsibilities
Participate in detailed level in design, coding, code walk through, peer code reviews and unit testing, System Testing, UAT, Demos, POCs, installation, maintenance of Software modules.
❑ Ensures the preparation of the following:
▪ Software prototype
▪ System Architecture
▪ Software Design Document
▪ User interfaces to be developed as per UX guidelines
▪ Code files ensuring coding guidelines followed
▪ Code review artefacts during peer code review
▪ Test plan and Test Cases
▪ Installation / Deployment document
▪ Release Document
▪ Technical Documentation
❑ Documents and demonstrates solutions by developing documentations, flowcharts, layouts, diagram, charts, code. comments and clear code; Ensuring that project task are completed in defined effort and timelines ❑ Prepares and installs solutions by determining and designing system specifications, standards & programming.
❑ Testing: Writing of test cases, unit testing, system testing, negative testing
❑ Trouble shooting: Log analysis and database query optimization
❑ Improves operations by conducting system's analysis.
❑ Updates job knowledge by studying state of the art development tools, programming techniques & computing equipment; participates in educational opportunities, reads professional publications & maintains personal networks.
❑ Protects operations by keeping information confidential.
❑ Provides information by collecting, analyzing and summarizing development and service issues. ❑ Develops software solution by studying information needs, conferring with users, studding system flow, data usage and work processes, investigating problem areas, following delivery cycle.
❑ Ensuring that the Newgen quality processes are in place and are followed.- - 2+ years experience in application support on Asp.Net and SQL
- - Should be able to debug production issues and bug fixes
- - Should be able to write queries for extracting data using joins
- - Interact with stakeholders and provide regular status updates on call logs to on-site and offshore project co-coordinator
- - Provide daily status updates and time-sheets to on-site and offshore project
- - Ready to work in shifts
- - Knowledge Transfer / Training to stakeholders
Personal Attributes
- - Good communication skills
- - Highly committed and able to work independently and as a team
- - Positive attitude towards learning
- - Deadline orientated and escalate in advance in case of delays
- - Contribute towards improving quality, standardization and documentation for all
- changes & Support activity
- - Ability to remain calm in a fast-paced and highly pressure environment
• Write clean, scalable code using .NET programming languages.
• Remain up to date with the terminology, concepts and best practices for coding mobile apps.
• Develop technical interfaces, specifications, and architecture.
• Use and adapt existing web applications for apps.
• Create and test software prototypes.
• Develop client displays and user interfaces.
• Assist software personnel in handling project related work and other requirements.
• Coordinate with other software professionals and developers.
Work Experience & Skills
• VB.NET (Framework 2.0/3.0/3.5/4.0) (Mandatory)
• SQL SERVER 2005 / 2008 (Mandatory)
• Must have experience in developing Windows application.
• Prior experience in Object Oriented Design and Development (OODD) is required. • 1+ years of .NET development (Framework 2.0/3.0/3.5/4.0) experience is required • Experience with SQL Server 2005 / 2008 are required.
• Knowledge/experience on Web Service and Unit Test.
• Oracle knowledge is added advantage
• Strong attention to detail
• Excellent troubleshooting and communication skills
• Able to work well in a team setting