Informatica Developer

Back

Informatica Developer

@ CGI

• Analysis skills: Analyzing Data feeds and interfaces from a wide variety of systems

• Designing development schema for data feed development, ETL feeds

• Work with large Market Data Feeds and Heterogeneous Source Systems like Oracle, SQL Server and Flat Files.

• Review Dimensional Data modeling, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.

• Test and debug all ETL and Oracle objects to evaluate the performance.

• Ability to work within a changing environment


Qualifications:

• Technical Diploma in IT with Equivalent Experience

• Oracle Certification (Optional)

• Minimum 3-5 years of experience in Oracle 10g or higher is required

• Minimum 3-5 years of experience in Informatica Power Center is required

• Highly skilled in Oracle SQL, PL/SQL, SQL Plus, development of Stored procedures, Triggers, PL/SQL packages

• Expertise in writing technical designs, developing, unit testing, and break fix support of ETL and PL/SQL objects

• Familiarity with the user of version control tools (such as Subversion, Dimensions)

• Skilled in performance tuning, analyzing query plans and query tuning, partitioning

• Fast learner, able to diagnose technical challenges through reading code and supporting technical documentation

• Team player with the ability to communicate effectively (verbally and written) at all levels of the SDLC

Nice to Have Skills and Experience:

• Experience with Oracle database support and development (PL/SQL) Oracle 10g

• Writing and triaging stored procedures

• Experience in working with TIDAL enterprise scheduler

Soft Skills:

• Very well organized and detail orientated and able to multitask effectively

• Have excellent time management, task planning and prioritization skills

• Able to adapt quickly to changing project requirements

• Possesses excellent written and oral communication skills

• Fast-paced office environment handling multiple demands. Must be able to exercise appropriate judgment as necessary

• Requires that the individual be well organized while being readily adaptable to changes in work assignments

• Good presentation skills

• Positive attitude and team focus are required

Tool and Technology:

• ETL tools - Informatica Power center, Informatica Power Exchange

• Database – Oracle, MS SQL Server

• Tools – MS Visio, Toad, SVN, TIDAL

• Modelling tools - ER/Studio or similar tool

Minimum Education Required- Technical Diploma in IT with equivalent experience


How to Apply:

Apply online at https://www.cgi.com/en/careers

Visit Site to Apply

Location: Lafayette, LA
Date Posted: December 21, 2020
Application Deadline: April 19, 2021