Description

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

Key Skills

Education

Any Graduate