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 www.epro-tech.com
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 DescriptionJob 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
Qualifications
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 [email protected] OR you can reach me @ 732-283-0499 X 227
Skills Required
- 5 to 7 years hands-on experience designing, developing, and implementing end-to-end ETL solutions for Data Warehouse and Data Marts using Informatica 9.0+
- Extensive practical experience with Informatica ETL tool
- Experience with DB2 (mainframe) and DB2 UDB database management systems
- Strong PL/SQL skills for ETL processes
- Experience handling mainframe flat files in ETL processes
- Proven ability to provide technical leadership to ETL developers across design, development, testing, and certification
- Well-versed in data modeling: conceptual, logical, physical; 3NF and dimensional modeling (star, snowflake)
- Translate business requirements into functional and technical specifications
- End-to-end responsibility for ETL design, development, testing, and certification, including estimates for data profiling, ETLs, testing, and data certification tasks
- Insurance industry experience, especially Property and Casualty; insurance data model experience such as IAA and Accord
What We Do
EPRO Services, Inc. is a leading provider of superior waterproofing and contaminant protection systems designed to keep building structures dry and safe. Founded in 1993, the company specializes in building envelope protection, offering a comprehensive range of solutions including vapor intrusion mitigation, air barrier systems, and leak repair services for a variety of site conditions across the United States and Canada.
