Data Architect - Informatica

Job Title: Data Architect - Informatica

Primary skills: Informatica, DWH

Secondary skills: SQL

Mode of Work: Work from Office

Experience: 12 - 16 Years

About the job

We are seeking a skilled Data Architect with expertise in Informatica to join our team and contribute to building scalable, efficient, and governed data solutions. The ideal candidate will have hands-on experience in designing and optimizing Informatica data warehouses, leveraging SQL queries for complex ETL/ELT processes. Proficiency in advanced Informatica features.

Know your team

At Value Momentum's Technology Solution Center, we are a team of passionate engineers who thrive on tackling complex business challenges with innovative solutions while transforming the P&C insurance value chain. We achieve this through a strong engineering foundation and continuously refining our processes, methodologies, tools, agile delivery teams, and core engineering archetypes. Our core expertise lies in 4 key areas: Platform, App & Infra Engineering, Data & BI Engineering, Core Engineering, Advance Analytics.

Join a team that invests in your growth. Our Infinity Program empowers you to build your career with role-specific skill development, leveraging immersive learning platforms. You'll have the opportunity to showcase your talents by contributing to impactful projects.

Responsibilities:

• Design, Develop, and Maintain ETL Processes: Create and manage ETL workflows using Informatica PowerCenter, PowerExchange, 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.

Technical Skills:

• Proficiency in Informatica PowerCenter and other Informatica products.
• Strong SQL skills and experience with databases like DB2, Oracle and SQL Server
• Knowledge of data warehousing concepts and BI architecture.
• Knowledge of Insurance will be added advantage.
• Experience with UNIX/Linux scripting.
• Experience with scheduling tools - IBM workload scheduler
• 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.
• Ability to work independently and manage multiple tasks simultaneously.

About Value Momentum

Value Momentum is a leading solutions provider for the global property & casualty insurance industry, supported by deep domain and technology capabilities. We offer a comprehensive suite of advisory, development, implementation, and maintenance services across the entire P&C insurance value chain. This includes Underwriting, Claims, Distribution, and more, empowering insurers to stay ahead with sustained growth, high performance, and enhanced stakeholder value. Trusted by over 75 insurers, Value Momentum is one of the largest standalone insurance-focused solutions providers in the US insurance industry.

Our culture – Our fuel

At Value Momentum, we believe in making employees win by nurturing them from within, collaborating and looking out for each other.

• People first - Empower employees to succeed.
• Nurture leaders - Nurture from within.
• Enjoy wins – Recognize and celebrate wins.
• Collaboration – Foster a culture of collaboration and people-centricity.
• Diversity – Committed to diversity, equity, and inclusion.
• Fun – Create a fun and engaging work environment.
• Warm welcome – Provide a personalized onboarding experience.

Company Benefits

• Compensation - Competitive compensation package comparable to the best in the industry.
• Career Growth - Career development, comprehensive training & certification programs, and fast track growth for high potential associates.
• Benefits: Comprehensive health benefits and life insurance.

****