Information Technology_USA - USA_System Administrator

Data Warehouse Tester/Developer

LOCAL to Mt Laurel, NJ ONLY! Role Descriptions: Experienced Data Warehouse Tester/Developer Databricks| 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 recover 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.