Sr ETL Validator

Sky Solutions Sarl - Woodlawn, MD

Full-time - Mid Level

Woodlawn, MD

Professional, Scientific, and Technical Services

About the position

The Sr ETL Validator is responsible for validating ETL processes, writing ETL specifications, and mentoring technical staff. This role involves testing MI reports in an Agile environment and participating in Agile ceremonies. The position requires strong expertise in SQL, PL/SQL, and experience with various database systems.

Responsibilities

• Validate ETL processes and ensure data integrity.
• Write detailed ETL specifications.
• Mentor and coach technical staff.
• Support multiple internal and external initiatives to achieve mission success.
• Test different modules of MI reporting.
• Attend Agile ceremonies including Daily standup, Sprint planning, Backlog grooming, and Sprint Retrospective meetings.
• Perform other duties as assigned.

Requirements

• Bachelor's degree in computer science, Mathematics, Engineering or a related field.
• 8+ years of experience in a training-related field.
• Expertise in writing ETL specifications.
• Experience validating ETL processes.
• Strong experience with SQL and database integration (DB2, Oracle 19c, PostgreSQL).
• Proficiency in writing scripts using Oracle PL/SQL, PostgreSQL, and Linux.
• Familiarity with extracting data from multiple sources (DB2, Oracle, flat files).
• Experience in scripting in a Linux environment for ETL automation.
• Knowledge of designing and developing test strategies based on Business Requirement documents.
• Strong communication and collaborative skills.

Nice-to-haves

• Development background in programming languages like Java with strong SQL skills.
• Proficiency in reading UNIX logs and executing basic UNIX commands.
• Hands-on experience with data warehouse BI/MI reporting environments.

Benefits

• Long-term contract opportunity.
• Hybrid work environment with on-site requirements.