Job Title: Technical BA (Informatica/ETL Any BI tools with SQL)

Experience: 7-10 Years

Location: [Pune, Mumbai, Hybrid]

Shift : EMEA

Looking Only Immediate to 15 days

Experience in Data ware house Project is must (Informatica/ ETL/ MicroStrategy)

Job Summary

We are seeking a detail-oriented and technically strong Business Analyst with expertise in Data Warehousing and Business Intelligence

Key Responsibilities

- Engage with business users to understand data and reporting needs.
- Gather, document, and analyze business, functional, and technical requirements for data warehouse and BI initiatives.
- Translate requirements into source-to-target mappings (STTM), data flow diagrams, and ETL specifications.
- Collaborate with data architects, data engineers, and ETL developers to design scalable data warehouse solutions.
- Validate data integration processes, data quality rules, and reconciliation between source and target systems.
- Support data modeling activities (star schema, snowflake, fact and dimension design).
- Assist in defining metadata, lineage, and governance requirements.
- Create and execute user acceptance test (UAT) plans for data warehouse deliverables.




- Develop ad-hoc SQL queries for requirement validation, data profiling, and reconciliation.
- Act as the primary liaison between business stakeholders and the technical development team.
- Prepare documentation such as BRD, use cases, user stories.
- Support production releases and post-implementation reviews.

Required Skills & Qualifications

- 7-10 years of experience as a Business Analyst with data warehousing / BI / ETL projects.
- Solid understanding of data warehousing concepts (ETL, OLAP, data marts, dimensional modeling).
- Proficiency in SQL for data analysis and validation.
- Experience working with any ETL tools (preferably Informatica).
- High level knowledge of reporting/visualization tools (Tableau, Power BI, Qlik, etc.) (Not Mandatory)
- Familiarity with data governance, lineage, and master data concepts.
- Experience working in Agile/Scrum methodology (user stories, backlog management, acceptance criteria).
- Strong communication, stakeholder management, and documentation skills.
- Bachelors degree in Computer Science, Information Systems, or a related field.

📌 Technical Business Analyst (Data warehousing, ETL ,Informatica) (Mumbai)
🏢 eClerx
📍 Mumbai