Informatica ETL Lead
As a market leader, the talent and passion of our people is critical to our success. Together, we share a common set of values rooted in integrity, excellence and strong team ethic. Compamy can provide a superior foundation for building a professional career – a place for people to learn, to achieve and grow. A philosophy that balances personal lifestyles, perspectives and needs is an important part of our culture.
Technology works as a strategic partner with our business units and the world's leading technology companies to redefine how we do business in ever more global, complex, and dynamic financial markets. The company's sizeable investment in technology results in quantitative trading systems, cutting-edge modelling and simulation software, comprehensive risk and security systems, and robust client-relationship capabilities, plus the worldwide infrastructure that forms the backbone of these systems and tools. Our insights, our applications and infrastructure give a competitive edge to clients' businesses and to our own.
The Institutional Securities Technology division (IST) develops and oversees the technology strategy and bespoke technology solutions to drive and enable the institutional business and enterprise-wide functions. With a global footprint of around 4,000 resources, sourcing and managing our talent pool whilst responding the business demand is a complex and dynamic challenge.
Institutional Technology team is looking for an experienced Informatica Power Center and IDQ lead, for its Data Governance and Data Quality platform. The candidate will lead the global team (Canada, UK, India) of ETL developers using Informatica power center for its state of the art (constantly evolving) Data Quality and Metadata Management platform. The platform is currently used across many systems across the breadth of our Institutional Securities, Firm Risk, Finance, Compliance and Operations Technology. The platform is poised to grow through other areas of the firm and will be adopted by several other systems.
Such a growth needs an hands on experienced ETL developer to design and develop the necessary data mart data model to store exceptions raised, build and guide the challenging ETL layer to load data and glue the various components of end to end solution. The candidate will work with BI reporting area to generate various dashboards and other core team members for DQ rule design and execution.
This is a unique opportunity that will help the person see the panoramic view of data across a large financial firm like ours and various aspects of Trading, Booking, Risk, PNL and Accounting.
The candidate should be technically extremely talented, hands on, experienced in data mart fact / dimension table design, development of Informatica workflows to load data from files on other databases to the data mart. Experienced in Informatica Data Quality and Data profiling tools is a must. Ability to work is in a fast paced and multiple projects at the same time. Excellent leadership qualities to mentor junior resources and work with team members across regions. Should have can-do attitude and work with clients across the firm.
Experience in scripting languages like Python and Perl are very desired. Finance data domain understanding is also desired.
Bachelors or Masters degree with about 8 to 10 years of experience.
Informatica Power Center, IDQ, DB2, Linux, Perl , Python, working in unix environment. Experience in BI platforms like Qlikview and Tableau will be a plus