Data Warehousing Job Vacancies in Pune

Job Title: Warehouse ExecutiveIndustry: Solar / Electrical ManufacturingLocation: Katraj PuneReporting To: Stores / Warehouse ManagerJob Summary:Responsible for warehouse operations, inventory records, and data entry of material movement to support smooth production in the solar manufacturing facility.Key ResponsibilitiesMaintain inventory records and stock data in ERP / ExcelHandle material inward and outward entriesPrepare GRN and dispatch documentationPerform data entry of daily stock transactionsCoordinate with purchase and production teams for material availabilitySupport stock verification and basic reportingRequirementsGraduate / Diploma in any disciplineBasic knowledge of Excel, ERP, or inventory software13 years experience in warehouse / stores operationsExperience in manufacturing industry preferred

As a Braze Consultant, your responsibilities will include:- Providing strategic guidance and technical expertise on the implementation and optimization of the Braze platform for clients- Collaborating with cross-functional teams to ensure successful integration of Braze with other systems such as CDP, CRM, and Data Warehouse- Designing and executing customer engagement strategies using the Braze platform to drive user behavior and retention

Work mode : Hybrid Overall 4-9 yrs of IT experience preferably in cloudMin 3 years in Azure Databricks on development projectsShould be 100% hands on in Pyspark codingShould have strong SQL expertise in writing advanced/complex SQL queriesDWH experience is a must for this roleExperience in programming using Python is an advantageExperience in data ingestion, preparation, integration, and operationalization techniques in optimally addressing the data requirementsShould be able to understand system architecture which involves Data Lakes, Data Warehouses and Data MartsExperience to own end-to-end development, including coding, testing, debugging and deploymentExcellent communication is required for this role

Store Cum Dispatch Executive to manage our warehouse operations and ensure timely and accurate delivery of products to our customers.

Role Summery you will be responsible for Analysing archiving and reporting requirements, source and destination systems and their data models and designing data transformation, archiving, reporting and analytics solutions that meet the functional and non-functional requirements. You will work closely with Project Managers to deliver the program. Dimension of Function Data Analysis, Data Modelling, Designing Data Solutions.Area of Responsibility Experienced Solutions Architect / Data Engineer with track record of creating large data tech solutions. Excellent understanding of the data tech solutions, specially Google Cloud. Data transformation and scripting experience. Sufficient programming knowledge to manage developer projects; for example, Python, JavaScript, SQL, etc. Working understanding of SQL Server 2008 & 2012. Developing software solutions. Familiar with industry data visualisation solutions.Knowledge / Experience Ability to present complex propositions in a simple manner. Able to articulate big ideas in plain language. Management of tech partners and experience at managing outsourcing / insourcing process. Experience working with internal/external dev teams and associated ways of working. Experience with multiple methodologies. Awareness of project management principles and experience of working with internal and external teams across multiple locations. Working knowledge of statistical techniques and predictive analytics also desirable. Excellent numerical and analytical skills Experience of statistical methodologies and data analysis techniques Ability to produce clear graphical representations and data visualisations. Knowledge of data analysis tools, for example, R Programming, Tableau Public, SAS, Apache Spark, Excel, RapidMiner Knowledge of data modelling, data cleansing, and data enrichment techniques An understanding of data protection issues Experience of working with Cloud based Data Analytics

Job Description AWS Data Engineer with min of 5 to 7 years of experience. Collaborate with business analysts to understand and gather requirements for existing or new ETL pipelines. Connect with stakeholders daily to discuss project progress and updates. Work within an Agile process to deliver projects in a timely and efficient manner. Design and develop Airflow DAGs to schedule and manage ETL workflows. Transform SQL queries into Spark SQL code for ETL pipelines. Develop custom Python functions to handle data quality and validation. Write PySpark scripts to process data and perform transformations. Perform data validation and ensure data accuracy and completeness by creating automated tests and implementing data validation processes. Run Spark jobs on AWS EMR cluster using Airflow DAGs. Monitor and troubleshoot ETL pipelines to ensure smooth operation. Implement best practices for data engineering, including data modeling, data warehousing, and data pipeline architecture. Collaborate with other members of the data engineering team to improve processes and implement new technologies. Stay up to date with emerging trends and technologies in data engineering and suggest ways to improve the team's efficiency and effectiveness.

Job PurposePlan, schedule, coordinate & execute testing activitiesResponsible for testing of systems to ensure delivery of Quality assured applications to production.Support Test Lead/ Test Manager in upward stakeholder management and day-to-day management of the QA & Test organizationJob ResponsibilitiesAssist with the planning and execution of Testing for a Project or BAU streamDevelop Test Plans, Status Reporting, Test Readiness Reviews and Test Completion Report as appropriateWork closely with off-shore team and on-shore team(s) to deliver projects to time, cost and quality requirements.Create data, conduct tests and analyze results to ensure that software meets or exceeds specified standards and /or customer requirements.Ensure that tests are successfully completed and documented and all problems are resolvedManage Risks and Issues associated with Testing engagementsQualificationsMinimum of 10 years of Testing experienceMust have strong analytical skills, reporting and problem solving skillsExcellent verbal and written communication skills(Must) Experience in Business intelligence and Data warehouse testing preferably in Hadoop Data Hub environment(Must) Expert in writing SQL queries and testing data flow across the data layers(Must) Expert in testing data quality, data integrity, data reconciliation and reporting solutions(Must) Good understanding on Data warehouse data models and creating test scenarios and cases(Preferred) Insurance (preferably general insurance) industry and product knowledge(Preferred) Experience in working with Agile teams(Preferred) Experience in DWH test automation with relevant tools.

Position: Data Engineer with Python.Location: RemoteDuration: 6 to 12 months+Work hours: 2/3 pm to 10/11 pm ISTType - ContractMinimum 5+ years in Data Engineer role.Expert in PythonFamiliarity with Spark, PySpark.Knowledge in at least any one of the Cloud platform - Azure or GCP or AWSExperience in writing complex and efficient ETL jobs and Data pipelines.Excellent in writing complex SQL Queries and ScriptsProven expertise in modern Data Architecture, Data Modeling, Database architecture, Database Design, Database programming (SQL, Python, etc..)Experience with analytics platforms in Cloud (Azure, GCP, AWS etc..)Experience designing and developing ETL and ELT processes in a variety of platforms (e.g. Azure Data Factory, Data Bricks, etc....)Experience with Data Collaboration Platforms (e.g. Calibra, Alation) and Automated meta data management solutionsExpertise in architecting Master Data Management, Operational Data Stores, Data Lakes, Data Warehousing solutions.

designing software components to improve reusability and maintainability.Develop backend functionalities with high-quality standards with proper unit tests.Build templates and platform extension to be reused to improve productivityDocument accurately the implemented designs and the produced code.Expr in Azure (ADF, Logic App), Azure Functions, SQL and Databases, languages like NodeJS or Python.

Notice Period Immediate JoinerC2H 1 year + ExtendCTC As per standard1) 5 to 8 years extensive hands on experience in working with Informatica power center tool in creating Informatica mapping,sessions,workflows,worklets etc. as per the business need. 2) Create the Unit test document, impact analysis document and various other supporting documents. 3) Informatica power center certification on version 10 will be an advantage.4) Good hands on experience in writing SQL queries, triggers, functions, procedures, packages. 5) Candidate should have well understanding on relational database management systems concepts and data warehousing concepts.6) Working knowledge on MS Sql Server will be an added advantage.7) Candidate should Work on new development as per the requirement from the customer/business analysts. 8) Support the exiting Insurance Data warehouse application and its peripheral components.9) Through understanding of water fall and agile development methodologies.10) Hands on experience in analyzing and understanding long Sql queries and its performance tuning aspects.11) Candidate should experience in working onshore/offshore model and able to interact and speak directly with customer and business persons. 12) Should have the ability to work and handle pressure situations.13) The person should be ready to work on process related activities at the project level.14) Sound understanding of Insurance business domain concepts and principles. This an advantage.15) Possesses solid analytical, organizational, and time-management skills.16) Excellent oral and written communication skills. 17) Ability to multitask and handle changing priorities with high level of quality.18) Informatica version 10 certification(Optional).19) Insurance domain certification(INS-21)(Optional)

Job Description :Senior MSBI Developer (SSIS) - BangaloreExperience required : 6 to 8 yearsLooking for immediate joiner (Work from home )SSIS with BFSI DomainLocation : Bangalore/ RemoteEducational : Any graduation- 6-8 years of work experience in designing and maintaining SSRS/SSIS environments Integrating, Migration, and conversions experience- Good experience in SSRS reports conversions of SSRS reports into crystal reports- Good experience in Architecture, team handling, and architecture flows.- Strong understanding and experience with Microsoft SQL Server database platform and SQL Server reporting and Analytics Services (SSRS, SSAS, and SSIS)- Hands-on experience with business intelligence, data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.- Good experience/ Knowledge of admin ,Data modeling in OLAP plus working technical knowledge of current systems software, protocols, and standards, including SQL, TSQL, ODBC, .NET, and Business Intelligence Standards- Expert experience in creating and using store procedures, views and user-defined functions- Well experience in Data Extraction, Transforming, and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS)- Develop Queries for generating drill down reports in SSRS latest version- Experience in working on SSRS Upgrade Projects (Upgrade from old version to new) Strong aptitude for modern BI solution development using Power BI and SQL Server- Deep Understanding of dimensional data modeling concepts as well as data warehouse design and lifecycle management principles- Collaborate with Performance Improvement, Quality Systems, and stakeholders to analyze and define data requirements needed to support the business processes; verify accurate data reporting; and integrate the data requirements throughout the data systemsNeed Immediate joiners or 15 days notice period.