SUMMARY:

• Proficient in the development of projects using Informatica 10.0/9.x/8.x/7.x, Oracle, Teradata,Unix,Python and Tableau.
• Experience in all the phases of Data warehouse life cycle involving requirements gathering/analysis, design, development, validation & testing of Data warehouses using ETL, Data Modeling, & Reporting tools.
• Analyzing the client’s data using Tableau and Python and building the analytics frameworks for better managed flow of project and development activities
• Aid in developing style guide for development of Tableau visualizations, design of components, naming of items, data source creation and naming.
• Extensively worked with Teradata version V15.10 and used utilities like BTEQ, Fast Export, Fast Load, TPT, Multi Load to export and load data to/from different source systems including flat files.
• Good Knowledge of Teradata Architecture and proficient in performance analysis, partitioning and SQL query tuning using EXPLAIN PLAN and Run stats.
• Excellent Experience with different indexes (PI, SI, PPI (MLPPI, SLPPI)) and collect statistics.
• Experienced working on Teradata SET/MULTISET tables.
• Experience in handling Large volume data both in Oracle and Teradata and worked on performance Issues when needed.
• Experience in using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant.
• Strong Data warehousing ETL experience in Informatica power center client tools (Power center designer, workflow manager, workflow monitor & Repository Manager) and Power Exchange.
• Experience in designing dashboards with the use of visualization tools like Tableau.
• Restricting data for particular users with the help of User filters in Tableau.
• Good in data warehouse concepts/data warehouse architecture and best practices.
• Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in working with UNIX Shell scripts and Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, Cobol, Oracle, SQL Server and Teradata.
• Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using ER-Win.
• Good knowledge on Sales & Marketing, Telecom, Retail & Manufacturing, Banking & Finance, Insurance, and Health care domains.
• Discussed extensively with developers, data architecture team, Business Analysts before designing a model that can fulfill all business needs.
• Clarified client requirements, business needs and project objectives, at each level of project implementation.
• Created and executed Test Plan, Test Scripts and Test Cases based on Design document and User Requirement document for testing purposes.
• Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance.
• Worked on various Scheduling tools like Auto Sys, Control-M, Tidal.
• Experienced in creating metadata entries for frame work tables.
• Excellent communication and interpersonal skills, good analytical reasoning and ability to learn quickly, high adaptability to new technologies and tools.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Experienced working on Teradata SET/MULTISET tables.
• Experience in handling Large volume data both in Oracle and Teradata and worked on performance Issues when needed.
• Experience in using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant.
• Strong Data warehousing ETL experience in Informatica power center client tools (Power center designer, workflow manager, workflow monitor & Repository Manager) and Power Exchange.
• Experience in designing dashboards with the use of visualization tools like Tableau.
• Restricting data for particular users with the help of User filters in Tableau.
• Good in data warehouse concepts/data warehouse architecture and best practices.
• Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in working with UNIX Shell scripts and Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, Cobol, Oracle, SQL Server and Teradata.
• Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using ER-Win.
• Good knowledge on Sales & Marketing, Telecom, Retail & Manufacturing, Banking & Finance, Insurance, and Health care domains.
• Discussed extensively with developers, data architecture team, Business Analysts before designing a model that can fulfill all business needs.
• Clarified client requirements, business needs and project objectives, at each level of project implementation.
• Created and executed Test Plan, Test Scripts and Test Cases based on Design document and User Requirement document for testing purposes.
• Excellent knowledge of software development life cycle activities including analysis, design, development, unit testing, regression testing, production deployment and Maintenance.
• Worked on various Scheduling tools like Auto Sys, Control-M, Tidal.
• Experienced in creating metadata entries for frame work tables.