Informatica ETL Engineer
Full Time
Occasional Travel Required
Hybrid
Depends on Experience
Voto Consulting LLC
Fitment
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- ETL Architecture
- PL/SQL
- Informatica
- Extract, Transform, Load
- Database Administration
- Root Cause Analysis
- Informatica PowerCenter
Summary
Local to MA Only
Job Title: Informatica ETL Engineer
Location: Worcester, MA
Duration: 6-12 Months
Visa: No H1b/OPT
Local Only
Job Description
- We are seeking an experienced Informatica ETL contractor to partner with our Claims Business unit. In this role, you will act as a core technical problem-solver—evaluating operational challenges, auditing legacy data workflows, and designing robust, modern ETL frameworks.
- You will work closely with our database team and provide heavy production support to ensure high data reliability. Prior experience in the P&C Insurance industry is not required; we are prioritizing strong core technical skills in Informatica PowerCenter and Oracle, a dedicated support mindset, and outstanding communication skills.
Key Responsibilities
- Problem Analysis & Solution Design
- Deep dive into existing data workflows within the Claims business area to identify performance bottlenecks, operational pain points, and systemic errors.
- Propose, design, and implement end-to-end technical solutions to improve overall system efficiency and business capabilities.
ETL Architecture & Framework Development
- Audit and research current ETL processes to recommend operational improvements and architectural changes.
- Design, build, and deploy flexible, scalable, and reusable ETL frameworks.
- Collaboration & Production Support
- Work hand-in-hand with the Database Engineering/DBA teams to align data models, optimize SQL queries, and streamline deployments.
- Provide comprehensive, hands-on production support, root-cause analysis, and performance tuning for critical ETL data pipelines.
Required Skills & Qualifications
Technical Stack & Experience
- Informatica: Advanced expertise in Informatica (PowerCenter and/or IICS) for building, managing, and troubleshooting data pipelines.
- Oracle: Strong knowledge of Oracle databases, including complex SQL querying, PL/SQL, and query performance optimization.
- Support Expertise: Extensive, proven experience in production support, incident management, and system maintenance.
- ETL Frameworks: Demonstrated background in auditing legacy ETL flows and designing new, scalable framework patterns.
Soft Skills & Soft Requirements
- Communication: Exceptional written and verbal communication skills; ability to articulate technical issues clearly to business stakeholders.
- Interpersonal Savvy: Strong cross-functional collaboration skills, particularly when partnering with database teams and business leads.
- Domain Experience: No Insurance experience required. We welcome candidates from any industry background who bring strong ETL engineering and support skills.
Job Responsibilities
- Problem Analysis & Solution Design
- Deep dive into existing data workflows within the Claims business area to identify performance bottlenecks, operational pain points, and systemic errors.
- Propose, design, and implement end-to-end technical solutions to improve overall system efficiency and business capabilities.
- ETL Architecture & Framework Development
- Audit and research current ETL processes to recommend operational improvements and architectural changes.
- Design, build, and deploy flexible, scalable, and reusable ETL frameworks.
- Collaboration & Production Support
- Work hand-in-hand with the Database Engineering/DBA teams to align data models, optimize SQL queries, and streamline deployments.
- Provide comprehensive, hands-on production support, root-cause analysis, and performance tuning for critical ETL data pipelines.
Thanks & Regards.
Aviral Sapra
Voto Consulting LLC
Direct #:
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 91014022
- Position Id: 9066031
- Posted 3 hours ago
Company Info
About Voto Consulting LLC
Who we are & What we do
Voto is new era technology enabler which aims to revolutionize digital transformation for enterprises and technology providers by delivering seamless customer experiences, business efficiency and actionable insights. We do this by leveraging a spectrum of disruptive technologies such as: artificial intelligence, blockchain, cloud, digital process automation, internet of things, robotics/drones, security, virtual/augmented reality, etc,
Agility is in our DNA that enhances our capabilities span digital solutions, infrastructure, product engineering and security. We deliver these services across industry sectors such as automotive, BFSI, consumer packaged goods, e-commerce, Edu-Tech, engineering R&D, hi-tech, manufacturing, retail, and travel/transportation/hospitality.
Agility is in our DNA that enhances our capabilities span digital solutions, infrastructure, product engineering and security. We deliver these services across industry sectors such as automotive, BFSI, consumer packaged goods, e-commerce, Edu-Tech, engineering R&D, hi-tech, manufacturing, retail, and travel/transportation/hospitality.
Recognized as one of the fastest-growing IT services firms globally, Voto is delivering solutions across North America, Europe, Middle East, and APAC countries.
Voto Consulting LLC is currently accepting resumes for a variety of positions. Please review the database of positions that we are seeking to fill and contact us for additional information about any specific opportunity.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs