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
Essential Job Functions
• Designs, develops, builds and implements extracts transforms and loads (i.e. the facilitation of data movement across platforms) utilizing IBM 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 modelling, Data Warehousing, and Data Integration Partner with Business Intelligence and Business operational teams to understand data sources and implement new requirements.
• Analyses 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.
Qualifications & Experience
• 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.
Mandatory Skillsets: ETL (IBM Data Stage), SQL/PLSQL, Datawarehouse concepts , Cloud experience.
Notice period: Immediate to 30 days Max
Education: B.E/B.Tech/M.E/M.Tech/MBA/M.S./MCA
Shift: Regular Dayshift (10am – 7PM) Might extend based on requirement.