Senior ETL Developer

4 weeks ago

Laurel, United States ASSYST Full time

ASSYST is seeking an experienced Senior ETL Developer to support our client in Laurel, MD. The selected candidate will be responsible for the design, development, and administration of ETL processes using Informatica PowerCenter, ensuring seamless data integration and transformation into cloud-based data platforms like Azure Synapse Analytics. This role requires expertise in developing, managing, and optimizing ETL workflows to handle large-scale data from various sources while ensuring high performance and data accuracy.


The ideal candidate will collaborate with data engineers, analysts, and stakeholders to implement scalable ETL solutions and ensure compliance with data governance policies. Strong knowledge in cloud technologies, SQL databases, and ETL administration is required, with a focus on performance tuning and troubleshooting.


Job Title: Senior ETL Developer

Location: Laurel, MD 20707(Hybrid - 3 days onsite 2 days remote)


Key Responsibilities:

  • Develop complex ETL workflows and mappings using Informatica PowerCenter to extract, transform, and load data from multiple sources.
  • Integrate data from disparate systems such as databases, flat files, and APIs into data warehouses, lakes, and repositories.
  • Administer the Informatica PowerCenter environment, including installation, configuration, upgrades, and patch management.
  • Monitor and optimize ETL processes through load balancing, parallel processing, and efficient transformations.
  • Identify and resolve ETL issues such as data inconsistencies, job failures, and performance bottlenecks to ensure high availability.
  • Ensure data accuracy and consistency by implementing rigorous validation checks throughout the ETL process.
  • Collaborate with business analysts, data architects, and stakeholders to gather requirements and align solutions with business needs.
  • Maintain documentation of ETL processes, workflows, mappings, and data models.
  • Automate ETL jobs and workflows, scheduling them for optimal execution and managing dependencies.
  • Implement data cleansing, data quality checks, and transformation logic to ensure data integrity.
  • Ensure ETL processes comply with security standards, data governance policies, and data privacy regulations.
  • Manage version control and updates for ETL processes, ensuring smooth production transitions.
  • Monitor system resources and scale infrastructure to accommodate future data growth.
  • Work with database administrators to optimize database performance for ETL operations.
  • Develop error-handling mechanisms, including logging, alerting, and rollback procedures.
  • Provide guidance and mentorship to junior developers and promote best practices for ETL development.
  • Ensure compliance with metadata management, data lineage tracking, and audit trail requirements.
  • Stay current with industry trends and implement improvements to enhance ETL processes.
  • Expertise in Oracle and SQL Server databases with strong skills in SQL and PL/SQL.
  • Preferred experience in Python for building data pipelines.


Preferred Experience & Qualifications:

  • Bachelor’s Degree in Information Systems, Computer Science, or a related technical field.
  • Minimum of 3 years of relevant experience in ETL development and data integration.
  • Experience in designing and implementing enterprise-level data solutions.
  • Industry experience in water and wastewater utilities with knowledge of Oracle utility applications is preferred.
  • Proven experience working on large-scale data projects with a focus on analytics, business intelligence, and enterprise systems.
  • Extensive experience with data modeling and database design.
  • Expertise in building enterprise-wide analytics solutions with data integration from multiple sources.
  • Strong knowledge of SQL, PL/SQL, and Oracle database management with performance optimization.
  • Familiarity with data governance frameworks to ensure data quality and security.
  • Excellent communication skills for translating business needs into technical solutions.
  • Strong problem-solving abilities, especially when handling complex datasets.


ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.

  • Senior ETL Developer

    4 weeks ago

    Laurel, United States Oakland Consulting Group, Inc. Full time

    Senior ETL Developer with expertise in Informatica PowerCenter will design, develop, and administer ETL processes to support data integration and transformation for cloud-based data solutions. The role involves building and optimizing complex ETL workflows using Informatica PowerCenter to extract, transform, and load data from various sources into Azure...

  • Senior ETL Developer

    4 weeks ago

    Laurel, United States Oakland Consulting Group, Inc. Full time

    Senior ETL Developer with expertise in Informatica PowerCenter will design, develop, and administer ETL processes to support data integration and transformation for cloud-based data solutions. The role involves building and optimizing complex ETL workflows using Informatica PowerCenter to extract, transform, and load data from various sources into Azure...

  • Senior ETL Developer

    4 weeks ago

    Laurel, Maryland, United States Assyst Full time

    At Assyst, we are seeking a highly skilled Senior ETL Developer to join our team. As a key member of our data integration team, you will be responsible for designing, developing, and administering ETL processes using Informatica PowerCenter. Your expertise will ensure seamless data integration and transformation into cloud-based data platforms like Azure...

  • Senior ETL Developer

    1 week ago

    Laurel, MD, United States Oakland Consulting Group, Inc. Full time

    Senior ETL Developer with expertise in Informatica PowerCenter will design, develop, and administer ETL processes to support data integration and transformation for cloud-based data solutions. The role involves building and optimizing complex ETL workflows using Informatica PowerCenter to extract, transform, and load data from various sources into Azure...

  • Senior ETL Developer

    4 weeks ago

    Laurel, Mississippi, United States Rubix Solutions LLC Full time

    Job SummaryAt Rubix Solutions LLC, we are seeking a highly skilled Data Integration Specialist to join our team. As a key member of our data engineering team, you will be responsible for designing, developing, and administering ETL processes to support data integration and transformation for cloud-based data solutions.Key ResponsibilitiesDesign and develop...

  • ETL Informatica Developer

    4 weeks ago

    Mount Laurel, New Jersey, United States Diverse Lynx Full time

    Job Title: ETL Informatica Developer - Data Warehouse ExpertRole Overview: We are seeking an experienced ETL Informatica Developer to join our team at Diverse Lynx LLC. As an ETL Informatica Developer, you will be responsible for designing, developing, and implementing ETL processes using Informatica Power Centre. Your expertise in data warehousing and ETL...

  • Senior Data Integration Specialist

    3 weeks ago

    Laurel, Mississippi, United States Oakland Consulting Full time

    Senior ETL Developer at Oakland ConsultingWe are seeking a highly skilled Senior ETL Developer to join our team and lead the design, development, and administration of ETL processes to support data integration and transformation for cloud-based data solutions.The ideal candidate will have expertise in Informatica PowerCenter and experience in building and...

  • Senior Enterprise Database Architect

    4 weeks ago

    Laurel, Montana, United States Pinnacle Treatment Centers Full time

    Job Title: Senior Enterprise Database ArchitectJob Summary:Pinnacle Treatment Centers seeks a skilled Senior Enterprise Database Architect to design and implement data systems that meet the needs of our organization. The ideal candidate will have experience in designing enterprise databases, data warehouse systems, and cloud data systems.Key...

  • Senior Data Engineer

    4 weeks ago

    laurel, United States Oakland Consulting Group, Inc. Full time

    Location: Laurel, MDContractDuration: 12+ MonthsUSC and W2The Senior Data Engineer with expertise in Azure Synapse Analytics and Microsoft Fabric will design, develop, and implement scalable data solutions to support analytics and reporting needs. The role involves creating, optimizing, and managing data pipelines to efficiently move and transform data...

  • Senior Data Engineer

    4 weeks ago

    laurel, United States Oakland Consulting Group, Inc. Full time

    Location: Laurel, MDContractDuration: 12+ MonthsUSC and W2The Senior Data Engineer with expertise in Azure Synapse Analytics and Microsoft Fabric will design, develop, and implement scalable data solutions to support analytics and reporting needs. The role involves creating, optimizing, and managing data pipelines to efficiently move and transform data...

  • Senior Data Engineer

    4 weeks ago

    Laurel, United States Oakland Consulting Group, Inc. Full time

    Location: Laurel, MDContractDuration: 12+ MonthsUSC and W2The Senior Data Engineer with expertise in Azure Synapse Analytics and Microsoft Fabric will design, develop, and implement scalable data solutions to support analytics and reporting needs. The role involves creating, optimizing, and managing data pipelines to efficiently move and transform data...

  • Senior Data Engineer

    4 weeks ago

    Laurel, United States Oakland Consulting Group, Inc. Full time

    Location: Laurel, MDContractDuration: 12+ MonthsUSC and W2The Senior Data Engineer with expertise in Azure Synapse Analytics and Microsoft Fabric will design, develop, and implement scalable data solutions to support analytics and reporting needs. The role involves creating, optimizing, and managing data pipelines to efficiently move and transform data...

  • Senior SQL Server DBA Developer

    6 months ago

    Mt Laurel, United States Pinnacle Treatment Centers Full time

    Job Description: Design strategies for enterprise databases, data warehouse systems, and cloud data systems. Develop complex ETL (extract, transform and load) scripts in SSIS, Azure Data Factory and Information to integrate external data sources with Pinnacle Enterprise Data Warehouse. Develop database archiving and partitioning strategy to improve...

  • Senior Business Intelligence Engineer

    4 weeks ago

    Mount Laurel, New Jersey, United States Array Behavioral Care Full time

    Job Title: Senior Business Intelligence EngineerArray Behavioral Care is seeking a highly skilled Senior Business Intelligence Engineer to join our team. As a key member of our Data Analytics & Engineering team, you will be responsible for designing, building, and maintaining complex data analytics solutions using Power BI.Key Responsibilities:Design and...

  • Senior Salesforce Developer

    4 weeks ago

    Laurel, Montana, United States Bestinfo Systems LLC Full time

    Senior Salesforce DeveloperWe are seeking a highly skilled Senior Salesforce Developer to join our team at Bestinfo Systems LLC. The ideal candidate will have extensive experience in Salesforce technologies and platforms, with a strong focus on design, development, and deployment of Salesforce solutions that meet business needs.Key Responsibilities:Design...

  • Senior Software Developer

    4 weeks ago

    Laurel, Maryland, United States Belay Technologies Full time

    Job Title: Senior Software DeveloperBelay Technologies is seeking a highly skilled Senior Software Developer to join our team. As a key member of our software development team, you will be responsible for designing, developing, and testing software applications.Key Responsibilities:Design and develop software applications using a variety of programming...

  • Data Integration Specialist

    4 weeks ago

    Mount Laurel, New Jersey, United States Mondo Staffing Full time

    Job Description:As a Data Integration Specialist at Mondo Staffing, you will be responsible for designing, developing, and documenting complex processes that consolidate and integrate data. This role requires a strong understanding of data integration workflows and the ability to follow and contribute to best practices.Key Responsibilities:• Design and...

  • Senior Salesforce Developer

    4 weeks ago

    Laurel, Montana, United States Bestinfo Systems LLC Full time

    Senior Salesforce Developer OpportunityWe are seeking a highly skilled Senior Salesforce Developer to join our team at Bestinfo Systems LLC.About the Role:This is a contract position that requires a hybrid work arrangement, with a focus on designing, developing, and deploying Salesforce solutions that meet business needs.Key Responsibilities:Design and...

  • Senior Salesforce Developer

    3 weeks ago

    Laurel, Montana, United States Bestinfo Systems LLC Full time

    We have an exciting opportunity for a Senior Salesforce Developer to join our team at Bestinfo Systems LLC. This role requires a seasoned professional with extensive experience in Salesforce technologies and platforms.Key Responsibilities:• Design, develop, and deploy scalable and secure Salesforce solutions that meet business needs.• Develop expertise...

  • Senior Software Developer

    1 month ago

    Laurel, Maryland, United States Belay Technologies Full time

    Belay TechnologiesWe are seeking a highly skilled Senior Software Developer to join our team at Belay Technologies. As a Senior Software Developer, you will be responsible for maintaining legacy applications, developing new applications, and automating system workflows to satisfy client organizational goals.Key Responsibilities:Maintain legacy applications...