Sql Server Metric Migration

Saicon Consultants, Inc.

$95K — $115K *
Omaha, NE 68104In-Person
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in SQL Server, Teradata, and Oracle environments.
  • Proficiency with SSIS packages and SQL Agent jobs for data operations.
  • Expertise in query optimization and development across multiple databases.
  • Strong analytical skills for data lineage and dependency analysis.
  • Experience in reverse engineering ETL processes and data migration.
  • Ability to document data lineage and migration processes clearly.
  • Strong communication skills for collaboration with various stakeholders.

Responsibilities

  • Build and migrate SQL Server tables and SSIS jobs to Teradata or Snowflake.
  • Optimize SQL queries for performance across diverse database platforms.
  • Conduct data lineage analysis to ensure data integrity during migration.
  • Reverse engineer legacy ETL processes for modernization and data validation.
  • Support production cutover activities to ensure seamless transitions.
  • Collaborate with project leads and technical teams on architecture reviews and testing.
  • Deliver accurate migration results that retain existing business logic.

Benefits

  • Opportunities for professional development and continuous learning.
  • Collaboration with a dynamic team of experts in data engineering.
  • Exposure to modern tools and platforms in data migration.
  • Contribution to significant projects in the transportation and logistics sectors.
Full Job Description
Job Description:
Data Engineering to Move Sql Server Tables and SSIS Jobs To Teradata or Snowflake.
Must Have:
  • Experience With Ssis Packages and Sql Agent Jobs
  • Strong Sql Development and Query Optimization In Teradata, Oracle, And Sql Server
  • Data Lineage and Dependency Analysis
  • Reverse Engineering Legacy Etl Processes; Data Migration and Modernization; Data Validation and Reconciliation Testing; Cross-Platform Sql Conversion

Good To Have:
  • Snowflake, Oracle Sql, Informatica, Etl Tools, Data Warehouse Experience, Railroad / Transportation / Logistics Experience, Production Cutover Support

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.

Similar Jobs

More Jobs at Saicon Consultants, Inc.

  • GW Developer
    $95K — $115K *
    Madison, WI 53711 (Dane County)
    Finance & Insurance
    In-Person
  • Data Analyst
    $100K — $120K *
    New York, NY 10025 (New York County)
    Finance & Insurance
    In-Person
  • Sql Server Metric Migration
    $95K — $115K *
    Omaha, NE 68104 (Douglas County)
    Information Technology
    In-Person
  • Warranty Analysis Engineer - HVAC
    $80K — $95K *
    Auburn Hills, MI 48326 (Oakland County)
    Manufacturing & Automotive
    In-Person
  • Firmware Engineer
    $80K — $95K *
    Austin, TX 78745 (Travis County)
    Information Technology
    In-Person

More Information Technology Jobs

Find similar Sql Server Metric Migration jobs: