Current opportunities >> Position Details >>
Position Details Job order - J0117-0996 - Permanent Full Time Title MS Access Developer with VBA and SQL Server Category Analytics and Emerging Digital Technologies City Herndon, Virginia, United States Job Description MS Access Developer with VBA and SQL Server Position Description We're currently hiring an MS Access Developer with VBA and SQL Server experience, to join our financial services team in Herndon, VA. This is an exciting full-time opportunity to participate in a massive technology replacement. As a result, we’re offering a stable opportunity with a complete benefits package that includes medical, dental, vision, 401k, paid vacation, etc. Your future duties and responsibilities In this role, you will be client facing with everyday interaction with Business teams to analyze requirements and develop solutions that align with the SDLC process. The successful candidate should be able communicate very well and work independently with minimum supervision. Candidates who have working experience with Agile Methodology are preferred (not a must). Required qualifications to be successful in this role - Perform requirement analysis and create Solution Specifications - Conduct high-level design session with the development team - Perform impact assessment, identify design impacts to the application and provide suggestion/guidance - Review and provide guidance for User Acceptance test cases and support testing efforts - Maintain application code developed in MS Access, VBA, MS SQL Server - Troubleshoot and resolve issues in production for the applications that are supported. Technical Skills include: -6yrs+ hands-on experience in the software development life cycle - Experience gathering requirements, develop solution and implementation - Able to maintain applications in MS Access and MS SQL Server - Experience writing functions and procedures in MS Access, MS SQL Server, and VBA - Capable of creating dynamic MS Access Pass-through queries to Oracle - Ability to implement Access 2010 table-level triggers and experience creating custom MS Access ribbon bars - SQL Server skills including T-SQL, Stored Procs, Triggers, Views, User Defined functions - Background in Dynamic SQL, Query optimization and debugging, SSIS, Linked Oracle Servers, SSRS - Experience troubleshooting application issues and provide directions to resolve them - Experience in relational data model and design - Most recent 2yrs of experience should be in MS Access and MS SQL Server - Experience in Oracle DB and PL/SQL is a plus - Experience in applications working in Citrix environment is a plus but not required Education Bachelor Degree or Equivalent *LI-RP1 At CGI, we’re a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 65,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com. This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans. We wish to thank all applicants for their interest and effort in applying for this position, however, only candidates selected for interviews will be contacted. No unsolicited agency referrals please. All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary depending upon specific assignment, or upon any US government security clearance if required. Qualified applicants will receive consideration for employment without regard to their race, color, religion, sex, gender Identity, sexual orientation, national origin, age, disability, veteran status, pregnancy, or other status protected by law. CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI’s legal duty to furnish information. Skills Reference 517463 Click here to apply