Rajeswari MeenakshiSundaram

ETL Informatica Developer

Email: ad3arn@r.postjobfree.com Cell: +1-940-***-****

EXECUTIVE SUMMARY:

With 5.5+ extensive experience in ETL development, particularly within the Informatica PowerCenter and Intelligent Cloud Services (IICS) environment, and a comprehensive skill set encompassing SQL, PL/SQL, Unix commands, performance tuning, EDW concepts, data modeling, as well as a solid background in both banking and healthcare domains.

My key qualifications and experiences include hands-on experience in designing, developing, and implementing ETL processes using Informatica PowerCenter and IICS. I have successfully delivered complex ETL solutions for various clients, ensuring data accuracy and consistency. I possess advanced SQL skills, which enable me to write complex queries, perform data transformations, and optimize SQL performance. This proficiency has been instrumental in enhancing the efficiency of ETL processes. I am well-versed in Unix commands, allowing me to manage and automate ETL workflows efficiently. I have a deep understanding of performance tuning techniques and have successfully optimized ETL processes. I possess a good understanding of EDW / ETL concepts and data models. My background includes extensive work in both the banking and healthcare sectors, enabling me to comprehend the specific data needs and compliance requirements of these industries. I am highly motivated and committed to delivering high-quality results, and I thrive in collaborative team environments.

SUMMARY OF QUALIFICATIONS:

Exposure in writing SQL using analytical functions like Ranking, case statement etc., also in writing optimize SQL query using ORACLE 18c/12c/11g, SQL Server 2014/2017.

Excellent experience in designing and development of ETL Methodology using Informatica PowerCenter 10.5/10.2/9.6 and Informatica Cloud IICS

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

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

Worked in Change Data Capture 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.

Expert in writing SQL query using multiple databases like ORACLE, SQL Server etc.

Extensive knowledge of Informatica tuning and SQL tuning.

Experience in integration of various data sources into staging area.

Performed Unit testing, System testing, Integration testing and users for UAT and prepared test report in different phases of project.

Designed and developed complex mappings, Mapplets, tasks and workflows and tuned it.

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 and other techniques.

Excellent interpersonal skills and have passion for working with end-users to understand their business requirements and translate them into technical specifications.

Education:

Master of Computer Application from Madurai Kamaraj university, India

Technical Skills:

ETL TECHNOLOGY

Informatica PowerCenter 10.5/10.2/9.x and Informatica Cloud

DATABASES

Oracle 18c/12c/11g, MS SQL Server 2017/ 2014

OTHERS

Autosys, AWS, AWS S3, Control M, TOAD, SQL, Rally, JIRA, MS Office, GitHub, SharePoint, Confluence

Professional Experience:

Client: HMS, Irving, TX

Duration: Apr 2021 to Current

Project: Operational Data Store ODS

Role: Informatica Developer

Description: Health Management Systems (HMS, now part of Gainwell Technologies) is the leader in cost containment, program integrity, and coordination of benefit solutions for government-funded and commercial healthcare entities throughout the country. HMS compares Eligibility insurance coverage information from Insurance carriers with Medicaid or Medicare claims. If a match is found and third-party coverage is confirmed, HMS will recover the money for the Medicaid and Medicare programs, since they are the payor of last resort.

ETL applications receive Eligibility Client and Carrier loads, Providers, claims information from both State and Managed Care Organization (MCO) clients, load that information into staging tables and reformat as per business requirement in stage process. These are loaded into base tables where a match or hit is identified between third party coverage and Medicaid/Medicare claims. Recovery is initiated based on the hit. Further, the reformatted data in the base tables populates into the data warehouse, which is used for healthcare trend analysis, Medicaid and Medicare business intelligence, generating audit reports etc.

Responsibilities:

Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.

Actively involved in interacting with business users to record user requirements and Business Analysis.

Outlined the complete process flow and documented the data conversion, integration and load mechanisms to verify specifications for this project.

Parsing high-level design spec to simple ETL coding and mapping standards.

Worked with PowerCenter Designer tools in developing mappings and Mapplets to extract and load the data from flat files and SQL server database.

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Created the design and technical specifications for the ETL process of the project.

Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups Using Connected, Unconnected, Expression, Aggregator, Update strategy & stored procedure transformation.

Worked with various complex mapping, designed slowly changing dimension Type1 and Type2.

Performance tuning of the process at the mapping level, session level, source level, and the target level.

Created Workflows containing command, email, session, decision and a wide variety of tasks.

Tuning the mappings based on criteria, creating partitions in case of performance issues.

Performed data validation after the successful End to End tests and appropriate error handling in ETL processes.

Resolving the tickets based on the priority levels raised by QA team.

Developed Parameter files for passing values to the mappings as per requirement.

Scheduled batch and sessions within Informatica using Informatica scheduler and also customized pre written shell scripts for job scheduling.

Environment: Informatica PowerCenter 10.5, IICS, Unix, Toad, Oracle 18c, Microsoft SQL Server 2017, Control M, GitHub, SharePoint, Confluence

Client: TCF BANK, Detroit, MI

Duration: Jun 2019 to Mar 2021

Project: TCF Integrated Data warehouse

Role: Informatica Developer

Description: TCF Bank is the wholly owned banking subsidiary of TCF Financial Corporation, a bank holding company. This project object is to build report and dashboard in residential mortgages, and home equity loans area which are falling under Consumer Banking segment Relevant data was integrated from various source system using ETL Informatica tools. Reports and Interactive dashboards

Responsibilities:

Worked with business analyst for requirement gathering, business analysis and testing and project- coordination, document analysis, business process descriptions, scenarios and workflow analysis.

Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.

Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, etc.

Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations

Designed and implemented ETL mappings and processes as per the company standards, using Informatica.

Extensively worked on complex mappings which involved slowly changing dimensions.

Developed several complex mappings in Informatica a variety of PowerCenter transformations, Mapping.

Analyzed the existing mapping logic to determine the reusability of the code.

Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.

Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Created Unit test plans and did unit testing using different scenarios separately for every process.

Involved in System test, Regression test and supported the UAT for the client.

Performing ETL and database code migrations across environments using deployment groups.

Populating the business rules using mappings into the target tables during code development

Involved in end-to-end system testing, performance and regression testing and data validations.

Unit test and support QA and UAT testing for database changes.

Managed performance and tuning of SQL queries and fixed the slow running queries in production.

Coordinated and worked closely with architects, operations, and business units to build and deploy.

Environment: PowerCenter 10.2, Oracle 12c, SQL Server 2017, Autosys, Putty, WinSCP, Notepad++, JIRA, CICD, GitHub

Client: Auto-Owners Insurance Co, Lansing, MI

Duration: Jan 2018 to Jun 2019

Project: EDW

Role: Informatica Developer

Description: Auto-Owners Insurance Group is among the nation’s largest insurers and provides insurance to nearly 3 million policyholders. The company is represented by 48,000 licensed agents in 26 states and offers multiple lines of insurance including life, home, auto and business. The object of integrated data mart is 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:

Worked with business users to get the requirement and to involve in complete SDLC of this project

Analyzed source data and gathered business requirements from the business users and source data team

Created Technical Design Document from business requirements document (BRD).

Analyzed business and system requirements to identify system impacts.

Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality.

Prepared source to target mapping and conducted meetings with the business to understand data / transformation logic.

Analyzed the existing mapping logic to determine the reusability of the code.

Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.

Done the extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Created Unit test plans and did unit testing using different scenarios separately for every process. Involved in System test, Regression test and supported the UAT for the client.

Performing ETL and database code migrations across environments using deployment groups.

Populating the business rules using mappings into the target tables.

Involved in end-to-end system testing, performance and regression testing and data validations.

Managed performance and tuning of SQL queries and fixed the slow running queries in production.

Created batch scripts for automated database build deployment.

Used prewritten scripts to run informatica workflow.

Worked on tuning SQL statements

Environment: Informatica PowerCenter 9.6, SQL Server 2014, Oracle 12c, Unix, Putty, WinSCP, Control M

Contact this candidate