SUMMARY:

• More than 8 years of IT experience and wide range of experience in software development, Data Integration, Data Warehousing and Oracle Development.
• Experience working with different stakeholders including business analysts, data architects, report developers, QA testing and production teams.
• Strong experience in Extraction, transformation and loading (ETL) of data from various data sources into data warehouses and data marts using Informatica Power center tools - designer, workflow manager and workflow monitor.
• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets.
• Extensively worked on development of various ETL mappings in Informatica designer to load the data from various source systems into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Router, Java, Lookup, Sequence Generator, Filter, and Sorter.
• Experience in developing XML/XSD/XSLT as a part of Source XML files for Informatica
• Experience working in different phases of Data Warehouse Life Cycle including source system analysis, ETL design/development, project deployment, production support
• Experience in using HP Quality center for defect tracking and defect reporting.
• Experience testing ETLInformaticamappings and other ETL Processes (Data Warehouse Testing)
• Strong ability to analyze source systems and business requirements, identify and document business rules.
• Extensive knowledge of Dimensional Data Modeling like Star schema and snowflake schema.
• Very strong knowledge of Entity-relationship concept, facts and dimension tables and slowly changing dimensions.
• Experience working with high volume data sets from various sources like Oracle, SQL server, XML files and flat files.
• Experience implementing slowly changing dimensions according to business requirements.
• Experience in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informaticaby creating Explain Plan, SQL hints for query and indexing the required columns.
• Expertise in UNIX Shell Scripting and also automation of ETL processes using UNIX shell scripting.
• Experience working with Autosys for scheduling the workflows.
• Knowledge in developing reports using Business Intelligence tools like Business Objects.
• Experience working with cross - functional departments.
• Experience working in an onsite-offshore structure and effectively coordinating tasks between onsite and offshore teams.
• Experience working as a liaison between the business users and IT team.
• A highly motivated self-starter and a good team-player with excellent verbal and written communication skills including experience in presentation skills.
• Excellent analytical and logical skills with a good understanding at the conceptual level and possess strong interpersonal skills.

TECHNICAL SKILLS:

Tools: TOAD, SQL *Plus, SQL *Loader, Informatica Power Center 9.1/9.5, FileZilla

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin Data Modeller

Databases: Oracle 11g/12c

Languages: SQL, PL/SQL, Unix Shell Scripting

Web Technologies: HTML, XML, Java Script

Tools: SQL Plus, PL/SQL Developer, Toad, SQL* Loader, Putty, Telnet

Operating Systems: UNIX (Sun Solaris, AIX), Linux and Windows 7/XP.

Schedulers: Autosys, Control M

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets.
• Extensively worked on development of various ETL mappings in Informatica designer to load the data from various source systems into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Router, Java, Lookup, Sequence Generator, Filter, and Sorter.
• Experience in developing XML/XSD/XSLT as a part of Source XML files for Informatica
• Experience working in different phases of Data Warehouse Life Cycle including source system analysis, ETL design/development, project deployment, production support
• Experience in using HP Quality center for defect tracking and defect reporting.
• Experience testing ETLInformaticamappings and other ETL Processes (Data Warehouse Testing)
• Strong ability to analyze source systems and business requirements, identify and document business rules.
• Extensive knowledge of Dimensional Data Modeling like Star schema and snowflake schema.
• Very strong knowledge of Entity-relationship concept, facts and dimension tables and slowly changing dimensions.
• Experience working with high volume data sets from various sources like Oracle, SQL server, XML files and flat files.
• Experience implementing slowly changing dimensions according to business requirements.
• Experience in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informaticaby creating Explain Plan, SQL hints for query and indexing the required columns.
• Expertise in UNIX Shell Scripting and also automation of ETL processes using UNIX shell scripting.
• Experience working with Autosys for scheduling the workflows.