informatica-etl-developer-jobs-in-kalyan, Kalyan

128 informatica Etl Developer Jobs nearby Kalyan

Toggle to save search
posted 3 weeks ago
experience7 to 12 Yrs
location
Pune, Chennai
skills
  • testing
  • webdriver
  • etl testing
  • automation
  • automation testing
  • python
  • database testing
  • selenium testing
  • pytest
Job Description
We are seeking a skilled ETL & Python Automation Tester to join our QA team. The ideal candidate will have strong experience in ETL testing, data validation, and Python-based automation to ensure the integrity, accuracy, and quality of data across data pipelines, warehouses, and reporting systems. Role : Automation Testing - ETL+ Python Automation Mode : HybridLocation : Pune/Chennai Key Responsibilities Design, develop, and execute ETL test cases for data ingestion, transformation, and loading processes. Validate data movement between source, staging, and target systems to ensure end-to-end data integrity. Automate ETL and data validation tests using Python and relevant testing frameworks. Create and maintain automated scripts for regression and functional testing. Work closely with Data Engineers, Developers, and Business Analysts to understand data flows and business rules. Perform data reconciliation, transformation validation, and schema testing. Implement and maintain test frameworks using pytest, unittest, or Robot Framework. Report and track defects in JIRA (or similar tools) and work with teams to resolve them. Contribute to test strategy, planning, and continuous integration (CI/CD) processes. Required Skills & Qualifications Bachelors degree in Computer Science, Information Technology, or related field. 3+ years of experience in software testing, with a focus on ETL and data testing. Strong knowledge of SQL for data verification and validation. Hands-on experience with Python scripting for automation. Experience with ETL tools (e.g., Informatica, Talend, SSIS, DataStage, Glue, etc.). Familiarity with data warehouses (Snowflake, Redshift, BigQuery, etc.). Knowledge of automation frameworks (pytest, unittest, Robot Framework). Experience with version control systems (Git) and CI/CD pipelines (Jenkins, GitLab CI, etc.). Strong analytical and problem-solving skills.
INTERVIEW ASSURED IN 15 MINS

Top Companies are Hiring in Your City

For Multiple Roles

Jio Platforms Ltd
Jio Platforms Ltdslide-preview-Genpact
posted 2 weeks ago

ETL Testing

Novature Tech
experience2 to 8 Yrs
location
Maharashtra
skills
  • ETL Testing
  • SQL
  • Informatica
  • HP ALM
  • QA services
  • TIDAL
  • OBIE
Job Description
As a Senior Test Engineer, your role will involve being proficient in QA services with strong knowledge in ETL testing processes and excellent SQL skills for query development. You should have a minimum of 2 years of hands-on experience in ETL testing specifically related to testing data warehouse systems. Your understanding of database and data warehouse concepts, particularly in ORACLE and SQL SERVER, will be crucial. You will also be expected to have working knowledge of tools such as Informatica, TIDAL, and OBIE. Writing complex SQL queries should be one of your strengths, and you must have experience using HP ALM for Test Artifacts management. Additionally, your responsibilities will include creating and executing complex test cases effectively. Qualifications Required: - Minimum 3 years of experience in software testing - Strong knowledge of ETL testing and processes - Proficiency in SQL for query development - Experience with tools like Informatica, TIDAL, and OBIE - Familiarity with HP ALM for Test Artifacts management Location: Mumbai If you require any further information about the company, please let me know.,
ACTIVELY HIRING
posted 2 weeks ago

Informatica MDM Developer

Unetra HR Solutions LLP
experience7 to 11 Yrs
location
Pune, All India
skills
  • Java
  • SQL
  • Informatica MDM
  • e360 development
  • Active VOS workflows
  • REST API development
Job Description
As an Informatica MDM Specialist, you will be responsible for the following: - Configure and manage MDM Hub including Landing, Staging, Base Objects, and Hierarchies. - Develop and maintain e360 UI for BES & API integration. - Design BES External Calls and integrate with REST/SOAP APIs. - Automate workflows using Active VOS (AVOS). - Ensure data quality and governance compliance. - Strong hands-on experience with Java, SQL, and REST API development. You are expected to have: - Deep expertise in Informatica MDM and AVOS. - Strong understanding of MDM architecture and data stewardship. - Experience in custom API development and integration. If there are any additional details about the company or role, it is not mentioned in the provided job description. As an Informatica MDM Specialist, you will be responsible for the following: - Configure and manage MDM Hub including Landing, Staging, Base Objects, and Hierarchies. - Develop and maintain e360 UI for BES & API integration. - Design BES External Calls and integrate with REST/SOAP APIs. - Automate workflows using Active VOS (AVOS). - Ensure data quality and governance compliance. - Strong hands-on experience with Java, SQL, and REST API development. You are expected to have: - Deep expertise in Informatica MDM and AVOS. - Strong understanding of MDM architecture and data stewardship. - Experience in custom API development and integration. If there are any additional details about the company or role, it is not mentioned in the provided job description.
ACTIVELY HIRING
question

Are these jobs relevant for you?

posted 2 months ago

INFORMATICA DEVELOPER

Alpharithm Technologies Private Limited
experience5 to 9 Yrs
location
Maharashtra
skills
  • SQL Server
  • Data integration
  • SQL queries
  • Informatica Intelligent Cloud Services IICS
  • AWS Redshift
  • AWS Database Migration Service DMS
  • ETL processes
  • Cloud data solutions
Job Description
As an experienced Informatica Developer, you will be joining a team that focuses on data integration, ETL processes, and cloud data solutions. Your expertise in Informatica Intelligent Cloud Services (IICS), AWS Redshift, AWS Database Migration Service (DMS), and SQL Server will be crucial for working on various data projects involving cloud technologies. **Roles & Responsibilities:** - Design, develop, and maintain ETL workflows using Informatica IICS to integrate data from different sources into AWS Redshift. - Implement and optimize AWS Redshift for efficient data storage and analytics. - Utilize AWS Database Migration Service (DMS) for migrating data from on-premises databases to AWS cloud environments. - Write complex SQL queries, perform data transformations, and ensure data quality and consistency in SQL Server. - Collaborate with data architects, business analysts, and stakeholders to understand data requirements and design efficient ETL processes. - Test and debug ETL processes to ensure accurate data load and transformation. - Monitor and optimize ETL performance for scalability and efficiency. - Ensure data security and compliance in both cloud environments and on-premises systems. - Provide ongoing support and maintenance for ETL processes, including troubleshooting production issues. - Document technical specifications, designs, and procedures related to data integration processes. **Qualifications Required:** - 5 years of experience in the field. - Strong background in data integration, ETL processes, and cloud data solutions. - Expertise in Informatica IICS, AWS Redshift, AWS Database Migration Service (DMS), and SQL Server. - Proficiency in writing complex SQL queries and performing data transformations. - Ability to collaborate with cross-functional teams and stakeholders. This is a great opportunity for an experienced Informatica Developer like you to be part of a team that works on cutting-edge data projects involving cloud technologies.,
ACTIVELY HIRING
posted 2 months ago
experience2 to 7 Yrs
location
Navi Mumbai, Maharashtra
skills
  • Informatica PowerCenter
  • SQL
  • Data Warehousing
  • Databricks
  • PySpark
  • ETL Development
  • Cloud Platforms
Job Description
As an ETL Migration Specialist for Informatica to Databricks, your role will involve analysing, reverse engineering, and refactoring existing Informatica mappings/workflows into efficient data processing workflows on Databricks. You will collaborate with both business and technical teams to ensure a seamless migration process. Key Responsibilities: - Reverse Engineering: Analyze Informatica mappings, workflows, sessions, and variables to understand data flow, transformations, and aggregations. - ETL Refactoring: Translate Informatica logic into PySpark/Databricks workflows for accuracy and performance. - Data Modeling & Transformation: Design and implement transformation logic aligned with business rules. - Performance Optimization: Refactor ETL logic for scalability and performance tuning. - Documentation: Create detailed documentation for converted pipelines capturing technical logic and business rules. - Testing & Validation: Collaborate with QA/Business teams to validate data correctness. - Best Practices: Ensure adherence to Databricks and cloud data engineering best practices. - Collaboration: Work with stakeholders to clarify requirements and resolve discrepancies. Qualifications Required: - Strong knowledge of Informatica objects such as Mappings, Workflows, Sessions. - Hands-on experience with Informatica transformations like Lookup, Joiner, Aggregator, etc. - Proficiency in handling Informatica parameters and variables. - Experience in designing reusable transformations and optimization techniques. - 5+ years of ETL development experience with Informatica PowerCenter. - 2+ years of experience in Databricks (PySpark, SQL, Delta Lake). - Strong understanding of data warehousing concepts and cloud platforms. - Proficiency in SQL and performance tuning. - Excellent problem-solving, debugging, and communication skills. This job also requires experience with DevOps/CI-CD pipelines, exposure to migration tools, knowledge of data lakehouse patterns, and experience in Agile/Scrum delivery.,
ACTIVELY HIRING
posted 2 months ago
experience3 to 7 Yrs
location
Thane, Maharashtra
skills
  • assessment skills
  • communication
  • interpersonal skills
  • developing training manuals
  • creating online training materials
  • facilitating training sessions
Job Description
As a Training Manual Developer at Bringle Academy, your role will involve developing training manuals for both end users and administrators. You will be responsible for creating online training materials and facilitating training sessions on the product as well as any changes in processes. These sessions will cover both the application itself and the new context in which it will be used. Your task will also include conducting training for groups ranging from 5 to 20 people. - Develop training manuals for end users and administrators - Create online training materials - Facilitate training sessions for product and process changes - Conduct training for groups of 5 to 20 people You will also be assessing the effectiveness of the training sessions by evaluating the knowledge acquired by the candidates. This may involve developing training assessments as necessary. As a part of your responsibilities, you will also be expected to manage any resistance to change that may arise during the training process. - Assess the knowledge acquired by candidates - Develop training assessments as necessary - Manage resistance to change during training Qualifications Required: - Experience in developing training manuals - Proficiency in creating online training materials - Ability to facilitate training sessions for groups - Strong assessment skills to determine knowledge acquisition - Excellent communication and interpersonal skills,
ACTIVELY HIRING
posted 2 weeks ago
experience4 to 8 Yrs
location
Pune, Maharashtra
skills
  • Installation
  • Configuration
  • User Management
  • Access Management
  • Troubleshooting
  • System Maintenance
  • Patch Management
  • Performance Monitoring
  • Analytical Skills
  • Informatica IDMC Administration
  • Upgrades
  • Informatica Data Quality
  • Informatica Metadata Manager
  • Informatica Reporting Services
  • Networking Concepts
  • Backup
  • Recovery Processes
  • ProblemSolving
Job Description
As an Informatica IDMC Admin at Vivid Edge Corp, your role will involve configuring and maintaining the Informatica IDMC platform at Pune. You will be responsible for scaling, tuning, and optimizing the environment, integrating with enterprise and cloud systems, administering platform security, supporting the project development lifecycle, working with enterprise architects to design best practices, monitoring, troubleshooting, automating, and handling ETL and data integration development and testing. Key Responsibilities: - Installation & Configuration: Install, configure, and upgrade Informatica IDMC software and environments according to business and technical requirements. - User & Access Management: Manage users, groups, roles, and permissions, including setting up authentication and authorization. - Troubleshooting & Support: Diagnose and resolve issues related to Informatica setups, workflows, and integrations. Provide technical guidance to team members. - System Maintenance: Perform updates, patches, upgrades, backups, restores, and disaster recovery processes to ensure data integrity and availability. - Subject Matter Expertise: Serve as the SME for Informatica products like Data Quality, Metadata Manager, and Reporting Services. - Operational Tasks: Handle patch installations, password changes, network updates, service restarts, and bouncing activities as needed. Qualifications Required: - Proficiency in Informatica IDMC (Intelligent Data Management Cloud) Administration. - Experience in installation, configuration, and upgrades of Informatica IDMC. - Strong knowledge of user, role, and access management including authentication and authorization. - Ability to troubleshoot Informatica setups, workflows, and integrations. - Familiarity with system maintenance tasks such as patches, updates, backups, restores, and disaster recovery. - Expertise in Informatica Data Quality (IDQ), Metadata Manager, and Reporting Services. - Skills in patch management, password changes, service restarts, and performance monitoring & optimization of Informatica environments. - Understanding of networking concepts for connectivity and integrations. - Knowledge of backup and recovery processes. - Strong problem-solving and analytical skills. - Experience working in hybrid environments. Please note: This job requires onsite presence at Pune and is a full-time permanent position with Vivid Edge Corp.,
ACTIVELY HIRING
posted 3 weeks ago
experience6 to 10 Yrs
location
Pune, Maharashtra
skills
  • Informatica
  • SQL
  • SCRIPTING
  • Azure
  • IDMC Administration
  • IDMC Development
  • DW concept
  • QLIK Admin
  • OSSERVER MGMT
  • SNOWFLAKEMPP
  • Data Replication
Job Description
Role Overview: You are responsible for configuring and maintaining the Informatica IDMC Admin (Intelligent Data Management Cloud) platform at Vivid Edge Corp's onsite location in Pune. Your role involves scaling, tuning, and optimizing the environment, integrating with enterprise and cloud systems, administering platform security, supporting project development lifecycle, and collaborating with enterprise architects to design and implement best practices. Additionally, you will be involved in monitoring, troubleshooting, automating processes, and assisting in ETL and data integration development and testing. Key Responsibilities: - Configure and maintain the Informatica IDMC Admin platform - Scale, tune, and optimize the environment - Integrate with enterprise and cloud systems - Administer and control platform security - Support project development lifecycle - Collaborate with enterprise architects to design and implement best practices - Monitor and troubleshoot platform performance - Automate processes for efficiency - Assist in ETL and data integration development and testing Qualifications Required: - Proficiency in Informatica with _____ years of experience - Strong experience in IDMC Administration with _____ years of experience - Knowledge of IDMC Development with _____ years of experience - Proficient in SQL with _____ years of experience - Experience in scripting with _____ years of experience - Understanding of data warehouse concepts with _____ years of experience - Familiarity with Qlik Admin with _____ years of experience - Expertise in OS-server management with _____ years of experience - Knowledge of Snowflake-MPP with _____ years of experience - Experience in data replication with _____ years of experience - Familiarity with Azure with _____ years of experience (Note: Please fill in the blanks with your relevant experience in each skill),
ACTIVELY HIRING
posted 2 months ago

Snowflake + IICS Developer

Reveille Technologies,Inc
experience9 to 13 Yrs
location
Pune, Maharashtra
skills
  • Snowflake
  • ETL
  • Data Warehousing
  • Performance Tuning
  • Integration
  • Informatica IICS
  • ELT
  • Data Pipelines
Job Description
As a Snowflake + IICS Developer at our company, you will be responsible for the following: - Strong expertise in Snowflake, including Data Warehousing and Performance Tuning - Hands-on experience with Informatica IICS (Cloud Services) - Solid understanding of ETL/ELT, data pipelines, and integration - Good communication skills and ability to work effectively in agile teams If you are interested in this opportunity, please reach out to rajesh@reveilletechnologies.com.,
ACTIVELY HIRING
posted 2 months ago
experience12 to 16 Yrs
location
Pune, Maharashtra
skills
  • Leadership
  • Project Planning
  • Team Management
  • Stakeholder Management
  • Risk Management
  • Resource Management
  • Budget Management
  • ETL Tools
  • Technical Project Management
  • Cloudbased Data Warehouses
  • Clientfacing Communication
  • Problemsolving
Job Description
Role Overview: As a seasoned Technical Project Manager, you will be responsible for overseeing and guiding large service engagements, involving teams of 35-50 individuals. Your role will require a balance of technical know-how, exceptional leadership abilities, and proven project management skills. Key Responsibilities: - Lead and manage complex technical projects from initiation to completion - Develop comprehensive project plans, ensuring timely delivery and quality - Coordinate cross-project activities - Lead diverse project teams, including technical developers, business analysts, quality assurance, and other essential stakeholders - Foster a collaborative and inclusive team environment, ensuring clarity in roles and responsibilities - Serve as the primary point of contact for clients and ensure regular communication of project updates and milestones - Manage stakeholder expectations, addressing concerns, and resolving conflicts or issues - Offer technical guidance to ensure project deliverables meet required standards and quality - Collaborate with architects and technical leads to ensure feasible project plans - Identify potential risks and devise contingency plans - Monitor project progress continuously and provide detailed scheduled reports on measurable items such as milestones - Ensure optimal allocation and availability of resources throughout the project - Prepare and manage project budgets, ensuring projects remain within scope and on target Qualifications Required: - Bachelor's degree in computer science, Engineering, IT, or MCA - 12 to 15 years of experience in technical project management, specifically in services for enterprise clients - Experience in executing Fixed Price projects, project planning & tracking using tools like Microsoft Project Planner - Familiarity with the architecture, design, and best practices of cloud-based data warehouses on Azure Data Services or AWS Data Service - Proven experience in leading large teams and handling large-scale projects - Strong technical background with understanding and/or hands-on experience in ETL tools such as Ab Initio, Data Stage, Informatica, and SSIS - Proficiency in project management software tools, methodologies, and best practices - Exceptional client-facing and internal communication skills - Strong problem-solving skills and willingness to roll up your sleeves to get the job done - Relevant professional certifications such as PMP would be a plus,
ACTIVELY HIRING
posted 5 days ago
experience3 to 7 Yrs
location
Pune, Maharashtra
skills
  • Flow
  • Informatica
  • Apex
  • LWC
  • Salesforce CPQ
  • Revenue Cloud
  • CICD
  • Gearset
Job Description
As a Salesforce Developer, you will be responsible for the following: - End-to-end development of Salesforce features and enhancements using Apex, LWC, and Flow. - Building sophisticated Lightning Web Components (LWC) to deliver intuitive, high-performance user experiences. - Configuring and customizing Salesforce CPQ and Revenue Cloud to support quote-to-cash and revenue processes. - Collaborating with product owners, business analysts, and QA to deliver high-quality, user-focused solutions. - Integrating Salesforce with other enterprise systems using Informatica for ETL and data synchronization. - Leveraging CI/CD pipelines using Gearset for version control, deployments, and release management. - Implementing Salesforce coding best practice standards. - Troubleshooting and optimizing applications for speed, scalability, and stability. - Staying up to date with Salesforce releases and emerging best practices and identifying opportunities for platform enhancement. Qualifications required for this role include: - Demonstrated expertise in configuring and customizing Salesforce CPQ and/or Revenue Cloud. - Hands-on experience in developing Salesforce Apex, Lightning Web Components (LWC), and Flow. - Practical experience in integrating Salesforce with external systems using Informatica. - Understanding of Salesforce data model, security framework, and performance best practices. - Strong problem-solving skills and experience in leading peer reviews. - Proficiency in Gearset for CI/CD automation and release management. - Excellent written and verbal communication skills for cross-functional collaboration. Additional details of the company are not mentioned in the job description.,
ACTIVELY HIRING
posted 1 month ago
experience3 to 7 Yrs
location
Pune, Maharashtra
skills
  • Java
  • IDQ
  • API
  • SQL
  • ETL
  • Data Quality
  • Informatica Master Data Management
  • BI technologies
  • Data Modelling
Job Description
As a Master Data Management developer at Medtronic, you will play a crucial role in the Master Data Management development team. Your responsibilities will include designing, developing, and testing MDM solutions. You should have hands-on experience in Informatica MDM 10.x, IDQ, and Java for MDM user exits. Here is a summary of your role: - Customize the MDM solution by writing Java user exits, updating Java code, and deploying EARs to higher environments. - Integrate external systems using MDM BES via create/update APIs. - Develop Match Rules, extensions, user exits, and composite web services for solution integration. - Configure and maintain Data Models, hierarchies, Activos workflows, match & merge survivorship rules, and user interface design. - Develop and maintain Master Data Integration processes for data ingestion, transformation, and integration with upstream and downstream systems. - Implement User exits and custom Java cleanse functions to customize the solution. - Design and maintain the E360 UI by creating layouts in the business entity framework. - Develop APIs for integrating external applications using BES services. - Provide support for escalated production issues and propose tuning opportunities for efficiency and quality. Qualifications required for this role: - Hands-on experience with Informatica Master Data Management (MDM) and standard REST API/SIF/Message Queue based integration. - Experience with Informatica MDM hub components, Informatica Data Quality (IDQ), relational databases, and SQL. - Knowledge of IICS and/or Informatica PowerCenter or other ETL/BI technologies is preferred. - Strong technical knowledge in Data Quality, Standards, Governance, and Design. - Bachelor's degree in computer science, Management Information Systems, or a related field. You will be part of a team that values employee contributions and offers competitive salaries and flexible benefits packages. Medtronic is committed to recognizing and rewarding its employees" success. Additionally, you may be eligible for the Medtronic Incentive Plan (MIP). At Medtronic, our mission is to alleviate pain, restore health, and extend life. We are a global team of passionate individuals dedicated to finding solutions to the most challenging health problems. Our culture fosters innovation and collaboration to engineer real solutions for real people. Join us in our mission to make a difference in healthcare technology.,
ACTIVELY HIRING
posted 2 months ago

Sr. Power BI Developer

ZK Technologies
experience3 to 7 Yrs
location
Pune, Maharashtra
skills
  • DAX
  • ETL
  • SQL
  • Data Modeling
  • AWS
  • APIs
  • Relational Databases
  • Data Warehousing
  • ETL Tools
  • Data Integration
  • SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • SSIS
  • Informatica
  • Azure
  • GCP
  • JSON
  • Python
  • R
  • Excel
  • VBA
  • Power BI Desktop
  • Power BI Service
  • Power BI Mobile
  • Power Query
  • Azure Data Factory
Job Description
As a Power BI Developer, your role will involve designing, developing, and implementing business intelligence solutions using your strong expertise in database technologies. You will be required to work with large datasets, ensure data integrity, and create impactful dashboards and reports to support business decision-making. Key Responsibilities: - Proficient in Power BI Desktop, Power BI Service, and Power BI Mobile. - Advanced knowledge of DAX (Data Analysis Expressions) and Power Query (M Language). - Expertise in creating custom visuals, slicers, and drill-through reports. - Knowledge of ETL tools and processes. - Familiarity with data warehousing concepts and cloud platforms like Azure Data Factory or AWS. - Ability to work with APIs and other third-party tools for data integration. Database Knowledge: - Hands-on experience with relational databases (e.g., SQL Server, MySQL, Oracle, PostgreSQL). - Proficient in writing complex SQL queries, stored procedures, and database scripts. - Strong understanding of data modeling concepts (e.g., star schema, snowflake schema). - Experience with indexing, query tuning, and database optimization techniques. ETL and Data Integration: - Experience with ETL tools (e.g., SSIS, Azure Data Factory, Informatica). - Knowledge of cloud platforms like Azure, AWS, or GCP for data storage and processing. - Ability to work with APIs, JSON, and flat files for data extraction. Other Tools & Technologies: - Knowledge of Azure Synapse Analytics, Databricks, or other big data platforms. - Familiarity with Python or R for data analysis (optional but preferred). - Advanced Excel skills, including VBA (preferred). Qualifications Required: - Bachelor's degree in computer science or related engineering field OR equivalent experience in a related field. - 5+ years of software development experience. - 3+ years of experience developing reports in SSIS, SSRS, SSAS, and Power BI. - Experience with building data pipelines. - Possess the ability to understand business processes and design reports. - Good written and verbal communication skills. - Great team player.,
ACTIVELY HIRING
posted 2 months ago
experience5 to 9 Yrs
location
Pune, Maharashtra
skills
  • Data Warehousing
  • SQL
  • RDBMS
  • Dimensional Modeling
  • Data Integration
  • Performance Tuning
  • Informatica
  • Talend
  • DataStage
  • Qlik Sense
  • BI Tools
  • Data Governance
  • Metadata Management
  • ETL development
  • StarSnowflake schemas
  • Cloud Platforms
Job Description
As an ETL & Data Warehousing Developer, your role involves designing, building, and optimizing robust ETL workflows to integrate data from diverse sources into the data warehouse. You will be responsible for implementing data quality and validation checks to ensure accuracy and consistency, translating business requirements into effective data models and transformation logic, and writing complex SQL queries to extract, transform, and load data efficiently. Additionally, you will develop star and snowflake schema data models for analytical reporting and partner with BI teams to integrate ETL pipelines with Qlik Sense or other BI tools. Furthermore, you will maintain and enhance the current data warehouse infrastructure for scalability and performance, as well as troubleshoot data anomalies and recommend long-term solutions. Key Responsibilities: - Design, build, and optimize robust ETL workflows - Implement data quality and validation checks - Translate business requirements into effective data models and transformation logic - Write complex SQL queries for data extraction, transformation, and loading - Develop star and snowflake schema data models - Partner with BI teams to integrate ETL pipelines with Qlik Sense or other BI tools - Maintain and enhance data warehouse infrastructure - Troubleshoot data anomalies and recommend solutions Qualifications Required: - Minimum 5 years of hands-on experience in ETL development and Data Warehousing - Strong command over SQL and RDBMS (Oracle, SQL Server, PostgreSQL, etc.) - Experience with leading ETL tools like Informatica, Talend, DataStage, or similar - Solid knowledge of dimensional modeling, star/snowflake schemas, and data integration best practices - Strong performance tuning experience for both SQL and ETL jobs Good to Have: - Experience with Qlik Sense, QlikView, or Qlik Replicate - Exposure to Power BI, Tableau, Looker, or other visualization tools - Familiarity with cloud platforms (AWS, Azure, GCP) - Knowledge of data governance, data cataloging, and metadata management If you choose to work with us, you will join a team focused on leveraging data to drive business decisions effectively.,
ACTIVELY HIRING
posted 3 weeks ago

Supplier MDM Developer

PwC Acceleration Center India
experience2 to 6 Yrs
location
Maharashtra
skills
  • Master Data Management
  • SAP MDG
  • SQL
  • APIs
  • Data integration
  • Python
  • Data governance
  • Data modeling
  • Data quality
  • SAP
  • Oracle
  • Analytical skills
  • Supplier Data Management
  • MDM applications
  • Informatica MDM
  • Reltio
  • ETL processes
  • Databricks
  • ERP systems
  • Coupa
  • Problemsolving
Job Description
Role Overview: You will be joining the Advisory Acceleration Centre at PwC, where you will play a vital role in designing, developing, and supporting data management focusing on supplier data. Your responsibilities will include building and maintaining MDM applications, developing integrations between various systems, and ensuring the accuracy and quality of supplier records. Your technical expertise, attention to detail, and ability to collaborate with both business and IT stakeholders will be crucial for this role. Key Responsibilities: - Develop and maintain MDM applications and workflows for supplier master data. - Enhance user interfaces within MDM tools to facilitate data stewardship and supplier data management. - Design and implement integrations between MDM platforms, ERP, procurement, and finance systems. - Establish data quality rules, matching processes, and de-duplication mechanisms for reliable supplier information. - Work closely with business teams to gather requirements and implement technical solutions. - Support supplier onboarding processes and ensure optimal performance of MDM solutions. - Create and maintain technical documentation including data models and integration designs. Qualifications: - 2-4 years of experience in Master Data Management development, focusing on supplier or vendor data. - Proficiency in at least one MDM tool such as Informatica MDM, SAP MDG, or Reltio. - Strong skills in SQL, ETL processes, APIs, and data integration methods. - Knowledge of Databricks/Python will be an added advantage. - Understanding of data governance, data modeling, and data quality principles. - Familiarity with ERP systems like SAP, Oracle, or Coupa. - Strong analytical and problem-solving abilities with keen attention to detail.,
ACTIVELY HIRING
posted 2 weeks ago

ETL Lead (Informatica)

Techknomatic Services
experience6 to 10 Yrs
location
Pune, Maharashtra
skills
  • Informatica PowerCenter
  • SQL
  • PLSQL
  • Unix
  • Informatica ICS
Job Description
As an experienced professional with 6-10 years of relevant experience in Apps Development or systems analysis role, your role as an Informatica ETL Specialist will involve the following responsibilities: - Accountable for the delivery of the Informatica ETL capabilities required by the business functions - Understanding specs, user stories, and product planning docs around ETL implementation - Converting business requirements into technical specifications and deciding timelines for accomplishment - Hands-on experience in Informatica Powercenter/ICS is a must - Analysing current ETL processes, defining and designing new systems - Designing, developing, testing, and deploying ETL processes - Working with users and team members at all levels for performance improvement and suggestions - Participating in the adoption and implementation of best practices across key data elements and processes - Helping resolve critical issues and providing technical resolutions - Identifying, root cause analysis, prioritizing, remediation planning, and coordinating and executing remediation activities for data issues - Participating in the development and maintenance of technologies that automate data processes - Having good knowledge of Databases (SQL/PLSQL) - Unix knowledge is considered good to have Your technical skills should include proficiency in Informatica PowerCenter/ICS. Additionally, soft skills such as strong communication, teamwork, collaboration, ability to work under aggressive timelines, persistence, multitasking, and innovation are essential for success in this role. You should demonstrate competencies in owning and driving tasks/assignments while collaborating with peers and other Technology teams. Balancing fast time to market with proper Governance, Compliance, and Audit mandates is crucial. Working closely with teams across the globe for project development and delivery is also expected. In summary, your role as an Informatica ETL Specialist will require a blend of technical expertise, soft skills, and competencies to effectively deliver ETL capabilities and drive successful project outcomes.,
ACTIVELY HIRING
posted 2 months ago
experience6 to 10 Yrs
location
Pune, Maharashtra
skills
  • AbInitio
  • Informatica
  • SQL tuning
  • Troubleshooting
  • Debugging
  • Test automation
  • Software architecture
  • Communication skills
  • Oracle PLSQL
  • ETL QA
  • Data conversionmigration
  • Process improvements
  • Analytic skills
  • Customer management skills
  • Facilitation skills
  • Relationshipbuilding skills
Job Description
As a QA and development professional for the Product Processor Technology area, you will work closely with the business and SMEs to prioritize business requests, manage ETL development work, and ensure timely delivery according to the SDLC. You will be part of the Product Processor Development Team in Pune, supporting the GTPL application for Product Control & Finance Department. Key Responsibilities: - Understand business and functional requirements and convert them into Technical Design Documents for the development team. - Lead a Technical Team in Pune supporting GTPL in Product Processor Departments. - Create project plans and ensure PTS documentation is up to date. - Collaborate with Cross Functional Teams for handover documents, manage SIT, UAT, and automate Unit Testing. - Proactively identify and resolve issues affecting system performance and usability. - Demonstrate a deep understanding of how development integrates within the business/technology objectives. - Address testing requirements independently and articulate issues with lead time. - Design, Implement, Integrate, and test new features. - Take ownership of successful delivery, mentor other developers, and organize review activities. - Explore existing application systems for complexity and potential risks. - Contribute to continual improvement by suggesting software architecture and process improvements. - Build relationships with business and technology stakeholders. Qualifications: - 10+ years of Software development and QA experience. - 6+ years of Oracle PL/SQL experience. - 6+ years of ETL QA Experience (AbInitio or Informatica). - Development experience in a fast-paced environment with test automation and reporting tools. - Proficiency in Oracle PL/SQL, SQL tuning, and data conversion/migration. - Strong trouble shooting and debugging skills. - Experience in an Onsite-offshore model. Skills: - Strong analytic skills. - Excellent communication and internal customer management skills. - Excellent facilitation and relationship-building skills. Qualifications: - B.E/B.Tech or Master degree in Computer Science or Engineering. Competencies: - Strong work organization and prioritization. - Ownership and accountability for assigned work. - Ability to manage multiple activities and identify key risks. - Personal maturity, drive, integrity, adaptability, and creativity. - Sensitivity to cultural differences and environments. - Values diversity and appreciates differences in style or perspective.,
ACTIVELY HIRING
posted 2 months ago
experience5 to 9 Yrs
location
Maharashtra
skills
  • SQL
  • Informatica
  • Oracle PLSQL
  • Accounting Knowledge
  • IFRS9
  • Banking Experience
Job Description
You will be joining Fusion Practices, one of the top 20 fastest growing consultancies, as an Oracle PLSQL Expert with good accounting knowledge. Your main focus will be to act as a liaison among stakeholders to analyze, communicate, and validate requirements for changes to business processes, policies, and information systems, specifically understanding the accounting lifecycle of Banking regulator. **Key Responsibilities:** - Work within a project team to deliver IT changes within the regulatory accounting space - Collaborate with the project team and Finance on change and development tasks - Develop new functionality or enhancements using Oracle database technologies including PL/SQL based packaged procedures, functions, VPD, views, materialized views, common database APIs, SQL*Loader routines, etc. - Ensure database development aligns with modern Oracle database development practices and database optimization, throughput, scale, and efficiency are considered in the design - Analyze financial data, run queries, and provide summarized extracts to business analysts - Document development through technical design documents, installation documents, unit test cases, etc. - Provide timely updates to stakeholders on progress and issue status - Work with Oracle support, raising SRs if necessary, and providing diagnostic information when required - Ensure all development is compliant with MUSI change control and information risk policies - Coordinate with wider technology teams to ensure fixes or enhancements are implemented in a controlled manner **Requirements:** - Extensive experience with database management systems, especially Oracle, considered an expert in this field - Strong understanding of database languages including SQL*Plus & PL/SQL, ideally with experience in Financial accounting systems - Proficient in working with interfaces and ETL techniques, preferably with Informatica experience - Involved in project implementations with a solid grasp of the project life cycle and different implementation techniques - Excellent communication skills to engage with various stakeholders, including department heads - Exposure to scheduling software such as Control-M, Autosys, Tivoli, etc.,
ACTIVELY HIRING
posted 2 weeks ago

Abinitio Developer

M/S. B. NANDI
M/S. B. NANDI
experience10 to 20 Yrs
Salary24 - 36 LPA
location
Pune, Bangalore+8

Bangalore, Noida, Chennai, Hyderabad, Kolkata, Amritsar, Uttar Dinajpur, Delhi, Uttarkashi

skills
  • developers
  • abinitio
  • development management
  • developer relations
  • technology evangelism
Job Description
Job Role Duties And Responsibilities. Ab Initio Developer is responsible for giving team status on a variety of projects. Their focus is to escalate an issue as necessary, assess and communicate risks to the development schedule and project to represent the data integration development teams interests in cross-functional project teams by ensuring project success as an ultimate goal. Responsibilities Monitor and Support existing production data pipelines developed in Ab Initio Analysis of highly complex business requirements, designs and/or data requires evaluation of intangible variance factors Debug daily production issues and rerun the jobs after understanding the issues Collaborate throughout the organisation on effective identification of technical issues Participates and provides feedback in design reviews Complete component design documents on assigned projects Participate and provide feedback in design reviews Requirements 1.7+ years of actual development experience building Etl applications/processes using Sas Relevant years of Hands-on experience with Ab Initio and Hadoop technologies (Hdfs, Hive, Impala etc Need to have good understanding of Etl concepts like Informatica, Data stage, Clover Etl Experience in Relational Databases like Oracle, Sql Server and Pl/Sql Understanding of Agile methodologies as well as Sdlc life-cycles and processes. Experience in writing Technical, Functional documentation Soft Skills Ability to work as an individual with minimal guidance/support Strong communication/team skills Strong analytical skills.
posted 2 weeks ago
experience6 to 12 Yrs
location
Pune, All India
skills
  • selenium webdriver
  • python
  • ui testing
  • postgresql
  • etl testing
  • snowflake
  • testing
  • data warehouse testing
  • agile methodologies
  • mysql
  • sql
  • dbt
  • agile
  • etl
  • automation
  • informatica
  • aws
  • bdd
  • behave
  • pytest
  • ms power bi
  • automation scripting
  • playwright
  • rds
  • gherkin
Job Description
As an experienced candidate with 9 to 12 years of experience, you will be responsible for the following: Role Overview: You will play a lead role in ETL testing, UI testing, database testing, and team management. Your main responsibilities will include understanding holistic requirements, reviewing and analyzing stories, specifications, and technical design documents to develop detailed test cases and test data for thorough business functionality testing, both automation and manual. You will also validate ETL workflows, ensure data integrity, accuracy, and transformation rules using complex Snowflake SQL queries. Additionally, you will create, execute, and maintain scripts on automation in BDD Gherkin/Behave, Pytest. Moreover, you will coordinate with cross-team subject matter experts to develop, maintain, and validate test scenarios to optimize the testing process. Key Responsibilities: - Lead ETL testing, UI testing, database testing, and team management - Develop detailed test cases and test data based on requirements - Validate ETL workflows and ensure data integrity using complex Snowflake SQL queries - Create, execute, and maintain automation scripts in BDD Gherkin/Behave, Pytest - Coordinate with cross-team subject matter experts for test scenario development - Create and maintain artifacts on test strategy, BRD, defect count/leakage report - Collaborate with DevOps/SRE team to integrate test automation into CI/CD pipelines - Guide a team of at least 4 testers, institutionalize best practices in testing processes - Provide feedback on testing approaches to internal stakeholders and senior leadership - Excel in an open and recognized work culture, be a problem solver, and a team player Qualifications Required: - 8-11 years of expertise in STLC, defect management, test strategy designing, planning, and approach - Minimum 6+ years of work experience in UI, database, ETL testing - Hands-on experience in writing database queries, preferably in PostgreSQL, Snowflake, MySQL, RDS - 3+ years of experience with automation scripts execution, maintenance, and enhancements - Strong analytical, problem-solving, communication skills, collaboration, and stakeholder management skills - Proven team leadership experience with a minimum of 2 people reporting - Experience with Agile methodologies, such as Scrum, Kanban Please note that any additional details about the company were not provided in the job description. As an experienced candidate with 9 to 12 years of experience, you will be responsible for the following: Role Overview: You will play a lead role in ETL testing, UI testing, database testing, and team management. Your main responsibilities will include understanding holistic requirements, reviewing and analyzing stories, specifications, and technical design documents to develop detailed test cases and test data for thorough business functionality testing, both automation and manual. You will also validate ETL workflows, ensure data integrity, accuracy, and transformation rules using complex Snowflake SQL queries. Additionally, you will create, execute, and maintain scripts on automation in BDD Gherkin/Behave, Pytest. Moreover, you will coordinate with cross-team subject matter experts to develop, maintain, and validate test scenarios to optimize the testing process. Key Responsibilities: - Lead ETL testing, UI testing, database testing, and team management - Develop detailed test cases and test data based on requirements - Validate ETL workflows and ensure data integrity using complex Snowflake SQL queries - Create, execute, and maintain automation scripts in BDD Gherkin/Behave, Pytest - Coordinate with cross-team subject matter experts for test scenario development - Create and maintain artifacts on test strategy, BRD, defect count/leakage report - Collaborate with DevOps/SRE team to integrate test automation into CI/CD pipelines - Guide a team of at least 4 testers, institutionalize best practices in testing processes - Provide feedback on testing approaches to internal stakeholders and senior leadership - Excel in an open and recognized work culture, be a problem solver, and a team player Qualifications Required: - 8-11 years of expertise in STLC, defect management, test strategy designing, planning, and approach - Minimum 6+ years of work experience in UI, database, ETL testing - Hands-on experience in writing database queries, preferably in PostgreSQL, Snowflake, MySQL, RDS - 3+ years of experience with automation scripts execution, maintenance, and enhancements - Strong analytical, problem-solving, communication skills, collaboration, and stakeholder management skills - Proven team leadership experience with a minimum of 2 people reporting - Experience with Agile methodologies, such as Scrum, Kanban Please note that any additional details about the company were not provided in the job description.
ACTIVELY HIRING
logo

@ 2025 Shine.com | All Right Reserved

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