Senior Application Consultant
Role: Senior Application Consultant
Experience: 10+ Years
Technical Skills:
ETL Tools : Informatica Power Center 9.1/10.5, IBM WebSphere DataStage 8.0.1/9.1.2PX
Programming Languages : SQL, PL/SQL
Big Data Tools : HDFS, Hive, Hue, Sqoop, Spark
Operating Systems : Windows, UNIX, Linux
Scripting Languages : UNIX, Shell Scripting
Databases : Oracle, Netezza, AS400
Decisioning and Analytics Tools : CMDS, SDS
Tools : BMC Remedy, Control-M, JIRA, Aldon, DevOps (CI/CD), SQL Developer, Toad
Key Responsibilities:
• Participate in end-to-end projects for system implementation of MLS system
• Engage and collaborate with Architects, Security and Development Lead to ensure solution design complies with enterprise design principles, security, and control standards
• Liaise with application teams across group and countries build the enhancements according to the technical solution plan
• Coordinate with Technology Delivery Manager and System Analyst to plan technical deliverables and schedule, perform design and development works to meet project requirements, and produce technical documents
• Escalate issues that impacts project schedule on timely basis and propose workarounds/resolutions
• Perform data profiling, cleansing, transformation and validation to ensure data quality and integrity throughout the shell scripts and ETL pipelines
• Test, maintain and recommend software improvements to ensure strong functionality and optimization
• Create and maintain technical documentation, including ETL specifications, data mappings, data dictionary, process workflows, data ownership and error handling procedures
• Implement project change request and in accordance with deployment schedule
• Partner with Test Management teams to ensure completion of SIT, UAT, performance / load testing and application security testing with quality result
• Facilitate and provide technical and testing support before and after production deployment
• Collaborate with cross-functional teams, such as data scientists, analysts, and business users, to understand their data requirements and provide support as needed
• Work with production support team members to conduct root cause analysis of issues, review new and existing code and/or perform sanity testing and unit testing
• Liaise with other units across IT and Business in the organization
• Manage external vendors for project delivery within schedule,
· Analyzing the impact for the existing models
· Analyzing business functions and process descriptions
· Product and application mappings creation
· Migration and Conversion of Citi history data to existing UOB data marts using ETL tools.
Generating Reconciliation reports
Key Requirements:
Must Have
• Bachelor's degree in computer science, information technology, or a related field
• At least 8 years of experience and knowledge in Control M, Unix Shell Scripting, and SQL
• At least 8 years of experience and knowledge in deployment process, create, manage and maintain CICD from source code repository, version control, code merge to deployment and housekeeping
• At least 6 years of experience in Hadoop, Hive, Hbase, HDFS and Data Engineering
• Experience in Bitbucket, Git, Jenkins, Artifactory and Aldon
• Experience in JIRA, Remedy and Incident Ticket management
• Ability to multitask effectively and handle large amounts of data
• Highly driven, pro-active and a strong team player
• Excellent interpersonal skills and written and verbal communication skills in English
Good to Have
• Experience in , Java, NoSQL
• Experience in System Interfaces (SFTP, FTP, Connect Direct, API, Rest)
• Experience in Confluence and SharePoint