Data AnalystETL Engineer
Department:
Job Summary
**Job Title:** Data Analyst / ETL Engineer - 4 to 9 years exp
**Location:** 5 days WFO from Chennai office
We are looking for a Data Analyst / ETL Engineer with strong SQL and stored procedure skills solid ETL experience (AWS Glue Informatica PowerCenter) and exposure to BI tools (MicroStrategy is a strong plus). The role focuses on building efficient data flows transformations and automation for reliable and fast data delivery.
Responsibilities:
- Write complex SQL queries and stored procedures on SQL Server or any SQL-based database.
- Design develop and maintain ETL pipelines using AWS Glue and Informatica PowerCenter.
- Use and manage Informatica PowerCenter components end-to-end (workflows sessions transformations).
- Design and implement transformations and data flows for quick and reliable data movement between systems.
- Evaluate and implement strategies to replace or optimize heavy stored procedures where appropriate.
- Collaborate with data consumers and BI teams to model data for reporting and analytics.
- Work with BI tools; exposure to MicroStrategy is a big plus.
- Automate recurring ETL and data processing tasks using scripting (same automation expectations as other data/DB roles).
- Ensure data quality integrity and performance across ETL processes and data pipelines.
Requirements:
- Strong SQL skills including complex queries stored procedures and performance-conscious designs.
- Experience with SQL Server or any other SQL-based RDBMS.
- Hands-on experience with ETL tools specifically AWS Glue and Informatica PowerCenter.
- Solid understanding of ETL concepts: transformations workflows and end-to-end data flow.
- Experience designing quick data movement strategies between source and target systems.
- Exposure to at least one BI tool; MicroStrategy experience is a strong plus.
- Experience with automation/scripting to streamline ETL operations and monitoring.
Additional Information
The recruitment process includes short online analytical assessment as a first step - we send it via e-mail after you apply please check also your SPAM folder and complete assessment as soon as possbile.
Work Location: Strategy Chennai office full-time Monday to Friday
Remote Work :
No
Employment Type :
Full-time
About Company
We provide powerful software solutions and expert services that empower every individual with actionable intelligence, helping enterprises unleash the full potential of their people and investments. Our analytics and mobility platform delivers high-performance business applications th ... View more