| Position Details |
Job order - J0123-2988 - Permanent Full Time
|
| Title |
Informatica Developer |
| Category |
Software Development/ Engineering |
| City |
Halifax, Nova Scotia, Canada |
|
| Job Description |
Informatica Developer
Position Description
We offer the opportunity to work with Canada’s largest Information Technology Outsourcing and Management Consulting Company with a true global presence in a fast-paced and energetic atmosphere where your personal and professional growth is accelerated by your desire and sense of commitment. CGI’s continuous growth is a testament to the confidence clients place in them and to the dedication of their professionals. At CGI, all employees are called members because they feel a powerful sense of ownership and accountability. Members at CGI are building their own company – in 100+ offices worldwide. CGI has the global resources, expertise, stability and dedicated professionals needed to achieve results for clients – and for members; that’s why an astounding 90 percent of them are CGI shareholders.
We're expanding in Atlantic Canada and we need your skills, enthusiasm, and dedication as part of our team.
Your future duties and responsibilities
Leadership
• 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
Required qualifications to be successful in this role
Must-have 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)
Nice-to-have 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
#LI-ST3
Insights you can act on
While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.
When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees "members" because they are CGI shareholders and owners and owners who enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today — one of the world’s largest independent providers of IT and business consulting services.
At CGI, we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.
Ready to become part of our success story? Join CGI — where your ideas and actions make a difference.
|
|
| Skills |
|
|
| Reference |
1032841 |
|
|
Click here to apply
|
|
|
|