The activities these candidates will be tasked with include, but are not limited to the following:
- Ensure support in analysis and designing during all phases of software production, including suggesting the most effective solutions for its implementation.
- Design, modify, write and implement software programming components and applications.
- Install or support the software component and application and to maintain process flow and documentation and to work from pre-written specifications and guidelines.
- The primary responsibilities are in the design, development, implementation and maintenance of Qlik Sense, SSRS, SSIS and SQL Server database solutions for business applications.
- Perform the extraction, transformation and loading (ETL) of data from source systems to destinations.
- Design, develop, and maintain both new and existing code, ranging from client-side development using Qlik Sense Reports, SSRS, SSIS, SQL, JavaScript, HTML, and CSS, to server-side code using C# and ASP.NET, C#, MVC, Web API, Entity Framework and ADO.NET/ for data persistence and retrieval.
-
General Knowledge, Skills and Abilities (KSAs)
- The submitted candidate(s) must be able to apply common knowledge, skills, and abilities in the following areas:
- Communication: Have the ability to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings (i.e.; project team meetings, management presentations, etc.). Must have the ability to effectively listen and process information provided by others.
- Customer Service: Works well with clients and customers (i.e.; business office, public, or other agencies). Able to assess the needs of the customer, provide information or assistance to satisfy expectations or resolve a problem.
- Decision Making: Makes sound, well-informed, and objective decisions.
- Flexibility: Is open to change, new processes (or process improvement), and new information. Has the ability to adapt in response to new information, changing conditions, or unexpected obstacles. Ability to receive and give constructive criticism, and maintain effective work relationships with others.
- Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.
- Leadership: Motivates, encourages, and challenges others. Is able to adapt leadership styles in a variety of situations.
- Problem Solving: Able to identify, evaluate, and use sound judgement to generate and evaluate alternative actions, and make recommendations as accordingly.
- Team Building: Encourages, inspires, and guides others toward accomplishing the common goal.
Specific Knowledge, Skills and Abilities (KSAs)
The submitted candidate(s) must be able to apply common knowledge, skills, and abilities in the following areas:
- Expert knowledge on SQL Server 2012+
- Design, build and deploy effective SSIS packages.
- Design, build and deploy Qlik Sense, SSRS Reports
- Design, build and deploy Qlik Sense Applications
- Implement stored procedures and effectively query a database
- Translate requirements from the business and analyst into technical code
- Identify and test for bugs and bottlenecks in the ETL solution
- Ensure the best possible performance and quality in the packages
- Provide support and fix issues in the packages
- Any work-related to SQL should be handled independently
- Trouble Shooting
- Expert knowledge of SQL Server Management Studio
- Ability to write and debug Stored Procedures, Triggers and Functions.
- Ability to write complex SQL queries.
- ASP.NET MVC. ASP.NET MVC, Web API, Windows services, and ADO.NET
- Experience in creating web applications using back-end technologies in Microsoft area: C#, .NET, WCF, Entity Framework with the knowledge of SQL Server database.
- Knowledge of an object programming and project patterns