Data Analyst - ETL tester

Expleo is the home of bold and reliable minds. With more than 50 years of experience in developing complex products, optimising manufacturing processes, and ensuring the quality of information systems, Expleo boasts an extensive global footprint, powered by 19,000 highly skilled experts delivering value in 30 countries.

Our efforts in creating a supportive and inclusive workplace in India have earned us some key recognitions:

• 'Great Place to Work' certification for building a supportive, engaging environment.
• 'Progressive Place to Work,' by ET Now, for our dedication to innovation and inclusive workplace policies.
• 'Best Organizations for Women,' by ET Now, for empowering women by providing equal opportunities, supporting professional development and promoting inclusive leadership.

• Must have an minimum of 3 to 5 yrs hands-on experience in ETL/Datawarehouse and Data migration testing
• Validation: ETL and Datawarehouse Testing processes to ensure Data completeness and accuracy
• Test planning: Experience in analyzing Data Mapping documents and Develop test cases, plans, and complex SQL scripts
• Data quality assurance: Identifying and documenting discrepancies, and working with development teams to resolve issues and re-test
• Automated testing: Creating and maintaining automated test scripts
• Experience working with Cloudera HIVE
• Reporting: Preparing and presenting detailed test reports, highlighting risks and issues
• Strong understanding of various testing cycles and release activities, Good in written and verbal communication
• Define and track quality assurance metrics such as defects, defect counts, test results and test status
• Experience testing Waterfall/Agile Development Projects
• Hands on experience in relational databases and database architecture. Understanding data models and ER diagrams
• Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions,facts

Must have

• SQL, UNIX, Python, HDFS, BI Reports
• IBM DB2, Cloudera HIVE, SQL Server,Teradata SQL Assisttant
• Exposure to IICS/Informatica/DataStage/ODI

• B.E./B. TECH in any stream/ MCA/ M.Sc. (IT)
• Bachelors degree

• SQL, UNIX, Python, HDFS, BI Reports
• IBM DB2, Cloudera HIVE, SQL Server,Teradata SQL Assisttant
• Exposure to IICS/Informatica/DataStage/ODI

• 3 to 5 Yrs