Jobs in Lansing, MI

About the role

Title: Sr. Technical Consultant Duration:4+ Months

What you'll bring

• Data profiling activities to validate and confirm on expected transformation rules.
• Expertise in ETL architecture design and experience in job design, optimization, scheduling, containers, job sequences, configurations, and transformer stages, involving data quality, testing and information delivery and access to the data warehouse.
• 5 years expertise in Teradata and Data Stage.
• 5 years writing SQL queries and stored procedures.
• 5 years of design and development of ETL Datastage jobs for handling enterprise inbound/outbound data and handling heterogeneous inputs.
• Writing shell scripting for various ETL needs and automation.
• Development of Source to Target Mapping Specifications, and supporting data modeling efforts.
• Expertise in building Teradata BTEQ scripts and utilizing Teradata utilities such as TPT, fast load, fast export, MLOAD to meet various business requirements
• Data profiling, data model design, review, ETL jobs design using DataStage.
• Experience in design data conversions, creating/validating data conversion rules.
• Data Base administration, data architect, and performance tuning.
• Interactions with project stake holders for design, business transformation rules and System testing/UAT activities.