ETL &ndash BI Reporting Specialist (IBM DataStage EIW Datamarts (Montreal)

ETL &ndash BI Reporting Specialist (IBM DataStage EIW Datamarts

The start date of this job is flexible and in order to find the best candidate the job may remain open much longer than the date mentioned on this posting .. or you may be asked to start sooner than the expected start date if you are able to do so URGENT Please read the job description below. If this interests you please send a MS-Word version copy of your updated resume (ASAP) along with your salary expectations first available date and a telephone contact number E-mail to prachi(at)teamrecruiter.com Please mention the job title above in the subject line The recruiter in charge of this role is Prachi AFTER you have submitted your resume via e-mail (when you have a moment) please apply online to match your resume to the job with following link s www.stafftrak.net ApplyOnline teamrecruiter.web tt JD& jobId 011946 If you do not think you are a match for this opportunity but know someone who is feel free to forward this email to them and you will be eligible for a referral bonus upon a successful hire. One of our Insurance clients is looking for ETL BI Reporting Specialist (IBM DataStage EIW Datamarts Mainframe Scripting) Length Contract term is 6 months with possible extension. Location Downtown Toronto Resource Profile Two (2) ETL Developers will focus on making sure that all ETL - Datastage batches have completed before start of Business in the morning. The roles will be available for maintaining the ETL environments by monitoring their performance to ensure functionality integrity and security of the environments and compliance with ITC information security and change management processes. Providing technical assistance advice and guidance in response to enquiries on the functionality of BI ETL tools and data in EIW and related datamarts to ensure efficient and uninterrupted IM services to business users with primary focus on data fixes existing and new (inclusive) MUST HAVE 8 Years of experience in designing developing testing and implementing ETL solutions using IBM DataStage 8.1 8 4 Expertise in RDBMS Data Mart and Data Warehouse design. Knowledge of data modeling Experience working with high volume data exchange and transaction processing systems preferably in a custom software development environment Strong understanding of ETL best practices 5 years of solid experience in COBOL JCL DB2 SAS VSAM CICS & CA7 Experience writing well documented unit tests and executing them 5 years working knowledge of scripting languages like Korn Bash Shell scripting Experience of reverse-engineering data mappings based on application-layer code highly desirable Ability to express complex technical concepts effectively both verbally and in writing Strong understanding of SDLC and Agile Methodologies Degree in computer science math engineering or equivalent work experience 3 Experience working with IBM Cognos BI tools Resource Responsibilities Provide support for Enterprise Warehouse operations (e.g. monthly update of EIW and datamarts EDW and IM Catalogue related systems to ensure the delivery of timely accurate and reliable data to business users. This includes monitoring the update processes updating maintaining the appropriate system documentation identifying potential problems and implementing solutions to ensure the efficiency and reliability of the IM operations. Maintain the ETL environments by monitoring their performance to ensure functionality integrity and security of the environments and compliance with BTS information security and change management processes. Identify and troubleshoot problems as they arise which may involve interacting with other areas within BTS for resolution. Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance. Provide technical assistance advice and guidance to Business Technology Services (BTS) staff and business users in response to enquiries on the functionality of BI ETL tools and data in EIW and related datamarts to ensure efficient and un-interrupted IM services to the business users. Candidate should be conversant with ETL methodologies and job design with a sound knowledge and experience of integrating input jobs from disparate systems and be able to maintain the Boards standard of ETL best practices Responsibilities including monitoring all batch flow processing and insure timely completion of endpoints milestones. Identify delays or bottlenecks using proprietary and vendor tools and resolve or escalate accordingly. Be proactive and check to make sure all daily and monthly runs work smoothly. Perform level 1 and level 2 support and resolution for all batch abends and document what was done to resolve. Lead and perform enterprise scheduler schedule updates Track incoming and outgoing transmissions ensuring they meet deadlines escalating to appropriate vendors and Datacenter management when necessary. Monitor real time performance of the computing environment utilizing automated solutions 3rd party monitoring software and in-house proprietary tools. Perform and verify system configuration changes as specified during weekend maintenance shutdown periods. Respond to all hardware faults or failures requiring escalation and support from outside vendors. Work with vendors toward resolving these incidents. Report them via incident management process. Respond to all console messages and alerts requiring intervention and action. Track and document all outages and incidents which adversely impact the environment Candidate must have experience in Mainframe batch environment and CAD environment knowledge of support operations best practices and processes Provide application teams with support on problem determination and resolution of scheduling issues. Creates reports and presentation materials related to scheduling. Documents all aspects of the batch schedule. Ensure Service Level Agreements are met for applications supported. Follow up on production control issues from daily change requests. Ensure daily scheduling requests are completed accurately and on time. Support Disaster Recovery tests Familiarity in managing within a compliance framework. Please fill the skill matrix below Required Skills Years of Experience Describe the experience 5 years experience in IBM Mainframe SAS programming JCL UNIX and ETL data warehousing concepts 4 years experience with SQL and SQL Scripting 8 years experience with IBM Infosphere DataStage version 8.5 or 8.7 4 years experience with DB2 UDB Mainframe DB2 MS SQL Server Oracle Databases 3 years experience working with IBM Cognos BI tools 4 years experience profiling various information systems capture source target mappings and transformations based on project requirements Excellent communication skills (both written and verbal) Please note that this is the most up to date version of job description available at this time During Client Interview you will receive additional information variance may apply When you have some time please register in our database (5 minute process) to be considered for future openings the link is available on our website at www.teamrecruiter.com in the Candidate section. We thank all applicants for their interest. Only those who meet the qualifications will be contacted through telephone email. You are encouraged to register with us in our database to be considered for future positions available. Have a great day. ......At Teamrecruiter.com we offer some of the most highly qualified professionals in the workforce. We dedicate an industry trained recruitment specialist to the following areas IT Finance Admin Sales Executive Search and Contractors. If you would like to learn more about our full-service recruiting firm please visit our website at www.teamrecruiter.com. CAMSC and ACSESS certified ..All Offers are conditional on Client Post-Offer Conditions being met and removed by end client prior to written offer signing