Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215

Sr. Data Warehouse Developer

Job Id : 15032

Jobtitle : Sr. Data Warehouse Developer

Location : Richmond, VA

Company Name : Vaco Technology

Industry : Information Technology

Salary : $49 - $59  PER HOUR

Job type : Contractor

Posted on: 2020-07-30

Required Skills : Data Warehouse, ETL, SQL, AWS, HTML, JavaScript, Python, Spark, Hive, SQL, Hadoop

Benefits : No benefits are available


    • Data Warehouse Developer is responsible for developing, testing, implementing, debugging, and supporting computer software used to create data warehouse applications.
    • This includes data design, database architecture, metadata and repository creation, identification and resolution of information flow, content issues, and transformation of business requirements, troubleshooting problems, and tuning existing warehouse applications.
    • Looking for the Data Warehouse Developer to be customer-focused, drive for success, emphasized teamwork, effective communication, innovation and flexibility, and adaptability.
    • Data Warehouse Application Developers are responsible for detailed technical design, development, and support of software applications using existing or new technology platforms.
    • They formulate concepts and develop solutions using defined user requirements and can interpret requirements and work with the customer to clarify requirements as needed.
    • They design, code, test, and document enhancements to existing systems of high complexity and scope, working with common application designs and specifications, utilizing industry and System standard procedures, products and methodologies, and execute performance and stress testing, as necessary.

     Other Responsibilities:

    • Develop software from user requirements
    • Solution Architecture
    • Data modeling
    • High-Level data movement (staging and processing)
    • Research data sources
    • Profile/Analyze source data
    • Staging and Dimensional table creation
    • Security modeling
    • Develop ETL
    • Code, in the ETL tool, the extraction, transformation, and loading of data from source systems to the data warehouse
    • Create OLAP Data Cubes
    • Implement user interface design using style sheets and gifs as provided by creative design from Analyst
    • Translate creative design into code
    • Work with Analyst Role as needed for Preliminary Use Cases 
    • Expand/Implement Requirements
    • Create prototypes
    • Code software following standard design patterns
    • Testing and Test Automation.
    • Contributes to the development, testing, implementation, and review of complex data warehouse solutions
    • Develops all or part of complex data warehouse applications, develops software from established requirements, plans and coordinates work of lower-level programmers to meet delivery commitments, creates prototypes; offers insight on the feasibility of system designs
    • Contributes to the design of technology infrastructure and configurations, recommends process improvements
    • Review complex patches and new versions of data warehouse applications. Implements complex software packages and deploy code
    • Key participant in cross-functional team initiatives and process improvement projects

    Knowledge, Skills, and Abilities:

    • 5 to 9+ years of experience developing and supporting moderate to complex data warehouses or data marts:
    • Strong Experience in installing and/or upgrading Informatica; ETL Tools (Informatica, MS SQL Server DTS, etc.)
    • Data Modeling - Dimensional and Normalized Relational; SQL (MS SQL Server, Oracle, etc.)
    • Business Intelligence Tool (Business Objects, Tableau); OLAP & Data Mining; Operating System Environment basic knowledge (Windows, Unix, etc.); HTML; JavaScript; Python; Spark, Hive, SQL and other Hadoop framework components; AWS Cloud (S3, Data Migration Service (DMS), Redshift, EC2, KMS, Systems, Manager, Glue, Lamda, Config, Cloudtrail, IAM, Secrets Manager, SNS); experience in Informatica Data Quality (IDQ).
    • Designs, develops, modifies, tests and automation used to provide data warehouse applications solutions.
    • This includes design, development, architecture recommendations, quality management, metadata and repository creation, troubleshooting problems, and tuning warehouse applications.
    • Develops transition and implementation plans.
    • Recommends changes in development, maintenance, and standards.
    • Advanced analytical ability and technical skill as well as the ability to provide innovative solutions to technical needs and business requirements
    • Ability to exercise independent judgment in making complex business decisions
    • Acute attention to detail with a high level of data integrity and accuracy
    • Excellent oral and written communication, with interpersonal skills to work with people at all levels of the organization
    • Ability to translate highly technical information into non-technical terms
    • Excellent computer skills including Microsoft Office along with various other software applications as needed for the role
    • Broad knowledge of the programming tools, concepts, practices, and principles including design, implementation, and testing
    • Position requires continuous visual concentration and manual dexterity to operate PC
    • Requires prolonged sitting and minimal standing/walking
    • Minor lifting and carrying, not likely to exceed ten pounds
    • May require extended work hours and/or schedule flexibility as unexpected situations and/or workflow to dictate
    • May require on-call status
    • Rare domestic travel including overnight stays may be necessary
    • 5 to 9+ years of relevant work experience
    • Bachelor's degree or equivalent experience

    Latest jobs for you

    • Java (Microservices) Developer

      VIVA USA Inc. Pittsburgh, PA

      Required Skillset Knowledge: Knowledge and practical experience of Java Springboot,. Ability...

      View Job
    • Senior Salesforce Developer (Vlocity)

      Youngsoft Ferndale, MI

      Job Description: Seeking a Salesforce Application Developer Advance for our Salesforce Platform ...

      View Job
    • Sr Engineer, Software - Salesforce/Heroku

      T-Mobile USA, Inc. Bellevue, WA

      Job Description: An experienced Heroku Developer to build and customize solutions and manage ...

      View Job
    • Salesforce Developer (Greater Kansas City or Remote, USA)

      Optiv Security Overland Park, KS

      Job Description: The Salesforce Developer will be responsible for all types of standard ...

      View Job
    • Senior Salesforce developer with apex exp

      ICONMA San Francisco, CA

      Job Description Architect, design, implement, test, and deliver highly scalable products. ...

      View Job

    Thanks For Your Feedback

    We’re an equal opportunity provider.
    All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. is not a Consulting Company/Training Company/H1B Sponsor.

    Attach A Resume First