BA – Financial Securities
Job Description
Position Overview:
We are seeking a detail-oriented and analytical professional to validate business logic during the migration of financial securities data from an Oracle database to a Snowflake environment. The ideal candidate will have a solid understanding of both financial data structures and business rules, ensuring data integrity and accuracy throughout the migration process.
Key Responsibilities:
* Business Logic Validation:
– Verify that all business rules, calculations, and data transformations are correctly applied in the Snowflake environment.
– Ensure consistency between Oracle and Snowflake databases, including matching data formats, precision, and financial metrics.
– Understanding of financial securities, including equities, bonds, and derivatives, life cycle
* Data Integrity Checks:
– Identify and troubleshoot discrepancies in securities data between Oracle and Snowflake.
– Validate data completeness, accuracy, and compliance with regulatory and business requirements.
* Testing & Reporting:
– Validate test cases to confirm the migration aligns with business logic requirements.
– Develop SQL scripts to validate data correctness and transformations.
– Analyze & Validate test results, including issues identified and recommendations for resolution.
* Collaboration & Communication:
– Collaborate with data engineers, analysts, and business stakeholders to understand business logic requirements.
– Work closely with IT teams to align expectations and resolve issues promptly.
* Documentation:
– Maintain detailed documentation of validation processes, test results, and data issues encountered during the migration.
Qualifications:
* Bachelor’s degree in finance, Computer Science, Data Analytics, or a related field.
* Understanding of financial securities, including equities, bonds, and derivatives.
* 3+ years of experience with financial data, data migrations, or database management.
* Strong knowledge of Oracle and Snowflake databases.
* Proficiency in SQL and experience with query optimization.
* Excellent analytical and problem-solving skills with high attention to detail.
* Strong communication skills and ability to collaborate effectively with cross-functional teams.
Preferred Skills:
* Experience with Oracle, Snowflake, ETL tools and processes, Oracle to Snowflake Migration
* Knowledge of data governance, compliance, and regulatory frameworks in financial markets.
* Familiarity with Python or other scripting languages for data validation.
About the Company:
Our Company applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to us and is reflected in our ’ Front2Back™ Transformation approach. Front2Back™ uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. Our’ Service Transformation approach helps ‘shrink the core’ through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Our’ core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients.
