Soni Kumari

ETL Informatica Developer

Email: ad3v9v@r.postjobfree.com Cell: +1-570-***-****

With around 6 years of IT experience in Data Warehousing technology and a comprehensive understanding of the Software Development Life Cycle, throughout my career, I have been extensively involved in various phases of the SDLC, including Business Requirement Analysis, Application design, Development, Implementations, and Testing. My experience spans multiple domains, specifically Banking and Healthcare Insurance, which have provided me with a deep understanding of industry-specific challenges and requirements.

One of my key strengths lies in the design and development of ETL solutions. I have worked extensively with Informatica PowerCenter versions 10.x, 9x and Informatica Cloud enabling efficient and seamless data integration processes. Additionally, I have hands-on experience working with databases such as ORACLE 18c/12c/11g, MySQL, and SQL Server 2019/2014, allowing me to effectively manage and manipulate data. I possess strong data modeling skills, enabling me to design robust and efficient data structures that align with business needs. Furthermore, my proficiency in Unix enables me to navigate complex system environments and troubleshoot any issues that may arise during the ETL process.

In my previous roles, I have consistently delivered high-quality solutions while adhering to project timelines and maintaining attention to detail. I am a proactive problem solver, constantly seeking opportunities to optimize SQL/ETL processes and enhance performance. My strong analytical and communication skills have allowed me to collaborate effectively with cross-functional teams, ensuring successful project outcomes.

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, MySQL etc.

Experience in Task Automation using UNIX Scripts, Job scheduling and communicating with Server using PMCMD command.

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.

Extensive experience with Data Extraction, Transformation, and Loading (ETL) from Multiple Sources.

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.

Well versed on 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.

Skilled in utilizing Unix command/utilities like grep, awk, sed, find etc. for data parsing, filtering, and transformation.

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

Education:

Masters in Business Administration, Symbiosis Centre for Distance Learning, India

Technical Skills:

ETL TECHNOLOGY

Informatica PowerCenter 10.x/9.x, Informatica Cloud

DATABASES

Oracle 18c/12c MS SQL Server 2019/ 2014

OTHERS

GIT, TOAD, PL/SQL, SQL, JIRA, MS Office, Autosys, Control M, Unix

Client: U.S. Bank, Dallas, TX Dec 2021 to Current

Role: ETL Informatica Developer Project: USBDW

U.S. Bank provides various financial services in the United States. It operates in Corporate and Commercial Banking, Consumer and Business Banking, Wealth Management and Investment Services, Payment Services, and Treasury and Corporate Support segments. As a part of this USBDW that stand for US Bank Data Warehouse, Data is being collected from all servicing originations Application systems, databases like oracle, flat files. Data is migrated from all various sources into ingested to staging table, and then pushed to the target system, Data is cleansed, and transformed based on the business rules through ETL tools

Responsibilities:

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

Documented Data Mappings/ Transformations as per the business requirement.

Prepared Technical Design documents and Test cases.

Participated in daily scrum, sprint, grooming, planning, and retrospective meetings as part of the agile process.

Creating and maintaining source-target mapping documents for ETL development team.

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

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

Utilized many services from Informatica cloud like Bundles, Integration Templates, Task Flows, Saved Queries, Input and Output Macro fields, Mapping Configuration Tasks etc.

Used Data synchronization task for incremental load, Data Replication Tasks, Mappings and Task Flows and customize tasks, assignments, and decision tasks.

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 tables.

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

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

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

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

Involved in committing the changes using GIT and then pushing the changes into Bitbucket.

Wrote hundreds of SQL query for data analysis to validate the input data against business rules.

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

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

Used pre written Unix shell scripts for scheduling Informatica pre/post session operations.

Used PMCMD command to start, stop and ping server from UNIX.

Created different parameter files and started sessions using these parameter files using PMCMD command to change session parameters, mapping parameters, and variables at runtime.

Improved performance testing in Mapping and the session level.

Coordinated with scheduling team to run Informatica jobs for loading historical data in production.

Maintaining bug, status using JIRA tool

Environment: Informatica PowerCenter 10.5, IICS, SQL, Oracle 18c, SQL Server 2019, Oracle SQL Developer, TOAD, Control M, Unix

Client: Humana, Irving, TX Apr 2019 to Jun 2021

Role: ETL Informatica Developer Project: EDW

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:

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.

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.2, Unix, TOAD, Oracle 12c, Microsoft SQL Server 2017, Autosys, Unix, SharePoint, Confluence

Client: Morgan Stanley, New York, NY Jan 2018 to Apr 2019

Role: ETL Developer CDM

Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, wealth management and investment management services. The objective of this project to consolidated customer data across the system into DataMart for long-term decision-making, strategic plans, support and solutions giving top management through dashboard and report.

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.

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.

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

Implemented various Performance Tuning techniques.

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 2014, Oracle 12c, MySQL, SQL, UNIX, Toad, SQL Developer, Control M

Contact this candidate