SQL Developer - Ampcus Incorporated

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.
 
Job Title: SQL Developer

Location(s): Sacramento, CA
 

Job Description:

• Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse as needed.
• Modify the data load ETL processes as needed to Extract, Transform and Load data from various data sources into the outage management data warehouse.
• Analyze and modify the data structures within a data warehouse to adapt them to our business needs and add enhanced functionality.
• Use programming languages, software development methods, "best practice" programming techniques and department standards guides to develop new data warehouse structures and reports and to modify existing ones.
• Unit test and debug code prior to delivery to stakeholders.
• Participate in requirements gathering and analysis, technical design, testing, documentation and planning.
• Consult with stakeholders to gather information about needs, objectives, functions, performance expectations and input and output requirements. Identify and propose technical alternatives to solving their requests and system problems and recommend the best alternative.
• Follow department standards and create written documentation and diagrams as required and/or requested. Documentation may include technical specifications, technical alternatives, structure charts, data flow diagrams, etc. for both new functionality and for modifications to existing functionality.
• Consult with functional areas as requested to aid in the development of their test scenarios, test plans and test scripts.
• Effective oral and written communication, especially when communicating technical information to the non-technical user community.
• Develop testing criteria, conduct testing, and debugging.
• Establish and maintain effective working relationships and work effectively in diverse teams.

Mandatory Requirements

• 3+ years of experience in ETL processing.
• Strong proficiency in writing SQL.
• Experience with SQL query optimization.
• Experience with Oracle and SQL Server.
• Data modeling experience for both transactional and data warehousing environments.
• Experience with C#.
• Strong interpersonal skills and problem-solving ability.
• Requires strong analytical, conceptual and problem-solving abilities.

Technical Requirements

• Oracle SQL knowledge.
• Microsoft SQL knowledge.

Desirable Qualifications

• Experience with PowerBI and SSRS.
• Experience in data warehousing, data engineering, or data architect role.

Questionnaire needs to be filled out by candidate:

• Describe the most recent ETL process project you were involved with. What were your key responsibilities? How did you accomplish the work assigned to you?
• Describe a project where you used your Oracle SQL knowledge to resolve a complex problem in order to meet business requirements. What were the results from the solution?
• Give an example of a situation that required you to troubleshoot a technical problem. What steps did you take?

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.