11+ Data warehouse QA Jobs in India

Strong PMO / Project Management Profile

Mandatory (Experience) – Must have a minimum 3+ YOE in Project Management and related roles

Mandatory (Skills 1) – Must have hands-on experience with Project Management standards, processes, and governance

Mandatory (Skills 2) – Must have experience of managing project status, risks, budgets, deviations, and defect tracking

Mandatory (Skills 3) – Must have experience in Project Planning & Scheduling using tools such as MS Project Planning and Advanced Excel

Mandatory (Skills 4) – Must have experience in developing dashboards and reports for management and stakeholders

Mandatory (Skills 5) – Must have experience in participating in Scrum calls and Agile ceremonies

Mandatory (Qualification) – Must hold a Bachelor’s degree

Preferred

Preferred (Skills) – Familiarity with Azure DevOps, Jira, and Power BI.

Preferred (Company) - Product Companies

• Planning and scheduling Deliverability Assessments (DA) for critical deals
•  Review of overall solution approach
•  Coordinating with service-line Subject Matter Experts(SME) and facilitating DA
•  Review the solution and identify risks based on experience/expertise in specific service-lines
• Articulation of risks and creation of risk reports based on SME connects
• Coordination with key stakeholders on risk mitigation/closure actions
• Creation of RAID(Risk-Assumption-Issue-Dependency) logs for senior leadership reviews

Role & Responsibilities

• Understand project specifications and develop work planning schedule for projects.

• Prepare cash flow timeline for various projects.

• Generate Daily, Weekly, Monthly Progress Reports.

• Keep a track of time overrun and cost overrun.

• Keep a track of the project and flag short falls.

• Prepare plan for the Execution team.

• Coordination with site team to ensure smooth running of the project.

• Prepare micro plan.

• Preparation of Site Logistic Plan.

• Preparation of Master project Schedule

• Preparation of Cash flow.

• Resource Planning (Man, Material, Machinery)

• Schedule Tracking

• Preparing MIS Reports

• Preparing Delay Analysis, Hindrance report.

• Should be proficient in using Primavera(P6) & MS Project software.

• Should have good working knowledge of design, procurement and construction/ field services workflow processes.

• Should have the ability to work independently in a multidisciplinary team environment.

• Experience in Pro-Services Cost Controls & Monitoring would be an added advantage.

Requirement

• Candidates working in the construction industry are preferred.
• 4-5 years of relevant experience.
• E. / B.Tech Civil.

• Key responsibility is to design and develop a data pipeline including the architecture, prototyping, and development of data extraction, transformation/processing, cleansing/standardizing, and loading in Data Warehouse at real-time/near the real-time frequency. Source data can be structured, semi-structured, and/or unstructured format.
• Provide technical expertise to design efficient data ingestion solutions to consolidate data from RDBMS, APIs, Messaging queues, weblogs, images, audios, documents, etc of  Enterprise Applications, SAAS applications, external 3rd party sites or APIs, etc through ETL/ELT, API integrations, Change Data Capture, Robotic Process Automation, Custom Python/Java Coding, etc
• Development of complex data transformation using Talend (BigData edition), Python/Java transformation in Talend, SQL/Python/Java UDXs, AWS S3, etc to load in OLAP Data Warehouse in Structured/Semi-structured form
• Development of data model and creating transformation logic to populate models for faster data consumption with simple SQL.
• Implementing automated Audit & Quality assurance checks in Data Pipeline
• Document & maintain data lineage to enable data governance
• Coordination with BIU, IT, and other stakeholders to provide best-in-class data pipeline solutions, exposing data via APIs, loading in down streams, No-SQL Databases, etc

Requirements

• Programming experience using Python / Java, to create functions / UDX
• Extensive technical experience with SQL on RDBMS (Oracle/MySQL/Postgresql etc) including code optimization techniques
• Strong ETL/ELT skillset using Talend BigData Edition. Experience in Talend CDC & MDM functionality will be an advantage.
• Experience & expertise in implementing complex data pipelines, including semi-structured & unstructured data processing
• Expertise to design efficient data ingestion solutions to consolidate data from RDBMS, APIs, Messaging queues, weblogs, images, audios, documents, etc of  Enterprise Applications, SAAS applications, external 3rd party sites or APIs, etc through ETL/ELT, API integrations, Change Data Capture, Robotic Process Automation, Custom Python/Java Coding, etc
• Good understanding & working experience in OLAP Data Warehousing solutions (Redshift, Synapse, Snowflake, Teradata, Vertica, etc) and cloud-native Data Lake (S3, ADLS, BigQuery, etc) solutions
• Familiarity with AWS tool stack for Storage & Processing. Able to recommend the right tools/solutions available to address a technical problem
• Good knowledge of database performance and tuning, troubleshooting, query optimization, and tuning
• Good analytical skills with the ability to synthesize data to design and deliver meaningful information
• Good knowledge of Design, Development & Performance tuning of 3NF/Flat/Hybrid Data Model
• Know-how on any No-SQL DB (DynamoDB, MongoDB, CosmosDB, etc) will be an advantage.
• Ability to understand business functionality, processes, and flows
• Good combination of technical and interpersonal skills with strong written and verbal communication; detail-oriented with the ability to work independently

Functional knowledge

• Data Governance & Quality Assurance
• Distributed computing
• Linux
• Data structures and algorithm
• Unstructured Data Processing

• Manage sales operations in assigned district to achieve revenue goals.
• Supervise sales team members; the BSMs, on daily basis and provide guidance whenever needed.
• Identify skill gaps and conduct trainings to sales team.
• Work with team to implement new sales techniques to obtain profits.
• Assist in employee recruitment, promotion, retention and termination activities.
• Conduct employee performance evaluation and provide feedback for improvements.
• Contact potential customers and identify new business opportunities.
• Stay abreast with customer needs, market trends and competitors.
• Maintain clear and complete sales reports for management review.
• Build strong relationships with customers for business growth.
• Analyze sales performances and recommend improvements.
• Ensure that sales team follows company policies and procedures at all times.
• Develop promotional programs to increase sales and revenue.
• Plan and coordinate sales activities for assigned projects.