Informatica Developer Sql

Sasikala Ramar

Informatica Developer Email: adxlef@r.postjobfree.com Cell: +1-713-***-**** Education : Master Degree in Computer Science

With 6 years of experience in developing ETL solutions using Informatica, 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. 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 technique. 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.

Expertise in analysis, design, development and implementation of Data warehouses and Decision Support Systems (DSS) using ETL tools Informatica 10.5/9.x with RDBMS like Oracle, MS SQL server and MySQL databases on Windows and UNIX platforms.

Good understanding of Data Warehousing Concepts like Dimensions Type I and II, Facts, Surrogate keys, ODS, staging area.

Good understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.

Good experience of writing SQL Queries for Data analysis, Data mapping specification, Data Profiling, Data Migration and creating Data Dictionaries.

Expert in writing complex SQL queries and optimizing the queries in Oracle, SQL Server etc.

Experience in developing very complex mappings, reusable transformations, sessions and workflows using Informatica ETL tool to extract data from various sources and load into targets.

Experience in Performance tuning of ETL process using pushdown optimization and other techniques.

Used mapplets, user defined functions, reusable transformations, look-ups in Informatica mapping.

Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.

Skilled in creating Source to target mapping, ETL Specification Documents and capturing requirement.

Experience with Informatica tools using real-time CDC (change data capture) and MD5.

Working experience in Agile and Waterfall methodologies.

Good communication and presentation skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.

EDUCATION:

Masters in computer science, Madurai Kamaraj university, India

TECHNICAL SKILLS:

ETL tools

Informatica PowerCenter 10.5/9.6/9.2

RDBMS

Oracle 12c/11g, MS SQL Server 2017, MySQL

Tools

Microsoft office, TOAD, Oracle SQL developer, WINSCP, Control-M, JIRA, Tivoli

Methodologies

SDLC, Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Client: Cigna, Houston, TX Jan 2020 to Current

Project: Claim Data Mart

Description: Cigna Corporation provides insurance and related products and services in the United States. Client wanted to build Datawarehouse for its Medicare & Medicaid business. The goal of this project to integrate its Government Business data into a central data warehouse to serve multiple purpose including enterprise reporting needs. Cigna sources data from multiple sources. By using ETL Informatica tool will load Data into Datawarehouse.

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.

Co-ordinated with scheduling team to run Informatica Jobs

Environment: Informatica PowerCenter 10.5, Unix, TOAD, Microsoft SQL Server 2017, Control M, SharePoint, Confluence

Client: Amegy Bank, Houston, TX Nov 2018 to Jan 2020

Project Name: IDW

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:

Worked with the business team to gather requirements for projects 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 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 9.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.

Environment: Informatica PowerCenter 9.6, SQL Server 2017, MySQL, UNIX, Toad, SQL Developer, AutoSys

Client: NOV, Houston, TX Sept 2017 to Nov 2018

Project Name: Omega Project

National Oilwell Varco is an American multinational corporation based in Houston, Texas. It is a leading worldwide provider of equipment and components used in oil and gas drilling and production operations, oilfield services, and supply chain integration services to the upstream oil and gas industry and operating through three reporting segments: Rig Technologies, Wellbore Technologies, and Completion & Production Solutions. The objective of this project to migrate the SQL database to Oracle to create Data Warehouse to smoothen and fasten their reporting system

Responsibilities:

Experienced in using Informatica for data profiling and data cleansing, applying rules and develop mappings to move data from source to target systems

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

Created Informatica mappings, Mapplets, worklets and workflows to populate the data from different sources to target.

Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.

Extensively worked on complex mappings which involved slowly changing dimensions.

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

Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update strategy, Sequence generator and Joiners.

Deployed reusable transformation objects such as Mapplets to avoid duplication of metadata, reducing the development time.

Worked on developing Change Data Capture mechanism using Informatica

Power Exchange for some of the interfaces based on the requirements and limitations of the Project.

Implemented performance and query tuning on all the objects of Informatica using SQL Developer.

Worked in the ETL Code Migration Process from DEV to QA and to PRODUCTION.

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

Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing

Involved in testing the database using complex SQL scripts and handled the performance issues effectively.

Environment: Informatica PowerCenter 9.1, Oracle 11g, SQL Server 2014, SQL, UNIX, Control-M

Contact this candidate