Description

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 Associate Essential Skills: Datawarehouse| Databricks| PySpark| informatica and SQL Desirable 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

Key Skills

Education

Bachelor's degree