Database Developer - ERWIN

Job Description

Role Purpose

The purpose of this role is to design, test and maintain software programs for operating systems or applications which needs to be deployed at a client end and ensure its meet 100% quality assurance parameters

͏

Do

Job Description: Database Developer

We are looking for a skilled Database Developer with strong expertise in relational data modeling, ETL development, and stored procedure development. The ideal candidate should have hands-on experience with SQL Server and/or UDB, along with the ability to work collaboratively within cross-functional project teams.

Key Responsibilities

• Design and develop relational data models using ERWin and database modeling best practices.
• Develop, optimize, and maintain stored procedures, SQL queries, and database objects.
• Support ETL development and data integration activities across systems.
• Collaborate with project teams, business stakeholders, and technical teams to deliver database solutions.
• Prepare and maintain technical documentation using UML, XML, and related standards where required.

Required Skills

• Strong knowledge of relational data modeling, ETL processes, and stored procedure development.
• Hands-on experience with ERWin, SQL Server, and/or UDB.
• Good understanding of UML and XML.
• Strong planning, organizational, interpersonal, and communication skills.
• Ability to work effectively as part of a project team with diverse technical skills.

Desired Profile

The candidate should be detail-oriented, proactive, and capable of delivering high-quality database solutions while coordinating effectively with business and technical stakeholders

͏

2. Perform coding and ensure optimal software/ module development

• Determine operational feasibility by evaluating analysis, problem definition, requirements, software development and proposed software
• Develop and automate processes for software validation by setting up and designing test cases/scenarios/usage cases, and executing these cases
• Modifying software to fix errors, adapt it to new hardware, improve its performance, or upgrade interfaces.
• Analyzing information to recommend and plan the installation of new systems or modifications of an existing system
• Ensuring that code is error free or has no bugs and test failure
• Preparing reports on programming project specifications, activities and status
• Ensure all the codes are raised as per the norm defined for project / program / account with clear description and replication patterns
• Compile timely, comprehensive and accurate documentation and reports as requested
• Coordinating with the team on daily project status and progress and documenting it
• Providing feedback on usability and serviceability, trace the result to quality risk and report it to concerned stakeholders

͏

3. Status Reporting and Customer Focus on an ongoing basis with respect to project and its execution

• Capturing all the requirements and clarifications from the client for better quality work
• Taking feedback on the regular basis to ensure smooth and on time delivery
• Participating in continuing education and training to remain current on best practices, learn new programming languages, and better assist other team members.
• Consulting with engineering staff to evaluate software-hardware interfaces and develop specifications and performance requirements
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
• Documenting very necessary details and reports in a formal way for proper understanding of software from client proposal to implementation
• Ensure good quality of interaction with customer w.r.t. e-mail content, fault report tracking, voice calls, business etiquette etc
• Timely Response to customer requests and no instances of complaints either internally or externally

͏

Deliver