6 Complex Sql Jobs

Role: QA Lead ETL EXP : 12 + years Location: Bangalore Notice: within 1 month Skills & Description: Job Description: Quality Engineer -Automation-ETL, Complex SQL, Azure Databricks "Specific requirements of this unique demand/role: The STAM project is seeking a skilled Software QA Test Engineer. STAM (Site Transaction Analytical Mobility) is a strategic Data LakeHouse solution within the Downstream Mobility Data & Analytics portfolio, designed to replace the current RSTS (SAP4HANA) system. RSTS captures transactional sales data from Shell retail stations and transforms it into actionable insights for reporting and analytics. The STAM solution leverages modern cloud technologies including Azure Event Hubs, Azure Databricks, Azure Data Factory, and Azure Data Lake Storage, with reporting via SAP BO, Power BI, and external system integration through APIs. Key Responsibilities: Develop and own QA deliverables including: Test Strategy, Test Plan, Test Cases (risk-based approach) Execute manual and automated test cases to validate data integrity and system functionality. Identify opportunities for test automation and contribute to automation strategy. Design and execute tests for large-scale data migrations, ensuring data availability, accuracy, and quality. Collaborate with developers, data engineers, and business stakeholders to ensure testing aligns with business requirements and technical design. Qualifications Proven experience in software QA and testing, preferably in data platforms or cloud-based solutions. Strong understanding of data pipelines, ETL processes, and data validation techniques. Familiarity with Azure cloud services, especially Databricks and Data Factory. Experience with test automation tools and scripting is a plus. Excellent analytical and communication skills. Roles and Responsibilities: Accountable for End to End testing deliverables in a portfolio and demand management, by bringing in capable candidates to the team and ensuring End to End delivery for each of the programs has top quality deliverables. Maintain Business Continuity. Manage a small team of 10-12 members, their goals, appraisals and the development plans supporting their aspirations. Demonstrate Automation experience, ability to manage and deliver top quality testing for medium to large programs. Take a leadership position in automation, working with Architects and Scrum team members to clarify requirements, ensure testability and the ability to automate. Provide feedback on design, both functional and technical. Innovate on latest tools and processes to improve QA functional, manual and Automation testing. Document best practices and mentor junior team members. Work on frameworks to ensure continuous deployment and continuous integration. www.talendroid.com 3 Talendroid Technologies - Confidential Develop new proofs-of-concepts for QA Automation, ensuring continual improvements. The role has frequent exposure to and interaction with senior levels of business leadership. Works independently under minimal managerial supervision. Delivers the work as assigned, applying the work procedures, frameworks. Guidance provided for those tasks where there are limited precedents available. Define roadmap for the CC in collaboration with Portfolio/IT managers and drive alignment across all stakeholders, Mandatory skills: Bachelor's Degree in computer science / equivalent and 12+ years of experience as QA lead. Agile testing & test automation (accelerators tools). Selenium C# with BDD framework using Specflow, API Automation. Implementation of selenium Grid. Applying appropriate test measurements & metrics. Optional skills: Leadership and ability to drive change using influence and networking. Good team player and effective leader with a long-term vision. Flexible re time zones - coordination with stakeholders in UK/US

Role: Data Solution Architect Location: Bangalore, Chennai, Hyderabad, Kochi, Mumbai, Kolkata, Noida, Gurgaon (Any office but he/she need to be local) Experience: 12-15 Years Budget: 35-40 LPA Only Immediate Joiners Role Objectives Design and maintain enterprise data architecture to support the analysis and interpretation of complex datasets from diverse sources, transforming them into actionable business insights. Lead deep technical investigations into complex data challenges to define solution architecture , propose target state models, and identify key benefits. Apply industry-standard templates, methodologies, and best practices for data architecture, integration, and governance. Implement enterprise data management capabilities including data catalogues , business glossaries , metadata management , data lineage , and reference/master data frameworks . Drive adoption of cloud-native platforms such as Azure Data Platform , Informatica , and automation tools for scalable data solutions. Architect automated data processing workflows using tools like Power Automate , Python , macros , and custom scripts to streamline data operations. Identify and implement data architecture optimizations for efficiency, performance, and scalability. Collaborate with cross-functional teams to enable data-driven decision-making through architectural guidance and scalable data solutions. Enforce and promote data management best practices and architectural governance standards. Stakeholder Management Partner with Product Owners and Data Governance Leaders to promote adoption and alignment of data architecture with business objectives. Ensure data solutions are understandable and usable by technical and non-technical stakeholders. Act as a data architecture evangelist , capturing feedback and driving continuous improvement. Governance and Compliance Operate in alignment with organizational policies, data standards, and regulatory requirements . Ensure adherence to enterprise data governance frameworks, policies, and audit controls . Essential Skills Strong experience as a Data Solution Architect in Financial Services (banking, superannuation, insurance, etc.) and expertise in customer data architecture . Proficiency in data architecture , data modeling , data warehouses , data lake design , and advanced analytics platforms . Experience in data transformation logic , data ingestion patterns , and data quality frameworks . Expertise in documenting and aligning business data requirements with technical solutions. Strategic thinker with strong collaboration and leadership capabilities. Excellent communication skills , translating business objectives into scalable data solutions. Project and stakeholder management , ensuring architectural deliverables are on track. Proven ability to manage multiple concurrent data architecture initiatives . Specific Skills We Are Seeking Candidates to Possess and Demonstrate Are: Ability to lead and operate independently , while collaborating with business users, architects, data engineers, testers, and analysts. Strong understanding of business workflows, enterprise systems , and gathering technical and business data requirements . Proficiency in creating data architecture artifacts , including ERDs, interface specs, data dictionaries, transformation logic, and lineage diagrams . Hands-on experience with complex SQL , ETL pipelines , and cloud-based data platforms . Additionally, It Would Be Advantageous If Candidates Can: Develop Power BI semantic models and design visual analytics dashboards for key business metrics. Evaluate and optimize data warehouse architecture and cloud migration strategies . Create data quality frameworks and reconciliation strategies across enterprise data sources. Lead or contribute to data governance initiatives and architectural enhancements.

Key Responsibilities : As an Enterprise Data Architect, you will : - Lead Data Architecture : Design, develop, and implement comprehensive enterprise data architectures, primarily leveraging Azure and Snowflake platforms. - Data Transformation & ETL : Oversee and guide complex data transformation and ETL processes for large and diverse datasets, ensuring data integrity, quality, and performance. - Customer-Centric Data Design : Specialize in designing and optimizing customer-centric datasets from various sources, including CRM, Call Center, Marketing, Offline, and Point of Sale systems. - Data Modeling : Drive the creation and maintenance of advanced data models, including Relational, Dimensional, Columnar, and Big Data models, to support analytical and operational needs. - Query Optimization : Develop, optimize, and troubleshoot complex SQL and NoSQL queries to ensure efficient data retrieval and manipulation. - Data Warehouse Management : Apply advanced data warehousing concepts to build and manage high-performing, scalable data warehouse solutions. - Tool Evaluation & Implementation : Evaluate, recommend, and implement industry-leading ETL tools such as Informatica and Unifi, ensuring best practices are followed. - Business Requirements & Analysis : Lead efforts in business requirements definition and management, structured analysis, process design, and use case documentation to translate business needs into technical specifications. - Reporting & Analytics Support : Collaborate with reporting teams, providing architectural guidance and support for reporting technologies like Tableau and PowerBI. - Software Development Practices : Apply professional software development principles and best practices to data solution delivery. - Stakeholder Collaboration : Interface effectively with sales teams and directly engage with customers to understand their data challenges and lead them to successful outcomes. - Project Management & Multi-tasking : Demonstrate exceptional organizational skills, with the ability to manage and prioritize multiple simultaneous customer projects effectively. - Strategic Thinking & Leadership : Act as a self-managed, proactive, and customer-focused leader, driving innovation and continuous improvement in data architecture. Position Requirements : of strong experience with data transformation & ETL on large data sets. - Experience with designing customer-centric datasets (i.e., CRM, Call Center, Marketing, Offline, Point of Sale, etc.). - 5+ years of Data Modeling experience (i.e., Relational, Dimensional, Columnar, Big Data). - 5+ years of complex SQL or NoSQL experience. - Extensive experience in advanced Data Warehouse concepts. - Proven experience with industry ETL tools (i.e., Informatica, Unifi). - Solid experience with Business Requirements definition and management, structured analysis, process design, and use case documentation. - Experience with Reporting Technologies (i.e., Tableau, PowerBI). - Demonstrated experience in professional software development. - Exceptional organizational skills and ability to multi-task simultaneous different customer projects. - Strong verbal & written communication skills to interface with sales teams and lead customers to successful outcomes. - Must be self-managed, proactive, and customer-focused. Technical Skills : - Cloud Platforms : Microsoft Azure - Data Warehousing : Snowflake - ETL Methodologies : Extensive experience in ETL processes and tools - Data Transformation : Large-scale data transformation - Data Modeling : Relational, Dimensional, Columnar, Big Data - Query Languages : Complex SQL, NoSQL - ETL Tools : Informatica, Unifi (or similar enterprise-grade tools) - Reporting & BI : Tableau, PowerBI

Key Responsibilities : As an Enterprise Data Architect, you will : - Lead Data Architecture : Design, develop, and implement comprehensive enterprise data architectures, primarily leveraging Azure and Snowflake platforms. - Data Transformation & ETL : Oversee and guide complex data transformation and ETL processes for large and diverse datasets, ensuring data integrity, quality, and performance. - Customer-Centric Data Design : Specialize in designing and optimizing customer-centric datasets from various sources, including CRM, Call Center, Marketing, Offline, and Point of Sale systems. - Data Modeling : Drive the creation and maintenance of advanced data models, including Relational, Dimensional, Columnar, and Big Data models, to support analytical and operational needs. - Query Optimization : Develop, optimize, and troubleshoot complex SQL and NoSQL queries to ensure efficient data retrieval and manipulation. - Data Warehouse Management : Apply advanced data warehousing concepts to build and manage high-performing, scalable data warehouse solutions. - Tool Evaluation & Implementation : Evaluate, recommend, and implement industry-leading ETL tools such as Informatica and Unifi, ensuring best practices are followed. - Business Requirements & Analysis : Lead efforts in business requirements definition and management, structured analysis, process design, and use case documentation to translate business needs into technical specifications. - Reporting & Analytics Support : Collaborate with reporting teams, providing architectural guidance and support for reporting technologies like Tableau and PowerBI. - Software Development Practices : Apply professional software development principles and best practices to data solution delivery. - Stakeholder Collaboration : Interface effectively with sales teams and directly engage with customers to understand their data challenges and lead them to successful outcomes. - Project Management & Multi-tasking : Demonstrate exceptional organizational skills, with the ability to manage and prioritize multiple simultaneous customer projects effectively. - Strategic Thinking & Leadership : Act as a self-managed, proactive, and customer-focused leader, driving innovation and continuous improvement in data architecture. Position Requirements : of strong experience with data transformation & ETL on large data sets. - Experience with designing customer-centric datasets (i.e., CRM, Call Center, Marketing, Offline, Point of Sale, etc.). - 5+ years of Data Modeling experience (i.e., Relational, Dimensional, Columnar, Big Data). - 5+ years of complex SQL or NoSQL experience. - Extensive experience in advanced Data Warehouse concepts. - Proven experience with industry ETL tools (i.e., Informatica, Unifi). - Solid experience with Business Requirements definition and management, structured analysis, process design, and use case documentation. - Experience with Reporting Technologies (i.e., Tableau, PowerBI). - Demonstrated experience in professional software development. - Exceptional organizational skills and ability to multi-task simultaneous different customer projects. - Strong verbal & written communication skills to interface with sales teams and lead customers to successful outcomes. - Must be self-managed, proactive, and customer-focused. Technical Skills : - Cloud Platforms : Microsoft Azure - Data Warehousing : Snowflake - ETL Methodologies : Extensive experience in ETL processes and tools - Data Transformation : Large-scale data transformation - Data Modeling : Relational, Dimensional, Columnar, Big Data - Query Languages : Complex SQL, NoSQL - ETL Tools : Informatica, Unifi (or similar enterprise-grade tools) - Reporting & BI : Tableau, PowerBI

Introduction In this role, youll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology. In this role, youll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology. Your role and responsibilities Responsible to develop triggers, functions, stored procedures to support this effort Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems. Assist with design, testing, support, and debugging of new and existing ETL and reporting processes. Perform data profiling and analysis using a variety of tools. Troubleshoot and support production processes. Create and maintain documentation Required education Bachelors Degree Preferred education Masters Degree Required technical and professional expertise BE / B Tech in any stream, M.Sc. (Computer Science/IT) / M.C.A, with Minimum 5 plus years of experience Must Have : Snowflake, AWS, Complex SQL Experience with software architecture in cloud-based infrastructures Experience in ETL processes and data modelling techniques Experience in designing and managing large scale data warehouses Preferred technical and professional experience Good to have in addition to Must haves: DBT, Tableau, python, JavaScript Develop complex SQL queries for data analytics and business intelligence. Background working with data analytics, business intelligence, or related fields

Introduction In this role, youll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology. In this role, youll work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology. Your role and responsibilities Responsible to develop triggers, functions, stored procedures to support this effort Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems. Assist with design, testing, support, and debugging of new and existing ETL and reporting processes. Perform data profiling and analysis using a variety of tools. Troubleshoot and support production processes. Create and maintain documentation Required education Bachelors Degree Preferred education Masters Degree Required technical and professional expertise BE / B Tech in any stream, M.Sc. (Computer Science/IT) / M.C.A, with Minimum 5 plus years of experience Must Have : Snowflake, AWS, Complex SQL Experience with software architecture in cloud-based infrastructures Experience in ETL processes and data modelling techniques Experience in designing and managing large scale data warehouses Preferred technical and professional experience Good to have in addition to Must haves: DBT, Tableau, python, javascript Develop complex SQL queries for data analytics and business intelligence. Background working with data analytics, business intelligence, or related fields