Keywords
Extract Transform Load (ETL)
Data Warehousing
Workflows
Analytical Thinking
Banking Services
Relational Databases
Functional Design
Problem Solving
Oracle Applications
Project Management Life Cycle
Skills
• Over all 5+ years of experience in Data warehousing by using Informatica.
• ETL Concepts to load data from different sources into data warehouse using Informatica Power Center.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Sorter and Sequence Generator.
• Extensively worked with Slowly Changing Dimensions
• Efficacy in relational database systems like Oracle.
• Good understanding Data Warehousing Concepts such as Star Schema and Dimension Table
• Designing and developing Workflows, Sessions and other tasks using Work flow manager tools.
• Involved in functional study of the application.
• Running the jobs/Workflows for ETL process.
• Prepared and run sql queries to verify Dimensional and Fact tables data.
• Verified column mapping between source and target
A leader with strong analytical, logical and problem-solving skills
• Well acquainted with Software Development Life Cycle.
• Good knowledge in all areas of a project lifecycle like analysis, design, coding, testing and documentation.
• Reviewing the functional specifications and Requirements documents.
• Have domain knowledge in Banking and Retail market.
• ETL Concepts to load data from different sources into data warehouse using Informatica Power Center.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Sorter and Sequence Generator.
• Extensively worked with Slowly Changing Dimensions
• Efficacy in relational database systems like Oracle.
• Good understanding Data Warehousing Concepts such as Star Schema and Dimension Table
• Designing and developing Workflows, Sessions and other tasks using Work flow manager tools.
• Involved in functional study of the application.
• Running the jobs/Workflows for ETL process.
• Prepared and run sql queries to verify Dimensional and Fact tables data.
• Verified column mapping between source and target
A leader with strong analytical, logical and problem-solving skills
• Well acquainted with Software Development Life Cycle.
• Good knowledge in all areas of a project lifecycle like analysis, design, coding, testing and documentation.
• Reviewing the functional specifications and Requirements documents.
• Have domain knowledge in Banking and Retail market.
Project history
Project Title : Sea Bird Data Warehouse.
Client : Sea Bird Shipping Agency
Environment : Informatica,Sybase, Pl/Sql, Shell script, Oracle 10g
Designation : Consultant
Domain : Logistic
Duration : Mar 2017 to till date
Description : SeaBIRd Data warehouse and BI solution. SeaBIRd is to become single source of information for all the reports that are used across different functional areas.
Responsibilities: Design, develop, analyze and implement Oracle, ETL.
Client : Sea Bird Shipping Agency
Environment : Informatica,Sybase, Pl/Sql, Shell script, Oracle 10g
Designation : Consultant
Domain : Logistic
Duration : Mar 2017 to till date
Description : SeaBIRd Data warehouse and BI solution. SeaBIRd is to become single source of information for all the reports that are used across different functional areas.
Responsibilities: Design, develop, analyze and implement Oracle, ETL.
- Assist team members with questions and decision making
- Write implementation, instructions and integration tests for applications
- Develop database procedures and packages
- Optimize the existing jobs using SQL/PL-SQL tuning methodologies
- Business Requirements gathering and analysis provided by the client, preparation of functional specifications and design documents.
- Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
- Created Informatica mappings, sessions and workflows to load the data.
- Created relational tables at the data base level for ODS and staging area.
- Involved in source to target count testing, source to target data testing, data mapping or transformation testing, data complete testing using minus query.
- Involved in functional study of the application.
- Running the jobs/Workflows for ETL process.
- Prepared and ran sql queries to verify Dimensional and Fact tab les.
- Verified column mapping between source and target
Local Availability
Only available in these countries:
India
Currently I am living in baneglure india , I can travel anywhere on demand
