ETL Architect

Job Title  : ETL Lead Designer and Developer

Location  : Grand Rapids, MI

Job Type :  Full Time

 

Job Description:

 

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.
  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

 

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

If you are interested, please send across your resume to gpoorani@epro-consulting.com OR you can reach me @ 732-283-0499 X 227