Data Engineering ETL
Monterrey
Job No. r00105133
Descripción De La Posición
DARE TO BE A PART OF THE CHALLENGE! COME AND JOIN OUR TEAM TOGETHER WE CAN MAKE THE DIFFERENCE!
Did you know that Accenture is leading the digital transformation in the World?
Accenture is a leading global professional services company, providing a broad range of services and solutions in strategy, consulting, digital, technology and operations. Our main purpose is to collaborate with our clients, so they can become high-performance businesses. Accenture is present in more than 200 offices, 120 cities, 56 countries and approximately 390,000 employees worldwide.
Requisitos
The Data Modeler will create and refine conceptual, logical and physical data models. He or she gather requirements, analyze source data,
Responsibilities
- Create, enhance and maintain logical and physical data models in Erwin
- Gather and questions business requirements
- Contribute to strategic decisions arounds standards, tools and DWBI direction
- Partner with business owners and source systems to become an IT SME on your process area
- Collaborate with ETL developers, QA testers and dashboard developers
- Develop, modify and troubleshoot SQL, views and stores procs
Skills
- 3-5 years of experience implementing logical and physical design database designs
- Expert knowledge of data modeling tools (Erwin preferred)
- Excellent SQL skills including stored procedures, triggers and high availability design
- Extensive experience with RDBMS. Knowledge of database internals: partitioning, indices, star schemas, optimization, and parallel queries.
- Excellent critical thinking skills
- Strong knowledge of normalized and dimensional data models.
- AWS
- IPC
- Hadoop