The bank for a changing world

We are looking for

Solution Architect

Contract

Standard / Permanent

Location

IN-MH-Mumbai

Job function

INFORMATION TECHNOLOGY

Reference

CIB003243

Essential Functions
• Demonstrate ability to influence change, define standards and follow industry best practices for ETL Development;
• Accountable for the metadata management practices and Informatica metadata management platform implementation of the organization;
• Ensure all efforts related to data quality and metadata management are planned for and executed during the SDLC;
• Demonstrate hands-on approach to implement data and information solutions that meet or exceed organizational initiatives and are consistent with enterprise architectural standards;
• Coach and mentor ETL Developers and collaborate with Business Analysts, Data Modelers, SMEs and Data governance liaisons to achieve a very good understanding metadata and data quality requirements and then design and develop sustainable ETL applications to address those requirements.
• Analyze data-related systems integration opportunities and challenges
• Validate data models from Data Integration perspective for current projects as well as other impacted projects;
• Drive the improvement of data quality and practices related to it in the EDW;
• Manage the Integration Ecosystem and ensure software is up to date and is able to scale;
• Conduct impact assessment and determine size of effort based on requirements
• Perform an active, leading role in shaping and enhancing overall ETL Informatica architecture.
• Assist and verify design of solution and production of all design phase deliverables.
• Manage build phase and quality assurance of code to ensure fulfilling requirements and adhering to ETL architecture.
 
Skills
• Familiarity with Retail and Commercial and Consumer lending as well as Deposits;
• Very Strong implementation experience and deep knowledge in Data Integration, Data Quality, Metadata Management and understanding of information reporting objective on Informatica platform
• Broad experience setting up Informatica Data Quality/Analyst
• Vast knowledge and hands-on experience configuring Data Quality scorecards, defining/recommending data quality rules and monitoring such quality indicators;
• Strong experience setting up, configuring and using data profiling tools (Informatica Data Explorer);
• Deep expertise in Informatica Data Integration platform architecture, configuration, best practices;
• Broad experience setting up Informatica Metadata Manager;
• Proven ability to translate business term definitions into a centrally managed business glossary;
• Demonstrated knowledge of the Metadata Integration process;
• Proven ability to manage a enterprise-wide environment with numerous users and systems;
• Previous Integration of Metadata Manager with Oracle, Hyperion, OBIEE, Erwin Model manager and any other custom data resources is a plus;
• Very good communication skills to ensure transfer of knowledge and best practices to Integration developers;
• Hands on experience on Informatica B2b implementation for handling complex source data
Experience in as data obfuscation and data masking is preferred
Experience in designing/implementing Data integration solutions for CCAR is highly desirable.
 

Education:
 Bachelor’s Degree in Systems Analysis, Computer Science, Software Engineering, Information Systems ,Financial systems and accounting or equivalent combination of education and experience required
 Master’s/Advanced Degree in Business preferred
 
Required Experience:
• 12+ years of Information Technology experience with 8+ years of Data Warehouse and data integration  experience (Data Warehouse, ETL tools, data quality, metadata management) using Informatica as ETL/Data Integration tool
• 5+ years of proven experience in implementing metadata management and data quality projects
• 5+ years in banking and financial services is preferred
• 5+ years of experience in a senior ETL developer/architect role
• 3+ years of experience deploying large scale projects using Informatica Master Data Management and Informatica Data Quality
 
 
Give us your feedback Complete our survey