Taniya Roy Email and Phone Number

• 10+ years of IT experience in DW & BI & involved in development, testing and implementation of end-to-end Data Warehouse systems using Teradata Utilities, Alteryx and Amazon Redshift. • Wide-ranging experience in system analysis, design, development, Testing and deployment of various Information Technology projects. • Involved in full lifecycle of various projects, including requirement gathering, system designing, application development, enhancement, deployment, maintenance and support.• Strong hands on experience using Teradata utilities (SQL, Bteq, Fast Load, Multiload, Fast Export, Tpump, TPT, Query Man),SQL queries,stored procedures,Macros and Unix Shell scripting.• Strong hands on experience in Alteryx ETL tool to develop mapping.• Strong hands on experience in Amazon Redshift. • Expertise in Query Analysing, performance tuning and testing and experienced in writing Unix shell scripts to support and automate the ETL process. Scheduled the Shell script through informatica workflow and tidal to kick off the batches.• Worked on Waterfall and Agile methodology. Experience in Logical and physical modelling using Erwin. • Sound knowledge of Data Warehousing concepts, ER Model & Dimensional modelling like star schema, snowflake schema and database architecture for OLTP and OLAP applications, Data analysis and ETL processes.• Experienced in Informatica Power Center.• Strong experience in creating database objects such as Tables, Views, Macro, Indexes, Cursor in Teradata.• Created Mapping documents and workflows and data dictionaries.• Involved in Unit Testing, Integration Testing and preparing system test script in Quality Center and HP ALM.• Very good understanding of Reporting tool like Microstaregy.• Sound Knowledge on Python scripting to automate the test cases.• Quick adaptability to new technologies and zeal to improve technical skills.• Good analytical, programming, problem solving and troubleshooting skills.