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

TradeJobsWorkforce

Aldi Produce Clerk Job at TradeJobsWorkforce

 ...Join our growing team as a Aldi Produce Clerk to assist with organizing, stocking, and general upkeep, manage daily responsibilities with a focus on quality and efficiency, and maintain accurate records and documentation. Other duties include respond promptly to inquiries... 

Goodwin Recruiting

Sous Chef Job at Goodwin Recruiting

 ...Prominent hospitality group is looking for a driven and passionate Sous Chef to join its award-winning team. This is a hands-on role where you will help bring smiles to guests faces, motivate your crew, and deliver exceptional guest experiences every day. If you love... 

Jobright.ai

Junior Cloud Engineer Job at Jobright.ai

Join to apply for the Junior Cloud Engineer role at Jobright.aiJoin to apply for the Junior Cloud Engineer role at Jobright.aiGet AI-powered advice on this job and more exclusive features.Jobright is an AI-powered career platform that helps job seekers discover the top... 

Templar Media

Senior Game Designer Job at Templar Media

 ...About Templar : As an independent developer and publisher, Templar develops the games that we want, on our own schedule. We are actively staffing up for both in-house game development and supporting published titles. Templar provides a professional yet non-corporate environment... 

L3Harris Technologies

Software Engineers (C++, Java, Linux) Job at L3Harris Technologies

L3Harris is dedicated to recruiting and developing high-performing talent who are passionate about what they do. Our employees are unified in a shared dedication to our customers mission and quest for professional growth. L3Harris provides an inclusive, engaging environment...