8 Datawarehousing Jobs

As a Programmer at Crimson & Co, you will play a crucial role in various aspects of client-application development, including requirement analysis, user interaction, design, testing, and deployment. Your responsibilities will involve creating and enhancing in-house tools, developing dashboards and reporting tools, and supporting Robotic Process Automation (RPA) projects. It is essential to understand the business needs and translate them into programable logic. You will collaborate with team members globally or domestically, and may need to go on-site as required. Your tasks will include participating in requirement analysis, architecture, design, development, testing, code review, and deployment. You will work on conceptualizing design and results based on available data to aid customers in making daily/tactical decisions. Additionally, you will contribute to the development of project estimates, scheduling, and deliverables. Tools creation and report automation can be accomplished using technologies such as MS .NET (C#), Python, MS Power BI, RDBMS engines, and MS Office (VBA). To qualify for this role, you need a B.E. / B. Tech. in Computer Science or MCA from a reputable university, with 0-2 years of experience, focusing on .NET (C#). Familiarity with both Waterfall and Agile methodologies is required, along with knowledge of SQL and preferably a RPA tool like UiPath. You should have a fundamental understanding of Business Intelligence concepts, RDBMs, data warehousing, and datamarts. Strong analytical, technical, oral, and written communication skills are essential, including proficiency in Microsoft Office tools. Having experience in Python, VBA, DB performance tuning, data visualization tools like MS Power BI or Tableau, version control systems like SVN or Git, and knowledge of SDLC models is a plus. Demonstrated expertise in at least one full life cycle Analytics or Systems integration engagement is advantageous. An interest in application training and support is beneficial. At Crimson & Co Mumbai office, you will be part of a collaborative and supportive team that specializes in Network and Distribution Center (DC) design and WMS selection services. The work environment is described as tight-knit, like a family, where team members help each other tackle challenges and nurture talent. The company offers a framework for career development and encourages employees to take on responsibility and grow into future leaders. Joining Crimson & Co offers you the opportunity for global exposure and direct client interaction, in a collaborative and growth-oriented environment. The organization's flexible structure allows new recruits to develop skills across various specialties, contributing to a multidisciplinary approach. Projects range from strategic initiatives to operational optimization, often within an international context. The company promotes a culture of mutual support and shared values, fostering personal and professional growth among team members.,

You should have at least 8+ years of experience in designing and implementing reports/dashboards using the PowerBI tool. Additionally, you should possess a minimum of 3+ years of direct management/supervisory experience. Your expertise should include a deep understanding of Datawarehousing and database concepts, as well as familiarity with the lifecycle of report development work. Proficiency in BI fundamentals is essential, along with hands-on experience in Microsoft SQL Server Database development, any RDBMS tool, or Azure Analysis Services. Your responsibilities will include defining all aspects of software development, from selecting the appropriate technology and workflow to establishing coding standards. You will be required to effectively communicate concepts and guidelines to the development team, providing technical guidance and coaching to the reporting team. Monitoring the progress of report/dashboard development to ensure alignment with DW/RDBMS design will also be part of your role. Engagement with stakeholders is crucial to identify business Key Performance Indicators (KPIs) and determining the correct tools/mechanisms to record them. You will be responsible for presenting actionable insights through reports and dashboards. Strong analytical and problem-solving skills are essential, along with excellent interpersonal and written communication abilities. Key Skills: - Power BI - Database concepts - Communication - Azure Analysis Services - Microsoft SQL Server - SQL - BI fundamentals - Datawarehousing - Report development - Problem-solving - Supervisory experience - Dashboards,

You will work closely with business IT partners to gain a deep understanding of business and data requirements. Your responsibilities will include acquiring data from primary or secondary sources, conducting data profiling, and interpreting data to provide quick analysis. You will be expected to identify trends and patterns in complex datasets, develop business matrices, proof of concepts, source mapping documents, and raw source data models. Additionally, you will play a key role in identifying and defining opportunities for process improvement. To excel in this role, you must possess a strong proficiency in Excel, databases (such as Redshift, Oracle), and programming languages (such as Python and R). Your ability to write SQL queries for data profiling, analysis, and presenting insights to stakeholders will be crucial. Familiarity with Datawarehousing and Data Modelling concepts, as well as exposure to the IT Project Lifecycle, will be highly beneficial. Previous experience in the Finance or Life Science domains is preferred. Knowledge of BI tools would be an added advantage for this position.,

NTT DATA is looking for a Business Intelligence Specialist to join their team in Chennai, Tamil Nadu, India. The ideal candidate should have at least 8 years of experience in ETL and Datawarehousing. They should be proficient in Transformations, Mapping Configuration, and lookups in any ETL tool, with experience in Informatica being an added advantage. Additionally, the candidate should possess good knowledge of Oracle, SQL, and PL/SQL, along with experience in integrating data with sources like SFDC and SAP. Familiarity with Business Objects and other business intelligence platforms is preferred. The candidate should have a strong understanding of functional requirements and Business Processes, along with excellent communication and facilitation skills. NTT DATA is a global innovator of business and technology services, serving 75% of the Fortune Global 100. They are dedicated to helping clients innovate, optimize, and transform for long-term success. As a Global Top Employer, NTT DATA has experts in over 50 countries and a partner ecosystem of established and start-up companies. Their services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation, and management of applications, infrastructure, and connectivity. NTT DATA is a leading provider of digital and AI infrastructure worldwide and is part of the NTT Group, investing over $3.6 billion annually in R&D to support organizations and society in transitioning confidently and sustainably into the digital future. Visit us at us.nttdata.com.,

Role & responsibilities 10+ years of related experience Data Engineers have to manage ETL Design Requirements, their implementation and maintenance. They should be able to develop/Deploy/Test and manage ETL Package solutions. They have to design/develop ETL jobs and design data models as per the analytics requirements. Data modeling Engineer have to Develop, deploy and maintain Data Models. They have to do dimensional modeling for data marts. They are expected to integrate and map data from multiple and complex data sources. Their role includes development of models/Cubes for depicting online and in performance tuning the same so that user queries are addressed. Data Steward should be capable of handling Data Quality interventions for Large enterprise projects. They have to understand the data quality issues and have to develop data quality related solutions using the tools (Python, SQL, Dataflux etc.). They Should be familiar with data cataloguing tools, Talend, Informatica etc. They have to manage PFMS Data Dictionary and have to do Data Cleaning and Implementation of Exception handling for ETL Packages. Minimum 10 years of Experience in Data Warehousing Projects. Must have experience of handling Data Quality interventions for Large enterprise projects. Should understand data quality issues and should have capability of using a tool (Python, SQL, Dataflux etc.) for developing data quality related solutions. Should be familiar with data cataloguing tools, Talend, Informatica etc. Qualification : BE / B. Tech / M. Tech/MCA in Computer/IT)/ Electronics & Tele-Communication Engineering Certification: MCSE: Data Management and Analytics, Microsoft Certified: Azure Data Engineer Associate CompTIA Data+ Microsoft Certified: Data Analyst Associate SAS Certified Big Data Professional BE / B. Tech / M. Tech/MCA in Computer/IT)/ Electronics & Tele-Communication Engineering Certification: MCSE: Data Management and Analytics, Microsoft Certified: Azure Data Engineer Associate CompTIA Data+ Microsoft Certified: Data Analyst Associate SAS Certified Big Data Professional

Requirements:What Youll Do:Analyse Business Requirements: Understand and evaluate client needs. Data Model Analysis & GAP Analysis: Review the current data model and identify gaps relative to business requirements. Design BI Schema: Develop Data Warehouse/Business Intelligence schemas. Data Transformation: Utilize Power BI, Tableau, SQL, or ETL tools to transform data. Create Reports & Dashboards: Develop interactive reports and dashboards with calculated formulas. SQL Expertise: Write complex SQL queries and stored procedures. Design BI Solutions: Architect effective business intelligence solutions tailored to business needs.Team Management: Lead and guide a team of BI developers.Data Integration: Integrate data from multiple sources into BI tools for comprehensive analysis. Performance Optimization: Ensure reports and dashboards run efficiently. Stakeholder Collaboration: Work with stakeholders to align BI projects with business goals. Mandatory Knowledge: In-depth knowledge of Data Warehousing; Data Engineering is a plus.What Youll Bring:Educational Qualification: B.Tech in Computer Science or equivalent. Experience: Minimum 7+ years of relevant experience.Share your resume with details on current CTC, expected CTC, and preferred location. Location - Hyderabad, Ahmedabad, Gurgaon, Indore (India)

Skill Set: MYSQL/Oracle , Python , Pyspark , AWS , Datawarehousing , Data Modeling Job Description: We are seeking a highly motivated and experienced DB Lead with a strong background in MYSQL/Oracle and technical leadership to join our dynamic team. The ideal candidate will have around 8+ years of experience in the IT industry, including extensive hands-on knowledge of the MYSQL/Oracle and expertise in Python and Pyspark along with AWS. Key Responsibilities: Roles & Responsibility Database Design and Architecture: Lead the design, implementation, and optimization of scalable and efficient database architectures to support business requirements. Data Modeling and Management: Develop data models, database schemas, and data pipelines for efficient storage, retrieval, and management of data across platforms. AWS Database Services: Manage AWS databases, including Aurora (PostgreSQL/MySQL) and DynamoDB, optimizing for cost, performance, and scalability. Python Scripting: Use Python for data manipulation, automation of database tasks, and integration with other systems. Database Performance Optimization: Monitor and optimize database performance, troubleshoot issues, and ensure high availability and disaster recovery. Documentation and Reporting: Maintain up-to-date documentation for database architectures, processes, and configurations. Generate reports on database performance, issues, and improvements. Primary Skills (Essential): At least five years of professional programming experience writing performant stored procedures/functions/SQL statements Database Management: Expertise in database administration, tuning, and troubleshooting. SQL Expertise: Strong SQL skills across various database systems. AWS Databases: Proficiency with Amazon Aurora (MySQL/PostgreSQL) and DynamoDB, including setup, optimization, and scaling. Python: Strong Python skills for data manipulation, automation, and database task management. Data Modeling: Proficiency in designing logical and physical data models to support business processes. Secondary Skills (Highly Beneficial): Snowflake: Hands-on experience with Snowflake data warehousing, data modeling, and data ingestion processes. ETL/ELT Tools: Familiarity with ETL/ELT processes and tools (e.g., Apache Airflow, AWS Glue) for data transformation and ingestion. Data Governance and Compliance: Knowledge of data governance practices, including data security and regulatory compliance standards. Required Skills and Qualifications: Experience: Around 8 years of overall IT experience, with at least 5 years focused on MYSQL/Oracle and 2+ years in AWS. Technical Skills: In-depth knowledge of the MYSQL/Oracle, including Python, Pyspark, and Data Modeling. Experience with AWS Leadership Skills: Excellent communication, presentation, and interpersonal skills. Ability to manage multiple presales opportunities simultaneously and work in a fast-paced environme We are seeking a highly motivated and experienced DB Lead with a strong background in Python and technical leadership to join our dynamic team. The ideal candidate will have around 8 years of experience in the IT industry, including extensive hands-on knowledge of the MYSQL/Oracle and expertise in Python . Location - Bengaluru,Kochi,Hyderabad,Chennai

Greetings from Coronis Ajuba!! We are looking to hire Automation Test Engineers for a full-time opportunity, preferably candidates based in Chennai, who can join us within 15 days. Experience Level : 5 Years above Job Location : Chennai Job Timings : 11 AM to 8 PM Good communication skills with a collaborative mindset. 5 + years of experience in Data Warehouse / ETL Testing. Proficiency in writing complex SQL queries for data validation. Experience with ETL tools (Informatica). Strong understanding of data models, dimensional modeling, snowflake schemas. Experience in Web and API Testing (Manual and Automation). Hands-on experience with Selenium, RestAssured, Postman and JMeter. Familiarity with Test Management tool Zephyr Scale, and Defect Tracking in Jira. Knowledge of Agile/Scrum methodologies. Interested candidates, please share your updated resume to mahalakshmi.chandrasekaran@coronishealth.com Regards, Mahalakshmi C Sr Team Lead - HR