Specialist - Data Engineering

BI ETL Developer :

Responsibilities:

• Work closely with functional heads, stakeholders, and developers to understand the requirement and create data pipelines using ETL tools.

• Designing, development and deployment using ETL eco-system and ensure delivery within given time while maintaining data quality and accuracy.

• Perform analysis of complex data sets to better understand trends, relationships between variables, and to formulate business intelligence insights.

• Excellent analytical skills to analyze business needs.

• Work in an Agile team and able to articulate problem statements & solutions.

• Works across multi-functional teams to formulate and fine tune design ideas and guidelines.

• Excellent collaborator, and flexible to work based on projects and deliverable deadlines.

• Identify and implement opportunities in the solution that will drive improvements in performance, scalability, reliability, and re-usability. Continue to drive down technical debt and cost of operations/support with the latest cutting-edge technologies and newer development methods & strategies.

• Ensure “operational excellence” capabilities (usability, availability, resilience, security, etc.) at-all-times.

What We are Looking For (Basic Qualifications): This position performs a wide range of duties including but not limited to the following:

• Overall, 5-8 years of work experience in designing, developing, and implementing Data Warehouse solutions.

• At least 5 years of work experience in ETL tools like Informatica Intelligent Cloud Services (Data & Application Integration), Oracle Data Integrator

• At least 5 years of collective work experience in multiple databases like AWS Redshift, Oracle 12c, and Oracle Autonomous Data Warehouse.

• At least 5 years of hands-on experience in PL/SQL.

• Must have complete understanding of Data warehouse life cycle right from data source to ETL transformations to multidimensional models like data marts, star schema and Reporting.

• Write Complex SQL queries on multiple tables using complex joins to perform end-to-end Data validation.

• Must have working experience in database Row/Object Level Security

• Effective communication and presentation skills (verbal & written) and be able to articulate the problems and recommended solution to make design decisions with conviction.

• A bachelor’s or master’s degree in engineering or business or finance or accounting.

Preferred Qualifications:

• Experience on Oracle ERP Finance application modules: Account Payables (AP) or Account Receivables (AR) or General Ledger (GL) or Fixed Assets (FA) or Cash Management (CM)

• Knowledge in Salesforce & Zuora systems will be an added advantage.

• Experience with REST API, SOAP messaging and integrations with other enterprise applications / SaaS applications using IICS / Oracle PaaS

• Good to have knowledge of data analytical tools like Alteryx.

• Basic knowledge and usage of visualization tools like Tableau, Power BI etc.

• Working experience in estimating effort required to develop code.

• Knowledge on Agile project implementation methods or usage of Microsoft Azure (VSTS) tool will be an added advantage.