ETL QA Mt Laurel - NJ - New Jersey
Role: Data Warehouse Tester ETL QA EngineerLocation: LOCAL to Mt Laurel, NJ ONLY ( onsite )Visa Type: Any VisaWork Type: C2CRole Descriptions: Experienced Data Warehouse TesterDeveloperDatabricks PySpark and SQL 5 years data warehouse testing or developer experience 2 years of Azure Cloud experience. Strong understanding of data marts and data warehouse concepts Quality Engineering mindset with experience resolving complex problems in a repeatable scalable and sustainable way Expert in SQL with the ability to create source-to-target comparison test cases in SQL Creation of test plans test cases traceability matrix closure reports Proficient with PySpark Python GitHub JIRA JTMF Agile Kanban and Scrum Azure Data Bricks Data Factory DevOps Mainframe EBCDIC and COBOL Copybooks Automation tools (Tosca BIDI Autosys) ETL Excel Macros Informatica Microsoft Certified AZ-900 Azure Fundamentals DP-900 Azure Data Fundamentals DP-203 Azure Data Engineer AssociateEssential Skills: Datawarehouse Databricks PySpark informatica and SQLDesirable Skills: Implement procedures to maintain monitor backup and recovery operations for ETL environment. Report regularly on health and performance of ETL environment and jobs. Conduct ETL optimization troubleshooting and debugging. Maintain ownership of release activities interacting with ETL projects. Perform import and export ETL jobs across various ETL projects and servers. Provide development support to ETL application development teams. Establish projects roles users privileges in different ETL environments (DEV QA PROD).Perform and assume other duties and responsibilities as required at direction of management. Perform administration of IBM Database and ETL tool. Collaborate with US data warehouse and ETL developers to implement ETL solutions. Establish ETL admin as part of team responsible for building out and maintaining US data warehouse. Record and maintain ETL software and operational procedures. Perform independently with little direct supervision in administration of ETL. Provide detailed analysis of problems and recommend solutions. Conduct troubleshooting production and ETL job issues.Keyword:Skills: Digital : DatabricksExperience Required: 8-10