The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
Mly26w732sffqz8k6dn

ETL Data Developer - Contract

Job Description

Our client is looking for a Microsoft CRM Developer for their Columbia, SC location. This will be a 6-month contract with possibility of extension.

Job Description
Our client is looking for a contract ETL Data Developer that is an expert in SQL, ETL and problem solving for our modern Enterprise Data Warehouse agile team. Candidate will work with a team of 10 developers, DBA's and BA's for a large SQL Server Data Warehouse.


Duties:

  • Work with business requirements analysts to identify and solve business problems
  • Map source system data to data warehouse models
  • Develop and test extraction, transformation, and load (ETL) processes
  • Define and capture metadata and rules associated with ETL processes
  • Adapt ETL processes to accommodate changes in source systems and new business user requirements
  • Identify conflicting views or issues, and strive to identify the best solutions, documenting issues
  • Demonstrate extensive system/application knowledge; provide system/application support as needed
  • Proficient with understanding business requirements and in some cases act as a BA
  • Promote and demonstrate effective teamwork in an Agile team setting
  • Must be results-oriented and able to manage time appropriately in order to meet assigned goals
  • Ability to analyze and estimate system requirements, develop alternatives, and implement solutions
  • Must have an solid understanding of computer systems including hardware, operating systems, programming languages
  • Must have an solid understanding of business processes and system interdependencies
  • Candidate must be able to effectively communicate in English (written & verbal)
  • Implement stored procedures and effectively query a database
  • Identify and test for bugs and bottlenecks in the ETL solution
  • Provide support and fix issues in the packages
  • Writes advanced SQL including some query tuning
  • Deep understanding of OLAP and OLTP
  • Candidate must demonstrate sounds principles with software architecture, design, implementation and support for RASP (Reliable, Available, Secure and highly Performing) solutions
  • Candidate must have deep skills in multiple areas including systems architecture and design, data development, and problem solving
  • Candidate must demonstrate secure coding practices
  • Candidate must demonstrate the ability to interpret requirements into design implementation and code effectively
  • Candidate must have permanent authorization to work in the USA for any employer

Job Requirements

Required Experience:

  • 12 years' experience with SQL Server (2016, 2012, 2008)
  • 7 years' experience with Microsoft SQL Server Integration Services (SSIS ETL) 2016, 2012, 2008
  • 7 years' experience with Data Modeling, Data Design and extensive experience with Data Integration
  • 4 years' experience with Microsoft SQL Server Reporting Services (SSRS) or Tableau Analytics

Education:


  • Bachelor (BS) or Master (MS) degree in Engineering or Computer Science required

Job Snapshot

Location US-SC-Columbia
Employment Type Contractor
Pay Type Year
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

Atlantic Partners Co.

Atlantic Partners was created with the clear objective of providing the most comprehensive IT staffing solutions, along with a robust executive search division. From staff augmentation to contract for hire to direct placement, Atlantic Partners offers a full range of staffing options. With over 100 years of experience, our team of account executives and technical recruiters has a proven track record of fulfilling the human capital needs of our clients. Learn More

Contact Information

US-SC-Columbia
Icon-social-facebookIcon-social-linkedinIcon-social-twitter
Snapshot
Atlantic Partners Co.
Company:
US-SC-Columbia
Location:
Contractor
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description

Our client is looking for a Microsoft CRM Developer for their Columbia, SC location. This will be a 6-month contract with possibility of extension.

Job Description
Our client is looking for a contract ETL Data Developer that is an expert in SQL, ETL and problem solving for our modern Enterprise Data Warehouse agile team. Candidate will work with a team of 10 developers, DBA's and BA's for a large SQL Server Data Warehouse.


Duties:

  • Work with business requirements analysts to identify and solve business problems
  • Map source system data to data warehouse models
  • Develop and test extraction, transformation, and load (ETL) processes
  • Define and capture metadata and rules associated with ETL processes
  • Adapt ETL processes to accommodate changes in source systems and new business user requirements
  • Identify conflicting views or issues, and strive to identify the best solutions, documenting issues
  • Demonstrate extensive system/application knowledge; provide system/application support as needed
  • Proficient with understanding business requirements and in some cases act as a BA
  • Promote and demonstrate effective teamwork in an Agile team setting
  • Must be results-oriented and able to manage time appropriately in order to meet assigned goals
  • Ability to analyze and estimate system requirements, develop alternatives, and implement solutions
  • Must have an solid understanding of computer systems including hardware, operating systems, programming languages
  • Must have an solid understanding of business processes and system interdependencies
  • Candidate must be able to effectively communicate in English (written & verbal)
  • Implement stored procedures and effectively query a database
  • Identify and test for bugs and bottlenecks in the ETL solution
  • Provide support and fix issues in the packages
  • Writes advanced SQL including some query tuning
  • Deep understanding of OLAP and OLTP
  • Candidate must demonstrate sounds principles with software architecture, design, implementation and support for RASP (Reliable, Available, Secure and highly Performing) solutions
  • Candidate must have deep skills in multiple areas including systems architecture and design, data development, and problem solving
  • Candidate must demonstrate secure coding practices
  • Candidate must demonstrate the ability to interpret requirements into design implementation and code effectively
  • Candidate must have permanent authorization to work in the USA for any employer

Job Requirements

Required Experience:

  • 12 years' experience with SQL Server (2016, 2012, 2008)
  • 7 years' experience with Microsoft SQL Server Integration Services (SSIS ETL) 2016, 2012, 2008
  • 7 years' experience with Data Modeling, Data Design and extensive experience with Data Integration
  • 4 years' experience with Microsoft SQL Server Reporting Services (SSRS) or Tableau Analytics

Education:


  • Bachelor (BS) or Master (MS) degree in Engineering or Computer Science required
Mwg7ln685bhyvvp7mpf
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
ETL Data Developer - Contract Apply now