DBA/ETL Consultant

Procom is a leading provider of professional IT services and staffing to businesses and governments in Canada. With revenues over $500 million, the Branham Group has recognized Procom as the 3rd largest professional services firm in Canada and is now the largest “Canadian-Owned” IT staffing/consulting company. Procom’s Areas of Staffing Expertise Application Development Project Management Quality Assurance Business/Systems Analysis Datawarehouse & Business Intelligence Infrastructure & Network Services Risk Management & Compliance Business Continuity & Disaster Recovery Security & Privacy SpecialtiesContract Staffing (Staff Augmentation) Permanent Placement (Staff Augmentation)ICAP (Contractor Payroll) Flextrack (Vendor Management System)

Load Monitoring - Monitoring the loads (workflows) whether the loads are scheduled to respective timings. Recovery or Re-start in loads in case of any failures. Identifying the tardiness in loading process in case of any sessions are in hung status. Mandatory Skills Minimum of 4 years of overall IT experience 2 years prior experience focused in ETL design, development, review, and testing 2 years professional experience in Data Integration/Data warehouse environments 4 years of experience with Informatica PowerCenter 2 years professional development experience in SQL Server 2005, 2008 or 2012 Development experience in transforming XML messages and understanding of XML schemas Integration experience with source code repositories (Subversion, Team Foundation Server).Experience working with offshore resources Experience working with vendors More than 2 years of experience in data warehouse/mart environments Experience building/implementing scalable, reliable, and high-performance ETL architectures Understanding of modern software engineering principles, practices, and systems development methodologies Excellent ETL design skills and hands‑on experience in developing ETL mappings Hands‑on experience in Informatica administration work Demonstrated experience in optimizing/troubleshooting poorly performing ETL mappings Working experience with insurance industry is a plus Professional experience with SAP Data Integrator as a designer and developer is a plus Strong Knowledge of the data governance and data management concepts and practices Strong Knowledge of the concepts, and best practices for ETL development High proficiency in understanding relational data models Advanced knowledge of XML, XSLT.Strong knowledge of Unit testing frameworks and SOAPUIASAP12 months