Description

You will design and implement scalable ETL/ELT pipelines and Business Intelligence solutions to support data-driven decision making.

Responsibilities

• Develop ETL/ELT orchestration and transformation pipelines to extract data from Oracle, PostgreSQL, and Netezza into Snowflake and Salesforce.
• Build data models and datamarts to support Power BI reports and analytics.
• Create Python scripts using AWS Lambda and Matillion to automate data processing, archiving, and framework efficiency.
• Implement data quality processes, error handling via AWS SNS, and data ingestion using AWS SQS and S3.
• Manage code migration and deployment across development, QA, and production environments within Agile/Scrum workflows.
• Document ETL processes, mapping documents, and project runbooks using Confluence.

Required Skills

• 5+ years of experience in ETL/ELT development.
• Proficiency with Snowflake Data Warehouse and Matillion.
• Hands-on experience with Oracle, PostgreSQL, and Netezza databases.
• Experience integrating data with Salesforce.
• Strong Power BI skills, including dashboard development and DAX expressions.
• Experience with AWS services including Lambda, S3, SNS, and SQS.
• Ability to develop Python scripts for data automation.
• Bachelor’s degree in Computer Science, Computer Systems Networking, or a related field.

Key Skills

Education

Bachelor’s degree in computer science, computer systems networking