dwh-jobs-in-hyderabad, Hyderabad

7 Dwh Jobs nearby Hyderabad

Toggle to save search
posted 1 month ago

Data Engineer - Investment domain

Technogen India Pvt. Ltd.
experience3 to 9 Yrs
location
Hyderabad, Telangana
skills
  • Informatica
  • DWH
  • Python
  • Strong Sql
  • Investment domain
Job Description
As a Data Engineer in the Investment Domain, you will be responsible for the following: Role Overview: - You should have 7-9 years of experience with data analytics, data modelling, and database design. - A minimum of 3 years of coding and scripting experience in Python, Java, and Scala is required. - 3+ years of experience with the Spark framework is essential. - You must have at least 5 years of experience with ELT methodologies and tools. - Proficiency in designing, developing, tuning, and troubleshooting SQL is a must. - Knowledge of Informatica Power center and Informatica IDMC is expected. - Familiarity with distributed, column-oriented technologies like Vertica and Snowflake is preferred. - Strong data analysis skills for extracting insights from financial data are necessary. - Proficiency in reporting tools such as Power BI and Tableau is a plus. Key Responsibilities: - Designing, developing, and tuning data analytics, data modelling, and database systems. - Coding and scripting in Python, Java, and Scala. - Working with the Spark framework for data processing. - Implementing ELT methodologies and tools for data transformation. - Utilizing SQL for database development and troubleshooting. - Utilizing Informatica Power center and Informatica IDMC for data management. - Utilizing distributed, column-oriented technologies like Vertica and Snowflake. - Analyzing financial data to extract valuable insights. - Creating reports using tools like Power BI and Tableau. Qualifications Required: - Domain knowledge of Investment Management operations including Security Masters, Securities Trade and Recon Operations, Reference data management, and Pricing. - Familiarity with regulatory requirements and compliance standards in the investment management industry. - Experience with IBORs such as Blackrock Alladin, CRD, Eagle STAR (ABOR), Eagle Pace, and Eagle DataMart. - Familiarity with investment data platforms such as GoldenSource, FINBOURNE, NeoXam, RIMES, and JPM Fusion. If you possess the required skills and experience in data analytics, data modelling, database design, and the investment domain, please drop your resume to jyothsna.g@technogenindia.com.,
ACTIVELY HIRING

Top Companies are Hiring in Your City

For Multiple Roles

Jio Platforms Ltd
Jio Platforms Ltdslide-preview-Genpact
posted 2 months ago
experience3 to 7 Yrs
location
Hyderabad, Telangana
skills
  • AWS
  • SQL
  • Python
  • DWH
  • Redshift
  • Cloud technologies
Job Description
Job Description: As an AWS Data Engineer with Redshift, your role will involve team management and client handling skills, focusing on SLA tracking and resolving job failures. You will be expected to have excellent knowledge in Cloud technologies, particularly AWS. Your expertise in AWS Data Engineering pipelines, SQL, Python, and DWH will be crucial for this role. Additionally, you will collaborate with AWS/SRE/D3C development teams to manage current job schedules and ensure adherence to SLAs within the AWS environment. Key Responsibilities: - Manage teams and handle clients, tracking SLAs and resolving job failures - Demonstrate strong expertise in Cloud technologies, particularly AWS - Develop and maintain AWS Data Engineering pipelines using SQL, Python, and DWH - Collaborate with AWS/SRE/D3C development teams to schedule jobs and ensure SLA compliance within the AWS environment Qualifications Required: - Proven experience in team management and client handling - Strong proficiency in Cloud technologies, with a focus on AWS - Proficiency in SQL, Python, and Data Warehouse technologies - Excellent communication and coordination skills for working with cross-functional development teams,
ACTIVELY HIRING
posted 3 weeks ago
experience8 to 12 Yrs
location
Hyderabad, Telangana
skills
  • Informatica Power Center
  • Oracle
  • Data Warehousing
  • Dimensional modeling
  • Data governance
  • Data quality
  • Code Analysis
  • Refactoring
  • Communication
  • Collaboration
  • SDLC
  • Agile methodologies
  • Customer communication
  • Adaptive
  • ETLELT development
  • SQLPLSQL
  • DWH concepts
  • Legacy ETL pipelines
  • Cloud Experience
  • GCP data stack
  • DevOps Mindset
  • Status reporting
  • Team player
  • Proactive
Job Description
Role Overview: As a highly skilled and experienced Informatica Power Center Technical Lead, you will be responsible for ETL development using Informatica Power Center. Your role will involve strong experience in ETL/ELT development and lifecycle management, advanced proficiency in Oracle SQL/PL/SQL, data warehousing concepts, code analysis, and refactoring. You should have the ability to work independently, communicate effectively, collaborate with various stakeholders, and possess a good understanding of cloud technologies. Key Responsibilities: - Develop ETL processes using Informatica Power Center - Utilize advanced SQL/PL/SQL skills for Oracle, including performance tuning and data modeling - Apply solid understanding of data warehousing concepts, dimensional modeling, data governance, and data quality - Review and enhance legacy ETL pipelines through code analysis and refactoring - Take ownership of tasks, manage priorities, and deliver results with minimal supervision - Document designs, decisions, and operational runbooks effectively - Collaborate with data engineers, analysts, and business stakeholders - Demonstrate familiarity with GCP data stack for DWH, including BigQuery, Dataflow/Dataproc, Cloud Composer, Cloud Storage, and Looker - Embrace a DevOps mindset and work collaboratively with the team - Apply knowledge of SDLC and Agile methodologies - Communicate with customers and provide daily status reports - Exhibit strong oral and written communication skills - Work well in a team environment - Display proactive and adaptive behavior Qualifications Required: - 8 to 10 years of experience in ETL development using Informatica Power Center - Proficiency in Oracle SQL/PL/SQL, data warehousing concepts, and data modeling - Strong communication skills with the ability to collaborate effectively - Familiarity with cloud technologies, particularly GCP data stack - Understanding of SDLC and Agile methodologies - Proven track record of working independently and delivering results - Ability to analyze and refactor code for ETL pipelines - Demonstrated ability to prioritize tasks and manage workload effectively (Note: Additional details about the company were not provided in the job description.),
ACTIVELY HIRING
question

Are these jobs relevant for you?

posted 2 months ago
experience5 to 9 Yrs
location
Hyderabad, Telangana
skills
  • SQL
  • ETL Testing
  • Snowflake
  • Azure
  • Change Data Capture
  • JIRA
  • PowerPoint
  • Excel
  • Bloomberg
  • DWH Concepts
  • Qlik Replicate
  • Data warehousing Concepts
  • Talend Cloud Data Integration
  • PentahoKettle
  • Xray defect management
  • Financial domain
  • State Street
  • Charles River Development CRD
  • Thirdparty data providers
  • Reuters
  • MSCI
  • Rating agencies
Job Description
As a QA Engineer, you play a crucial role in maintaining the quality and accuracy of data in ETL Testing, Snowflake, and DWH Concepts. Your responsibilities include: - Strong SQL knowledge & debugging skills are vital for analyzing and troubleshooting data issues effectively. - Experience with Azure and Snowflake Testing is advantageous. - Familiarity with Qlik Replicate and Compose tools, especially Change Data Capture tools, is a valuable asset. - Thorough understanding of Data warehousing Concepts and proficiency in ETL tools like Talend Cloud Data Integration, Pentaho/Kettle tool. - Knowledge of JIRA and Xray defect management tool is beneficial. - Exposure to the financial domain is a plus. - Testing the data-readiness to address code or data issues. - Ability to rationalize problems, exercise judgment, and innovate solutions effectively. - Collaborative experience across regions (APAC, EMEA, and NA) to identify root causes of code/data issues and propose permanent solutions. - Experience with State Street and Charles River Development (CRD) is advantageous. - Proficiency in tools such as PowerPoint, Excel, and SQL. - Exposure to Third-party data providers like Bloomberg, Reuters, MSCI, and other Rating agencies is considered a plus. Key Attributes: - Team player with a professional and positive approach. - Creative, innovative, and able to think outside of the box. - Strong attention to detail during root cause analysis and defect issue resolution. - Self-motivated & self-sufficient. - Effective communicator, both written and verbal. - Brings a high level of energy with enthusiasm to motivate the team. - Ability to work under pressure with tight deadlines and/or multiple projects. - Experience in negotiation and conflict resolution. Please note: State Street's Speak Up Line is available for reporting any concerns.,
ACTIVELY HIRING
posted 2 weeks ago
experience3 to 7 Yrs
location
Hyderabad, Telangana
skills
  • SQL
  • ETL Testing
  • Data Warehousing
  • Dimensional Modeling
  • Data Validation
  • DWH Testing
  • Performance Testing
  • Defect Management
  • Collaboration
  • Complex SQL Querying
Job Description
As a Data Warehouse (DWH) / ETL Test Engineer with 3 to 6 years of experience, your role will involve ensuring the accuracy, completeness, and integrity of data flowing through Extract, Transform, Load (ETL) pipelines and residing in the enterprise Data Warehouse. Your expertise in complex SQL queries, dimensional modeling, and commitment to data quality assurance will be crucial for this position. Key Responsibilities: - Design, develop, and execute detailed test plans and test cases for ETL processes, data migrations, and DWH reports/dashboards. - Perform comprehensive data validation and reconciliation between source systems, staging areas, and the target data warehouse/data marts. - Write and execute complex SQL queries to validate data transformations and business rules. - Verify data modeling, fact and dimension table loading, historical data maintenance, and slowly changing dimensions (SCDs). - Test data flow across various ETL tools and technologies. - Execute tests to validate ETL job execution performance and ensure data loads meet defined service level agreements (SLAs). - Identify, log, track, and retest defects using defect management tools and communicate status updates clearly to stakeholders. - Work closely with ETL Developers, Data Architects, Business Analysts, and BI teams to understand requirements and resolve data quality issues. Required Qualifications (3-6 Years): - 3-6 years of professional experience dedicated to Data Warehouse (DWH) and ETL testing. - Expert-level proficiency in writing and troubleshooting complex SQL queries. - Strong conceptual knowledge of Data Warehousing principles, including dimensional modeling, schemas, OLAP/OLTP concepts, and data mart design. - Proven experience in the full software testing lifecycle specific to data projects. - Hands-on experience with at least one major ETL tool or cloud-native ETL services. - Excellent written and verbal communication skills to explain technical issues to both technical and non-technical audiences.,
ACTIVELY HIRING
posted 1 week ago
experience5 to 9 Yrs
location
Hyderabad, Telangana
skills
  • AWS
  • Automation
  • Data analytics
  • Kubernetes
  • Python
  • Git
  • Jenkins
  • Ansible
  • Databases
  • Cloudbased solutions
  • Micro services architectures
  • AWS networking
  • Security best practices
  • DWH tooling
  • S3
  • EC2
  • RDS
  • EFS
  • Lambda
  • Microservice architecture
  • IAC
  • Cloud formation
  • Terraform
  • Devops orchestration tools
  • Cloud infrastructure management
  • Cloud Migration
  • AWS Services
Job Description
As a Cloud Infrastructure Engineer at ValueLabs, you will play a crucial role in designing and implementing solutions, including scalable cloud-based solutions and microservices architectures. Your responsibilities will include: - Experience in automation for deploying and managing infrastructure, database, and networking architectures for Internet-scale applications. - Proficiency in migrating applications, databases, and storage systems to AWS from Enterprise On-premises infrastructure. - Familiarity with setting up AWS networking fundamentals such as VPC, Subnets, security Groups, DHCP, Route 53 DNS, etc. - Strong understanding of AWS Security best practices and setting up an end-to-end security model for AWS-based Architecture. - Hands-on experience with AWS Data analytics and DWH tooling, including Glue, EMR, Athena, Redshift spectrum, etc. - Proficiency in working with S3, EC2, RDS, EFS, Lambda, and other serverless technologies. - Understanding of Kubernetes framework and good to have knowledge of EKS. - Clear concept of microservice architecture and strong programming skills in Python or any other language. - Hands-on experience in IAC like cloud formation or Terraform. - Experience in DevOps orchestration tools like Git, Jenkins, Ansible. - Assist in designing and building reliable, fault-tolerant cloud infrastructure following industry best practices. - Manage and document cloud infrastructure and policies. - Identify automation opportunities and implement using tools such as Ansible, Terraform, cloud formation templates, and other similar tools. - Collaborate with projects to facilitate the adoption of cloud infrastructure and services to reduce cost and deployment times. - Mentor and train other members of the client's IT team. - Integrate on-premises policies, solutions, and technologies with cloud infrastructure where applicable. - Implement cloud security best practices and work with Security teams to design and implement a security infrastructure. - Act as a technical liaison between customers, service engineering teams, and support. - Perform Cloud Migration of Databases using AWS Services like DMS, Data Pipeline. If you are passionate about cloud infrastructure and have the required skills and experience, we encourage you to share your resume with us at grishmaravindrar@valuelabs.com along with the following details: Total Experience: Current CTC: Expected CTC: Notice Period: Current Location: Interested to relocate to Hyderabad. We at ValueLabs are dedicated to fostering a collaborative and dynamic work environment that promotes growth, learning, and innovation. Join us in our mission to revolutionize businesses with innovative solutions.,
ACTIVELY HIRING
posted 2 weeks ago
experience6 to 10 Yrs
location
Hyderabad, Telangana
skills
  • Oracle SQL
  • ServiceNow
  • Oracle Business Intelligence OBIEE
  • Agile Way of Working
Job Description
As an Oracle Business Intelligence (OBIEE) Developer with 6 to 8 years of relevant experience, you will be responsible for the following key responsibilities: - Extensive knowledge in Creating Physical, Business Model and Mapping layers in the OBIEE repository. - Designing and developing OBIEE repository (RPD) and Dashboards. - Developing complex custom Dashboards, Analysis, and reports. - Creating complex queries, data models, hierarchies, dimensions, facts, and measures. - Troubleshooting and resolving issues related to OBIEE. - Testing and deploying OBIEE applications. - Utilizing your knowledge in DWH or BI environment and infrastructure. - Applying strong analytical and problem-solving skills effectively. Qualifications required for this role as an Oracle Business Intelligence (OBIEE) Developer: - Proficiency in Oracle Business Intelligence (OBIEE). - Strong command over Oracle SQL. - Familiarity with Agile Way of Working. - Experience with ServiceNow. Please note that the company's additional details were not provided in the job description.,
ACTIVELY HIRING
posted 1 week ago
experience8 to 12 Yrs
location
Punjab
skills
  • ETL tools
  • SQL Server
  • MySQL
  • Snowflake
  • Tableau
  • Power BI
  • Python
  • AWS
  • Azure
  • Data MartEDW methodologies
  • star schemas
  • snowflake schemas
  • fact
  • dimension tables
  • BigQuery
Job Description
As an experienced ETL & DWH Engineer/Data Analyst with over 8 years of expertise in data integration, warehousing, and analytics, your role is crucial in leading complex data engineering projects from design to deployment. Your deep technical knowledge in ETL tools, data modeling, and leadership abilities will be instrumental in ensuring project success. **Key Responsibilities:** - Hands-on experience (4+ years) with ETL tools like SSIS, Informatica, DataStage, or Talend. - Proficiency in relational databases such as SQL Server and MySQL. - Strong understanding of Data Mart/EDW methodologies. - Designing star schemas, snowflake schemas, fact and dimension tables. - Familiarity with Snowflake or BigQuery. - Knowledge of reporting and analytics tools like Tableau and Power BI. - Proficiency in scripting and programming using Python. - Experience with cloud platforms like AWS or Azure. - Leading recruitment, estimation, and project execution. - Exposure to Sales and Marketing data domains. - Working with cross-functional and geographically distributed teams. - Translating complex data problems into actionable insights. - Excellent communication and client management skills. - Self-starter with a collaborative attitude and problem-solving mindset. **Qualifications Required:** - Bachelor's degree in Computer Science, Information Technology, or related field. - Minimum 8 years of experience in ETL, data warehousing, and analytics. - Strong expertise in ETL tools, data modeling, and database management. - Proven track record of leading and delivering complex data engineering projects. - Certification in relevant technologies (e.g., AWS, Azure, ETL tools) is a plus. The company values your ability to deliver high-level and low-level design documents for middleware and ETL architecture, review data integration components, ensure delivery quality and timeliness, provide technical guidance to junior team members, drive QA processes, lead issue escalation, and support planning and resourcing across data engineering efforts. Your contributions will play a key role in the success of global data implementations and continuous improvement initiatives.,
ACTIVELY HIRING
posted 2 months ago

Simcorp and DWH Business Analyst

Societe Generale Global Solution Centre
experience3 to 7 Yrs
location
Karnataka
skills
  • Business Analysis
  • Agile
  • JIRA
  • Manual testing
  • SQL queries
  • Change Management
  • Release management
  • Kanban
  • Scrum
  • SAFe
  • Design thinking
  • Testing methodologies
  • BDD
  • Database basics
  • UIUX principles
  • Excel features
  • Unit testing frameworks
  • UIUX principles
  • User journey mapping
Job Description
Role Overview: As a Business Analyst, you will play a crucial role in creating detailed business analysis, optimizing existing processes, and ensuring bug-free release validations. You will also be responsible for maintaining communication with stakeholders, enriching functional documents, and mentoring team members on Agile and BA skills. Key Responsibilities: - Create a detailed business analysis by outlining problems, opportunities, and solutions. - Ensure accurate and consistent delivery of committed artifacts by adhering to agile development methodologies. - Develop new testing scenarios to enhance the efficiency of existing processes. - Optimize existing business processes to meet stakeholder expectations. - Participate in team ceremonies, including agile practices and chapter meetings. - Perform bug-free release validations and generate test and defect reports. - Adhere to change management and release management processes. - Maintain clear and timely communication with stakeholders on requirements, planning, and issues. - Enrich existing functional documents to keep them up to date. - Address email queries based on priority and urgency until closure. - Ensure adherence to scrum methodology and foster best practices in the team as an Agile Master. - Assist Product Owner/Proxy PO in prioritizing user stories and preparing the backlog regularly. - Resolve team challenges to ensure on-time deliverables and self-organization. - Drive relentless improvement through retrospectives and review/adapt workshops. - Be accountable for Feature team deliveries. - Mentor and coach team members on Agile and BA skills. Qualifications Required: - Proficiency in Business Analysis methodologies, Business/process flows, GAP analysis, User stories creation, acceptance criteria, and JIRA tool. - Familiarity with Testing methodologies, including Test case preparation, Manual testing, BDD, Helios, and Zephyr scale. - Knowledge of Testing tools & Frameworks such as Unit testing frameworks (NUnit, xUnit, Junit, Jasmine/Karma), SQL queries, Database basics (Oracle DB, SQL server, Postgre database), UI/UX principles (Design thinking, UX principles, user journey mapping), Excel features, and Change Management & Release management tools like Ezpulse, Unity, JIRA, Notify Now, Zephyr. - Understanding of Agile methodologies including Kanban, Scrum, SAFe, Spotify frameworks.,
ACTIVELY HIRING
posted 2 months ago
experience10 to 15 Yrs
location
All India
skills
  • Snowflake
  • performance tuning
  • stored Procedures
  • DWH
  • GitHub
  • data quality
  • data governance
  • SQL
  • Troubleshooting
  • performance tuning
  • stored procedures
  • time travel
  • Agile Methodology
  • Scrum
  • Snow SQL CLI
  • Snow Pipe
  • Snowflake stored producers
  • schema modelling
  • data modelling
  • ELT
  • Snowflake SQL
  • Snowflake Task Orchestration
  • ETL concepts
  • DBT CLI
  • DBT Cloud
  • DBT scripting
  • SQL processes
  • ETL processes
  • data pipeline build
  • CICD process
  • GitHubDBT Snowflake integrations
  • Analytical functions
  • problemsolving
  • resource monitors
  • virtual warehouse sizing
  • query performance tuning
  • zerocopy clone
  • data auditing
Job Description
As an experienced Manager/Senior Manager with 10-15 years of experience, you will be responsible for the following: - Working experience in Snowflake, including the use of Snow SQL CLI, Snow Pipe creation of custom functions, Snowflake stored producers, schema modelling, and performance tuning. - Expertise in Snowflake data modelling, ELT using Snowflake SQL, Snowflake Task Orchestration, implementing complex stored Procedures and standard DWH and ETL concepts. - Extensive experience in DBT CLI, DBT Cloud, GitHub version control and repository knowledge, and DBT scripting to design & develop SQL processes for complex ELT processes and data pipeline build. - Ability to independently envision and develop innovative ETL and reporting solutions and execute them through to completion. - Triage issues to find gaps in existing pipelines and fix the issues. - Analyze the data quality, align the technical design to data governance, and address all the required non-business but operational requirements during the design and build of data pipelines. - Develop and maintain data pipelines using DBT. - Provide advice, guidance, and best practices around Snowflake. - Provide guidance on moving data across different environments in Snowflake. - Create relevant documentation around database objects. - Troubleshoot production support issues post-deployment and come up with solutions as required. - Good Understanding and knowledge of CI/CD process and GitHub->DBT-> Snowflake integrations. - Advance SQL knowledge and hands-on experience in complex query writing using Analytical functions, Troubleshooting, problem-solving, and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge of stored procedures. - Experience in Snowflake advanced concepts such as resource monitors, virtual warehouse sizing, query performance tuning, zero-copy clone, time travel, and understanding how to use these features. - Help joiner team members to resolve issues and technical challenges. - Drive technical discussions with client architect and team members. - Good experience in developing scripts for data auditing and automating various database platform manual activities. - Understanding of the full software lifecycle and how development teams should work with DevOps to create more software faster. - Excellent communication, working in Agile Methodology/Scrum. You will be working in Bangalore, Chennai, Gurugram, Kolkata, or Pune locations. Immediate joining is required with a maximum of 30 days for the joining process.,
ACTIVELY HIRING
posted 2 months ago
experience10 to 14 Yrs
location
Maharashtra, Pune
skills
  • BI reporting
  • DWH
  • Power BI
  • Tableau
  • Oracle
  • SQL Server
  • Agile
  • SDLC
  • ETL solutions
  • analytics solutions
  • SQL programming
  • cloud technology stack
Job Description
As a Manager Software Engineer in the Business Insights & DWH engineering team at Mastercard, you will lead scrum teams of software developers and testers to deliver quality software solutions. Your role will involve providing technical leadership in BI reporting, ETL solutions, DWH, and other analytics solutions. You will work closely with product and architecture teams to drive innovation and ensure efficient project delivery. Additionally, you will be responsible for automating software delivery processes, introducing new technologies, and fostering effective partnerships across organizations. - Manage scrum teams to develop quality software solutions efficiently. - Lead major cross-department initiatives with broad scope and long-term implications. - Provide technical leadership in BI reporting, ETL solutions, DWH, and analytics solutions. - Collaborate with product and architecture teams on product definition and technical design. - Ensure project staffing, training, and management align with approved guidelines. - Drive prioritization decisions and trade-offs with product partners. - Automate and simplify software delivery processes. - Introduce new technologies following enterprise guidelines. - Build effective partnerships across organizations. - Lead by example with hands-on engineering excellence. - Provide technology leadership in BI, DWH, and cloud data platforms. - Stay updated on analytics technology trends and industry best practices. - Participate in architectural discussions and agile ceremonies. - Support System and User Acceptance Testing. - Adhere to Agile processes and actively participate in SDLC practices. - Minimum 10+ years of experience in Requirement management, Business Insights, Data Warehousing, and OnPrem/Cloud data platforms. - Strong understanding of software systems, cloud data platforms, BI reporting, and ETL solutions. - Proficiency in DWH and SQL programming. - Hands-on experience with analytics tools like Power BI, Tableau, etc. - Exposure to cloud technology stack such as Databricks, Snowflake, AWS, or Azure is a plus. - Familiarity with Oracle, SQL Server, or other relational databases. - Experience in designing and implementing solutions focusing on non-functional concerns. - Ability to collaborate with cross-functional teams and stakeholders effectively. - Strong communication skills at all levels of the organization. - Experience in Agile and SDLC practices. - Ability to address challenges and opportunities with urgency, fairness, and decency.,
ACTIVELY HIRING
posted 6 days ago

Testing Practices

E2E Infoware Management Services
experience3 to 7 Yrs
location
Chennai, Tamil Nadu
skills
  • Manual Testing
  • Automation Testing
  • Java
  • Selenium
  • Junit
  • Database Testing
  • DWH Testing
  • Big Data Testing
Job Description
Job Description: As a Test Engineer, you will be responsible for the following tasks: - Perform Manual Testing including Block, White, and Gray Box Testing. - Conduct Automation Testing using Java with a focus on Selenium. - Utilize Junit for testing purposes. - Implement Database Testing with strong database skills. - Execute Big Data Testing and Data Warehouse Testing. Qualifications Required: - Proficiency in Manual and Automation Testing methodologies. - Strong experience in Java and Selenium for Automation Testing. - Knowledge of Junit for test execution. - Ability to perform Database Testing with a good understanding of database concepts. - Experience in Big Data Testing and Data Warehouse Testing would be beneficial. (Note: No additional details of the company were provided in the job description),
ACTIVELY HIRING
posted 2 days ago
experience3 to 7 Yrs
location
All India
skills
  • Python
  • AWS
  • Glue
  • EMR
  • Spark
  • Scala
  • Kubernetes
  • Kafka
  • Airflow
  • DBT
  • SQL
  • Data Warehousing
  • Data Modeling
  • Data Integration
  • Data Governance
  • Data Quality
  • Data Profiling
  • Data Validation
  • Apache Kafka
  • Machine Learning
  • DevOps
  • Pyspark
  • Snowflake Snow SQL
  • Redshift
  • Dagster
  • ETLELT
  • Streaming Pipelines
  • Terraform
  • CloudFormation
Job Description
As a Remote Senior Data Engineer (ETL Data Modeling) for our client in the UK, you will play a crucial role in expanding the external technical platform, meeting customer needs, and promoting technical excellence within the team. **Key Responsibilities:** - Implement ETL/ELT pipelines using Python, Pyspark, and Snowflake's Snow SQL within and outside of a data warehouse. - Assist in the migration from Redshift DWH to Snowflake. - Design, implement, and maintain data warehouse/data lake infrastructure utilizing AWS big data stack, Python, Redshift, Snowflake, Glue/lake formation, EMR/Spark/Scala, etc. - Collaborate with data analysts to enhance value-creating capabilities, including data integrations, transformations, model features, and statistical/machine learning models. - Engage with various teams like Product Managers, Finance, Service Engineering, and Sales to meet their analytics requirements. - Implement data quality and data governance measures, conduct data profiling, and execute data validation procedures. - Uphold data governance practices to ensure data quality, integrity, and security throughout the data lifecycle. - Utilize open-source technologies to construct robust and cost-effective data solutions. - Develop and manage streaming pipelines using technologies like Apache Kafka. **Qualifications Required:** - Minimum 5 years of IT experience with at least 3 years in data Integration, ETL/ELT development, and database design or Data Warehouse design. - Proficiency in distributed systems, streaming systems, and data engineering tools like Kubernetes, Kafka, Airflow, Dagster, etc. - Experience in data transformation, ETL/ELT tools (AWS Glue, DBT, etc.), and ingesting/integrating data from various sources. - Deep knowledge of Python, SQL, relational/non-relational database design, and master data strategies. - Experience in defining, architecting, and deploying data products, including managing them through their lifecycle. - Familiarity with Star and Snowflake dimensional modeling, relational databases, SQL queries, and data warehouses. - Strong SQL proficiency and expertise in at least one programming language (Python, Scala, JS). - Knowledge of data orchestration tools like Apache Airflow and agile methodologies. - Proficiency with version control systems like Bitbucket/Git. - Ability to thrive in a fast-paced startup environment, handle changing requirements, and manage multiple ongoing projects simultaneously. - Excellent verbal and written communication skills. The company offers a dynamic work environment in a rapidly growing organization, international exposure, a flat hierarchy, intellectually stimulating work, and flexible working hours. (Note: Preferred/bonus skills and details about the company's work environment have been omitted as per your request),
ACTIVELY HIRING
posted 1 day ago
experience8 to 12 Yrs
location
Karnataka
skills
  • SQL
  • Python
  • communication skills
  • interpersonal skills
  • stakeholder management
  • data analytics
  • automation
  • Tableau
  • Power BI
  • project management
  • database management systems
  • data visualization software
  • banking domain knowledge
  • data visualization tools
Job Description
Role Overview: As an AVP (IC SME), MIS at Citi within the Operations Analytics & MIS team, you will play a crucial role in driving data-driven initiatives across the organization. Your primary objective will be to generate actionable intelligence for business leaders, focusing on proactive insight generation, early warning systems, automated commentaries, and acting as a vital bridge between business stakeholders and analytics capabilities. Leveraging your technical expertise, analytical skills, and leadership abilities, you will contribute to streamlining processes, improving efficiency, and achieving strategic goals. Key Responsibilities: - Data Exploration: Understanding existing data & reporting by engaging with various platforms and individuals across business teams and technology. - Data Analysis & Interpretation: Conducting in-depth data analysis to identify trends, patterns, and anomalies, and developing data-driven insights to enhance business performance. - Data Infrastructure Management & Optimization: Managing and optimizing data infrastructure supporting reporting capabilities, ensuring scalability, reliability, and security. - Reporting Solution Design & Development: Designing, developing, and maintaining complex reporting solutions that offer actionable insights into business performance. - Technical Leadership & Mentorship: Providing guidance and mentorship to junior team members on best practices in data analysis, reporting, and data infrastructure management. - Stakeholder Management: Collaborating effectively with cross-functional teams, managing expectations, and ensuring alignment on project goals and deliverables. - Project Management: Leading multiple automation projects from inception to completion, ensuring adherence to timelines, budgets, and governance. - Dashboarding and Visualization: Developing visually compelling dashboards that support decision-making and drive adoption. - Governance & Compliance: Establishing and maintaining appropriate governance processes to ensure compliance with requirements and internal standards. Qualifications Required: - Experience: At least 8+ years with a Masters in a relevant domain or 10+ years with a Bachelors in a relevant domain. - Knowledge of database management systems (e.g., DWH, EAP, SQL Server, Oracle). - Proficiency in data analysis techniques and tools (e.g., SQL, Python, data visualization software). - Strong analytical and problem-solving skills with a passion for data, analytics, and automation. - Good understanding of the banking domain, banking products, and operations in banking. - Excellent communication, interpersonal, and stakeholder management skills. - Demonstrated ability to drive change and innovation. - Ability to learn quickly and adapt to new technologies. - Experience with data visualization tools such as Tableau or Power BI is preferable. - Proven ability to lead, motivate, and develop high-performing teams.,
ACTIVELY HIRING
posted 2 weeks ago
experience10 to 16 Yrs
location
Noida, Uttar Pradesh
skills
  • data integration
  • data migration
  • data quality
  • Salesforce
  • PostgreSQL
  • REST
  • SOAP
  • Azure
  • Informatica PowerCenter
  • data models
  • team management
  • documentation
  • collaboration
  • communication skills
  • ETL processes
  • IDMC
  • Informatica IDMC
  • ETL processes
  • data transformations
  • API integration
  • cloud platform concepts
  • database knowledge
  • Data Warehouse DWH concepts
  • Talent solutions
  • clientfacing roles
Job Description
As an ETL Architect Engineer with over 10 years of experience, you will be required to have the following core expertise: - Extensive experience in ETL processes, data integration, and data migration. - Strong knowledge of IDMC (Intelligent Data Management Cloud). - Hands-on experience with Informatica IDMC components: CAI, CDI, IDQ. Your technical skills should include proficiency in ETL processes, data transformations, and data quality. You should have experience with Salesforce and PostgreSQL components. Additionally, hands-on API integration using CDI and CAI, real-time data processing with REST and SOAP implementations, familiarity with cloud platform concepts, and experience with Informatica PowerCenter and strong database knowledge are essential. You should be well-versed in Data Warehouse (DWH) concepts and large-volume data implementations. Designing and implementing data models for data-driven initiatives should be one of your strong suits. Preferred experience for this role includes talent solutions experience and previous involvement in client-facing roles and team management. Your responsibilities will involve creating and maintaining comprehensive documentation for ETL processes, data mappings, and workflows. Collaboration with business analysts, data architects, and stakeholders to understand requirements and deliver solutions will also be a key part of your role. Moreover, soft skills such as strong communication skills for cross-functional collaboration will be essential for success in this position.,
ACTIVELY HIRING
posted 1 week ago
experience2 to 6 Yrs
location
Chennai, Tamil Nadu
skills
  • Cloud Computing
  • Analytics
  • Data Management
  • Managed Services
  • Machine Learning
  • CRM
  • ERP
  • SCM
  • SaaS
  • ITSM
  • DWH
  • SDLC
  • MS Office
  • IT Sales
  • Cloud Integrations
  • APIbased Integrations
  • Data Storage
  • RPA
  • AI
  • Presales processes
Job Description
As a Technical Proposal Writer, your role will involve responding to RFI, RFP, RFQ in a timely manner to meet deadlines. You will be responsible for creating various proposal documents such as Whitepapers, Case Studies, Presentations, and Web Content. Your key responsibilities will include identifying and enhancing pre-written content, understanding Company's services and technologies, and collaborating with cross-functional teams like Delivery, Sales, Presales, and Technical SMEs. You should be able to adapt quickly to different project requirements, communicate effectively with stakeholders, and have strong time management skills. Additionally, you will work closely with Cloud Integration teams to gather solution inputs and align documentation with cloud architecture and best practices. Qualifications Required: - MBA / MCA / Engineering Graduate with a solid IT background - Excellent oral and written communication skills - Strong command of written English - Basic understanding of core IT concepts including Cloud Computing, Data Management, RPA, AI & Machine Learning - Additional knowledge of CRM, ERP, SCM, SaaS, ITSM, DWH is advantageous - Understanding of SDLC - Proficiency in MS Office - Familiarity with IT Sales & Presales processes - Ability to build strong working relationships within the team The company offers a Full-time, Permanent position with benefits including a flexible schedule, health insurance, paid sick time, and Provident Fund. The work location is in person, preferably in Chennai or willing to work from the Chennai office.,
ACTIVELY HIRING
posted 2 months ago
experience12 to 16 Yrs
location
Gujarat, Vadodara
skills
  • Microsoft SQL Server
  • Dimensional Modeling
  • SSIS
  • Python
  • Power BI
  • SQL
  • Git
  • JIRA
  • Data Warehouse
  • Azure SQL
  • Azure Synapse
  • Relational Database Design
Job Description
As a Lead Data Warehouse Engineer, your role involves architecting, managing, and evolving the enterprise data warehouse to support business intelligence and analytics. Here are the key responsibilities you will handle: - Design and set up the data warehouse from scratch with a focus on scalability, reliability, and alignment with business goals. - Lead the design of dimensional models and enforce data governance standards for maintaining a single version of truth. - Oversee the development and optimization of ETL pipelines using SSIS, Python, and cloud-native tools for efficient data ingestion from various systems. - Monitor and optimize database performance, indexing strategies, and query execution plans to ensure optimal system responsiveness. - Collaborate with business stakeholders to gather requirements, translate them into technical specifications, and deliver actionable insights. - Mentor junior engineers, conduct code reviews, and manage project timelines and deliverables within the data engineering team. - Maintain comprehensive documentation for data flows, integration logic, and system configurations while ensuring compliance with internal and external data standards. Qualifications Required: Must have - Bachelors or Masters degree in computer science, Information Technology, or a related field. - 12+ years of experience with Microsoft SQL Server. - Expertise in building Data Warehouse using SQL Server. - Hands-on experience Dimensional Modeling using Facts and Dimensions. - Experience with cloud-based SQL databases like Azure SQL or Azure Synapse. - Expertise in SSIS and Python for ETL development. - Familiarity with Azure Data Factory. - Strong experience in Power BI for reporting and data visualization. - Strong understanding of relational database design, indexing, and performance tuning. - Ability to write complex SQL scripts, stored procedures and views. - Experience with Git and JIRA. - Problem-solving mindset and analytical skills. - Excellent communication and documentation abilities. Nice to Have - Experience with Microsoft Fabric. - Experience with Azure Databricks. - Familiarity with CI/CD for database deployments and automation tools. - Knowledge of big data technologies like Snowflake.,
ACTIVELY HIRING
posted 4 days ago
experience6 to 13 Yrs
location
Chennai, Tamil Nadu
skills
  • Team management
  • Client handling
  • AWS
  • Data Engineering
  • SQL
  • Python
  • DWH
  • SLA tracking
  • failure resolution
  • Cloud technologies
Job Description
Job Description: You will be responsible for managing teams and handling clients, including tracking SLAs and resolving job failures efficiently. Your expertise in Cloud technologies, particularly AWS, will be crucial for this role. You must have a strong background in AWS Data Engineering pipelines, SQL, Python, and Data Warehousing. Additionally, you will collaborate with AWS/SRE/D3C development teams to ensure job schedules and SLAs are met within the AWS environment. Qualifications Required: - Minimum 6 to 13 years of experience - Team management and client handling skills - Excellent knowledge in Cloud technologies, especially AWS - Strong skills in AWS Data Engineering pipelines, SQL, Python, and Data Warehousing,
ACTIVELY HIRING
posted 1 week ago
experience3 to 7 Yrs
location
Karnataka
skills
  • Technology
  • Data Mining
  • Data Integration
  • Data Processing
  • Streams
  • BI
  • DWH
  • Data Analysis
  • Data Analytics Activities
  • Big Data Tools Systems
  • ETL Roles
  • DWH Architect
  • Pre Sales Support Activities
  • Responding to RFPs
Job Description
Role Overview: As a Data Engineer, you will be responsible for analyzing methods to improve data reliability and quality. Your role will involve combining raw information from various sources to create consistent and machine-readable formats. Additionally, you will be required to develop and test architectures that facilitate data extraction and transformation for predictive or prescriptive modeling. Key Responsibilities: - Analyze and organize raw data - Build data systems and pipelines - Evaluate business needs and objectives - Interpret trends and patterns - Conduct complex data analysis and report on results - Prepare data for prescriptive and predictive modeling - Build algorithms and prototypes - Combine raw information from different sources - Explore ways to enhance data quality and reliability - Identify opportunities for data acquisition - Develop analytical tools and programs - Collaborate with data scientists and architects on various projects Qualifications Required: - Engineer with a degree in B.E / B.Tech / MCA - Experience in Technology, Data Analytics Activities, Data Mining, Data Integration, Data Processing, Big Data Tools / Systems, BI, DWH, ETL Roles, and Pre Sales Support Activities - Microsoft Certification for performing Data Engineering on Microsoft HD Insight Please note that the job is located in Bengaluru, India.,
ACTIVELY HIRING
posted 2 months ago
experience3 to 7 Yrs
location
Chennai, Tamil Nadu
skills
  • Data analytics
  • OBIEE
  • Business Analysis
  • Informatica
  • ODI
  • SSIS
  • Reporting
  • Dashboards
  • BI Publisher
  • Security Implementation
  • Data Flow
  • Data Visualization
  • Data Models
  • Data Modeling
  • Agile
  • SQL
  • PLSQL
  • OAC
  • Visualisation Tools
  • ETLELT Process
  • RPD Logical Modeling
  • Agents
  • SelfService Data Preparation
  • Data Sync
  • Data Sets
  • DWH Concepts
  • Waterfall SDLC
Job Description
At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. **Role Overview:** As a Senior expertise in Data analytics specializing in OBIEE/OAC at EY GDS Data and Analytics (D&A), you will be responsible for creating and managing large BI and analytics solutions using Visualisation Tools such as OBIEE/OAC to turn data into knowledge. Your background in data and business analysis, analytical skills, and excellent communication abilities will be key in this role. **Key Responsibilities:** - Work as a team member and Lead to contribute to various technical streams of OBIEE/OAC implementation projects - Provide product and design level technical best practices - Interface and communicate with the onsite coordinators - Complete assigned tasks on time and provide regular status reports to the lead **Qualification Required:** - BE/BTech/MCA/MBA with adequate industry experience - 3 to 7 years of experience in OBIEE/OAC - Experience in Working with OBIEE, OAC end-to-end implementation - Understanding ETL/ELT Process using tools like Informatica/ODI/SSIS - Knowledge of reporting, dashboards, RPD logical modeling - Experience with BI Publisher and Agents - Experience in Security implementation in OAC/OBIEE - Ability to manage self-service data preparation, data sync, data flow, and working with curated data sets - Manage connections to multiple data sources - cloud, non-cloud using available various data connector with OAC - Create pixel-perfect reports, manage contents in the catalog, dashboards, prompts, calculations - Create data sets, map layers, multiple data visualization, story in OAC - Understanding of various data models e.g. snowflakes, data marts, star data models, data lakes, etc. - Excellent written and verbal communication skills - Cloud experience is an added advantage - Migrating OBIEE on-premise to Oracle analytics in the cloud - Knowledge and working experience with Oracle autonomous database - Strong knowledge in DWH concepts - Strong data modeling skills - Familiar with Agile and Waterfall SDLC process - Strong SQL/PLSQL with analytical skill (Note: Additional Details of the company are omitted as they are not available in the provided Job Description),
ACTIVELY HIRING
logo

@ 2025 Shine.com | All Right Reserved

Connect with us:
  • LinkedIn
  • Instagram
  • Facebook
  • YouTube
  • Twitter