Etl Informatica Data Quality

Ramya Polisetty

ETL Informatica/IICS Developer

Email: *****************@*****.*** Cell: +1-512-***-****

PROFESSIONAL SUMMARY

* ***** ** ********** ** developing ETL solutions using Informatica PowerCenter and IICS, my experience includes working with HealthCare insurance and banking domains. I have designed and developed complex ETL processes, including creating mappings, sessions, and workflows using Informatica PowerCenter and IICS. I have also been responsible for ensuring data quality and integrity and have gained expertise in EDW concepts. I have good understanding of ER and dimensional data modeling. I have also been responsible for working closely with business stakeholders to understand their requirements and ensuring that the ETL processes meet their needs. As an SQL expert, I have developed strong skills in writing and interpreting SQL statements. I have experience in using SQL for data analysis and have developed expertise in SQL optimization and performance tuning. I am proficient in Unix command and having good understanding of shell scripting, which has enabled me to automate ETL processes and enhance efficiency in my work. I am highly motivated, a quick learner, and possess excellent problem-solving capabilities.

Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.5, 9.6.1/9.1.1 and Informatica Cloud IICS

Having experience in working with ORACLE 18c/12c, MySQL, SQL Server 2016/2014 databases.

Expert in Change Data Capture (CDC) Methodology using Informatica PowerCenter 10.x/9. x

Interacted with end-users and functional analysts to identify and develop Business Requirement Document (BRD) and transform it into technical requirements.

Worked extensively in design and analysis of Requirements, Development, Testing and Production deployment.

Prepared various types of documents like requirements gathering, ETL specification, Data Mapping, Test cases, Data dictionary etc.

Performed Unit testing, Integration testing and helped users for UAT and prepared test report.

Experience in Debugging and Performance tuning of targets, sources, mappings and sessions in Informatica.

Good understanding of the Data modeling concepts like Star-Schema Modeling, Snowflake Schema Modeling.

Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations like Mapplets.

Extensively used Slowly Changing Dimension (SCD) technique in business application.

Experience in Performance tuning of ETL process using pushdown optimization.

Experience working with Onsite and Offshore model and while working in that project ensured proper work assignment and review.

EDUCATION

Bachelor of Technology, JNTU, India

TECHNICAL SKILLS

ETL TECHNOLOGY

Informatica PowerCenter 10.5, 9.x and Informatica Cloud IICS,Snowflake

DATA WAREHOUSE

Star Schema, Snowflake schema

DATABASES

Oracle 18c/12c, MS SQL Server 2016/2014, MySQL

Others

PL/SQL. Control M, Autosys, MS Office, TOAD, SQL, WinSCP, Putty, Rally, Shell Scripts, Unix, AWS,GCP

PROFESSIONAL EXPERIENCE

Charles Schwab, Austin, TX Jun 2021 to Current ETL Informatica/IICS Developer

Description: Charles Schwab is a different kind of investment services firm – one that strives to disrupt the status quo of the traditional Wall Street approach on behalf of their clients. they provide a full range of brokerage, banking and financial advisory services. Its broker-dealer subsidiary, Charles Schwab offers investment services and products. Its banking subsidiary, Charles Schwab Bank provides deposit and lending services and products.

The goal of this project to integrate its daily transactional data into a central data warehouse to serve multiple purpose including enterprise reporting needs using ETL Informatica tool into Teradata target tables/views.

Responsibilities:

Interacted with business partners to identify and understand the requirements and design specifications.

Handled data profiling, source analysis and data quality analysis.

Handled and developed complex informatica cloud mappings, task, task flows and scheduled.

Design, develop, and support our Data applications and infrastructure utilizing various technologies to process large volumes of data, including Snowflake, SQL Data Warehouse, Informatica IICS.

Create solutions and environments to enable Analytics and Business Intelligence capabilities.

Partner with the Analytics, Modelling and Claims business organizations to get feedback and iterate the development of Snowflake Database.

Research trends and emerging technologies in the Cloud and Data spaces, participate in user communities, and share learning with internal teams.

Analyzing and evaluating data sources, data volume, and business rules.

Automation, job scheduling, dependencies, monitoring.

Extraction, transformation, and load of data using the ETL tools.

Configure/Script Business rules and transformation rules in Informatica.

Understanding the data model, designing the model for EDW, mapping the data and running the ETL jobs.

Ensure appropriate level of Unit Test and System Test of all the deliverables.

Defect fixes for System Test, Operational Acceptance Test and Production Preparing status report and discuss with Business and Technical lead in daily status call.

Creating Document related to Designs, Technical Specifications & Unit testing.

Skills: Computer Science · RDBMS · Fine Tuning · Job Scheduling · Scheduling Tools · File Handling · Shell Scripting · STTM · Data Marts · Complex Analysis · Agile Methodologies · Data Warehouse Architecture · Data Integration · ETL Tools · Data Validation · CDC · Extract, Transform, Load (ETL) · Data Analysis · Requirements Gathering · Software Development Life Cycle(SDLC) · Data Lakes · Amazon Web Services (AWS) · Snowflake · Google Cloud Platform (GCP) · GitHub · Linux · Performance Tuning · Oracle Database · Requirements Analysis · Informatica PowerCenter 10.4 · IICS(IDMC)· SQL · Oracle 18c · SQL Server 2019 · Control M · Jira · Toad

Humana, Irving, TX Sept 2019 to Jun 2021 ETL Informatica Developer

Description: Humana operates as a health and well-being company in the United States. The company offers medical and supplemental benefit plans to individuals. It also has contract with Centers for Medicare and Medicaid Services to administer the Limited Income Newly Eligible Transition prescription drug plan program; and contracts with various states to provide Medicaid, dual eligible, and long-term support services benefits.

Responsibilities:

Worked with the business team to gather requirements and created strategies to handle the requirements.

Documented Data Mappings/ Transformations as per the business requirement.

Worked on project documentation which included the Technical and ETL Specification documents.

Used Informatica Power Center and IICS for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Involved in extracting the data from the Flat Files and Relational databases into staging area.

Mappings, Sessions, Workflows from Development to Test and then to UAT environment.

Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.

Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.

Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.

Developed several reusable transformations and mapplets that were used in other mappings.

Prepared Technical Design documents and Test cases.

Extensively worked on Unit testing for the Informatica code using SQL Queries.

Implemented various Performance Tuning techniques.

Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Sorter, Expression, Router, Filter, Aggregator and Sequence Generator transformations.

Wrote SQL queries to view and validate the data loaded into the warehouse.

Developed transformation logic as per the requirement, created mappings and loaded data into respective targets.

Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Used PMCMD command to run workflows from command line interface.

Improved performance testing in Mapping and the session level.

Migrated the code by CI/CD method using GIT and Bitbucket

Coordinated with multiple teams to run Informatica jobs for loading historical data in production.

Maintaining bug, status using JIRA tool

Scheduled batch and sessions using Control M and used existing shell scripts for job scheduling.

Environment: Informatica PowerCenter 9.6.1,IICS, SQL Server 2016, ORACLE 12c SQL, UNIX, Toad, SQL Developer, JIRA

Amegy Bank, Houston, TX Jan 2017 to Aug 2019 ETL Informatica Developer

Description: Amegy Bank specialize in banking privately owned business of all sizes and public companies in all industries with additional expertise in real estate, energy and correspondent banking. Amegy Bank operates in nearly 500 local financial centers across 11 Western states, it is known as Zions Bancorporation in S&P 500. The objective of this project is to enrich data from new sources into existing IDW i.e., integrated data warehouse to enable improved decision-making, strategic plans, support and solutions that favorably impact costs, quality of care, outcomes, and customer satisfaction through an information-driven environment that leverages their integrated data assets for competitive advantage.

Responsibilities:

Co-ordination from various business users’ stakeholders and SME to get Functional expertise, design and business test scenarios review, UAT participation and validation of data from multiple sources.

Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.

Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.

Used SQL to analyze source data, performed data analysis and validate the data.

Scheduled Informatica Jobs through Autosys scheduling tool.

Worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.

Involved in creating Informatica mappings, Mapplets, worklets and workflows to populate the data from different sources to warehouse.

Wrote complex SQL scripts and handled SQL performance issues effectively.

Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Informatica Power Center 9.6.1, Oracle 12c, SQL, SQL developer, SQL Server 2014, Unix, AutoSys, WinSCP, JIRA

Contact this candidate