ETL Lead

2 months ago


minneapolis, United States ITC Infotech Full time

Job Title: ETL Lead.

Location: Minneapolis, MN. - This role would require you to be there in office for business hours for 2-3 days in a week.

Job Type: Full-Time


About the Role:

We are seeking an experienced ETL Developer to lead the conversion of DataStage ETL processes to SSIS, transitioning from Oracle to SQL Server source and target systems. The ideal candidate will have expertise in ETL development, SQL Server, and experience with Epic (Clarity, Caboodle, RWB) to help optimize data flows and support analytics. This role involves hands-on development, quality assurance, metadata management, and strategic guidance to future-proof the ETL architecture.


Key Responsibilities:

  • ETL Development & Conversion:

Convert DataStage ETL jobs to SSIS (SQL Server Integration Services) jobs as part of the Oracle to SQL Server migration.

Oversee complex ETL transformations in high-impact subject areas, including claims, member files, and payer data.

Ensure the new ETL architecture is scalable and adaptable for future business requirements.

  • Quality Assurance & Optimization:

Perform quality checks on new SQL Server processes, ensuring accuracy in analytics, data transformations, and ETL flows.

Identify and resolve any data discrepancies or inefficiencies in the ETL pipeline.

  • Metadata Management & Reporting:

Manage ETL-related metadata, enabling efficient querying for report dependencies and ETL job status.

Design queries to track and answer metadata-related questions, such as identifying reports relying on specific ETL tables or pinpointing jobs that can be retired.

  • Epic Data Model Expertise:

Work with Epic data models (Clarity, Caboodle, RWB) to support healthcare data management.

Integrate Epic systems into SQL Server processes, optimizing data usage for healthcare analytics.

  • Standards & Best Practices:

Review and update existing ETL standards as necessary to align with best practices and the latest technologies.

  • Organize and prioritize ETL tasks, monitor conversion progress, and ensure Oracle-to-SQL Server conversion processes follow established standards.


Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • Minimum of 7 hands-on experience with ETL tools such as DataStage and SSIS.
  • Strong SQL development skills with SQL Server; experience with Oracle is a plus.
  • Experience with Epic systems (Clarity, Caboodle, RWB) is essential.
  • Proficiency in metadata management, with the ability to create queries to assess ETL and reporting relationships.
  • Excellent organizational and project management skills, with a focus on accuracy and attention to detail.


Our Mission:

ITC Infotech is a leading global technology services and solutions provider, led by Business and Technology Consulting. ITC Infotech provides business-friendly solutions to help clients succeed and be future-ready, by seamlessly bringing together digital expertise, strong industry specific alliances and the unique ability to leverage deep domain expertise from ITC Group businesses. We provide technology solutions and services to enterprises across industries such as Banking & Financial Services, Healthcare, Manufacturing, Consumer Goods, Travel and Hospitality, through a combination of traditional and newer business models, as a long-term sustainable partner.


  • ETL Lead

    2 months ago


    Minneapolis, United States ITC Infotech Full time

    Job Title: ETL Lead.Location: Minneapolis, MN. - This role would require you to be there in office for business hours for 2-3 days in a week.Job Type: Full-TimeAbout the Role:We are seeking an experienced ETL Developer to lead the conversion of DataStage ETL processes to SSIS, transitioning from Oracle to SQL Server source and target systems. The ideal...


  • Minneapolis, United States Diverse Lynx Full time

    Role: Lead ETL Developer with PySpark Location: Minneapolis Downtown, MN (Onsite) Job Type: ContractJob Description: ETL Developer (5+years) to create data pipeline ETL Jobs using AWS Glue and PySpark Responsibilities: Work with a scrum team(s) to deliver product stories according to priorities set by the business and the Product Owners. Interact with...


  • Minneapolis, Minnesota, United States Diverse Lynx Full time

    Job Overview:We are looking for a highly experienced PySpark ETL Developer Lead to join our team at Diverse Lynx LLC. As a key member of our data pipelining team, you will be responsible for designing, developing, and maintaining efficient ETL processes using AWS Glue and PySpark.Key Responsibilities:Design and develop ETL processes using AWS Glue and...

  • ETL Lead

    7 days ago


    Minneapolis, United States ITC Infotech Full time

    Job Title: ETL Lead.Location: Minneapolis, MN. - This role would require you to be there in office for business hours for 2-3 days in a week.Job Type: Full-TimeAbout the Role:We are seeking an experienced ETL Developer to lead the conversion of DataStage ETL processes to SSIS, transitioning from Oracle to SQL Server source and target systems. The ideal...

  • ETL Developer

    4 days ago


    Minneapolis, United States Net2Source Inc. Full time

    Job Title: ETL DeveloperLocation: Minneapolis - MN - RemoteContract Required Skills: Python, Scala, SparkWe are seeking an experienced ETL Developer with 12+ years of experience to join our team.The ETL Developer will play a crucial role in designing and implementing scalable solutions that align with our business goals.ResponsibilitiesLead the design and...

  • ETL Developer

    3 weeks ago


    Minneapolis, United States Net2Source Inc. Full time

    Job Title: ETL DeveloperLocation: Minneapolis - MN - RemoteContract Required Skills: Python, Scala, SparkWe are seeking an experienced ETL Developer with 12+ years of experience to join our team.The ETL Developer will play a crucial role in designing and implementing scalable solutions that align with our business goals.ResponsibilitiesLead the design and...


  • Minneapolis, Minnesota, United States Syntricate Technologies Full time

    About Syntricate TechnologiesWe are a forward-thinking technology company dedicated to providing innovative solutions that propel our clients forward.Job DetailsThis is a full-time position, requiring a strong background in data engineering, software development, and team leadership.Responsibilities Lead the design, development, and implementation of...


  • Minneapolis, Minnesota, United States Accuro Group Full time

    We are seeking a highly skilled Data Integration Lead to join our team at Accuro Group in Minneapolis, MN. The ideal candidate will have 10+ years of experience in ETL development and a strong background in PySpark.Job DescriptionRole: Data Integration Lead with SparkLocation: Minneapolis, MN (Onsite)Experience: 10+ YearsDuration: Long-term contractJob...


  • Minneapolis, Minnesota, United States K&K Global Talent Solutions Inc. Full time

    Job OverviewWe are seeking a highly skilled Lead Data Integration Engineer to join our team at K&K Global Talent Solutions Inc. in this key role, you will be responsible for designing, developing, and maintaining ETL processes to support data integration and business intelligence initiatives.About the RoleThis is a full-time position with an estimated salary...

  • Data Engineering Lead

    2 weeks ago


    Minneapolis, Minnesota, United States Futran Tech Solutions Pvt. Ltd. Full time

    Futran Tech Solutions Pvt. Ltd. is seeking a highly skilled Data Engineer to join their team in Minneapolis, MN. This role requires at least 10 years of experience in big data skills and expertise in Apache Spark Scala development. The ideal candidate will have strong SQL concepts, Unix skills, and experience with ETL tools like Data Stage and Spark/Scala....

  • Data Engineer Lead

    1 month ago


    Minneapolis, Minnesota, United States Futran Tech Solutions Pvt. Ltd. Full time

    Futran Tech Solutions Pvt. Ltd. is seeking a highly skilled Data Engineer Lead to join our team.Job Responsibilities:Lead a team of data engineers in designing, developing, and maintaining large-scale data processing systems.Develop and implement efficient ETL pipelines using Apache Spark and Scala.Collaborate with cross-functional teams to integrate data...

  • Technical Lead

    4 weeks ago


    Minneapolis, United States Wipro Full time

    About Wipro: Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading technology services and consulting company focused on building innovative solutions that address clients' most complex digital transformation needs. We leverage our holistic portfolio of capabilities in consulting, design, engineering, operations, and emerging technologies to help...


  • Minneapolis, Minnesota, United States RIT Solutions, Inc. Full time

    Lead .NET Developer PositionWe are seeking an experienced Lead .NET Developer to join our team at RIT Solutions, Inc. The successful candidate will have strong technical skills in .Net Core, ETL, and REST API (web services) and experience with CSV or other fixed format bulk data upload.About the Role:This role involves leading a team of developers to develop...

  • Data Engineer Lead

    2 weeks ago


    Minneapolis, Minnesota, United States Futran Tech Solutions Pvt. Ltd. Full time

    Futran Tech Solutions Pvt. Ltd. is looking for a skilled Data Engineer Lead to join their team in Minneapolis, MN. As a key member of the data engineering team, you will design and build complex data processing pipelines using ADF and Airflow. You will work closely with cross-functional teams to ensure seamless integration with cloud databases like SQL. The...


  • Minneapolis, Minnesota, United States Diverse Lynx Full time

    Job DescriptionWe are seeking a highly skilled Cloud Data Engineering Lead to join our team at Diverse Lynx LLC. As a key member of our data engineering team, you will be responsible for designing, developing, and optimizing scalable ETL processes using Python, Apache Spark, and Azure Synapse. Your expertise in Azure Cloud, including SQL Pools and Spark...


  • Minneapolis, Minnesota, United States Allianz Full time

    Job DescriptionWe are seeking a highly skilled Senior IT Systems Lead to partner with our business, IT teams, and product vendors to lead the implementation and continuous improvement of Annuity and Life reinsurance solutions as well as the PAM solution.This role will work closely with Application Support partners to drive solutions in a timely manner. The...

  • Data Engineer

    1 month ago


    Minneapolis, United States Futran Tech Solutions Pvt. Ltd. Full time

    JC Number: 2006703 Role: Data Engineer - Apache Spark - Tech Lead Location: Minneapolis, MN (Day 1 onsite) Yrs. of exp: 10+ Yrs. # of positions: 2 Salary: $120K(Including QPLC) Top Skills: Good Apache spark Scala skills Good Big Data Skills Good Unix Skills Job Description: Atleast 2+ years as Lead Strong in Spark Scala development (Minimum 5 years of...

  • Data Engineer Lead

    3 weeks ago


    Minneapolis, Minnesota, United States Futran Tech Solutions Pvt. Ltd. Full time

    Job DescriptionWe are seeking a highly skilled Data Engineer to join our team at Futran Tech Solutions Pvt. Ltd. in Minneapolis, Minnesota, USA. As a key member of our team, you will be responsible for designing, developing, and implementing data engineering solutions that meet the business needs of our clients.About the RoleDesign, develop, and implement...


  • Minneapolis, Minnesota, United States Aloden, Inc. Full time

    Job DescriptionWe are seeking an experienced Azure Data Engineer Lead to join our team at Aloden, Inc. As a key member of our engineering team, you will be responsible for leading the design, development, and implementation of large-scale data solutions on Microsoft Azure.The ideal candidate will have a strong understanding of relational database concepts,...


  • Minneapolis, Minnesota, United States Diverse Lynx Full time

    Job Description:Diverse Lynx LLC is seeking a highly skilled Senior Data Integration Specialist to lead our data pipelining efforts using PySpark. As a key member of our team, you will design, develop, and maintain efficient ETL processes to support data integration and business intelligence initiatives.Responsibilities:Work closely with stakeholders to...