May 12, 2024
Apply Now
Bengaluru, Karnataka, India, India
May 12, 2024
Apply NowJob description
Description
JOB ROLE Data Engineer
Job Role
JOB ROLE Data Engineer
Job Role
- We are looking for an experienced SQL , PLSQL and Data Stage ETL developer to join our team as a Data Engineer who will work as part of a team to help design and develop data-driven solutions that deliver insights to the business.
- The ideal candidate is a data pipeline builder and data wrangler who enjoys building data-driven systems that drive analytical solutions and building them from the ground up.
- You will be responsible for building and optimizing our data as well as building automated processes for production jobs.
- You will support our software developers, database architects, data analysts and data scientists on data initiatives.
- Designs, develops, builds and implements extracts transforms and loads (i.e. the facilitation of data movement across platforms) utilizing Client DataStage ETL Tool.
- Designs and develops highly complex ETL processing the support of data warehouses and/ or operational data stores.
- Outstanding SQL/PLSQL Skills and experience performing deep data analysis on multiple database platforms. (Oracle is preferable)
- Understanding Data Transformation and translations requirements and which tools to leverage to get the job done.
- Experience in Data Lake Implementation in snowflake (preferable).
- Develops UNIX scripts and Oracle packages.
- Determines the appropriate design for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
- Works closely with project management, analysts, data modelers and the existing ETL developers to understand project requirements and contribute to the project solution.
- Provides technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration Partner with Business Intelligence and Business operational teams to understand data sources and implement new requirements.
- Analyzes and summarize data to facilitate Business Intelligent decisions.
- A Solid Experience and understanding of designing and operationalization of large-scale data and analytics solution on snowflake cloud data warehouse.
- Advanced proficiency with SQL and related RDBMS query tools
- Ability to clearly communicate solutions to both technical and non-technical teams
- Scripting /Coding experience in Python /UNIX.
- Bachelor's degree in computer science, computer engineering, or a related field.
- 5 + years of experience working with Oracle and ETL (Data Stage)
- 2+ years of experience with the snowflake (Preferable) .
- Familiar with issue tracking systems like JIRA (Project Management Tool) or Trello.
- Experience working in an agile environment.
- Experience in Snowflake.
- Experience in DataStage and Snap logic
- Working knowledge of AWS or Azure
- Experience in migrating from on-prem to cloud systems.
- Experience in Data Lake Implementation in Snowflake (preferable).
