DATA ENGINEER

Position: DATA ENGINEER - SQL SERVER METRIC MIGRATION


Location: Omaha, NE
Job type: Contract


SUMMARY : DATA ENGINEERING TO MOVE SQL SERVER TABLES AND SSIS JOBS TO TERADATA OR SNOWFLAKE.


MUST HAVE :

1. EXPERIENCE WITH SSIS PACKAGES AND SQL AGENT JOBS.
2. STRONG SQL DEVELOPMENT AND QUERY OPTIMIZATION IN TERADATA, ORACLE, AND SQL SERVER; DATA LINEAGE AND DEPENDENCY ANALYSIS.
3. REVERSE ENGINEERING LEGACY ETL PROCESSES.
4. DATA MIGRATION AND MODERNIZATION.
5. DATA VALIDATION AND RECONCILIATION TESTING;
6. CROSS-PLATFORM SQL CONVERSION

GOOD TO HAVE : SNOWFLAKE, ORACLE SQL, INFORMATICA, ETL TOOLS, DATA WAREHOUSE EXPERIENCE, RAILROAD / TRANSPORTATION / LOGISTICS EXPERIENCE, PRODUCTION CUTOVER SUPPORT


REQUIRED WORK LOCATION : PREFERRED CANDIDATE WILL WORK ONSITE AT UPC IN OMAHA, NE. MUST BE ONSHORE, EVEN IF WORKING REMOTELY.


DESIRED PROFILE:

• • STRONG SQL SERVER AND TERADATA TECHNICAL SKILLS AND ABILITY TO TRACE COMPLEX TABLES, VIEWS, STORED PROCEDURES, SSIS PACKAGES, AND SQL AGENT JOBS.
  • VERY GOOD ANALYTICAL SKILLS AND PROBLEM-SOLVING ABILITY A MUST.
  • ABILITY TO DOCUMENT END-TO-END DATA LINEAGE, DEPENDENCIES, RISKS, DECISIONS CLEARLY.
  • EXPERIENCE WORKING ACROSS SQL SERVER, TERADATA, ORACLE, AND SNOWFLAKE ENVIRONMENTS.
  • MUST BE CAPABLE OF INDEPENDENTLY TRACING DATA LINEAGE, REVERSE ENGINEERING ETL PROCESSES, AND MIGRATING BUSINESS-CRITICAL DATA AND REPORTING LOGIC BETWEEN PLATFORMS AFTER ONBOARDING.
  • STRONG COMMUNICATION SKILLS AND ABILITY TO WORK WITH PROJECT LEADERSHIP, TECHNICAL TEAMS, AND BUSINESS STAKEHOLDERS.
  • EXPERIENCE SUPPORTING ARCHITECTURE REVIEWS, VALIDATION TESTING, HISTORICAL DATA MIGRATION, PRODUCTION CUTOVER, AND IMPLEMENTATION ACTIVITIES.
  • STRONG BACKGROUND DELIVERING ACCURATE MIGRATION RESULTS WHILE PRESERVING EXISTING BUSINESS LOGIC AND REPORTING BEHAVIOR