Venkata “Teja” Jandhyala

ETL Developer

Teja has over 6 years of IT experience in analysis, design, development and implementation of Data warehouses, data marts and Decision Support Systems (DSS) using Informatica Power Center with Oracle, MS SQL server and DB2. Teja has strong data processing experience in designing and implementing Data Warehouse and Data Mart applications, mainly Transformation processes using ETL tool Informatica Power Center, and UNIX Shell Scripting. Teja has experience in SQL & PL/SQL in developing & executing Stored Procedures, Functions, Triggers and tuning on queries while extracting and loading data. He has experience working in an Agile environment and his latest project was also in the insurance industry.

Proficient level working with Informatica PowerCenter Methodology. Hands on experience identifying the most critical information within organization and creation of a single source of its truth to power business processes.

Extensively work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.

Proficiency in data warehousing techniques for data cleansing, slowly changing dimensions types (1, 2 and 3)

Monitoring actively Informatica job runs.

Experience in Performance Tuning and Debugging of existing ETL processes.

Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/projects.

Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.

Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.

Extensive experience and knowledge of the project lifecycle, including requirements gathering, development and execution.

Coordinated offshore efforts and day-to-day activities,

Expertise in Data Modeling using Star Schema/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling using ERWIN 4.x/3. x.

Experience in documenting High Level Design, Low level Design, STM's, Unit test plan, Unit test cases and Deployment documents.

Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.

Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.

ETL Tools

Informatics Power Center 10.1,9.6/9.1/8.6/8.1/, Siberian/Informatics 10.0/9.1

Reporting Tools

OBIEE, BI- Framework manager, Query studio, Report studio

Programming Languages

SQL, PL/SQL, HTML, Basic UNIX shell scripting

Database

Oracle 9i/10g/ 11g, Teradata, DB2, Siebel, MS SQL Server 2010/ 2005, Netezza,

Operating System

Windows 98/NT/2000/XP/7, UNIX

Programming Tools

SQL*PLUS, SQL* Loader, Siebel Analytics TOAD 10.0, Putty

Office Tools

MS PowerPoint, MS Word, MS Excel

Scheduling tools

DAC,Control M, Skybot, Robot, Crontab, UC4, Mastero, CA Workstation

Defect Management

HP Quality Centre, HP ALM, JIRA, Service Now

Internet Tools

HTML, XML, XSLT

Bachelors in Electronics and Communication from Vignan University in 2014, India

Masters in CSIT from Sacred Heart University, CT in 2018

07/19 to 09/20 Informatica Developer Nationwide Insurance; Des Moines, IA

Followed Agile-Scrum methodology to design, develop, test and deliver the code.

Documentation to describe program development, logic, coding, testing, changes and corrections.

Participated in weekly status meetings, conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Worked on some Investments projects.

Worked with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.

Used Informatica Workflow Manager to create workflows, sessions and batches to run the mappings.

Developed mappings that perform Extraction, Transformation and load source data in to Target using transformation like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Joiner, Rank, Expression to meet business logic.

Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager and monitored the results using workflow monitor.

Developed Pre and post session commands at session level in the workflow.

Modify existing business logic in Informatica ETL flows.

Used Variables and Parameters in the mappings to pass the values between mappings and sessions.

Used Unix Shell Scripts to automate pre-session and post-session processes.

Extensively worked on batch frame work to run all Informatica job scheduling.

Documented test scenarios as a part of Unit testing before requesting for migration to higher environment levels and handled production deployments.

Used Debugger in identifying bugs in existed mappings by analyzing data flow.

Modified Stored Procedures, Functions and Packages.

Worked on Decommissioning un used BEE (Bash Execution Engine) processes.

Used tools like Winscp, Putty to move files or to run scripts in Linux servers.

Used deployment tool like UCD (Urban Code Deployment), XML export, GIT for code deployment and migration.

Validated the output according to the specifications.

Used Z/OS explorer and have hands on Mainframe for creating change man packages.

Automated/Scheduled the jobs to run daily with email notifications for any failures.

Environment: Informatica 10.1.1, 9.5, Oracle, XML, SQL Server 2008, Mainframe, CA Work station, AQT, Winscp, Putty, Service Now.

11/18 to 07/19 Informatica Developer / ETL Developer

Farmers Insurance; Woodland Hills, CA

Followed Agile-Scrum methodology to design, develop, test and deliver the code.

Modify existing business logic in Informatica ETL flows.

Involved in performance tuning and optimization of mapping to manage very large volume of data

Worked on Informatica Utilities Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Router, Sorter, Expression, Normalizer, Sequence Generator and Update StrategyDevelop complex ETL mappings on Informatica 10.x platform as part of the Risk Data integration efforts.

Implemented SCD Type 1 and SCD Type 2 for loading data into data warehouse dimension tables.

Implemented error handling for invalid and rejected rows by loading them into error tables.

Extensively worked on batch frame work to run all Informatica job scheduling.

Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.

Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.

Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.

Used Variables and Parameters in the mappings to pass the values between mappings and sessions.

Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.

Implemented restart strategy and error handling techniques to recover failed sessions.

Used Unix Shell Scripts to automate pre-session and post-session processes.

Did performance tuning to improve Data Extraction, Data process and Load time.

Worked with data modelers to understand financial data model and provided suggestions to the logical and physical data model.

Designed presentations based on the test cases and obtained UAT signoffs

Documented test scenarios as a part of Unit testing before requesting for migration to higher environment levels and handled production deployments

Recorded defects as a part of Defect tracker during SIT and UAT

Identified performance bottlenecks and suggested improvements.

Performed Unit testing for jobs developed, to ensure that it meets the requirements

Handled major Production GO-LIVE and User acceptance test activities.

Created architecture diagrams for the project based on industry standards

Defined escalation process metrics on any aborts and met SLA for production support ticket

Environment: Informatica 10.1.1, 9.5, Oracle, XML, SQL Server 2008, Web services, DB2 Mainframe, DAC(Scheduler)

12/17 to 10/18 ETL Developer

Eagle Creek Software Service; Eden Prairie, MN

Involved in the requirement definition and analysis in support of Data Warehouse efforts.

Developed ETL mappings, transformations using Informatica Power Center

Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.

Extensively used ETL to load data from Flat Files to Oracle.

Worked as a part of AWS build team.

Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.

Developed data Mappings between source systems and warehouse components using Mapping Designer

Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.

Implemented Type 1 & Type 2 Slowly changing dimensions.

Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions

Troubleshoot connectivity problems. Looked up and read session, event and error logs for troubleshooting

Documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.6.1, Workflow Manager, Workflow Monitor, PL/SQL, Oracle 11g, Erwin, Autosys, SQL Server 2005, AWS, Toad 9.0.

03/17 to 12/17 ETL Informatica Developer

Merck; West Point, Pennsylvania

Project - Pharma

Involved in gathering and analyzing the business requirements.

Designed and developed mappings by using Lookup, Expression, Update Strategy, Sequence generator, Aggregator, Router, Joiner transformations to implement the mapping.

Worked with Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.

Extracted data from Hive files and transformed it in accordance with the Business logic and loaded data into Oracle tables using ETL tool.

Involved in creating Oracle staging table structures and modifying existing tables as per the design specifications.

Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica Power Center.

Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.

Involved in debugging Informatica mappings, Performance and Unit testing of Informatica Sessions and Target Data.

Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.

Involved in Performance Tuning of mappings in Informatica.

Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Participated in weekly status meetings, conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g, SQL, SQL Developer, UNIX, Maestro, Putty.

07/14 to 08/16 Informatica Developer

Confidential; Bangalore, India

Followed Agile-Scrum methodology to design, develop, test and deliver the code.

Modify existing business logic in Informatica ETL flows.

Design new ETL flows as per the mapping sheets.

Involved in ETL developing, creating required mappings for the data flow using Informatica.

Used transformations like Source qualifier, Filter, Aggregator, Joiner, Expression, Lookup, Router, Sorter and Union.

Involved in designing the mapplet and reusable transformations according to the data flow requirements.

Validated the output according to the specifications.

Enhancements in existing mappings according to the business logic.

Attended daily scrum calls to post the required status update.

Testing activities involve Unit Test Plan Preparation, Unit Testing, Sprint Testing, UAT and performance testing.

Gathering reporting requirements and making enhancements to any existing logic if required.

Developed Oracle PL/SQL packages, procedures and functions.

Coded Oracle SQL to create ad-hoc reports on an as-needed basis.

Used Oracle Warehouse Builder to implement changes to the operational data store, as well as create data marts.

Involved in the data analysis for source and target systems. Good understanding of Data warehousing concepts, Star schema and Snow-flake schema.

Involved in supporting and maintaining Oracle Import, Export and SQL*Loader jobs.

Environment: Informatica PowerCenter 9.5.1, PL/SQL.

Qualifications Summary

Technical Skills Highlights

Education and Certifications

Professional Experience

Contact this candidate