SQL Developer (DC Reporting Analytics)

Responsibilities:

• Writing and optimizing SQL queries for data validation.
• Validating ETL processes and ensuring data integrity.
• Collaborating with ETL developers and DBAs to troubleshoot and resolve data issues.
• Documenting testing results and maintaining audit logs.
• Participating in Agile or DevOps workflows.

Technical Skills:

• SQL (Strong query writing and optimization skills) – for querying large datasets efficiently.
• Oracle SQL & PL/SQL (Bonus skill) – helpful in enterprise environments using Oracle DB.
• ETL Tools (Informatica, Talend, or similar) – understand the ETL workflow and validate data transformation processes.
• Data Modeling (Joins, aggregations, transformations) – how data is structured and related to write effective queries.
• Documentation & Audit Tools – tracking validation results and compliance.

Complexity Indicators:

• Executing detailed data validation (row counts, data accuracy).
• Troubleshooting data discrepancies.
• Collaboration with ETL developers and DBAs for issue resolution.
• Participation in Agile/DevOps workflows (preferred).
• Exposure to ETL testing or QA processes (preferred).

Education & Certification:

• Typically requires a bachelor’s degree in computer science, Information Technology, or related fields.
• Certifications helpful for credibility and knowledge enhancement:
• Microsoft Certified: Azure Data Fundamentals
• Oracle Database SQL Certified Associate
• Informatica Certified Developer (if focusing on Informatica ETL)
• Certified Data Management Professional (CDMP) for broader data governance understanding.
• Alternatives include practical experience in SQL, ETL testing, and Agile workflows if formal certification is missing.