21 Apr
Datawarehouse Lead
Vacancy expired!
- Bachelors or Master’s degree in computer science or related discipline.
- 10+ years of progressive software development experience in ETL with last 4 years in Informatica development.
- 2+ years of experience in Data and Analytics using any of the tools like Tableau, Qlik, Power BI or SSRS
- Expert in writing efficient Analytic and windowing functions in Oracle.
- Expertise in writing and tuning complex SQL
- Experience working and requirement gathering with BI teams for reporting dashboard on any of the tools such as Tableau, Looker, Power BI or Qlik
- Expertise in using partitioning, transformations, incremental caching in Informatica toolset.
- Expert understanding of slowly changing dimensions (SCD's) in Informatica.
- Expert understanding of join logic and query optimization in Informatica
- Experience with stored procedures, Triggers, PL/SQL in Oracle.
- Extensive Business and/or technical background in the areas of Data modeling, EDW, Data Mart, Master Data Management, Metadata management, Data Quality, Data Governance, Data integration (ETL) and Data Security
- Must have experience in onsite/offshore model, handling a team of 3-5 offshore team members
- Must have exp in Agile projects and be able to meet the demand of agile environment
Vacancy expired!