Description

You will design, develop, and deploy business rules into PL/SQL and ETL code for data analysis, transformation, and cleansing. You will own the end-to-end data flow from source to target, ensuring data integrity and completeness through robust error handling and automation.

Responsibilities

• Design overall ETL frameworks, data flows, and source-to-target mapping rules.
• Develop stored procedures, packages, views, and functions within Oracle.
• Create staging, source, and target tables to store, retrieve, and manipulate data.
• Implement processes to extract, transform, and load data from various formats while automating mappings and workflows.
• Oversee and deliver development artifacts from offshore teams.

Required Skills

• Expertise in PL/SQL development.
• Strong experience with Oracle database environments.
• Hands-on experience with ETL technologies and frameworks.
• Ability to implement error handling to validate data integrity and completeness.
• Experience developing, executing, and automating workflows.
• Ability to travel to or relocate to unanticipated client sites throughout the USA.
• Bachelor’s degree in Computer Science, IT, Business, Engineering, or a related field with 5 years of progressive work experience, or a Master’s degree with 6 months of relevant experience.

Key Skills

Education

Any Graduate