Sensiple
InsuranceDirect SmartRecruiters career site

ETL Architect

Location
Grand Rapids, MI · On-site
Job type
Full-time
Level
Lead / Staff
Experience
5+ years
Listed
Yesterday

Skills & highlights for this role

  • Informatica PowerCenter 9.0+
  • DB2 UDB
  • PL/SQL
  • data modeling (3NF and dimensional)

Also useful

  • Insurance data models (IAA, ACORD)
  • mainframe flat files
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Sensiple role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

About the role

  • Job Title: ETL Lead Designer and Developer
  • Location: Grand Rapids, MI
  • Job Type: Full Time

Roles and Responsibilities

  • 5 to 7 years of hands-on experience in design, development, and implementation of end-to-end ETL solutions for Data Warehouse and Data Marts using Informatica version 9.0 or above.

Provides Technical Leadership to ETL Developers during Design and Development, Testing and Certification.

  • Well versed with data modeling (i.e., conceptual, logical and physical design – with both traditional 3rd normal form as well as dimensional modeling (star, snowflake).
  • Translates business requirements into functional and technical specifications to enable and shape the design and development process.
  • Responsible for end to end ETL design, development, testing, and certification constructs.

Additional information

Provides detailed estimates for all deliverables related to Data Profiling, ETLs, Testing, and Data Certification tasks.

  • Works with BI Architect/Project Manager to ensure the on-time and under/within budget delivery of work products.
  • Seeks for opportunities to reuse, share, consolidate and leverage existing data architectures.
  • The position assumes technical leadership as well as hands-on contribution to design, development, testing, validation, performance tuning and quality assurance activities related to data sourcing, staging, loading, cleansing, transformation, and it’s integration.

Ensures high data quality and appropriate data integrity throughout the project life cycle

Qualifications & Requirements

Technical/Functional Skills

  • Insurance industry experience, especially in Property and Casualty domain, is heavily preferred.

Insurance data model experience, such as IAA and Accord.

  • Strong knowledge and extensive practical experience with Informatica ETL tool, DB2 (mainframe) and DB2 UDB database management systems, PL/SQL, and handling flat files (mainframe) with respect to ETL processes

About the Company

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs.

We have been retained for providing recruiting assistance, for direct hires, by one of the world-leading information technology consulting, services, and business process outsourcing organization that envisioned and pioneered the adoption of the flexible global business practices that today enable companies to operate more efficiently and produce more value.

Additional Information:

Read the original posting

From Sensiple's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this ETL Architect role at Sensiple, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the ETL Architect job at Sensiple located?

This ETL Architect position at Sensiple is located in Grand Rapids, MI (On-site). Always check Sensiple's application page for specific state eligibility or relocation policies.

What qualifications are required for ETL Architect at Sensiple?

For the ETL Architect role, Sensiple highlights 5+ years of relevant experience; experience with Informatica PowerCenter 9.0+, DB2 UDB, PL/SQL, data modeling (3NF and dimensional). Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the ETL Architect position at Sensiple?

This listing links directly to Sensiple's SmartRecruiters application page. You can apply directly on Sensiple's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.