
Prior experience in data quality and data stewardship functions is a plusīachelors/Masters Degree in Engineering, preferably Computer Science/Engineering, from a top tier Universityīackground in Financial Services requiredĮxcellent communication skills in English language are essential, both written and oral Knowledge of retail broker dealer business back-office operations and trade processing familiarity with a wide range of financial instruments such as stocks, options, mutual funds, fixed income

SQL Server, Sybase)Įxperience in BigData technologies like Hadoop, HBase, Hive, HDFS TeraData and Informatica is a mustĭemonstrated expertise with the some of the following tools/languages/disciplines: data modeling, data profiling, relational database SQL (e.g.

Interface with the business team and business analysts, support QA & UAT Testing, deployment, and Level 3 support for Data & ETLĪ minimum of 10 years of experience in IT, 5 years in Retail Brokerage ITĮxcellent knowledge of and experience with data warehousing/data marts concepts and practices viz. Provide support to the Business in adhoc query space Stay up to date on the evolving data architecture of the Insights applications Productionize the ETL changes by going through the review and approval processes by interfacing with different teams like engineering, operations and DBAs Provide support to the different Insights and non-Insights dev teams for their data needs Understand the requirements, design and implement data sourcing solutions by doing data modeling and implementing ETL using technologies like TeraData, Informatica and TWS Work in a globally distributed team that will deliver Business driven projects and IT solutions for Data & ETL requirements for Insights and non-Insights spaces Understanding of the agile development methodology Proactively identify improvements and address them through independent thinking within a consensus driven teamĢ+ years experience in financial services with a focus in Securities Processing Interface with external vendors and their technical support and development organizations ensuring focus to resolution of issues and strategic enhancements Navigate the wider technology organization build relationships to help manage the team’s agenda with our critical technology partners Relationship management internally with the back office, trade support, and at times front office teams Ownership and participation in the Incident and problem management processes, being accountable for resolution, root cause analysis and technology and business reporting and communication Work with other Back Office Technology teams to make appropriate changes that will enhance the stability of the overall environment Troubleshooting business issues, solving problems to provide solutions to diverse teams and the product aligned support areas
#JUNIOR PL SQL DEVELOPER JOBS IN USA SOFTWARE#
Understanding of software development methods, including AgileĪpplication Development of related projects/enhancements/bug fixes for the accounting platform, including interfacing with Operations and other business users Good understanding of the software project lifecycleĪsset Management and/or Financial Services experience desirable
#JUNIOR PL SQL DEVELOPER JOBS IN USA PLUS#
Knowledge of Unix and shell scripting skills are a plus Strong experience in writing ANSI SQL code, as well as the ability to design and implement functional, stress and regression tests to assure correct operation of application Strong database experience working with various RDBMS platforms knowledge of Oracle 10g/11 and Sybase 12x

Strong experience of data warehouse solutions using implementations of star and snowflake schemas Minimum 1 year experience in design and development of Business Intelligence solutions, using Business Objects or Cognos Knowledge of industry best practices for ETL and the common approaches to data warehouse architectures Minimum 3 years experience using Informatica PowerCenter 8.6 or higherĮxperience using Informatica to interface with Salesforce is highly desirableĮxperience in optimizing/tuning ETL objects, indexing and partitioning for better performance and efficiency Minimum 5 years experience developing ETL solutions for data warehouse environments Perform general system maintenance and support as necessary Analyze requirements and develop ETL/BI reports with minimal supervisionĭesign and develop BI programs with consideration to data quality, data integrity and performanceĭesign and develop database objects with consideration to best practices and reporting needsĬonduct unit testing and participate in integration and system testing as required
