ETL Tester Sr.

Experience:

• + 4 YOE with Testing
• Informatica Powercenter, SQL, ETL OR Datawarehouse
• Advanced Conversational English

Nice to have:

• Unix Shell Scripting

Responsibilities:

• Lead the design and implementation of data warehousing solutions to support business intelligence and analytics needs.
• Oversee the Test case creation and testing ETL processes using Informatica Powercenter.
• Provide expertise in data integration and ensure seamless data flow across systems.
• Develop and optimize SQL queries for data extraction transformation and loading.
• Utilize Unix Shell Scripting to automate data processing tasks and improve efficiency.
• Collaborate with business analysts and stakeholders to understand data requirements and deliver solutions.
• Ensure data quality and integrity by implementing robust validation and error-handling mechanisms.
• Monitor and troubleshoot ETL processes to ensure timely and accurate data delivery.
• Maintain documentation of data models ETL processes and data integration workflows.
• Stay updated with industry trends and best practices in data warehousing and ETL technologies.
• Contribute to the continuous improvement of data management practices and standards.
• Provide technical guidance and mentorship to junior developers.
• Participate in code reviews and ensure adherence to coding standards and best practices.

Qualifications

Knowledge with:

• Data Warehousing Concepts and ETL processes.
• Aadvanced SQL skills for data manipulation and querying.
• Unix Shell Scripting for automation.
• Domain expertise in Property & Casualty Insurance.
• Nice to have experience with other data integration tools and technologies.
• Nice to have knowledge of data governance and data quality frameworks.

BENEFITS:

• 100% payrrol
• All law benefits
• 50% of Vacation Bonus
• 24 days of Crhistmas Bonus
• Monthly Pantry Tickets aditional to your salary
• MME & Life Insurance
• Dental & Visual Insurance
• Personal & Professional growth: Unlimited access to Udemy and Cognizant Academy