Senior Analyst - Compliance (SQL or Oracle)

Job Profile Position details: As a part of Compliance Technology, the Analyst will support multiple business lines through Development, Enhancement and Implementation of Core Compliance Solutions using vendor products like Behavox , Global Relay, Shell Scripts, Java, Oracle and related technologies. This individual will work closely with business analysts, developers, and modelers to understand requirements and create Functional Design Documents (FDDs), Detailed Design Documents (DDDs), Data Sourcing Documents (DSDs) and Unit Test Plans (UTPs). They will also support development and testing environments for Vendor solutions like Behavox / Global Relay and advise on necessary patches and upgrades. The Developer/Implementer partners with geographically distributed stakeholders across a variety of businesses and functions. Experience in various Software Development Lifecycle (SDLC) methodologies, including Waterfall and Agile, and having a good understanding of PowerShell Scripting, SQL programming and Unix Shell scripting is a must. Roles and Responsibilities: Responsible for creating Functional and Detailed Design documents, Software Configuration Plans and Unit Test Plans. Responsible for extraction, transformation and load of User data using Shell Scripting & Java. Responsible for administering and maintaining non-production environments. Create Behavox workflows, rule and dashboards. Work with Team and Implement Data Quality Checks. Experience implementing, programming, and administering Behavox. Quick to learn new process and technology and adapt to business needs and requirement. Customize Behavox Alert Generation Process modules to meet specific business requirements. Work With Business Stakeholders for Documentation of Standard Operation Procedure for IT Controls and Automate them using Shell Scripting, Java and batch processing. Responsible for ad-hoc data analysis reports to support production issues. Create UNIX shell scripts to call Batch jobs from scheduling tools like Tidal / AutoSys. Create scripts to handle calls between vendor modules. Analysis, preparation and update technical documentation within the project team following prescribed Bank technical policy and procedures. Identification and escalation of risks, issues, and blockers Collaboration with business analysts to understand requirements, review designs, conduct testing and demonstrate products. Proactive communication of compliance application changes to Operations & Technology and business stakeholders Mentoring and coaching team members and participation in all aspects of Vendor Products architecture, design, development and testing. Job Requirements: Bachelor's degree in Information Technology or Information Systems or Computer Science or related required 2 years of experience in software development in cross functional teams 2 years of experience implementing technology solutions at banks or financial institutions. 1 years of experience writing complex queries in Oracle, DB2 or SQL Server. 1 years of experience writing Unix shell scripts 1 years of experience writing Power shell scripts Any experience implementing and administering Core Compliance / AML / Sanctions/ Hot Scan. Good Understanding of Application Governance Process like Vulnerability Remediation, Disaster Recovery, Business Impact Analysis and others. Experience customizing Alert Generation Process modules and Alert Tunning. Experience using any BI Tool or other analytic reporting platforms. Experience with SAS, Actimize Case Manager and Actimize SAM is a plus. Well organized and demonstrates strong technical proficiency in system analysis and application design. Proven ability to learn new technologies quickly. Well organized and be able to simultaneously manage several disparate tasks over varying timescales. Self-motivated, and able to troubleshoot issues independently. Experience with both Agile and Waterfall SDLC methodologies In-depth knowledge of Compliance Risks and Risk Management, including Anti-Money Laundering. Excellent oral and written communication skills. Excellent analytical and troubleshooting skills. Experience writing FDDs and DDDs. Ability to prioritize, meet deadlines and manage changing priorities.

Location: bangalore, IN

Posted Date: 11/23/2024