Soni Kumari

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.