141373-Programmer Analyst 3 - PowerBuilder Developer

As a Programmer Analyst 3 - PowerBuilder Developer, your day-to-day responsibilities will involve data management, software development, and unit testing. You'll work with source control tools like TFS/Azure DevOps and GIT, ensuring effective documentation and change management. Your expertise in advanced T-SQL query writing will be crucial for data extraction, migration, and cleansing within Sybase and MS SQL Server databases.

To qualify for the Programmer Analyst 3 - PowerBuilder Developer position, you should possess at least some college education in Computer Science, Information Technology, or a related field. Additionally, hands-on experience with PowerBuilder (version 7 or higher) and a strong command of T-SQL query writing are essential. A proven background in data management, unit testing, and documentation is also required.

The Programmer Analyst 3 - PowerBuilder Developer role is hybrid, requiring you to be onsite at our Lansing, MI location two days per week. Wednesdays are mandatory onsite, and the other onsite day can be flexible based on your schedule. Note that there is no option for remote-only work.

Necessary skills for the Programmer Analyst 3 - PowerBuilder Developer position include proficiency in PowerBuilder Development, advanced T-SQL query writing, data management, and familiarity with source control technologies such as TFS/Azure DevOps or GIT. Experience in unit testing, documentation, and change management is also vital for success in this role.

In the role of Programmer Analyst 3 - PowerBuilder Developer, you will engage in various projects that include enhancing existing applications, performing data migration, and ensuring data integrity. You will leverage your skills in PowerBuilder and T-SQL to support the organization’s data needs and collaborate with business analysts and clients to execute testing scenarios effectively.

In your response, focus on specific projects where you've utilized PowerBuilder. Highlight your expertise with version 7 or higher and discuss any applications you've developed, emphasizing how you approached problem-solving and the impact on the organization.

Discuss your thought process when writing T-SQL queries, including how you approach data extraction and manipulation. Provide examples where you've successfully pulled intricate data from Sybase or MS SQL Server databases, showcasing your skills in data migration and cleansing.

Explain your methodical approach to data management, including data profiling, mapping, and validation. Discuss any tools or techniques you use to ensure data integrity and how you've addressed any data-related challenges in previous roles.

Describe your familiarity with change management processes. Talk about how you document changes, follow established protocols, and collaborate with team members to ensure smooth transitions and minimize disruptions during project phases.

Discuss your unit testing strategy, including how you design and execute test cases. Share specific experiences where your testing identified issues early in the software development life cycle, ultimately improving the quality of applications.

Provide a detailed account of a specific production support issue you encountered. Discuss how you identified the root cause, the analysis process you followed, and the steps taken to solve the problem, emphasizing your analytical skills.

Explain the tools or methods you employ for documentation. Highlight your experience in creating and updating system specifications, flow diagrams, and user manuals, ensuring they are clear and accessible for both technical and non-technical audiences.

Talk about your experience using source control systems. Provide insights on how you've managed code versions, collaborated with team members on projects, and any best practices you've adopted to streamline your workflow and ensure project integrity.

Describe your collaborative approach with business analysts and clients, focusing on how you gather requirements, incorporate stakeholder feedback, and communicate technical concepts effectively to ensure project alignment and success.

Share your passion for programming and development, particularly in PowerBuilder. Discuss what aspects of the role excite you, your enthusiasm for tackling new challenges, and how you continuously strive to learn and grow in the field.