Data marts/Data warehousing techniques (Star Schema, snow flaking, denormalization, Normalization, Aggregations).

• Managed the data load production process and the implementation of new data load files in accordance with the department's change management process.
• Created, executed, and documented unit test plans for ETL and data integration processes and programs.
• Performed tasks required to conform to the company's configuration management and software release processes.
• Monitored and administered automated and manual data integration and ETL jobs to verify execution and measure performance.
• Strong experience on RDBMS (DB2) with good PL/SQL concepts & strong DAX and SQL skills.
• ETL Development experience with strong ETL and SQL programming skills (TSQL& MySQL).
• Strong ETL testing experience and verification utilizing SQL querying skills (PL/SQL, Toad or other tools) and formal testing methodologies. Microsoft Office, and advanced data analytics using Microsoft Excel Power Query, Pivot tables, import/export, formulas, and conditional formatting. Experience in designing and developing analytical applications using Microsoft Power BI, Azure Data factory, Excel, and SQL Server Analysis.
• Experience with collaborating and interfacing project needs, business data requirements with multiple levels of management, vendors, and clients.
• Participate in the management of the VDP templates used at Vision. Develop rules used to validate data and transform client data.
• InRule Data development and business data automations with APIs and SSIS packages.
• Manage Rules Applications for both internal and client-facing systems.
• Work with developers to integrate with automated client systems and web portals. Secondary Responsibilities
• Participated in client-onboarding by assisting with the documentation process and requirements gathering related to client data.
• Executed daily, weekly, or one-off programs requiring SSIS applications or special database skills.
• Supported Vision clients by participating in weekly or other recurring meetings or conference calls.
• Supported other Vision departments with ad-hoc data or reporting requests. Microsoft Office, and advanced data analytics using Microsoft Excel Power Query, Pivot tables, import/export, formulas, and conditional formatting. Experience in designing and developing analytical applications using Microsoft Power BI, Excel, SQL Server Analysis. Managed file transfer automation experience: FTP, SFTP, PGP collaborating and interfacing project needs, business and data requirements with multiple levels of management, vendors, and clients.