ETL Developer with Snowflake Job at PamTen, Erie, PA

Yzl1TVBJNy9iRm9weEhaN09Bb3VnODNZcUE9PQ==
  • PamTen
  • Erie, PA

Job Description

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 (e.g., star, snowflake schemas). Soft Skills: Excellent problem-solving and analytical skills. Strong communication and teamwork abilities. bility to work independently and manage multiple tasks simultaneously. PamTen

Job Tags

Similar Jobs

Jobot

Certified Diabetes Educator (Hiring Immediately) Job at Jobot

 ...helping people live better lives through improved health. As a team, we work together to empower individuals with diabetes through comprehensive education and support, making a positive impact on our communitys well-being. Please reach out to me directly to learn more... 

Luxury Bath NJPA

Entry Level Marketing Job at Luxury Bath NJPA

**PLEASE READ** This position is entry-level, we provide ALL training and no experience is necessary. Our goal is to build your knowledge of business, communications, marketing, and sales. This position is perfect for someone looking to grow, someone looking to change... 

The Youth Cartel

Radio Station Production Manager + On-Air - Columbus, OH Job at The Youth Cartel

Radio Station Production Manager + On-Air - Columbus, OH Radio Station Production Manager + On-Air - Columbus, OHNoncommercial, Gen Z-focused Christian rock, pop, and hip hop RadioU has a full-time opening for a radio Production Manager and on-air host at its studios in... 

T-Mobile

Mobile Event Expert Job at T-Mobile

Mobile Event Expert Location Odessa, TX : Be unstoppable with us! T-Mobile is synonymous with innovation-and you could be part of the team that disrupted an entire industry! We reinvented customer service, brought real 5G to the nation, and now we're shaping the future... 

Berkshire Health Systems

Medical Assistant Training Program, Berkshire Faculty Services, Shift Days, 40hrs. Job at Berkshire Health Systems

 ...participates in the Berkshire Health Systems Medical Assistant Program. The Practice Assistant receives clinical skill instruction. After...  ...cultures and cultural differences. Ability to learn new computer software; Ability to adapt to fast-paced, multifaceted position...