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
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:
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.
Similar roles
- Sr Application Analyst Health Data Science Analytics Information Technology Houston Methodist Academic InstituteHouston Methodist · United States
- Analytics Engineer IIISutter Health · Sacramento, CA
- Data ArchitectAmerican Eagle Outfitters · Pittsburgh, PA
- Sr. Data Enterprise EngineerBJC HealthCare · Saint Louis, MO
- Mid-Level/Lead DA Engineer (GRAPH DATABASE ENGINEER): HYBRIDState Farm · Bloomington, IL
- Application Architect-RDBMSIBM · Herndon
More at Sensiple
All Sensiple jobsCommon 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.