Experience: 10+ Years
Role: Developer
Key Skills:
SQL Server, Informatica, Windows Scripting, Windows Server 2012/2016, SQL Server 2016, PowerShell Scripting, Power BI, SSIS, SSRS, IIS, Networking, Connect Direct, SFTP, Control-M, Aldon, SQL Server Performance tuning, Citrix, WebSphere, Tomcat
Key Responsibilities:
• To enhance and develop projects/Change Requests related changes and to ensure deliverables are in good quality
• To participate in user requirements gathering and able to provide impact analysis and efforts estimation
• To develop functionalities to cater for business requirements using Windows Scripting, SQL
• To design and build the Control-M jobs for batch processing
• To carry out unit testing and SIT on the developed functions
• To support UAT cycle, troubleshoot the issues and provide bug fixes
• To raise remedy ticket for required changes in controlled environments
• To migrate deliverables objects using Aldon migration tools to UAT/Production environment
• To provide proper documentation for all the deliverables
• To be able to work with team member, guiding junior staff and take responsibility for delivery of the code
Key Requirements:
• Developer experience in SQL Server, Informatica
• Good knowledge of SQL database
• Proficient with Batch & Power Shell scripting
• Good understanding in Data Warehouse and Data Mart concept
• Experience in Performance tuning of queries
• Good knowledge on SSIS & SSRS - ETL transformation & Reporting purposes