About

Apoorva Chauhan is a highly skilled Sr. ETL Informatica Developer with over 6 years of experience in SQL, Data Warehouse, UNIX, ETL, Business Intelligence, and Data Analytics tools. She is passionate about her work and is always eager to learn new technologies. She is seeking a position where she can efficiently apply her skills and abilities to the growth of the organization and build her professional career. Apoorva has problem-solving skills and experience in providing business insights and recommendations from large datasets. Apoorva has experience working with databases such as MS SQL Server, MySQL, Oracle, and Teradata. She is proficient in languages and applications such as Visual Studio, NetBeans, MS Excel, MS Word, SQL, R, Python, Power BI, Tableau, Unix, Linux, SAS Visual Tools, SAS Enterprise Miner, and Informatica. She also has experience in web development languages such as PHP, ASP.NET, HTML, CSS, and JavaScript. Apoorva has domain knowledge in Data Mining, Business Intelligence, Data Visualization, SDLC, and Agile Development. Currently, Apoorva is working as a Sr. ETL Informatica Developer at Bank of America. In her previous role as an ETL Developer at Cigna, she led the development of the project using Informatica 10.2, 837-I, Teradata, MS SQL Server & Active Batch. She was involved in full cycle development, including design, ETL strategy, troubleshoot reporting, and identifying facts and dimensions for various projects. She also designed and developed the logic for handling Slowly Changing Dimension (SCD) processes. Apoorva documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling, and analysis. She was responsible for performance tuning at the mapping, session, source, and target level for data loading. Apoorva created tables, views, and stored procedures in MS SQL Server and Teradata. She deployed the jobs in Jenkins and Git and developed and scheduled the jobs on Active Batch. Prior to Bank of America, Apoorva worked as a Business Intelligence Developer at Danone. She performed the code migration from Informatica 9.6 to Informatica 10.2 and from Oracle to MS SQL Server database. She extensively worked with various flat files & tables, applying the business