Faheem Mohammed E-mail: acn2v7@r.postjobfree.com
Informatica Developer Telephone: +1-647-***-****
Overview:
5+ Years of Total rich software services industry experience that spans Data Warehousing,
Managing client relations, Project delivery and hands on development gained by working with
Oracle, DB2 and SQL.
IT Experience in Data Loading, Analysis, Design, Development, and Coding by using Various
Technologies like Informatica Power Center and Oracle in Data Warehousing.
Development and Coding Experience on ETL processes by using Informatica Power Center
9x8.6.0 & Oracle 11g, Oracle 10g like PL/SQL Coding, Shell Scripting on UNIX Platform.
Extensive experience with Data Warehouse and BI methodologies and strong understanding of
Relational, Multi-Dimensional Database concepts and OLAP.
Experience working with different Databases like Oracle 11, Oracle10g, Oracle 9i/8i, SQL Server
2000/2005 and MS Access.
Hands-on experience in designing, tuning, and leveraging large data warehouses using RDBMS
databases like Oracle, SQL Server database applications and Data warehouse appliances.
Strong experience in designing/modeling and developing Business Intelligence solutions in
staging, populating Operational Data Store (ODS), Master Data Management (MDM), Metadata
Management, Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using
ETL tools, Informatica PowerCenter 8.x/7.x/6.x, PowerExchange 8.0,Data explorer, OLTP &
OLAP.
Experienced in Global Delivery Model and management of Onsite/Offshore teams.
Developed PL/SQL stored procedures, functions, packages, SQL queries, indexes, triggers and
materialized views.
Worked on Informatica Power Center Client Tools like Designer, Workflow Manager, Workflow
Monitor & Repository.
Extensive experience in extraction, transformation and loading of data directly from different
heterogeneous source and target systems like flat files, MS SQL, Oracle.
Extensively worked on Informatica Designer Components - Source analyzer, Transformations
Developer, Mapplet and Mapping Designer.
Hands on experience with complex mappings using varied transformation logics like
Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable
transformations.
Faheem Mohammed E-mail: acn2v7@r.postjobfree.com
Informatica Developer Telephone: +1-647-***-****
Developing ETL processes like Data Extraction, Transformation, and Loading using various
Versions like Informatica Power Center 9.1.0/ 8.6.0 and 7.1.1.
Strong knowledge in Informatica Architecture.
Extensively worked on Informatica Power Center Designer, Workflow Manager and Workflow
Monitor tools.
Strong Knowledge on ETL tool like Informatica and Clear understanding of Software
Development Life Cycle (SDLC) in Data Warehousing.
Have clear understanding of Data warehousing Concepts like BI, Star Schema, Snowflake
Schema, OLTP, OLAP, Staging Area and ODS.
Extensively worked on third party tool like TOAD, SQL*PLUS and PL/SQL Developer.
Good Knowledge on RDBMS Concepts in Oracle.
Ability to work with any Environment based on client requirement and Ability to interact with
Client regularly.
Ability to manage project issues and Risks, Deliver work on time with multiple, competing
priorities.
Ability to work in a team or individual and handling multiple tasks simultaneously and Ability to
pick up new skills quickly.
Good Analytical and strong Interpersonal skills and Excellent Communication Skills.
Technical Competencies:
ETL Tool : Informatica Power Center 9.1/8.x/7.x
Databases & Tools : Oracle 8i, 9i and 10g (SQL*Plus, PL/SQL with Stored Procedures) SQL Server
2005, DB2
Operating Systems : Windows 2007/2003/2000/NT/ XP. Linux, UNIX Shell Scripting.
Languages : PL/SQL, advanced SQL, Unix Shell Scripting.
Reporting tools : Cognos
Present Status:
Canada Permanent Resident
Work Experience:
Sr. Informatica Developer Symcor
June 2013 to Present
Faheem Mohammed E-mail: acn2v7@r.postjobfree.com
Informatica Developer Telephone: +1-647-***-****
Roles and Responsibilities:
• Worked closely with client in understanding the Business requirements, data analysis and deliver the
client expectation.
• Used Informatica PowerCenter 9.x and its all features extensively in migrating data from OLTP to
Enterprise Data warehouse.
• Worked with Business Analysis team in gathering the requirements and created Functional and ETL
specification documents. •
Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction,
business logic implementation & loading into targets.
• Extracted data from different sources like Oracle, flat files, XML and SQL Server loaded into DWH.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, and Sequence
Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure
transformations. •
Created sessions and batches for incremental load and schedule them to run daily.
• Developed mappings/Reusable Objects/Mapplets by using mapping designer, transformation developer
and Mapplet designer in Informatica PowerCenter 9.X
• Used Informatica PowerCenter 9.X for extraction, loading and transformation (ETL) of data in the data
warehouse.
• Handle slowly changing dimensions (Type I, Type II and Type III) based on the business requirements.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic
embedded in the mappings.
• Involved in creation of Folders, Users, Repositories and Deployment Groups using Repository
Manager.
• Involved in PL/SQL and UNIX Shell scripting for scheduling the sessions in Informatica.
• Involved in scheduling the Informatica workflows using Autosys.
• Migrated mappings, sessions, and workflows from development to testing and then to Production
environments.
• Involved in Performance tuning for sources, targets, mappings and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test
scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum
performance.
• Worked extensively with different caches such as Index cache, Data cache and Lookup cache (Static,
Dynamic, Persistence and Shared)
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports.
• involved in documentation for KT for the support team.
Environment: Informatica PowerCenter 9.1, Oracle 11i, Oracle SQL Developer, Windows, BO
ETL Developer
Aug 2011 to May 2013 Moneris
Description: The application is Customer Business Management, of a Company that keeps track of the
Assets, which are given to lease. The source system is capable of accepting request for Assets and
processes it, when there is an Exception then it is the Analyst duty to manually process that request. The
company want to keep track of what sort of exception are Raised, to reduce the number of exceptions so,
as to reduce the burden on analyst. This is implemented using tool like Informatica Power Center and
Oracle PL/SQL with SP then to load the Data Warehouse.
Roles:
Faheem Mohammed E-mail: acn2v7@r.postjobfree.com
Informatica Developer Telephone: +1-647-***-****
• Understanding the Customer Requirements and the Technical specifications Documents.
• Extraction of data from Different Sources like Oracle and Flat files.
• Extensively used Designer Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet
Designer and Transformation developer. •
Creation of Mappings using Different Transformations like Joiner, Filter, Router, Lookups (Connected &
unconnected) Transformations. •
Implemented Type I, Type II and Type III slowly changing Dimensions based on business requirements.
• Development and Testing, Performance Tuning of Mappings.
• Creation of Sessions & Batches to Schedule ETL Mappings.
• Preparation of Design Documents, Test Cases and Test Scripts
• Involved in PL/SQL Coding like Stored Procedures, Triggers and Packages
• Validating the Required data at the database level by using 3rd party tool like TOAD.
• Played an effective team member's role in the team of 6.
Environment: Informatica Power Center 9.1, Oracle 10 (SQL, PL/SQL), TOAD, VISIO
Informatica Developer
June 2009 to July 2011 Infosys
Roles:
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 9i) using
Informatica PowerCenter 7.1
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
Knowledge of Identifying Fact and Dimension tables.
• Created reusable transformations and mapplets and used them in mappings
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router,
Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Created Several Informatica Mappings to populate the data into dimension and fact tables.
• Involved in Performance tuning for sources, targets, mappings, and sessions.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test
scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum
performance.
• Automated the load process using UNIX shell scripts.
• Created sessions and batches for incremental load and schedule them to run daily.
• Implemented Type II slowly changing Dimension to maintain all historical information in Dimension
Tables.
• Investigated and fixed problems encountered in the production environment on a day to day basis.
• Actively involved in the production support and also transferred knowledge to the other team members.
• Co-ordinate between different teams across circle and organization to resolve release related issues.
Environment: Informatica Power Center 8.6, Oracle 9i, Oracle SQL Developer, Windows.