Required experience: 10+ Years
Skills: Informatica 10/ 9.5/8.6/7.x (PowerCenter), Data Stage 8.1, Talend 5.0.2, Attunity, Golden Gate, SAP Business Objects, Power BI, ERWIN and SSIS, Oracle11g, Teradata, Hadoop, Hive, Sqoop and Flume, Windows, UNIX, and Linux
Requirement details:
- Must have experience n ETL Architecture, Development, Enhancement, Maintenance, Data Modelling and BI Reporting including Business & System Requirement Gathering of Enterprise Data Warehouses
- Sound knowledge on Investment Banking & Retail Banking Business, Financial concepts, Products & Services. Regulatory & Compliance, Risk Management, Business Intelligence, MIS, Data Lake (ODS), Data Warehouse / Marts, Modelling & Mapping, Governance, Privacy policies and FSLDM
- Ability to perform independent analysis, ask focused questions and rapidly gain in-depth understanding on various business requirements and deliver necessary solution using multiple technologies, straddling the line between IT and Business to help bridge the gap and improve efficiency.
- Experienced in project management, planning, resourcing, outsourcing, vendor negotiations & management, budgeting and implementing projects ensuring consistency with global strategy, goals, commitments, governance and controls using Waterfall and Agile model.
- Expert in SQL (Teradata, SQL Server, Oracle), ETL Tools (Informatica, Datastage, SSIS), BI Reporting tools (Cognos, Power BI, SSAS)
- Efficient in performing in-depth data analysis using SQL and tools with strong analytical, problem solving and critical thinking skills.
- Good understanding of business process, studying and analysing workflow to design solutions (As-Is and To-Be Analysis); conducting gap & impact analysis, assess scope of studies and suggesting the most suited solution.
- An effective leader with proven abilities in leading teams during the project phase, guiding members and enabling knowledge sharing among the team