Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | Bangalore |
Education | Not Mentioned |
Salary | Not Disclosed |
Industry | IT - Software |
Functional Area | General / Other Software |
EmploymentType | Full-time |
Job ResponsibilitiesJ D :-1. The ETL Lead Analyst will be responsible for analyzing the business requirements design develop and implement highly efficient highly scalable ETL processes Candidate is required to perform daily project functions with a focus on meeting the business objectives on time in rapidly changing work environment 15 years of experience as ETL Lead Analyst in Banking Domain .2. Thorough understanding of DWH and BI Dashboard Reporting concepts.3. Thorough understanding of Credit Risk and Operation Risk Understanding of Data Models Conceptual Logical and Physical Dimensional Relational Data Model Design Develop detailed ETL specifications based on business requirements Analyze functional specifications and assist in designing potential technical solutions Identifies data sources and works with source system team and data analyst to define data extraction methodologies.4. Proficient in ETL Informatica OFSSA Proficient in Greenpum Wherescape Defines develops documents and maintains Informatica ETL mappings and need to be well versed in Unix shell scripting.5. Good knowledge in writing complex queries in DB2 Oracle PLSQL Unit Integration testing activities and assist in User Acceptance Testing Maintain batch processing jobs and respond to critical production issues communicate well with stakeholders on his her proposal recommendations Knowledge status risks regarding delivering solution on time Data Analysis Data Profiling Root Cause Analysis Source to Target Mapping.6. Should able to understand Data Warehouse architecture and code Should able to understand Banking system processes and data flow lead and mentor the team of around 50 Resource Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels.7. Extensive experience implementing relational database designs data warehousing data architecture data modeling including strong knowledge of various data modeling approaches and practices experience with 3NF star schemas and multi dimensional designs.8. Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels Extensive experience implementing relational database designs data warehousing data architecture data modeling including strong knowledge of various data modeling approaches and practices experience with 3NF star schemas and multi dimensional designs.,
Keyskills :
sqljava reportingmentoring root cause analysisuser acceptance testing data warehouse architecturedata flow