ETL Lead cum Techno-Functional Business Analyst || Immediate Joiner || Chennai

Role : ETL Lead cum Techno-Functional Business Analyst

Experience : 8 to 12 years Location: Chennai

Job Description: We are seeking an experienced ETL Lead cum Techno-Functional Business Analyst with strong expertise in data integration, ETL development, SQL, and business analysis. The ideal candidate should possess a blend of technical and functional capabilities to lead ETL initiatives, analyze business requirements, collaborate with stakeholders, and deliver scalable data integration solutions. Prior experience in the Banking/NBFC domain will be an added advantage.

Responsibilities: * Collaborate with business stakeholders to gather, analyze, and document functional and technical requirements. * Translate business requirements into ETL design specifications and technical solution documents. * Lead the design, development, and implementation of enterprise ETL solutions. * Perform data mapping, transformation analysis, and source-to-target mapping. * Design and optimize SQL queries for data extraction, validation, reconciliation, and reporting. * Coordinate with application development, data engineering, and business teams throughout the project lifecycle. * Ensure data quality, integrity, and consistency across multiple source systems. * Perform impact analysis for new enhancements and production changes. * Support SIT, UAT, and production deployment activities. * Prepare functional specifications, data mapping documents, process flows, and technical documentation. * Ensure adherence to data governance, metadata management, and data lineage standards. * Mentor team members and provide technical guidance during project execution.

Essential Skills: * Strong proficiency in SQL (Mandatory). * Hands-on experience with one or more ETL tools: Oracle Data Integrator (ODI) Informatica PowerCenter Talend Microsoft SSIS Equivalent ETL platforms * Experience in data extraction, transformation, and loading processes. * Strong understanding of: Data Integration Data Lineage Metadata Management * Experience with Data Modeling tools such as: Erwin PowerDesigner Equivalent modeling tools * Expertise in Source-to-Target Mapping (STTM). * Strong knowledge of relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL. * Experience in data validation, reconciliation, and data quality analysis. * Ability to prepare BRD, FRD, Functional Specifications, and Mapping Documents. * Strong analytical and problem-solving skills. * Excellent stakeholder communication and requirement elicitation skills.

Desired Skills: * Experience in Banking or NBFC data warehouse and reporting projects. * Exposure to Data Warehouse concepts including Star Schema and Snowflake Schema. * Knowledge of Data Governance frameworks. * Experience with API integrations and enterprise data platforms. * Exposure to cloud-based ETL platforms (AWS, Azure, or GCP) is desirable. * Familiarity with BI and reporting tools such as Power BI, Tableau, or Oracle BI. * Experience working with Jira, Confluence, Azure DevOps, or similar ALM tools. * Understanding of regulatory reporting and financial data processing. * Knowledge of Python or Shell Scripting will be an added advantage.

Experience: * Total Experience: 8–12 Years * Relevant ETL Experience: Minimum 6+ Years * Business Analysis Experience: Minimum 3+ Years * Domain: Banking / Financial Services / NBFC (Preferred) * Notice Period: Immediate to 30 Days (Preferred)

Qualification: * Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline. * 8–12 years of experience in ETL Development, Data Integration, and Business Analysis. * Strong techno-functional exposure across the complete Software Development Lifecycle (SDLC). * Experience working in Agile and Waterfall delivery models. * Banking, Financial Services, or NBFC experience is preferred.