Senior ETL Engineer

  • MicroStrategy
  • Mumbai, Maharashtra, India
  • Apr 03, 2024
Full time Information Technology

Job Description

The Senior ETL Engineer is part of a team responsible for the architecture, development and maintenance of a companywide Business Intelligence System that provides business insight through enterprise reporting to decision-makers at all organization levels and functions by delivering accurate, timely and actionable information. One of the main responsibilities of this position is to apply ETL experience and data warehousing principles to ensure complete, reliable, and secure data delivery to business stakeholders. The position reports to the Director of Business Intelligence. 

 

Job Duties (include but not limited to): 

  • Design and develop advanced ETL jobs and routines to process data from multiple sources into a centralized warehouse 
  • Administer, maintain, and performance-tune Informatica PowerCenter and Informatica Cloud workflows. 
  • Communicate with system users worldwide from key business groups, including Finance, Sales, Tech Support, Human Resources, Consulting, Education and Marketing to gather project requirements and business insight, perform feasibility analysis and manage expectations.  Engineers are responsible for communicating with project sponsors and stakeholders during the entire life cycle of a reporting project. A key measure of success in this position will be to timely and accurately meet project milestones and deliverables as agreed upon all key items 
  • Prepare ad-hoc queries against different data source systems 
  • Provide detailed documentation of enterprise reporting projects 
  • Define, implement and administer data security as appropriate 
  • Apply Quality Assurance methods to ensure that information provided to business users is accurate and actionable 
  • Contribute to periodic projects related to the maintenance of reporting system components outside of regular business hours 
  • Prepare Dashboards and Reports for business users.  

 

Job Requirements: 

  • Minimum bachelor’s degree, preferably in Computer Science, Information Systems, or a related field 
  • 3+ years Experience with Informatica PowerCenter and Informatica Cloud 
  • SQL programming knowledge in MS SQL Server 
  • Exceptional analytical and problem-solving skills 
  • Experience with MicroStrategy or other Business Intelligence applications is a plus 
  • Python language skills is a plus 
  • Knowledge of data warehousing principles is a plus 
  • Strong aspiration to learn new technologies 
  • Strong written and verbal communication 
  • Proactive and Creative 
  • Ability to multitask in a dynamic environment 
  • Ability to work in a distributed team environment 
  • Willing to work 9am – 6pm ET (US Hours) 

Additional Information

Once you apply you will receive assessments as a first step (English, logic, business). Please check your email and SPAM folder.