ETL Developer with Snowflake

1 month ago


Erie, United States PamTen Full time
Responsibilities: Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter, Power Exchange, and other related technologies. Data Integration: Collaborate with business analysts and data architects to translate business requirements into technical specifications and implement efficient data integration solutions. 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. Collaboration: Work closely with cross-functional teams to define data requirements and contribute to database design decisions. 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: Proficiency in Informatica PowerCenter and other Informatica products. Strong SQL skills and experience with databases like Azure DB and SQL Server Knowledge of data warehousing concepts and BI architecture. Knowledge of Insurance, Guidewire Policy Center and Policy Migration Tool will be added advantage. Experience with UNIX/Linux scripting and scheduling tools. Familiarity with data modeling techniques and schema designs (, star, snowflake schemas). Soft Skills: Excellent problem-solving and analytical skills. Strong communication and teamwork abilities. Ability to work independently and manage multiple tasks simultaneously.

  • Erie, United States PamTen Full time

    Responsibilities: Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter, Power Exchange, and other related technologies. Data Integration: Collaborate with business analysts and data architects to translate business requirements into technical specifications and implement efficient data integration...


  • 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 PamTen Full time

    Job Title: Senior ETL DeveloperWe 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...


  • 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 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, United States Maintec Technologies Full time

    Role: Sr. DataStage Developer Location: ERIE, PA Duration: Long Term Responsibilities: 10+ years of Experience in ETL design & development with 5-6 years of IBM DataStage tool experience Need to have worked on Version 11.5 Good to have worked on Version 11.7/Cloud pak for data Experience creating and parsing XML messages with Datastage Experience of...


  • 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...

  • Data Scientist II

    1 week ago


    Erie, United States Comcast Corporation Full time

    Make your mark at Comcast -- a Fortune 30 global media and technology company. From the connectivity and platforms we provide, to the content and experiences we create, we reach hundreds of millions of customers, viewers, and guests worldwide. Become part of our award-winning technology team that turns big ideas into cutting-edge products, platforms, and...

  • Data Scientist II

    1 week ago


    Erie, PA, United States Comcast Corporation Full time

    Make your mark at Comcast -- a Fortune 30 global media and technology company. From the connectivity and platforms we provide, to the content and experiences we create, we reach hundreds of millions of customers, viewers, and guests worldwide. Become part of our award-winning technology team that turns big ideas into cutting-edge products, platforms, and...