Zylog delivers top jobs to top talent. We are currently seeking experienced professionals for exciting new opportunities and career advancement.
Zylog represents hundreds of client companies for both contract and permanent positions. New jobs are being filled every day and our experienced professional resource managers are waiting to help you screen the top jobs that match your skills and experience.
You don’t have time to search long lists of postings repeated on multiple web sites, so let our trained and experienced resource managers do the work for you. We review top jobs and will be the first to alert you when the right opportunity arises.
Job Description
Our client has a requirement for a Senior Informatica Developer for 3 months contract. The position is located in Halifax.
What makes this Special
Our client has a prestigious reputation and excellent work environment. This position offers an opportunity for personal learning and to contribute to important initiatives that make a difference. Our client is actively screening resumes and scheduling interviews to fill this position, so let one our professional resource managers represent you to the client, promote your skills, and help you prepare.
Responsibilities
Leadership:
- Provide technical leadership through Informatica Power Center ETL design & development for ODS and Enterprise Data Warehouse
- Provide recommendations for re-usable design patterns
- Provide input & vision to ETL development standards and guidelines
- Lead teams of technical staff (Oracle and Informatica) for ETL architecture, design, development, unit testing, deployment and short-term warranty support
- Lead by example
- Demonstrate a positive attitude and team focus
- Share knowledge and expertise with team
Consulting & Communication:
- Provide senior level consulting and advisory services to clients as subject matter expert for Informatica Power Center ETL and team delivery
- Provide analysis and recommendations for ETL implementation
- Take part in Design Brainstorm & design approval process
- Generate estimates for ODS & Warehouse ETL activities
- Strong organizational and written/verbal communication skills
- Excellent presentation skills
- Escalate and mitigate risk & issues
Technical Strength:
- Informatica design & development
- Design & develop highly efficient/high performance ETL mappings/workflows
- Implement industry best practices (e.g. Velocity methodology)
- Strong working knowledge of Oracle DDL / DML and performance tuning strategies
- Comfortable working in a fast paced, changing environment
Data Warehousing:
- Extensive hands-on experience with design, development and deployment of Informatica ETL’s to/from data warehouse environments
- Experience with data warehousing best practices
- Strong performance tuning experience
- Type 2 dimension loading experience
Mandatory Skills
- Minimum 5 years experience with Informatica Power Center 8.x/9.x
- Minimum 5 years experience with Oracle 10g or higher
- Experience with Oracle SQL (DML & DDL), PL/SQL, packages, stored procedures, triggers
- Expertise in reviewing business requirements, technical requirements documentation
- Expertise in writing high and low level design documentation
- Experience in writing re-usable unit test documents
- Extensive experience with developing, unit testing, break/fix support of Informatica ETL
- Skilled in performance tuning, query plan / explain plan analysis, indexing, table partitioning
- Excellent communication skills, both verbal and written
- Experience leading technical teams
- Familiarity with use of version control / source code management tools (CVS, Dimensions, etc.)
- Full SDLC experience
- Well organized, detail oriented, ability to multi-task
- Excellent time-management, planning and prioritization
- Comfortable working with all project stakeholders (business users, architects, project managers, business analysts, developers, test analysts, production support team)
- Bachelors Degree in Computer Science or Diploma in IT with equivalent IT experience
Desirable Skills
- Informatica Power Exchange (for CDC, multi-format records)
- Project management skills
- Experience working with Agile methodology
- Data modeling & star schema data warehouse design
- Experience with HP-ILM (previously known as Quality Center/Test Director)
- Linux / Unix scripting
- Tidal Enterprise Scheduler knowledge
Keywords: Informatica, ETL, MDM, Oracle, SQL, Architect
How to Apply
Online:
To apply for this and other suitable exciting opportunities with Zylog Systems (Canada) Ltd., you can register and apply online at www.ZylogCanada.com
No comments:
Post a Comment