Accenture is a global management consulting, technology services and outsourcing company, with more than 305,000 people serving clients in more than 120 countries. Combining unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the world’s most successful companies, Accenture collaborates with clients to help them become high-performance businesses and governments. The company generated net revenues of US$30.0 billion for the fiscal year ended Aug. 31, 2014. Its home page is www.accenture.com.
ETL/BI Consultant
Workplace: Warszawa
Nr Ref.: 00415313
Accenture has an over 25 years of experience on Polish market:
- Support of 9 out of 10 technology mergers in Poland
- Facilitation of 80% of mobile calls in Poland by systems implemented by Accenture
- Most complex IT transformations in Poland
- 60% of current accounts in Polish banks work on systems implemented by Accenture
As the ETL/BI Consultant you will:
- Design and implement medium and large scale Data Warehouses, Management Information Systems, analytical repositories (CRM, subject oriented Data Marts) and operational data stores
- Design and implement data migration and conversion processes for medium and large scale Enterprise Transformation Projects
- Design logical and physical data models for normalized and multidimensional repositories
- Design and implement ETL processes
- Design and implement tools, processes and methods supporting Data Quality monitoringand management
- Assess ETL processes performance, recommend improvements and fine tuning
- Plan, prepare and execute automated and manual tests of ETL processes
Qualifications:
- Minimum1 year of experience with design and implementation of Decision Supporting Systems (Data Warehouse, Management Information System, subject oriented DataMarts) in ETL and data modeling areas
- Solid knowledge of multidimensional modeling patterns including fact tables, slowly changing dimensions, star and snowflake schemas
- Solid knowledge of one or more of the leading RDBMS platforms (e.g. Oracle, DB2, MSSQL Server). Solid knowledge of Teradata would be considered as an additional asset.
- Knowledge of one or more of column oriented RDBMS platform (e.g. Netezza, SAP IQ and HANA) would be considered an asset
- Solid knowledge in physical data model design
- Excellent command of SQL
- Extensive knowledge of one or more leading ETL platforms (e.g. Informatica PowerCenter, AbInitio, IBM Data Stage, Oracle Data Integrator, SAS Data Integration Studio,Microsoft SQL Server Integration Services)
- Solid and practice knowledge related to ETL processes and architectures: operations metadata, surrogate keys management, data quality monitoring, data cleaning and conforming, data lineage, etc.
- Knowledge of banking services business and operating model would be considered an asset
- Strong problem-solving skills combined with theability to creatively untangle complex issues and develop innovative and efficient solutions within a narrow time frame
- Very good knowledge of English - level enabling fluent communication with the client
- Ability to meet travel requirements when applicable. Head office is located in Warsaw
As our Employee you are entitled to have great benefits:
- Competitive salary, private medical care, multisport card, lunch card
- Life insurance and personal accident insurance
- Corporate credit card AMEX Gold
- Large and impressive technology stack
- Training and development opportunities - several thousand interactive courses
- Work in international teams with dedicated colleagues who are experts
- Clear career path
- Possibility to work on various projects within Poland and abroad