ETL Developer - Informatica PowerCenter Expert

TEJASWINI G

ETL DEVELOPER

LOCATION: Dallas, TX

PHONE: +1-469-***-****

EMAIL: ************@*****.***

PROFESSIONAL SUMMARY:

Over 6 years of experience in Information Technology including Data Warehouse development using ETL/Informatica Power Center across various industries.

Extensive experience in developing ETL mappings, scripts and data integration using Informatica Power Center 10.x/9.x Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.

Experience in working with business analysts to identify and understand requirements in order to create Technical Design Documents.

Experienced in data profiling and data analysis.

Attended data model review sessions with Data Modeler.

Expertise in understanding Business Model Identifying Dimensions and Facts.

Solid understanding of OLAP concepts and challenges, especially with large data sets.

Experience in creating Reusable Transformations (Joiner, Sorter, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Aggregator, and Rank) for better usability.

Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snowflake Schema).

Expertise in implementing Slowly Changing Dimensions - SCD Type 1 & SCD Type 2.

Experience in integration of various data sources like Oracle, DB2, Sybase, My Sql, SQL Server and non-relational sources like flat files into staging area.

Experienced with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, SQL Assistant.

Experience in doing Tuning of Teradata Queries using Explain plan.

Experience in converting SSIS packages & Hadoop Hive QL to Informatica.

Extensively worked with Sql and Pl/Sql.

Experience in doing performance Tuning of Data Base queries.

Experience in UNIX environment, file transfers and job scheduling.

Worked on Informatica Performance Tuning identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions

Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).

Involved in Unit testing, System testing to check whether the data loads into target are accurate.

Experienced in ETL Informatica & Database Upgrade Testing.

Experience working in Agile methodology and ability to manage change effectively.

Excellent communication, interpersonal skills, enthusiastic, self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.x/9.x

Data Modeling: Dimensional Modeling, ER Modeling, Ralph Kimball Methodology, Bill Inman Methodology, Star, Snowflake, Fact Tables, Dimension Tables, Physical and Logical Modeling, Normalization and De Normalization.

Databases: Teradata 14/12, Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2012/2008, DB2, Sybase, My Sql

Others: Toad, SQL Navigator, FACETS 4.3/4.7, Shell Scripting, Sql Assistant, Sql, Java

EXPERIENCE:

Aug 2023 – PRESENT

ETL INFORMATICA / TERADATA DEVELOPER, VERIZON, IRVING, TX

Worked with Business Analyst & Data Modelers in understanding the BRD - Business Requirement Document, Mapping Document and Data Model.

Extracted data from different source systems - Oracle, DB2, My Sql, Flat Files and XML Files.

Developed ETL programs using Informatica Power center 9.6.1/9.5.1 to implement the business requirements.

Involved in enhancements and maintenance activities of the Enterprise Data Warehouse.

Communicated with business customers to discuss the issues and requirements.

Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un Connected), Expression, Update Strategy, Transaction Control and Sequence Generator.

Implemented Slowly Changing Dimensions - Type 1 & Type 2 to maintain the history in Dimension tables.

Worked with Huge data sets to load Fact Tables.

Implemented Change Data Capture (CDC) for handling delta loads.

Involved in Informatica upgrade process and testing the whole existing Informatica flow in new upgrade environment.

Experienced in doing performance Tuning of Informatica objects- Finding the bottle necks at source, Target and mapping level and eliminating them with tuning methods.

Used Informatica file watch events to pole the FTP sites for the external files.

Involved in Enhancing existing Production informatica objects for change or additional requirements and pushing it back to production after successful QA testing.

Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load in to Teradata Warehouse.

Built several BTEQ to load data from Stage to Base after considering several performance techniques in Teradata sql.

Involved in Teradata upgrade process from TD 12/TD 14.

Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.

Has a very good knowledge of FACETS tool and Healthcare domain, Worked on the various modules like Subscriber/Member, Groups, Enrollment, Claims, Billing, Accounting, Provider, MTM and Utilization Management.

Good experience on FACETS CTP (Claims Test Pro) and FACETS Testing.

Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.

Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Pre and post session assignment variables were used to pass the variable values from one session to other.

Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks,

Used Cron Job to schedule jobs.

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

Worked with ETL Admin team for code migration activities and deployments.

Worked with QA team for better understanding of code development.

Implemented & followed organization level Informatica best Standards & Procedures.

Involved in Solving Trouble tickets raised by Business users as part of application support team.

APR 2019 - FEB 2023

ETL INFORMATICA / TERADATA DEVELOPER, ADAPTIVE SOFTWARE SOLUTIONS PVT LTD, HYDERABAD, INDIA

Analyzed the Business Requirement Documents (BRD) and laid out the steps for the data extraction, business logic implementation & loading into targets.

Responsible for Impact Analysis, upstream/downstream impacts.

Created detailed technical specifications for Data Warehouse and ETL processes.

Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into Teradata using Teradata Utilities.

Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.

Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.

Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.

Developed mappings to load Fact, Dimension tables (SCD Type 1 and SCD Type 2 dimensions) and Incremental loading and unit tested the mappings.

Successfully upgraded Informatica 9.1 and to 9.5 and responsible for validating objects in new version of Informatica.

Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.

Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.

Loaded data into the Teradata tables using Teradata Utilities Bteq, Fast Load, Multi Load, and Fast Export, TPT.

Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.

Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.

Integrated the data into centralized location. Used migration, redesign and Evaluation approaches.

Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.

Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.

Scheduling Informatica jobs and implementing dependencies if necessary, using Autosys.

Managed postproduction issues and delivered all assignments/projects within specified timelines.

EDUCATION:

B.E-Chalapathi Institute of Engineering and Technology/Electronics & communication Engineering/Guntur/2020

Contact this candidate