11+ Informatica PowerCenter Jobs in Mumbai | Informatica PowerCenter Job openings in Mumbai

Key skills:
Informatica PowerCenter, Informatica Change Data Capture, Azure SQL, Azure Data Lake

Job Description
Minimum of 15 years of Experience with Informatica ETL, Database technologies Experience with Azure database technologies including Azure SQL Server, Azure Data Lake Exposure to Change data capture technology Lead and guide development of an Informatica based ETL architecture. Develop solution in highly demanding environment and provide hands on guidance to other team members. Head complex ETL requirements and design. Implement an Informatica based ETL solution fulfilling stringent performance requirements. Collaborate with product development teams and senior designers to develop architectural requirements for the requirements. Assess requirements for completeness and accuracy. Determine if requirements are actionable for ETL team. Conduct impact assessment and determine size of effort based on requirements. Develop full SDLC project plans to implement ETL solution and identify resource requirements. Perform as active, leading role in shaping and enhancing overall ETL Informatica architecture and Identify, recommend and implement ETL process and architecture improvements. Assist and verify design of solution and production of all design phase deliverables. Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.

Professional Skillset:
 Professional experience in Python – Mandatory experience
 Basic knowledge of any BI Tool (Microsoft Power BI, Tableau etc.) and experience in R
will be an added advantage
 Proficient in Excel
 Good verbal and written communication skills


Key Responsibilities:
 Analyze data trends and provide intelligent business insights, monitor operational and
business metrics
 Complete ownership of business excellence dashboard and preparation of reports for
senior management stating trends, patterns, and predictions using relevant data
 Review, validate and analyse data points and implement new data analysis
methodologies
 Perform data profiling to identify and understand anomalies
 Perform analysis to assess quality and meaning of data
 Develop policies and procedures for the collection and analysis of data
 Analyse existing process with the help of data and propose process change and/or lead
process re-engineering initiatives
 Use BI Tools (Microsoft Power BI/Tableau) and develop and manage BI solutions

• 4+ yrs of experience having strong fundamentals on Windchill Customization & Configurations, Reporting Framework Customization, Workflow Customization , Customer handling
• Strong Customization background around Form Processors, Validator, data utilities, Form Controllers etc.
• Strong Programming skills in Java/J2EE technologies – JavaScript, GWT, JQuerry, XMLs, JSPs, SQL etc.
• Deep Knowledge in Windchill architecture

• Experience in atleast one full lifecycle PLM implementation with Windchill.
• Should have strong coding skills in Windchill development and Customization, ThingWorx Navigate Development (Mandatory), Thing Worx Architecture Configurations Mashup creation, ThingWorx and Windchill Upgrade

• Should have Build and Configuration management (Mandatory) - HPQC \JIRA\Azure\SVN\GITHUB \ Ant
• Knowledge & Experience in Build and Release process
• Having worked on custom upgrade will be a plus.
• Understanding of application s development environment, Database, data management and infrastructure capabilities and constraints. Understanding of Database administration, Database design and performance Tuning
• Follow Quality processes for tasks with appropriate reviews. Participate in sharing knowledge within the team.

Role / Purpose - Lead Developer - API and Microservices

Must have a strong hands-on development track record building integration utilizing a variety of integration products, tools, protocols, technologies, and patterns.

• Must have an in-depth understanding of SOA/EAI/ESB concepts, SOA Governance, Event-Driven Architecture, message-based architectures, file sharing, and exchange platforms, data virtualization and caching strategies, J2EE design patterns, frameworks
• Should possess experience with at least one of middleware technologies (Application Servers, BPMS, BRMS, ESB & Message Brokers), Programming languages (e.g. Java/J2EE, JavaScript, COBOL, C), Operating Systems (e.g. Windows, Linux, MVS), and Databases (DB2, MySQL, No SQL Databases like MongoDB, Cassandra, Hadoop, etc.)
• Must have experience implementing API Service architectures (SOAP, REST) using any of the market-leading API Management tools such as Apigee and frameworks such as Spring Boot for Microservices
• Should have Advanced skills in implementing API Service architectures (SOAP, REST) using any of the market-leading API Management tools such as Apigee or similar frameworks such as Spring Boot for Microservices 
• Appetite to manage large-scale projects and multiple tracks
•  Experience and knowhow of the e-commerce domain and retail experience are preferred
•  Good communication & people managerial skills

• Implementing Environment solutions for projects in a dynamic corporate environment
• Communicating and collaborating with project and technical teams on Environment requirements, delivery and support
• Delivering and Maintaining Environment Management Plans, Bookings, Access Details and Schedules for Projects
• Working with Environment Team on Technical Environment Delivery Solutions
• Troubleshooting, managing and tracking Environment Incidents & Service Requests in conjunction with technical teams and external partners via the service management tool
• Leadership support in the North Sydney office
• Mentoring, guiding and leading other team
• Creation of new test environments
• Provisioning infrastructure and platform

Test environment configuration (module, system, sub-module)

• Test data provisioning (privatization, traceability, ETL, segregation)
• Endpoint integration
• Monitoring the test environment
• Updating/deleting outdated test-environments and their details
• Investigation of test environment issues and at times, co- ordination till its resolution

Job Description – Developer (ETL + Database)

 

 Develop, document & Support ETL mappings, Database structures & BI reports.

 Perform unit testing of developments done by him/her.

 Participate in UAT process and ensure quick resolution of any UAT issue.

 Manage different environments and be responsible for proper deployment of code in all client

environments.

 Prepare release documents.

 Prepare and Maintain project documents as advised by Team Leads.

 

Skill-sets:

 3+ years of Hands on experience on ETL Pentaho Spoon Talend & MS SQL Server, Oracle & SYBASE Database tools.

 Ability to write complex SQL and database procedures.

 Good knowledge and understanding regarding Data warehouse Concepts, ETL Concepts, ETL

Loading Strategies, Data archiving, Data Reconciliation, ETL error handling etc.

 Problem Solving.

 Good communication skills – written and verbal.

 Self-motivated, team player, action and result oriented.

 Ability to successfully work under tight project schedule

Job Description

This requirement is to service our client which is a leading big data technology company that measures what viewers consume across platforms to enable marketers make better advertising decisions. We are seeking a Senior Data Operations Analyst to mine large-scale datasets for our client. Their work will have a direct impact on driving business strategies for prominent industry leaders. Self-motivation and strong communication skills are both must-haves. Ability to work in a fast-paced work environment is desired.

Problems being solved by our client: 

Measure consumer usage of devices linked to the internet and home networks including computers, mobile phones, tablets, streaming sticks, smart TVs, thermostats and other appliances. There are more screens and other connected devices in homes than ever before, yet there have been major gaps in understanding how consumers interact with this technology. Our client uses a measurement technology to unravel dynamics of consumers’ interactions with multiple devices.

Duties and responsibilities:

• The successful candidate will contribute to the development of novel audience measurement and demographic inference solutions. 
• Develop, implement, and support statistical or machine learning methodologies and processes. 

• Build, test new features and concepts and integrate into production process
• Participate in ongoing research and evaluation of new technologies
• Exercise your experience in the development lifecycle through analysis, design, development, testing and deployment of this system
• Collaborate with teams in Software Engineering, Operations, and Product Management to deliver timely and quality data. You will be the knowledge expert, delivering quality data to our clients

Qualifications:

• 3-5 years relevant work experience in areas as outlined below
• Experience in extracting data using SQL from large databases
• Experience in writing complex ETL processes and frameworks for analytics and data management. Must have experience in working on ETL tools.

• Master’s degree or PhD in Statistics, Data Science, Economics, Operations Research, Computer Science, or a similar degree with a focus on statistical methods. A Bachelor’s degree in the same fields with significant, demonstrated professional research experience will also be considered. 
• Programming experience in scientific computing language (R, Python, Julia) and the ability to interact with relational data (SQL, Apache Pig, SparkSQL). General purpose programming (Python, Scala, Java) and familiarity with Hadoop is a plus.  
• Excellent verbal and written communication skills. 
• Experience with TV or digital audience measurement or market research data is a plus. 
• Familiarity with systems analysis or systems thinking is a plus. 

• Must be comfortable with analyzing complex, high-volume and high-dimension data from varying sources
• Excellent verbal, written and computer communication skills
• Ability to engage with Senior Leaders across all functional departments
• Ability to take on new responsibilities and adapt to changes

 

Tools you’ll need to succeed this role are as follows:
● Good experience with Continuous integration and deployment tools like
Jenkins, Spinnaker, etc.
● Ability to understand problems and craft maintainable solutions.
● Working cross-functionally with a broad set of business partners to understand
and integrate their API or data flow systems with Xeno, so a minimal
understanding of data and API integration is a must.
● Experience with docker and microservice based architecture using
orchestration platforms like Kubernetes.
● Understanding of Public Cloud, We use Azure and Google Cloud.
● Familiarity with web servers like Apache, nginx, etc.
● Possessing knowledge of monitoring tools such as Prometheus, Grafana, New
Relic, etc.
● Scripting in languages like Python, Golang, etc is required.
● Some knowledge of database technologies like MYSQL and Postgres is
required.
● Understanding Linux, specifically Ubuntu.
● Bonus points for knowledge and best practices related to security.
● Knowledge of Java or NodeJS would be a significant advantage.


Initially, when you join some of the projects you’d get to own are:
● Audit and improve overall security of the Infrastructure.
● Setting up different environments for different sets of teams like
QA,Development, Business etc.

Job Description: 

 
• Responsible for the Strategy, Roadmap, Architecture, Design, Engineering and Lifecycle Delivery of our End User Devices, ensuring they are current and meet the needs of the business.  These technologies include physical devices, Operating Systems, Device Software, printing and mobility services
•        SCCM, (Windows 10, MAC & Linux) desktops, Modern Endpoint Management, InTune, endpoint security
•        Customer focused, confident and articulate with lots of experience in stakeholder meetings and presentations
•        Skills in contributing to technical roadmaps for technologies supported by End users
•        High level understanding of all EUC technology namely SCCM, Nexthink, OS (Windows and Mac) , End point security , Privilege management  , Intune / JAMF
•        Govern the upgrades and compatibility of End User devices to ensure seamless upgrades to the business and new functionality and capabilities are introduced effectively
•        Simplify the environment so our technology is current and delivers a great customer experience
•        Responsible for the management, prioritization and execution of demand
•        Engages with key Stakeholders and Customers to ensure these technologies meet customer needs.
•        Manages our technology partners effectively to ensure that our services are optimized and cost effective
•        Lead a strong technical team to deliver the right technology services to the business to deliver a great customer experience across these services
•        Architecture governance for the Device portfolio to ensure all our technology solutions are designed and implemented to work seamlessly with our applications and infrastructure to deliver a great customer experience.
•        Work across the Infrastructure and Applications team to ensure effective lifecycle management so our IT tools and services are optimized for the business.

Job title: Azure Architect

Locations: Noida, Pune, Bangalore and Mumbai

 

Responsibilities:

• Develop and maintain scalable architecture, database design and data pipelines and build out new Data Source integrations to support continuing increases in data volume and complexity
• Design and Develop the Data lake, Data warehouse using Azure Cloud Services
• Assist in designing end to end data and Analytics solution architecture and perform POCs within Azure
• Drive the design, sizing, POC setup, etc. of Azure environments and related services for the use cases and the solutions
• Reviews the solution requirements support architecture design to ensure the selection of appropriate technology, efficient use of resources and integration of multiple systems and technology.
• Must possess good client-facing experience with the ability to facilitate requirements sessions and lead teams
• Support internal presentations to technical and business teams
• Provide technical guidance, mentoring and code review, design level technical best practices

 

Experience Needed:

• 12-15 years of industry experience and at least 3 years of experience in architect role is required along with at least 3 to 4 years’ experience designing and building analytics solutions in Azure.
• Experience in architecting data ingestion/integration frameworks capable of processing structured, semi-structured & unstructured data sets in batch & real-time
• Hands-on experience in the design of reporting schemas, data marts and development of reporting solutions
• Develop batch processing, streaming and integration solutions and process Structured and Non-Structured Data
• Demonstrated experience with ETL development both on-premises and in the cloud using SSIS, Data Factory, and Azure Analysis Services and other ETL technologies.
• Experience in Perform Design, Development & Deployment using Azure Services ( Azure Synapse, Data Factory, Azure Data Lake Storage, Databricks, Python and SSIS)
• Worked with transactional, temporal, time series, and structured and unstructured data.
• Deep understanding of the operational dependencies of applications, networks, systems, security, and policy (both on-premise and in the cloud; VMs, Networking, VPN (Express Route), Active Directory, Storage (Blob, etc.), Windows/Linux).

 

 

Mandatory Skills: Azure Synapse, Data Factory, Azure Data Lake Storage, Azure DW, Databricks, Python

Role 1 : Core Java

Experience  - 5 – 10 years

Location – Mumbai ( NKP) / Weworks

Primary Skills / Must have:

• Knows Java Programming Language (Java 7, 8) with Object-Oriented Design and Spring Framework. Understanding of RESTFul Services development.
• Has a good understanding of asynchronous requests, multithreading and related issues and ways to resolve them.
• Has a good understanding of web and web programming principles, cookies, sessions etc.
• Familiar with tomcat, servlet model and their limitations.
• Has a good understanding of basic algorithms and data structures.
• Good analytical skills, problem-solving skills and willingness to learn.
• Good communication and collaboration skills. Willing to ask questions.
• Team player.

 Secondary Skills / Desired skills

• Modern web development tools including JavaScript frameworks such as Angular JS and CSS frameworks such as Bootstrap.
• Familiarity with Git and Linux/Unix commands.

 

Role 2 – JAVA + Linux + SQL Server combination of skills - Bangalore

Experience  – 4 – 9 years

Location – Bangalore  ( RMZ Ecoworld)

Required Technical Skills:

• Strong Java experience.
• Experienced in Agile development lifecycle.
• Hands-on experience with Programming language: Python, and SQL
• Experience in database platforms : DB2/Sybase/MSSQL server.
• Working knowledge of Linux/Unix.
• Working knowledge of Java spring framework,Angular 7/8,GIT.

Desired Technical Skills:

• Working experience on Actimize RCM solution.
• Knowledge of testing automation tools like selenium.
• Good knowledge of Actimize AIS solution
• CI/CD

 

Required Aptitudes

• Ability to take on challenges and open to learning new technologies.
• Ability to work on multiple projects at the same time.
• Passion for innovation and find creative solutions to complex business problems.
• Team player.

Educational qualification and experience:

• Bachelor degree in engineering/computer science or MCA from recognized institution
• Minimum 3 years of development experience in required technical skills.

 

Role 3 – Java+ Spring + Azure  ( Mandatory)

Location – Bangalore

Experience – 4 – 7 years

 

Role 4 – Java Fullstack

Experience  - 5 – 9 years

 

Location – Mumbai ( NKP)

 

No of open role – 4

 

Mandatory Skills – Core Java , Full stack and Unix

 

Responsibilities Include:

Ø  Work closely with Business Analysts to understand User and Functional Requirements

Ø  Conduct Technical Design, create Design Prototype and Design Specifications. Be able to understand business needs and translate into technology solutions

Ø  Implement the requirements using the latest firm wide technologies and approved global solutions

Ø  Perform Unit Testing and, wherever applicable, collaborate with QA Engineer on System / Integration / QA / Regression / Performance / Capacity Testing, and create testing documentation

Ø  Coordinate with users on User Acceptance Testing and provide testing support

 

Required technical skills:

Ø  Minimum 3-4 years of hands-on experience in software development

Ø  Good programming skills using Java

Ø  Excellent relational database skills on Sybase / DB2 & Unix Shell Scripting

Ø  Good knowledge and solid experience in Agile software development

Ø  Good knowledge, skills and abilities to perform high quality software testing

Ø  Experience on Axiom / XML / SOAP / Informatica is preferred but not essential

 

Required professional skills:

Ø  Enthusiasm for and interest in learning and applying new technologies to solve real world business problems

Ø  Pursuit for perfect delivery quality in a zero-error-tolerance environment

Ø  Strong analytical and problem solving skills

Ø  Good communication skills including ability to explain technical issues to non-technical people

Ø  Highly organized, self-motivated, result-oriented, and proactive with capability to work with minimal supervision

Ø  A strong can-do attitude

Ø  Creative and flexible while observing policies, rules and standards

Demonstrate highly proficient written and verbal communication skills in the English language

 

Role 5 – Core Java / Java backend hands on developer

Location – Mumbai and Banglare

Experience  - 5  – 10 years /