ETL Architect

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. For more details please visit our website

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.

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