Sr Etl/ Data Engineer

**Who is DigitalOnUs by Tech Mahindra?**At DigitalOnUs by Tech Mahindra, we not only provide Agile and DevOps methodologies to our customers, we have adopted the same within the company as well.Our nimble processes are not mired in red tape, yet robust, flexible and result-oriented.We are Software Engineers, Technical Architects, Cloud and DevOps specialists.But the most important, we are dreamers, creators and challengers.Each day, we strive to make great come alive.Our lemma: "work smart and play hard"Our technology partners are **Hashicorp, Cloudbees, Chef, Pagerduty, Docker** and **SAP**.We're looking for a passionate, **Sr.** ETL/ Data Engineer** who have hacked systems in creative ways, who are curious about new languages, technologies, and trends.We believe that working hard is a byproduct of loving what you do and not something that can be me assured on a timesheet.**Location Remote**:Mexico, Guadalajara / Monterrey / Saltillo****Role requirements**:- 5+ years of software product development and delivery experience- 4+ years of ETL testing/SQL experience- 3+ years of Informatica Power Center, IDQ experience- 3+ years' experience overseeing the development of data test plans, test scenarios, testcases, execution of test case and documentation of test results- 2+ years of experience in some of the Azure Cloud tools: ADF, Pyspark, databricks notebooks- Experience with Python and libraries like Panads, Numpy & Matplotlib.- Ability to interpret and drawSystem & Architecture diagrams.- Familiar with Latest Cloud Technologies- Experience in summarizing large number of metrics into meaningful graphs and reports**Skills/ Experience Requirements**:- Experience in Data Testing, Data Conversion, Data Migration, Data Transformations, Data Profiling, Data Analysis and Data Quality Validation- Experience in testing of ETL Mappings to extract data from multiple sources like Oracle, SQL Server, Flat files etc. into target tables using transformations.- Hands on experience in design and implementation of E2E Data testing strategies and developing data testing automation frameworks.- Work on End-to-End product feature testing and Business Report Testing.Designing, testing, and troubleshooting data and reports.- Knowledge of any of database systems like SQL Server, Oracle or db2 etc and experience writing complex queries and creating stored procedures- Good understanding or knowledge in Azure Cloud, ADF.- Good exposure to Python, Pyspark, Databricks notebook.- Interact with project teams, development, operations, and infrastructure resources to recommend solutions to remediate data issues.- Experience in defect life cycle management -logging, replication, triaging, verification, closing, metrics reporting, etc.- Demonstrated ability to acquire high volumes of test data required to support Test execution.- Good understanding of Agile methodology.- Experience in test environment and test datamanagement- Strong communication and collaborationskills, to challenge the norm**What you can expect from us**At DigitalOnUs, what distinguishes us from other teams is the comfortable environment which engenders trust within teams and with our customers.Trust and openness leads to quality, innovation, commitment to deliverables, efficiency and cost-effectiveness for all our customers.- Work with some truly remarkable IT engineers, architects, specialists and more.- We're growing at a phenomenal pace and we'd like some company.- Hear your voice, nurture your talent and help you strengthen your foot print- Benefits above the law- Mentorship, and opportunities to grow and learnID: ****