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

Sr. SQL ETL Developer


Job Id : 12566

Jobtitle : Sr. SQL ETL Developer

Location : Richmond, VA

Company Name : Wafts Solutions, Inc

Industry : Information Technology

Salary : $51,000 - $73,000  PER YEAR

Job type : Contractor

Posted on: 2020-03-25


Required Skills : ETL, ETL Developer, SQL, SSIS, Data Modeling, Security, ACTIVE DIRECTORY

Benefits : No benefits are available


Job Description:

  • Sr. ETL Developer Solution Analysis and Design Perform analysis and design for complex ETL development and maintenance projects
  • Develop and documents ETL designs and analyzes impact to systems and alternatives
  • Determine the impact and potential costs of proposed changes
  • Conduct and participates in peer design reviews Software Development
  • Possesses and applies advanced knowledge of technology principles, best practices and procedures to the completion of complex ETL development assignments
  • Develop complex code and configuration data using secure coding practices
  • Ensure that all code, configuration data, and system documentation is accurate, complete, understandable, and adheres to VRS standards and Source Control processes
  • Address security vulnerabilities
  • Use tools to assure security; analyze outputs; recommend corrective actions
  • Conduct and participates in code reviews Software Testing
  • Develop and executes unit test scenarios and scripts to ensure comprehensive testing of business software using non-sensitive data
  • Gather or creates test data to execute test scripts in compliance with VRS standards.
  • Execute tests and documents results. Maintain performance baselines Work with QA on test results, defect remediation and script re-use.

 

Skills and Abilities

Demonstrated ability to:

  • Ascertain and meet customer expectations Work effectively and independently in a fast paced team environment where priorities can rapidly change
  • Prioritize own work activities with minimal guidance and coaching Solve complex problems through discovery and analysis with minimal guidance
  • Complete complex projects independently with minimal oversight and direction
  • Manage competing priorities to meet goals Learn new technologies and mentor others in learning new technologies
  • Communicate effectively orally and in writing
  • Develop and manage detailed and accurate work plans and appropriately communicate work plan risks and impacts to management
  • Provide, maintain and follow technical documentation
  • Demonstrated comprehensive knowledge of the following tools/technologies:
  • Windows server 2012 and 2016, and Active Directory SQL Server 2012, 2014 and 2016
  • ETL process design, development and support ETL
  • Design Patterns and Anti-Patterns ETL tools such as SSIS or equivalent
  • Database Design and Data Modelling Erwin or similar data modelling tool
  • Complex T-SQL statements and stored procedures
  • Query Tuning and Optimization Batch files, Java script and PowerShell scripts XML files SSRS and SSAS.

 

Required skills:

  • SSIS Indexing SQL Stored Procedure Optimization SSIS flows

Latest jobs for you

  • .Net developer with Angular and C Experience

    Adifice Technologies Kansas City, KS

    Job Description: 7 years of experience in web-based applications using Microsoft technology ...

    View Job
  • Software Engineer (Java)

    Prime Robotics Denver, CO

    Job Description: You will work on some of the server or client applications that interact with ...

    View Job
  • Senior Java/Scala Developer

    Logisoft Technologies Inc Cary, NC

    Responsibilities: Analyze user requirements and design appropriate Big Data solutions that ...

    View Job
  • Java Developer

    UCA services Albany, NY

    Job Description: 7 years of experience as a Java Developer More than Three(3) Years ...

    View Job
  • Java Developer

    SkillStorm Washington, DC

    Job Description: The Senior Java Developer is responsible for Java EE application development ...

    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.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First