Skill: sql , unix scripting , java , debugging , pl / sql , problem solving , technology , it , environment , written communication , oracle sql; Exp: 8-11 years; Development Lead (Technology & Operations / Technology Services / Development / J040)-(1800020627) JobTechnology Primary LocationASEAN & South Asia-India-Bangalore ScheduleFull-time Employee StatusPermanent Posting Date27/Jun/2018 Unposting DateOngoing Leading the way in International Banking. We support the people and companies driving investment, trade and wealth creation across Asia, Africa and the Middle East. And our heritage and values are expressed in our brand promise here for good. Strong analytical and problem solving skills Ability to learn and adapt to new technologies and frameworks Good verbal and written communication skills Good understanding of software development lifecycle using Agile/Waterfall models Good knowledge on object oriented analysis and design Good programming and debugging skills Experience in requirements gathering, design, and development reviews Experience in Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Experience in Performance tuning, Optimization of ETL Jobs 8 Years of experience in ETL – Informatica Power centre tool for Client Due Diligence & On-boarding data migration Ability to be a leader and be independent in delivering the stream of works Technical Competence Informatica Power center – ETL tool expertise in data ware housing and data migration. Hands-on experience in developing ETL process, ETL architecture design, debugging and performance tuning of mappings and sessions. Designing logical and physical data models after analyzing and understanding the Business processes in detailed Hands-on experience in Informatica in creating Mappings to load data from various sources using different transformations like Expression, Lookup, Aggregator, Update Strategy, Joiner, Normalizer, SQL, Java, Filter, Router, Union Transformations etc. Creating re-usable components for transformations, Mapplets and Worklets wherever it is necessary using Informatica Power center Strong programming experience in Oracle SQL and PL/SQL Hands-on experience in Unix Scripting in processing the ETL workflows, Source/Target File Validation and necessary scripting skills. ETL Performance Tuning and the Database tuning discussion with the application team members and DBA. Hands on experience on BigData Hands on experience in Data Quality (OEDQ, IDQ), Reporting (Microstrategy) is desirable but non mandatory Standard Chartered is committed to diversity and inclusion. We believe that a work environment which embraces diversity will enable us to get the best out of the broadest spectrum of people to sustain strong business performance and competitive advantage. By building an inclusive culture, each employee can develop a sense of belonging, and have the opportunity to maximise their personal potential.
Function: IT Software : Software Products & Services