Role Proficiency:
This role requires proficiency in data pipeline development including coding and testing data pipelines for ingesting wrangling transforming and joining data from various sources. Must be adept at using ETL tools such as Informatica Glue Databricks and DataProc with coding skills in Python PySpark and SQL. Works independently and demonstrates proficiency in at least one domain related to data with a solid understanding of SCD concepts and data warehousing principles.
Outcomes:
- Collaborate closely with data analysts data scientists and other stakeholders to ensure data accessibility quality and security across various data sources.rnDesign develop and maintain data pipelines that collect process and transform large volumes of data from various sources.
- Implement ETL (Extract Transform Load) processes to facilitate efficient data movement and transformation.
- Integrate data from multiple sources including databases APIs cloud services and third-party data providers.
- Establish data quality checks and validation procedures to ensure data accuracy completeness and consistency.
- Develop and manage data storage solutions including relational databases NoSQL databases and data lakes.
- Stay updated on the latest trends and best practices in data engineering cloud technologies and big data tools.
Measures of Outcomes:
- Adherence to engineering processes and standards
- Adherence to schedule / timelines
- Adhere to SLAs where applicable
- # of defects post delivery
- # of non-compliance issues
- Reduction of reoccurrence of known defects
- Quickly turnaround production bugs
- Completion of applicable technical/domain certifications
- Completion of all mandatory training requirementst
- Efficiency improvements in data pipelines (e.g. reduced resource consumption faster run times).
- Average time to detect respond to and resolve pipeline failures or data issues.
Outputs Expected:
Code Development:
- Develop data processing code independently
ensuring it meets performance and scalability requirements.
Documentation:
- Create documentation for personal work and review deliverable documents
including source-target mappings
test cases
and results.
Configuration:
- Follow configuration processes diligently.
Testing:
- Create and conduct unit tests for data pipelines and transformations to ensure data quality and correctness.
- Validate the accuracy and performance of data processes.
Domain Relevance:
- Develop features and components with a solid understanding of the business problems being addressed for the client.
- Understand data schemas in relation to domain-specific contexts
such as EDI formats.
Defect Management:
- Raise
fix
and retest defects in accordance with project standards.
Estimation:
- Estimate time
effort
and resource dependencies for personal work.
Knowledge Management:
- Consume and contribute to project-related documents
SharePoint
libraries
and client universities.
Design Understanding:
- Understand design and low-level design (LLD) and link it to requirements and user stories.
Certifications:
- Obtain relevant technology certifications to enhance skills and knowledge.
Skill Examples:
- Proficiency in SQL Python or other programming languages utilized for data manipulation.
- Experience with ETL tools such as Apache Airflow Talend Informatica AWS Glue Dataproc and Azure ADF.
- Hands-on experience with cloud platforms like AWS Azure or Google Cloud particularly with data-related services (e.g. AWS Glue BigQuery).
- Conduct tests on data pipelines and evaluate results against data quality and performance specifications.
- Experience in performance tuning data processes.
- Proficiency in querying data warehouses.
Knowledge Examples:
Knowledge Examples
- Knowledge of various ETL services provided by cloud providers including Apache PySpark AWS Glue GCP DataProc/DataFlow and Azure ADF/ADLF.
- Understanding of data warehousing principles and practices.
- Proficiency in SQL for analytics including windowing functions.
- Familiarity with data schemas and models.
- Understanding of domain-related data and its implications.
Additional Comments:
Migration Consultant Role: Responsibilities Required During the Migration: Meet with all of our customers to help them re-setup their instance in AWS. This individual will work with the PM to understand the customer’s unique integration setup and the PM will provide a check-list of items unique to the customer that need to be reconfigured to complete the migration. Work with project team to identify customer’s custom integrations and with Migration Engineer develop a plan for migration Educate customers on how to set up SSO (ADFS, Azure, Okta, OneLogin, Google SAML, etc) and 3rd party integrations (i.e., SharePoint, Confluence, Google Drive, Slack, Box…etc.,) Assist in manage enterprise level customer relationships and address customer escalations Demonstrate migration process best practices applied across a breadth of technologies to solve problems, articulate and translate technical customer issues to engineering team Validate recon report to confirm migration success with customer Advise customers on the differences business process changes between the two Simpplr platforms (SFDC & AWS) Assist the customer with technical troubleshooting in both SFDC and AWS environments during the migration process Collaborate with the customer to understand technical issues to translate requirements to internal Simpplr program manager, product teams and engineering teams Identify areas to improve process efficiency and communicate items to Program Manager to resolve Migration Consultant Qualifications: 5+ years of hands-on technical implementation or consulting experience 3+ years of experience in customer/partner facing in technical positions Bachelor's Degree in Technical Discipline or related field Experience with large scale / enterprise customers Experience leading the process of executing on migrating from SFDC to AWS cloud systems Strong verbal and written communication skills; high degree of comfort with technical and customer audiences Excellent problem-solving skills and the ability to troubleshoot complex technical issues Led a SaaS based product migration Strong interpersonal & communication skills; able to quickly establish a trusted advisor relationship with customers
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.