2nd Round In person
Need the candidate from TX who can go onsite for an interview.
Hybrid 1/2 days onsita a week.
Team Overview: IT Team in Customer Experience data
NOTES:
- Skill matrix must be matching with the resume.
- C2H role (12 months with chance to convert)
- Currently on Ab Initio/ Teradata and moving to AWS/ keeping Ab Initio
- Ab Initio is a MUST have as that is the main ETL tool
- Strong with SQL
- The transition to Redshift will be a bit part of this role in addition to standard ETL/ Data Warehouse duties
- Bachelor's Degree required
- Teradata experience required (Redshift they can train)
- Tivoli scheduling tool experience is highly preferred
- Kafka, Spark and Glue will in future be in the tech stack
Required:
- Ab Initio
- SQL
- Redshift or Teradata
- Python
- S3
Preferred:
- Tivoli or other scheduling tool
- Kafka
- Spark
- Glue/ EMR
- Lambda
- AWS Step Functions
Job Description:
- Work on complex problems, where analysis of situations or data requires an in-depth evaluation of multiple factors.
- Lead and/or provide expertise to functional project teams and participate in cross-functional initiatives.
- Provide direction and guidance to process improvements, including helping to establish/advise on policies.
- Work with a number of external vendors, helping to provide them with effective solutions and insights.
- Use independent judgment within broadly defined policies and practices, including determining the best method for accomplishing work.
- Assemble large, complex sets of data that meet non-functional and functional business requirements
- Identify, design and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
- Build required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies
- Build analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition
- Work with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues
- Work with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues
- Generate or adapt equipment and technology to serve user needs
- May perform other job duties as directed by Employee's Leaders
- Knowledge of the practical application of engineering science and technology, including applying principles, techniques, procedures, and equipment to the design and production of various goods and services
- Knowledge of design techniques, tools, and principles involved in production of precision technical plans, blueprints, drawings, and models
- Ability to use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems
- Ability to understand the implications of new information for both current and future problem-solving and decision-making
- Skilled in identifying complex problems and reviewing related information to develop and evaluate options and implement solutions
- Ability to tell when something is wrong or is likely to go wrong. It does not involve solving the problem, only recognizing there is a problem
- Ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events)
- Ability to shift back and forth between two or more activities or sources of information (such as speech, sounds, touch, or other sources)
- Ability to arrange things or actions in a certain order or pattern according to a specific rule or set of rules (e.g., patterns of numbers, letters, words, pictures, mathematical operations)
- Ability to identify or detect a known pattern (a figure, object, word, or sound) that is hidden in other distracting material
Skill Highlights- please indicate the # of years on each of the following skills:
- Ab Initio
- SQL
- Redshift or Teradata
- Python
- S3
- Tivoli or other scheduling tool
- Kafka
- Spark
- Glue/ EMR
- Lambda
- AWS Step Functions