Tejasri Reddy Email & Phone Number

Mckinney, TX, US

Houston, Texas, United States

• Involved in building the ETL datapipelines and Source to Target mapping to load, transform, cleanse data into snowflake Data warehouse.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Developed an ETL Informatica mappings in order to load data into staging area. Extracted data from Mainframe files, flat files, SQL Server and loaded into Oracle 11g target database.
• Designed ETL process using Talend Tool to load from Sources to Targets through data Transformations.
• Worked on tFileInputPositional, tFlowToIterate, tMap, tFilterRow, tUniqueRow components to validate, extract and convert the data from the positional file.
• Created Informatica Slowly Changing Dimensions SCD I, II&III Mappings using Informatica Designer.

Mclean, Virginia, United States

• Based on the requirement for knowing type of feed, source file format, business and transformations rules required for the process.
• Hands-on experience on Hortonworks Hadoop Distributed File System (HDFS) including MapReduce, HBase, PySpark, Spark Streaming API, Apache Storm and Hive, along with hands on experience in Microsoft Azure such as.
• Handled importing of data in Talend from various data sources, performed transformations using Hive, Pig and Spark and loaded data into HDFS.
• Developed jobs with bigdata components like HDFS and HIVE components to capture raw data into Hadoop system.
• Created Hive tables, partitions and implemented incremental imports to perform ad-hoc queries on structured data.
• Generated server side PL/ SQL scripts for data manipulation, validation and materialized views for remote instances

Irving, Texas, United States

• Parsing the JSON data using the Snowpipe to load data into a variant table in snowflake.
• Created Streams and Tasks to populate JSON data into a Flat tables in snowflake
• Migrated the existing stored procedures into a java bases Snowflake stored procedures.
• Data Analysis and Documentation, Participate in PRD reviews business impacts, feedback and final approvals.
• Collaboration and Communication in an Agile Scrum development environment.
• PL/SQL, SQL Tuning and Optimization of current and existing applications.

Hyderabad, Telangana, India

• Migrated the on-Premises RDBMS to Amazon RDS
• Migrated the on-Premises Big Data to AWS.
• Utilized Jaspersoft for creating interactive and visually appealing reports and dashboards, enabling stakeholders to derive actionable insights from data analysis.
• Strong AWS knowledge on S3, EMR, ECS, EC2, Glue, Lambda, IAM, Kafka, RDS, Route 53, VPC, Code build, Code pipeline, Cloud watch and Cloud formation.
• Adequate knowledge in Hadoop Ecosystem and its major components and Pyspark, Presto, Airflow, Hive, Ranger and Zeppelin.
• Designed, built, and maintained data integration programs in a Hadoop and RDBMS environment, working with both traditional and non-traditional source systems, as well as RDBMS and NoSQL data stores for data access and.