29 Etl Automation Jobs - Page 2

Qualification: Strong SQL and data transformation skills Experience in programming or scripting languages such as Python, C#, Java, JavaScript/TypeScript Understanding of ETL/ELT process fundamentals Experience in designing, developing, and maintaining robust and scalable test automation frameworks such as Playwright, Selenium, or Cypress Experience in testing of data with tools such as PowerBI, DBT, and Snowflake (nice to have) Experience with GitHub Actions or similar platforms for automating and managing test workflows. Responsibilities: Translate project requirements into effective and comprehensive test cases. Define clear testing objectives that align with overall project goals. Establish the testing scope, prioritizing critical features and functionalities. Document expected deliverables, such as detailed test plans , scripts , and reports . Use dbt to build tests that ensure the ETL process is working as intended Automate the common manual testing done by the QA through creating macros in dbt Build and monitor automated system health checks Collaborate with Enterprise Data Engineers to investigate the root cause of issues and suggest resolutions. Orchestrate data testing solutions using Airflow Be able to support the team in doing releases Develop and maintain test automation frameworks, integrating them with CI/CD pipelines. Collaborate effectively with developers to implement testing strategies at lower levels, facilitating a "shift left" approach and promoting early defect detection. Take ownership of application quality from requirements gathering through development and testing, ensuring a high standard of product excellence

Job Title:GN - SC&O - S&P – Spend Analytics – Senior Data Scientist Management Level:8 – Associate Manager Location:Gurgaon Must have skills:Data Handling, Data Classification, AI/ML Good to have Skills: Data Mining, Python Job Summary : As an Associate Manager in Spend Analytics and Senior Data Scientist, you will be responsible for leading the design, development, and implementation of AI/ML-powered procurement and analytics solutions. You will be working closely with cross-functional teams to conceptualize and deploy platforms that identify cost-saving opportunities, enhance supplier management, and deliver business intelligence to enterprise clients. Roles and Responsibilities: Data Handling Data Collection:Participate in calls with stakeholders (internal and external, based in the US) to gather data from various sources (email, Dropbox, Egnyte, databases). Data Audit:Lead assessment of data quality, identify gaps, and create summaries as per database requirements. Data Scrubbing:Assist with creating data cleansing rules and incorporate data clarifications provided by data source owners. Data Profiling:Assist with creating multi-dimensional data views, data analysis reports, and extracts. Data Classification: Spend Classification:Analyze procurement spend using several techniques to comprehensively classify into a custom taxonomy in Accenture's spend analytics tool. Enhancements:Diligently incorporate feedback and make recommendations for process improvement. Report Generation:Create specific and opportunity spend-assessment reports/templates. Periodic Refreshes:Lead discussions with US-based stakeholders for data gathering, data quality checks, control total validation, and spend classification. Advanced Analytics and AI/ML Develop custom data models and algorithms to apply to data sets. Use machine learning tools and statistical techniques to produce solutions to problems. Implement clustering and auto classification using predictive and supervised learning techniques. Design and implement complex data models from scratch. Develop and optimize ETL processes to ensure efficient data handling and processing. Create intuitive and effective front-end interfaces from scratch. Apply AI/ML techniques to optimize supply chain management, including demand forecasting, inventory optimization, and supplier performance analysis. Utilize advanced machine learning algorithms and statistics:regression, simulation, scenario analysis, modeling, clustering, decision trees, neural networks, etc. Develop and implement AI/ML models for predictive analytics and automated decision-making in supply chain operations. Industry Research Secondary Research:Conduct market research to create company and industry primers using online secondary data or information sources. Professional and Technical Skills Python:Hands-on experience with threading limitations and multi-process architecture. MySQL:Ability to integrate multiple data sources using MySQL. Strong coding knowledge and experience with several languages (e.g., R, SQL, JavaScript, Java, CSS, C++). Familiarity with statistical and data mining techniques (e.g., GLM/Regression, Random Forest, Boosting, Trees, text mining, social network analysis). Experience with advanced machine learning algorithms and statistics:regression, simulation, scenario analysis, modeling, clustering, decision trees, neural networks, etc. Coordinate with different functional teams to implement models and monitor outcomes. Develop processes and tools to monitor and analyze model performance and data accuracy. Excellent spoken and written English communication skills, with the ability to participate in global team calls. Additional Information: Work Experience:9-11 years of relevant experience in data modeling, ETL automation, AI/ML, and front-end design. Academic Qualifications:Bachelor's or Master's degree in Engineering, Mathematics, Computer Science, or a related field. Extensive experience in handling and classifying spend data using AI/ML Techniques. Strong leadership and team management skills. Proficiency in MS Excel and MS PowerPoint. High attention to detail, accuracy, and innovative problem-solving skills. Preferred experience in supply chain management, with a focus on applying AI/ techniques to optimize operations. About Our Company | Accenture Qualification Experience:9+ years Educational Qualification:Bachelor’s or Master’s degree

We are seeking a Backend and Data Processing Engineer to join our team. In this role, you will be responsible to develop CRM system on AWS for data integration from each ERP system and connecting with the messaging hub system. You will work closely with front-end developers, data scientists, and other stakeholders to ensure that our systems are scalable, reliable, and performant. You will be responsible in creating a robust and secure AWS-based data lake by collecting diverse data sources and standardization. Experience Level: 3 ~ 4 years. Key Responsibilities: Standardize data and store/manage it in an AWS-based data lake. Collect customer data such as reservations, memberships, and payments from ERP systems across various locations. Implement automation for data pipelines and data consistency verification logic. Design marketing triggers based on customer journeys and implement automated scenario execution logic. Integrate with internal messaging hub systems to automatically send personalized SMS, emails, and notifications. Design structures for collecting data on message delivery results and user responses. Required Skill Set: Proficiency in backend development using Python, Node.js, etc. Experience designing and developing RESTful APIs. Skilled in SQL-based data analysis and database design. Experience in collecting and standardizing data from external systems such as ERP. Familiarity with ETL automation and scheduling. Experience in integrating with messaging systems. Qualifications: Bachelor or Master's degree in Computer Science or related field. Relevant backend and data pipeline building experience is crucial. Prior experience on CRM systems development / integration is preferred for this position

•Candidate will be involved in both automated & manual ETL testing across multiple scrum teams. •Hands on experience in Writing SQL queries. •Good knowledge of writing python scripts. •Writing test scenarios and test scripts. Required Candidate profile •Good understanding of framework of ETL •Write SQL queries •Ability to write manual test cases from business requirements & technical specifications •Strong oral & written English communication skills