Operations and Compliance Technology (OCT) is looking for an ETL developer for our Mumbai office. FinMet Platform is a key component of Enterprise Metrics & Analytics Practice Area within OCT.
This practice supports Global Operations and Finance Control Group by defining, acquiring, publishing, and analyzing an integrated set of key risk and performance metrics.
These metrics enable managers to make informed decisions, while executing the Firm?s objectives across the domains of Risk, Financial and Manpower.
The successful candidate will work with global teams spread across Mumbai and New York. You will get the opportunity to develop new streams, enhance existing streams and work on critical data sourcing aspect of the project.
You will also get the opportunity to work with upstream Technology teams, Report users (Sr. management), internal / external vendors, Support teams related to requirement, design, development and user support.
The successful candidate will display ownership attitude and will be responsible for
Design, coding, testing, tuning and maintenance of DB2 datamarts and Informatica code
Work directly with Modelers / Architects / DBA on data modeling, logical / physical schema design, SQL query tuning; and the application of data-
related business rules while assisting in troubleshooting, debugging, and issue resolution
Communicate effectively with end users, peers, and management regarding assignments, and must have a can-do attitude and a desire to provide solutions
Delivering projects with a high-level of data quality and integrity
Meet deadlines and possess a proven record of successful project execution and delivery.
Demonstrate knowledge of SDLC processes and procedures adjusted for a Rapid Application Development methodology (agile)
Provide support for the resolution of all reporting issues escalated by the Support Operations Team post-implementation.
Working with global development team to have designs implemented, tested, productionalized and present to user groups
Influencing decisions with divisional partners, internal teams, senior management, and external partners.
Collaborate with the team to define the information architecture, advocating interaction design best practices with a focus on consistency and usability
5-8 years of development experience in Informatica
Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
Experience in integration of data sources like DB2 and Flat Files into the staging area
Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing stages.
Good experience with ETL tools : Informatica or SSIS / Data Stage
Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
Good knowledge in designing audit / logging metadata for capturing operational metrics (runtime failures, record counts) and integrating with ETL flows for auto recovery, restart ability from point of failure
Experience in any scripting language like perl, shell, python to be used for automating data cleansing, data re-formatting
Expert knowledge of DB2, SQL Stored Procedures, Physical Modeling (partitioning, indexing), Triggers, and data querying optimization.
Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment
Clear understanding of RDBMS, ER, 3rd n forms, OLAP dimensional Models
Ability to effectively interact with, present information to, and respond to questions from all levels of the organization and partners.
Ability to communicate complex analysis in a clear, precise, and actionable manner
Comfortable with ambiguity, creative thinking and leading change
Financial Services experience will be a strong plus
Ability to research and troubleshoot technical problems