Project Delivery Manager- ETL Architect

Are you an experienced, passionate pioneer in technology who wants to work in a collaborative environment? As an experienced Project Delivery Manager - ETL Architectyou will have the ability to share new ideas and collaborate on projects as a consultant without the extensive demands of travel. If so, consider an opportunity with Deloitte under our Project Delivery Talent Model. Project Delivery Model (PDM) is a talent model that is tailored specifically for long-term, onsite client service delivery.
The team
This is a hands-on position where you will be empowered to be creative, ambitious, and bold; to solve novel problems and have the potential to directly impact the lives of people around the world. We have impressive toolkits and clients with world class data, and we are now looking for talented people to join our team.
Client account has a multi-year tech foundry setup to help client with testing, development, and automation of solutions across the portfolio. Clients' Personalization Real-Time (PRE) program is key to accomplishing several key strategic objectives for cross-sell, upsell, and efficient targeting. US Cellular needs a strong and reliable partner to support Development, Testing and Managed Services on the PRE platform. Objective of the project is to provide comprehensive development & managed services support for the PRE platform and adhere to the SLAs to ensure the platform can deliver the PREprogram objectives. ADMS project for Verizon supporting and testing custom applications.
Work You'll do/Responsibilities:

• Ensures adherence to Enterprise data movement, quality, and accountability standards in technology
• Conducts data driven analyses of usage of detailed data elements across the business domain to provide optimal data provisioning patterns across the application space.
• Responsible for independently conducting quantitative analytics
• Leads efforts in development of new models, analytic processes, or system approaches
• Creates documentation for all activities and may work with technology staff in design of any system to run models developed
• Performing current state data architecture and tooling assessment across all data domains supported by control functions
• Developing high-level Data master plan and a roadmap to advance data architecture and tooling strategy
• Establishing data architecture & tooling best practices and participating in project architecture / design reviews to ensure consistency and standardization
• Requirement Gathering: Understand, Interpret, and clarify Functional requirements as well as technical requirements.
• Understand the overall system landscape, upstream and downstream systems.
• Understand ETL tech specifications and develop the code efficiently
• Demonstrate Informatica Cloud features/functions to the achieve best results
• Performance tuning, pushdown optimization in IICS
• Review and optimize ETL tech specifications and code developed by the team. Ensure alignment with overall system architecture and data flow

Qualifications
Required

• 12+ years of IT experience in Data Engineering, Data Quality, Data Migrations, Data Architecture, and Data Analytics. Must have worked in producing architecture document for small to large solution implementations.
• Consulting experience
• Strong ETL development and architecting experience.
• Strong SQL and Python skills.
• Ability to demonstrate Informatica Cloud features/functions
• Rich data warehouse experience.
• Hands-on design and implementation experience with one/more of the following data tools:
• Data Analysis / Profiling - Python (Jupyterlab, PyCharm, etc.), Toad, MySQL
• Data Platforms - Hadoop, Spark, Oracle, Exadata, SQL Server, DB2, MongoDB, Teradata, etc
• Data Transformation - Informatica, SSIS, Alteryx, Trifacta etc
• BI - Tableau, MicroStrategy, metadata/lineage tools, Distributed Caching tools
• Strong knowledge of database modeling principles, techniques, and enterprise data management best practices
• Ability to communicate technical concepts and implications to business partners

Preferred

• Exposure to Talend, GCP BQ, SQL and UNIX scripting.
• Exposure to Python and Shell Scripting, Control-M, GCP Data Flow, GCP Composer