ETL Developer

Back to job search
  • Location:

    Charlotte

  • Job type:

    Contract

  • Job ref:

    348760

  • Published:

    about 2 months ago

  • Duration:

    24 months

  • Expiration date:

    11/18/2021

  • Start date:

    ASAP

Job Summary:

Signature Consultants is seeking a ETL Developer (remote until after Covid-19 ~ on site after covid sometime in 2022) for an opportunity with a client located in Charlotte, NC. Our client is looking for someone to work on an assignment for 24 months.


Responsibilities:

  • Act as senior developer working with other developers, BA and QA staff in programming, development, testing, and implementation process
  • Create thorough designs - taking care to assure that designs integrate well into existing architecture
  • Analyze highly complex business requirements, designs and write technical specifications
  • Collaborate across teams, including global teams, to create high quality solution designs
  • Design, develop, test, and deploy data integration initiative
  • Perform Design & Code reviews and process optimization
  • Provide design and development support for analytical systems and data integration applications
  • Contributes in analyzing complex requirements and translates to technical design and specifications
  • Design, development, test, and implement application ETL (Extract, Transform and Load) code
  • Utilize a thorough understanding of available technology, tools, and existing designs to source, map, extract and load large volumes of data
  • Work on complex problems where analysis of data requires a solid grasp of compliance, regulatory and technology risk domains
  • Experience in relational and dimensional models
  • Experience in large scale data warehouse architectures & Performance optimization

Required Qualifications:

  • 7+ years of software engineering experience
  • 7 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning
  • 7+ years of SQL experience
  • 2+ years of experience creating visual reports with one or combination of the following: SSRS, Tableau, or PowerBI
  • 7+ years of experience delivering ETL, data warehouse and data analytics capabilities on big-data architecture such as Hadoop
  • 3 + years of experience working with large data sets
  • 5+ years of experience with scripting languages such as Bash, PowerShell, Python, Shell, VBScript, or JavaScript

Desired Qualifications:

  • An industry-standard technology certification
  • Strong verbal, written, and interpersonal communication skills
  • SQL Server Integration Services (SSIS) experience
  • Basic Microsoft Visio skills
  • Knowledge and understanding of data modeling tools, such as Power Designer
  • Experience with Spark, Hive and Kafka
  • 4+ years of experience with source coding in one or a combination of the following: GitHub, SVN(Subversion), TFVC (Team Foundation Version Control) or TFSGit (Team Foundation Server)
    Ability to communicate effectively with a quantitative development team about models and integration strategies
  • Ability to dissect technical problems, analyze data, and recommend potential solutions
  • Knowledge and understanding of data dimensional modeling
  • Good data analytical and validation skills
  • BS/BA degree or higher in information technology

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.

EEO Employer

Signature Consultants is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Signature will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or 888.838.1020.