Join Our Team

Job Code COS-SD1909


Software Developer Duties:

Analyze, develop, implement, customize, tune and test database and data warehousing software applications using Oracle RDBMS, MySQL, PL/SQL, SQL*Plus, SQL*LOADER, Oracle Forms & Reports, Shell Scripts, Informatica, Data Stage, Business Objects, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Quality Center, Crystal Reports, and related tools. Gather and analyze business and data requirements. Perform data modeling to design logical database model; build and implement logical and physical database design. Create database tables, views and appropriate indexes. Create PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the (Extract, Transform & Load) ETL application using Oracle, MS SQL Server. Create SQL reports, data extraction and data loading scripts for different databases and schemas. Develop mappings to extract data from source systems and load into target data warehouse/data mart. Develop ETL Process to extract data from source systems and load it into Oracle, MS SQL Server data warehouses using SSIS Packages, Informatica, Data Stage, and PL/SQL. Develop complex analytical reports using SQL Server Reporting Services (SSRS), Business Objects, and Crystal Reports. Tune SQL queries for optimized performance. Design and develop Oracle Forms & Reports.


Bachelor’s degree or equivalent in Computer Science, Information Systems, Electrical/Electronics Engineering, or a related field and 1 year of experience as a Database Developer, Software Developer, Systems Analyst, ETL Developer, or any job involving database or enterprise data warehouse development. Experience must include database Or ETL or enterprise data warehouse development.

Work Location:

Canopy One Solutions, 4229 Lafayette Center Drive, Suite 1625, Chantilly, VA 20151. Travel/relocation to various unanticipated client locations throughout the US may be required.

Apply to:

HR, Canopy One Solutions, 4229 Lafayette Ctr Dr #1625, Chantilly, VA 20151 or

Equal Opportunity Employer*