HCLTech | Transformation Consultant | chennai

MegaWalkin Drive in HCLTECH for BITS skillset on 12-Nov-24 to 13-Nov-24Interview Location- HCL Technologies Ltd. ETA 3- Techno Park, Special Economic Zone, 33, Rajiv Gandhi Salai, Navallur Village and Panchayat, Thiruporur Panchayat Union, Navallur, Tamil Nadu 603103Interview Timing- 11.30 am to 2.00pmContact Person- Nandhinee HR Total Experience- 3 - 5 YearsMandatory Skillset:Visual Basics,SQL,Expertise in Excel and other MS PackagesAdded advantage (Experience in Python and Power BI)Candidate with above mandatory skillset alone eligible for interviewKindly bring the updated resume and ID proof.BITS Job DescriptionJob highlightsCollaborate with stakeholders for requirement gathering, translating business problems into technical requirement and implement automation utilities.Expert in Visual Basic, SQL, Power BI, Excel Automation and hands on experience in Excel functions and formulas.Key SkillsQuery Optimization, Business Intelligence, RPA, LCA, MS SQL, Power BI, Big Data, Data Visualization, SQL Server, Visual Bacis, UI Path, Automation Anywhere and Excel Formulas,Job DescriptionDeveloping the utility tools independently on MS Access and MS Excel platforms.Strong Knowledge of Tool Development, End to End Automation and Tool Quality assurance best practices and methodologies.Strong Knowledge of MS applications (Excel, Access, PowerPoint, Word, Outlook).Strong understanding of different platform tool development and automated tools.Strong analytical skills and experience with implementation and administration of Tool quality assurance metrics.Automation development knowledge with VBA & SQL.Familiar with Excel Functions, Formula, Form Creation.Ability to design and build MI reports and dashboards that present accurate MI that is simple and easy to understandWorks with projects, operations, and technical teams to understand processes and underlying requirement at very granular level to build utility delivery to meet and exceed requirementsStrong attention to detail and ability to create sustainable automated processesBuilds in preventative and detective controls to manage risk to accuracy and timeliness of MI developmentsStrong excel skills including VBA, pivots, chartsStrong Microsoft power BI (or equivalent) and PowerPoint skillsStrong data ETL and manipulation skillsStrong SQL and SQL server skillsAbility to access and extract data from various source systems to transform, manipulate, analyze and Organised and able to meet tight deadlinesStrong documentation skills to ensure processes are robustly maintained and data is kept up to dateWorks with technical teams to quickly resolve data load issues and get to root cause fixes to prevent recurrenceAbility to develop sustainable automated solutions that require little or no manual intervention AGG