@ 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
• 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