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.

More Information Technology Jobs

Find similar Sql Server Metric Migration jobs: