Senior ETL Developer for Data Warehousing

3 weeks ago


Erie, Pennsylvania, United States PamTen Full time

Job Title: Senior ETL Developer

We are seeking an experienced ETL developer to join PamTen, a leading company in data warehousing and business intelligence. The ideal candidate will have a strong background in ETL development, with a focus on Informatica tools.

 

Responsibilities:

  • Data Integration: Collaborate with data architects to translate business requirements into technical specifications and implement efficient data integration solutions.
  • Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter and other related technologies.
  • Performance Optimization: Optimize ETL processes for performance and efficiency, ensuring minimal downtime and maximum throughput.
  • Data Quality and Integrity: Ensure data quality and integrity throughout the ETL process, implementing data validation and cleansing routines.
  • Testing and Troubleshooting: Conduct unit and integration testing of ETL processes, troubleshoot issues, and provide post-production support.
  • Documentation: Maintain comprehensive documentation of ETL processes, data mappings, and workflows.

Qualifications:

  • Educational Background: Bachelor's or master's degree in computer science, Information Systems, or a related field.
  • Experience: 5-8 years of experience in ETL development, with a strong focus on Informatica tools.
  • Technical Skills:
    • Informatica PowerCenter: Proficiency in Informatica PowerCenter and other Informatica products.
    • SQL Skills: Strong SQL skills and experience with databases like Azure DB and SQL Server
    • Data Warehousing Concepts: Knowledge of data warehousing concepts and BI architecture.

Estimated Salary: $120,000 - $150,000 per year. This is a full-time position with a competitive salary and benefits package.



  • Erie, Pennsylvania, United States Maintec Technologies Full time

    Earn a Competitive Salary:The successful candidate will have access to a highly competitive salary range of $120,000 - $180,000 per year. This role offers a unique opportunity to grow professionally and financially.About the Job:We are seeking a skilled Datastage ETL Solutions Specialist to join our team. The ideal candidate will have extensive experience in...


  • Erie, Pennsylvania, United States Derex Technologies Full time

    Key ResponsibilitiesDesign, develop, and maintain ETL processes using Informatica PowerCenter, Power Exchange, and other related tools to ensure seamless data integration.Collaborate with cross-functional teams to translate business requirements into technical specifications, driving the implementation of effective data solutions.Evaluate data quality and...


  • Erie, Pennsylvania, United States Maintec Technologies Full time

    Dream Career Opportunity:We are seeking a talented Senior Data Pipeline Developer to join our dynamic team at Maintec Technologies. As a key member of our team, you will be responsible for designing and developing robust ETL pipelines using Datastage. You will also collaborate with cross-functional teams to deliver high-quality projects on time.About the...


  • Erie, Pennsylvania, United States Maintec Technologies Full time

    Role Overview:We are seeking an experienced professional to lead the design and development of our Enterprise ETL architecture. This includes leveraging Shared components for data movement from source to target systems, creating and parsing XML messages with Datastage, and developing ETL programs based on standards and guidelines.About Maintec...


  • Erie, Pennsylvania, United States Derex Technologies Full time

    Job Description: Senior Business Intelligence Developer - P&C Insurance Domain SpecialistDerex Technologies INC is looking for an experienced Senior Business Intelligence Developer to join our team. The ideal candidate will have strong expertise in Property and Casualty Insurance, specifically in the area of Underwriting workbench/workstation.This role...


  • Erie, Pennsylvania, United States Essentra Full time

    Job OpportunityWe are seeking a Marketing Data Strategist to join our team in Erie, PA or Houston, TX.Estimated Salary: $60,000 - $80,000 per year.About EssentraEssentra is a global market leader in plastic injection molded, vinyl dip molded, and metal components with a history of over 65 years.Our product range features caps and plugs, wire and cable...


  • Erie, Pennsylvania, United States Tata Consultancy Services Full time

    Company OverviewTata Consultancy Services is a global leader in digital transformation driving your business growth. Salary$120k per annum, based on experience and qualifications. Job DescriptionWe are seeking a highly skilled AWS Data Engineer to join our team. The successful candidate will be responsible for designing, building, and maintaining...


  • Erie, Pennsylvania, United States One Senior Care, LLC. Full time

    About the RoleWe are seeking an experienced Data Analyst with a strong background in Power BI to join our team at One Senior Care, LLC.The ideal candidate will have excellent analytical and problem-solving skills, with the ability to work independently and collaboratively as part of a dynamic team.Key responsibilities will include:Crafting interactive...


  • Erie, Pennsylvania, United States Derex Technologies Full time

    About UsDerex Technologies Inc is a leading provider of IT consulting, staffing solutions, and software services. With over two decades of experience, we have established ourselves as a trusted partner for businesses across various industries. Our team of experts is dedicated to delivering high-quality technology professionals and customized IT talent...


  • Erie, Pennsylvania, United States ApexDrop Full time

    Sales Manager Opportunity at ApexDropWe are seeking an experienced Sales Manager to join our team at ApexDrop. As a Sales Manager, you will be responsible for leading the sales team, driving new business opportunities, and ensuring our company hits its ambitious revenue targets.About ApexDrop:Since 2015, ApexDrop has reshaped the way brands and influencers...


  • Erie, Pennsylvania, United States Derex Technologies Full time

    Company OverviewDerex Technologies Inc is a renowned IT consulting firm that specializes in providing cutting-edge staffing solutions and software services. Headquartered in New Jersey since 1996, Derex has established itself as a global leader in delivering high-quality technology professionals and customized IT talent solutions to clients across North...


  • Erie, Pennsylvania, United States Diverse Lynx Full time

    Cloud Career OpportunityWe are seeking an experienced Senior Cloud Engineer to join Diverse Lynx LLC at our headquarters in the US.About UsDiverse Lynx is a leading company that provides cutting-edge cloud solutions for various industries. Our team is dedicated to delivering exceptional results and exceeding client expectations.Job DescriptionAs a Senior...


  • Erie, Pennsylvania, United States Innova Solutions Full time

    Job DescriptionThe successful candidate will be responsible for implementing basic code and configuration changes under direction in a low-risk environment.They will also support IGC business users for any technical issues related to the tool, perform data profiling using IA tools, develop queries and APIs to support IGC business users' data needs, and...


  • Erie, Pennsylvania, United States erie Indemnity Company Full time

    Erie Indemnity Company is seeking a talented Senior IT Analyst to join our team in Erie, PA. The estimated salary range for this position is $95,000 - $130,000 per year.In this role, you'll be responsible for driving transformational change, managing complex projects, and collaborating with stakeholders to achieve business objectives.Key responsibilities...


  • Erie, Pennsylvania, United States Asbury Communities Full time

    BenefitsSalary Range: $50,000 - $65,000 per yearAre you a compassionate and skilled driver looking for a new challenge? Do you want to make a difference in the lives of seniors and their families?As a Transportation Services Coordinator at Asbury Communities, you will have the opportunity to work with a talented team of professionals who share your...


  • Erie, Pennsylvania, United States ERIEBANK Full time

    Why Work at ERIEBANK?ERIEBANK offers a unique opportunity to join a dynamic and growing organization that values innovation, diversity, and inclusion. Our employees enjoy a comprehensive benefits package, including competitive salaries, bonuses, and retirement savings plans.We believe in fostering a culture of collaboration, creativity, and professional...


  • Erie, Pennsylvania, United States Donjon Shipbuilding & Repair, LLC Full time

    At Donjon Shipbuilding & Repair, LLC, we are seeking an experienced Senior Engineering Director to lead our Engineering Department in Erie, PA. This role offers a competitive salary of $120,000 - $180,000 per year, depending on experience.Job Description:The Senior Engineering Director will be responsible for ensuring that our engineering department is...


  • Erie, Pennsylvania, United States New Perspective Senior Living LLC Full time

    OverviewNew Perspective Senior Living LLC is a leading provider of senior living services, dedicated to creating a purposeful and engaging community for our residents. We are seeking a highly motivated Housekeeper to join our team and contribute to delivering exceptional care and hospitality.We offer a comprehensive benefits package, opportunities for growth...


  • Erie, Pennsylvania, United States Phoenix Technical Solutions Full time

    Key ResponsibilitiesThe Design Engineer (DE) will work within defined parameters to make decisions and apply concepts to complex issues, providing direction and assistance to the engineering team as needed.Key tasks include:Documenting technical data generated by assigned projects consistent with engineering policies and procedures.Participating in technical...


  • Erie, Pennsylvania, United States New Perspective Senior Living LLC Full time

    About New Perspective Senior LivingWe're a growing company serving over 2,000 seniors today with a goal of reaching 10,000 by 2025. Our growth is creating energy, excitement, and the opportunity to make a difference in the lives of others.We have a culture of servant leadership and collaboration that supports each team member's personal and professional...