Previous Job
Previous
Lead SQL/ETL Analyst
Ref No.: 17-05112
Location: Charlotte, North Carolina
Qualified candidates send your resume to scooper@inttechnologies.com

C2C is not an option at this time

Title: SQL LEAD ETL ANALYST
Location: Charlotte, NC CIC
Duration: 6 Months contract to hire
Onsite Interviews REQUIRED - NO PHONE SCREENS
Manager Notes - This is not a SQL ETL Developer - This is a Technical Analyst.
***Must Have Lead experience


Job Requirements:
  • Must have 10+ years of experience in data validation and integration testing
  • Develop ETL test scripts based on technical specifications/Data design documents and Source to Target mappings
  • Must know Complex SQL Tables, Joins, ETL data modeling
  • Validating the target database checks such as record counts, mandatory key fields, aggregate, derived, dimension checks and more
  • Ability to validate the transformation logic by performing checks such as business check, derived field check, surrogate key check and more
  • Validating the staging tables to ensure the record counts, reconcile counts with source, invalidity of junk data, duplicate data and data size checks -SSIS, TSQL, stored procedures, user defined functions, etc. from the SQL Server stack
  • Providing assistance to identify, evaluate, and develop solutions that are cost effective and meet or exceed business requirements
  • Working with end-users, partners, and cross functional teams to provide project support, resolve questions, assess needs, and recommend changes
  • Providing production support, testing, validating changes, writing requirements, documentation, and change management related to tool releases and other needs Providing guidance and best practices for leveraging tools capabilities
  • Working with user groups to provide training, resolve questions, assess user needs, and recommend changes
  • Facilitating and documenting meetings and workshops with business and technology partners