ETL Lead/Techno-Functional Business Analyst

As an experienced ETL Lead cum Techno-Functional Business Analyst, your role will involve leading data integration initiatives and bridging the gap between business stakeholders and technical teams. Your expertise in ETL development, data warehousing, SQL, data modeling, and business analysis will be crucial for the successful execution of your responsibilities. Key Responsibilities: - Collaborate with business users, product owners, and stakeholders to gather and analyze requirements. - Translate business requirements into functional and technical specifications. - Prepare BRDs, FRDs, user stories, process flows, and data mapping documents. - Conduct requirement workshops and solution discussions with business teams. - Act as a liaison between business and technical teams. - Lead end-to-end ETL development and implementation activities. - Design and develop scalable data integration solutions. - Define source-to-target mappings and transformation logic. - Perform data profiling, data validation, and reconciliation activities. - Ensure data quality and consistency across systems. - Troubleshoot and resolve ETL and data-related issues. - Design and review data models. - Implement data lineage and metadata management practices. - Ensure compliance with enterprise data governance standards. - Support data migration and modernization initiatives. - Collaborate with architecture teams on enterprise data strategy. - Lead ETL developers and data analysts. - Review technical designs and code deliverables. - Drive project planning, estimations, and delivery. - Mentor junior team members and provide technical guidance. Required Technical Skills: SQL & Database Expertise (Mandatory): - Advanced SQL development skills. - Query optimization and performance tuning. - Complex joins, stored procedures, functions, views, and indexing. - Experience with Oracle, SQL Server, PostgreSQL, or MySQL. ETL Tools: - Hands-on experience in one or more: Oracle Data Integrator (ODI), Informatica PowerCenter, Talend, SSIS (SQL Server Integration Services), DataStage (Preferred). Data Warehousing: - Data Warehouse concepts. - Dimensional Modeling. - Fact and Dimension Design. - Star Schema. - Snowflake Schema. - Data Mart Design. Data Modeling Tools: - Experience with: Erwin Data Modeler, PowerDesigner, ER Studio (Preferred). Data Management: - Data Integration. - Data Lineage. - Metadata Management. - Master Data Management (MDM). - Data Governance Frameworks. Preferred Skills: - Banking or Financial Services domain experience. - Experience working in large-scale data transformation projects. - Knowledge of Cloud Data Platforms (AWS, Azure, GCP). - Exposure to Big Data ecosystems. - Experience with Agile/Scrum methodologies. - Knowledge of reporting and BI tools such as Power BI, Tableau, or Qlik. Educational Qualification: - Bachelor's or Master's Degree in Computer Science, Information Technology, Engineering, Statistics, or related field. Key Competencies: - Strong analytical and problem-solving skills. - Excellent stakeholder management abilities. - Strong communication and presentation skills. - Ability to manage multiple projects simultaneously. - Leadership and mentoring capabilities. As an experienced ETL Lead cum Techno-Functional Business Analyst, your role will involve leading data integration initiatives and bridging the gap between business stakeholders and technical teams. Your expertise in ETL development, data warehousing, SQL, data modeling, and business analysis will be crucial for the successful execution of your responsibilities. Key Responsibilities: - Collaborate with business users, product owners, and stakeholders to gather and analyze requirements. - Translate business requirements into functional and technical specifications. - Prepare BRDs, FRDs, user stories, process flows, and data mapping documents. - Conduct requirement workshops and solution discussions with business teams. - Act as a liaison between business and technical teams. - Lead end-to-end ETL development and implementation activities. - Design and develop scalable data integration solutions. - Define source-to-target mappings and transformation logic. - Perform data profiling, data validation, and reconciliation activities. - Ensure data quality and consistency across systems. - Troubleshoot and resolve ETL and data-related issues. - Design and review data models. - Implement data lineage and metadata management practices. - Ensure compliance with enterprise data governance standards. - Support data migration and modernization initiatives. - Collaborate with architecture teams on enterprise data strategy. - Lead ETL developers and data analysts. - Review technical designs and code deliverables. - Drive project planning, estimations, and delivery. - Mentor junior team members and provide technical guidance. Required Technical Skills: SQL & Database Expertise (Mandatory): - Adv