Data Engineer with WhereScape RED

Job Description:

• Will be working as an ELT Engineer for an enterprise datawarehouse that handles data extraction, loading and transformation process for lead, sales, commission, calls, finance, and few other domains.
• Will be involved in data pipeline design, data integration and data retention activities.
• Will be guiding project team members on development, enhancements, and production support activities.
• Will be creating new ELT processes that extracts data from SQL server and CSV files, loads and transform in Snowflake database (on AWS cloud)
• Will be modifying existing ELT processes to accommodate any business logic changes.
• Will be creating new ELT processes to handle near-real time data processing that extracts data from transactional systems and loads in Snowflake database (on AWS cloud)
• Will be working with architect to apply data quality, data access and data security principles.
• Will be optimizing existing ELT jobs to improve ELT performance.
• Will be working with project team members and business in triaging new feature prioritization and implementation.
• Will be responsible for any bug fixes in the production environment and production rerun and ticket resolution.
• Will be following change approval process, release management and production deployment process.
• Handles user queries on data (data lineage and troubleshooting).
• Will be responsible in creating and updating design document and SOP documents.
• Resource is required to be having 3+ years of hands-on experience in WhereScape RED ELT tool and Snowflake (DDL, DML and stored procedures)
• Resource should be knowledgeable on data orchestration and pipeline automation using WhereScape RED tool.
• Resource should be knowledgeable in Pebble scripting (that comes along with RED ELT tool).
• 70% of time will be spent on new development and enhancement activities; 30% time will be spent on bug-fixes, user queries, and production support