T

Tejasri Pannala

About

Detail

Data Engineer/ETL Developer
Plano, Texas, United States

Contact Tejasri regarding: 
work
Full-time jobs

Timeline


work
Job
school
Education

Résumé


Jobs verified_user 0% verified
  • A
    Data Engineer/ETL Developer
    AIG Insurance
    Jun 2021 - Nov 2023 (2 years 6 months)
    Responsibilities
    • Involved in building the ETL architecture 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.
    • Develop 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.
    • Created Informatica Slowly Changing Dimensions SCD I, II&III Mappings using Informatica
    Designer.
    • Performance tuning concepts using Informatica Partitionin
  • F
    Data Engineer /ETL Developer
    Freddie Mac McLean
    Feb 2019 - Jun 2021 (2 years 5 months)
    Responsibilities
    • 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 Databricks, Cosmos DB & Data Lakes store with
    Apache Spark.
    • 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.
    • Designed partial restart a
  • Verizon
    Data engineer/ETL Developer
    Verizon
    May 2018 - Feb 2019 (10 months)
    Responsibilities
    • 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.
    • Collaborate with the business analysts to discuss issues in interpreting the
    requirements.
    • Perform Integration and System testing, and coordinate with
  • Polaris
    Data Engineer
    Polaris
    Jul 2016 - Feb 2018 (1 year 8 months)
    Responsibilities
    • Migrated the on-Premises RDBMS to Amazon RDS
    • Migrated the on-Premises Big Data to AWS.
    • Support the business development lifecycle (Business Development, Capture, Solution Architect and Pricing).
    • 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 an
Education verified_user 0% verified
  • Jntuh
    Bachelor of Science in Computer Science
    Jntuh
    Aug 2012 - Jun 2016 (3 years 11 months)