Job Category: Contract Onsite
Job Type: Full Time
Job Location: Mount Laurel NJ
Duration: 6 Months
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.
