34+ Informatica Jobs in India

Job Title: Database Engineer   

Location: Bangalore, Karnataka 

Company: Wissen Technology   

Experience: 5-7 Years 

Joining Period: Immediate candidates, Currently Serving, 15-20 days ONLY 

About Us: 

Wissen Technology is a global leader in technology consulting and development. We specialize in delivering top-notch solutions for Fortune 500 companies across various industries. Join us to work on cutting-edge projects in a collaborative and innovative environment.   

Key Responsibilities: 

• Develop and maintain ETL processes using the Informatica ETL tool, adhering to best practices.   
• Write efficient and optimized SQL queries and manage database operations.   
• Create and manage UNIX shell scripts to support automation and database activities.   
• Analyze business requirements, propose robust solutions, and implement them effectively.   
• Work collaboratively with global teams to deliver high-quality solutions within an Agile framework.   
• Leverage JIRA or other ALM tools to maintain a productive development environment.   
• Stay updated with new technologies and concepts to address business challenges innovatively.   

Required Skills: 

• Proficiency in Informatica ETL tools and ETL processes.   
• Strong SQL database expertise.   
• Advanced hands-on experience with UNIX shell scripting.   
• Experience working in Agile methodologies.   
• Familiarity with JIRA or similar ALM tools.   
• Excellent problem-solving, verbal, and written communication skills.   
• Proven ability to collaborate with global teams effectively.   

Desired Skills:  

• Knowledge of financial markets, payment solutions, and wealth management.   
• Experience with Spark scripting (preferred but not mandatory).   

Qualifications:   

• BTech / MTech/ MCA or any related field 
• Candidate needs to be an immediate joiner / serving notice period / 15-20 days 

Why Join Wissen Technology? 

• Opportunity to be part of a growing team focused on data-driven innovation and quality. 
• Exposure to global clients and complex data management projects. 
• Competitive benefits, including health coverage, paid time off, and a collaborative work environment. 

At Wissen Technology, we value our team members and their contributions. We offer competitive compensation, opportunities for growth, and an environment where your ideas can make a difference! 

We look forward to welcoming a detail-oriented and driven Data Analyst Associate to our team! 

Job Summary:

We are looking for an experienced ETL Tester with 5 to 7 years of experience and expertise

in the banking domain. The candidate will be responsible for testing ETL processes,

ensuring data quality, and validating data flows in large-scale projects.

Key Responsibilities:

 Design and execute ETL test cases, ensuring data integrity and accuracy.

 Perform data validation using complex SQL queries.

 Collaborate with business analysts to define testing requirements.

 Track defects and work with developers to resolve issues.

 Conduct performance testing for ETL processes.

 Banking Domain Knowledge: Strong understanding of banking processes such as

payments, loans, credit, accounts, and regulatory reporting.

Required Skills:

 5-7 years of ETL testing experience.

 Strong SQL skills and experience with ETL tools (Informatica, SSIS, etc.).

 Knowledge of banking domain processes.

 Experience with test management tools (JIRA, HP ALM).

 Familiarity with Agile methodologies.

Location – Hyderabad

Good experience in the Extraction, Transformation, and Loading (ETL) of data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager,

Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Connect as ETL tool on Oracle, and SQL Server Databases.

 Knowledge of Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations teamed with

project scope, Analysis, requirements gathering, data modeling, ETL Design, development,

System testing, Implementation, and production support.

 Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts

and Dimensions

 Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,

Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

 Developed mapping parameters and variables to support SQL override.

 Created applets to use them in different mappings.

 Created sessions, configured workflows to extract data from various sources, transformed data,

and loading into the data warehouse.

 Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

 Modified existing mappings for enhancements of new business requirements.

 Involved in Performance tuning at source, target, mappings, sessions, and system levels.

 Prepared migration document to move the mappings from development to testing and then to

production repositories

 Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex

SQL queries using PL/SQL.

 Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica

/Talend sessions as well as performance tuning of mappings and sessions.

 Experience in all phases of Data warehouse development from requirements gathering for the

data warehouse to develop the code, Unit Testing, and Documenting.

 Extensive experience in writing UNIX shell scripts and automation of the ETL processes using

UNIX shell scripting.

 Experience in using Automation Scheduling tools like Control-M.

 Hands-on experience across all stages of Software Development Life Cycle (SDLC) including

business requirement analysis, data mapping, build, unit testing, systems integration, and user

acceptance testing.

 Build, operate, monitor, and troubleshoot Hadoop infrastructure.

 Develop tools and libraries, and maintain processes for other engineers to access data and write

MapReduce programs.

Good experience in Extraction, Transformation, and Loading (ETL) of data from various sources

into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager,

Designer, Workflow Manager, Workflow Monitor, Metadata Manager), Power Connect as ETL

tool on Oracle, and SQL Server Databases.

 Knowledge of Data Warehouse/Data mart, ODS, OLTP, and OLAP implementations teamed with

project scope, Analysis, requirements gathering, data modeling, ETL Design, development,

System testing, Implementation, and production support.

 Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts

and Dimensions

• Support and maintain production Cognos web portal to manage the OLAP cube and folders.
• Used various transformations like expression, union, source qualifier, aggregator, router, store procedure, lookup transformations.
• Work on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
• Work with relational databases like DB2.
• Develop mappings with XML as target and formatting the target data according to the requirement.
• Work with logical, physical, conceptual, star, snow flake schema data models.
• Extract data from flat files, DB2 and to load the data into the SalesForce database.
• Work with various data sources--relational, flat file (fix width, delimitate) and XML.
• Involve in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration.
• Involve in all phases of SDLC - requirement gathering, design, development, testing and implementation and post-production support.
• Involve in writing PERL scripts for file transfers, file renaming and few other database scripts to be execute from UNIX.
• Create functional and technical mapping specifications and documentation for QA team.
• Support implementation and execution of MAPREDUCE programs in a cluster environment.
• Maintain data integrity during extraction, manipulation, processing, analysis and storage.
• Migrate repository objects, services and scripts from development environment to production environment.

Technical/Core skills

1. Minimum 3 yrs of exp in Informatica Big data Developer(BDM) in Hadoop environment.
2. Have knowledge of informatica Power exchange (PWX).
3. Minimum 3 yrs of exp in big data querying tool like Hive and Impala.
4. Ability to designing/development of complex mappings using informatica Big data Developer.
5. Create and manage Informatica power exchange and CDC real time implementation
6. Strong Unix knowledge skills for writing shell scripts and troubleshoot of existing scripts.
7. Good knowledge of big data platforms and its framework.
8. Good to have an experience in cloudera data platform (CDP)
9. Experience with building stream processing systems using Kafka and spark
10. Excellent SQL knowledge

Soft skills :

1. Ability to work independently 
2. Strong analytical and problem solving skills
3. Attitude of learning new technology
4. Regular interaction with vendors, partners and stakeholders

We are looking for a Senior Data Engineer to join the Customer Innovation team, who will be responsible for acquiring, transforming, and integrating customer data onto our Data Activation Platform from customers’ clinical, claims, and other data sources. You will work closely with customers to build data and analytics solutions to support their business needs, and be the engine that powers the partnership that we build with them by delivering high-fidelity data assets.

In this role, you will work closely with our Product Managers, Data Scientists, and Software Engineers to build the solution architecture that will support customer objectives. You'll work with some of the brightest minds in the industry, work with one of the richest healthcare data sets in the world, use cutting-edge technology, and see your efforts affect products and people on a regular basis. The ideal candidate is someone that

• Has healthcare experience and is passionate about helping heal people,
• Loves working with data,
• Has an obsessive focus on data quality,
• Is comfortable with ambiguity and making decisions based on available data and reasonable assumptions,
• Has strong data interrogation and analysis skills,
• Defaults to written communication and delivers clean documentation, and,
• Enjoys working with customers and problem solving for them.

A day in the life at Innovaccer:

• Define the end-to-end solution architecture for projects by mapping customers’ business and technical requirements against the suite of Innovaccer products and Solutions.
• Measure and communicate impact to our customers.
• Enabling customers on how to activate data themselves using SQL, BI tools, or APIs to solve questions they have at speed.

What You Need:

• 4+ years of experience in a Data Engineering role, a Graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field.
• 4+ years of experience working with relational databases like Snowflake, Redshift, or Postgres.
• Intermediate to advanced level SQL programming skills.
• Data Analytics and Visualization (using tools like PowerBI)
• The ability to engage with both the business and technical teams of a client - to document and explain technical problems or concepts in a clear and concise way.
• Ability to work in a fast-paced and agile environment.
• Easily adapt and learn new things whether it’s a new library, framework, process, or visual design concept.

What we offer:

• Industry certifications: We want you to be a subject matter expert in what you do. So, whether it’s our product or our domain, we’ll help you dive in and get certified.
• Quarterly rewards and recognition programs: We foster learning and encourage people to take risks. We recognize and reward your hard work.
• Health benefits: We cover health insurance for you and your loved ones.
• Sabbatical policy: We encourage people to take time off and rejuvenate, learn new skills, and pursue their interests so they can generate new ideas with Innovaccer.
• Pet-friendly office and open floor plan: No boring cubicles.

Job Description

The applicant must have a minimum of 5 years of hands-on IT experience, working on a full software lifecycle in Agile mode.

Good to have experience in data modeling and/or systems architecture.
Responsibilities will include technical analysis, design, development and perform enhancements.

You will participate in all/most of the following activities:
- Working with business analysts and other project leads to understand requirements.
- Modeling and implementing database schemas in DB2 UDB or other relational databases.
- Designing, developing, maintaining and Data processing using Python, DB2, Greenplum, Autosys and other technologies

Skills /Expertise Required :

Work experience in developing large volume database (DB2/Greenplum/Oracle/Sybase).

Good experience in writing stored procedures, integration of database processing, tuning and optimizing database queries.

Strong knowledge of table partitions, high-performance loading and data processing.
Good to have hands-on experience working with Perl or Python.
Hands on development using Spark / KDB / Greenplum platform will be a strong plus.
Designing, developing, maintaining and supporting Data Extract, Transform and Load (ETL) software using Informatica, Shell Scripts, DB2 UDB and Autosys.
Coming up with system architecture/re-design proposals for greater efficiency and ease of maintenance and developing software to turn proposals into implementations.

Need to work with business analysts and other project leads to understand requirements.
Strong collaboration and communication skills

• Experience implementing large-scale ETL processes using Informatica PowerCenter.
• Design high-level ETL process and data flow from the source system to target databases.
• Strong experience with Oracle databases and strong SQL.
• Develop & unit test Informatica ETL processes for optimal performance utilizing best practices.
• Performance tune Informatica ETL mappings and report queries.
• Develop database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Hands-on Experience in Unix.
• Experience in Informatica Cloud (IICS).
• Work with appropriate leads and review high-level ETL design, source to target data mapping document, and be the point of contact for any ETL-related questions.
• Good understanding of project life cycle, especially tasks within the ETL phase.
• Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment.
• Excellent communication and presentation skills.
• Effectively worked on the Onsite and Offshore work model.

Informatica PowerCenter (9x ,10.2) : Minimum 2+ years experience

SQL / PLSQL: Understanding of SQL procedure. Able to convert procedures into Informatica mapping.

Good to have- Advantage if you have knowledge of Windows Batch Script.

Job Description

We are looking for a senior resource with Analyst skills and knowledge of IT projects, to support delivery of risk mitigation activities and automation in Aviva’s Global Finance Data Office. The successful candidate will bring structure to this new role in a developing team, with excellent communication, organisational and analytical skills. The Candidate will play the primary role of supporting data governance project/change activities. Candidates should be comfortable with ambiguity in a fast-paced and ever-changing environment. Preferred skills include knowledge of Data Governance, Informatica Axon, SQL, AWS. In our team, success is measured by results and we encourage flexible working where possible.

Key Responsibilities

• Engage with stakeholders to drive delivery of the Finance Data Strategy
• Support data governance project/change activities in Aviva’s Finance function.
• Identify opportunities and implement Automations for enhanced performance of the Team

Required profile

• Relevant work experience in at least one of the following: business/project analyst, project/change management and data analytics.
• Proven track record of successful communication of analytical outcomes, including an ability to effectively communicate with both business and technical teams.
• Ability to manage multiple, competing priorities and hold the team and stakeholders to account on progress.
• Contribute, plan and execute end to end data governance framework.
• Basic knowledge of IT systems/projects and the development lifecycle.
• Experience gathering business requirements and reports.
• Advanced experience of MS Excel data processing (VBA Macros).
• Good communication

Additional Information

Degree in a quantitative or scientific field (e.g. Engineering, MBA Finance, Project Management) and/or experience in data governance/quality/privacy
Knowledge of Finance systems/processes
Experience in analysing large data sets using dedicated analytics tools

Designation – Assistant Manager TS

Location – Bangalore

Skills- Informatica with Big Data Management

1.Minimum 6 to 8 years of experience in informatica BDM development
2.Experience working on Spark/SQL
3.Develops informtica mapping/Sql 

Informatica PowerCenter (9x ,10.2) : Minimum 2+ years experience

SQL / PLSQL: Understanding of SQL procedure. Able to convert procedures into Informatica mapping.

Good to have- Advantage if you have knowledge of Windows Batch Script.

Key  Responsibilities :

• Development of proprietary processes and procedures designed to process various data streams around critical databases in the org
• Manage technical resources around data technologies, including relational databases, NO SQL DBs, business intelligence databases, scripting languages, big data tools and technologies, visualization tools.
• Creation of a project plan including timelines and critical milestones to success in support of the project
• Identification of the vital skill sets/staff required to complete the project
• Identification of crucial sources of the data needed to achieve the objective.

Skill Requirement :

• Experience with data pipeline processes and tools
• Well versed in the Data domains (Data Warehousing, Data Governance, MDM, Data Quality, Data Catalog, Analytics, BI, Operational Data Store, Metadata, Unstructured Data, ETL, ESB)
• Experience with an existing ETL tool e.g Informatica and Ab initio etc
• Deep understanding of big data systems like Hadoop, Spark, YARN, Hive, Ranger, Ambari
• Deep knowledge of Qlik ecosystems like  Qlikview, Qliksense, and Nprinting
• Python, or a similar programming language
• Exposure to data science and machine learning
• Comfort working in a fast-paced environment

Soft attributes :

• Independence: Must have the ability to work on his/her own without constant direction or supervision. He/she must be self-motivated and possess a strong work ethic to strive to put forth extra effort continually
• Creativity: Must be able to generate imaginative, innovative solutions that meet the needs of the organization. You must be a strategic thinker/solution seller and should be able to think of integrated solutions (with field force apps, customer apps, CCT solutions etc.). Hence, it would be best to approach each unique situation/challenge in different ways using the same tools.
• Resilience: Must remain effective in high-pressure situations, using both positive and negative outcomes as an incentive to move forward toward fulfilling commitments to achieving personal and team goals.

• 4-7 years of Industry experience in IT or consulting organizations
• 3+ years of experience defining and delivering Informatica Cloud Data Integration & Application Integration enterprise applications in lead developer role
• Must have working knowledge on integrating with Salesforce, Oracle DB, JIRA Cloud  
• Must have working scripting knowledge (windows or Nodejs) 

Soft Skills 

• Superb interpersonal skills, both written and verbal, in order to effectively develop materials that are appropriate for variety of audience in business & technical teams
• Strong presentation skills, successfully present and defend point of view to Business & IT audiences
• Excellent analysis skills and ability to rapidly learn and take advantage of new concepts, business models, and technologies

 Review all job requirements and specifications required for deploying the solution into the production environment. 

 Perform various unit/tests as per the checklist on deployment steps with help of test cases and maintain documents for the same. 

 Work with Lead to resolve all issues within the required timeframe and inform for any delays. 

 Collaborate with the development team to review new programs for implementation activities and manage communication (if required) with different functions to resolve issues and assist implementation leads to manage production deployments. 

 Document all issues during the deployment phase and document all findings from logs/during actual deployment and share the analysis. 

 Review and maintain all technical and business documents.  Conduct and monitor software implementation lifecycle and assist/make appropriate customization to all software for clients as per the deployment/implementation guide 

 Train new members on product deployment, issues and identify all issues in processes and provide solutions for the same. 

 Ensure project tasks as appropriately updated in JIRA / ticket tool for in-progress/done and raise the issues. 

 Should take self-initiative to learn/understand the technologies i.e. Vertica SQL, Internal Data integration tool (Athena), Pulse Framework, Tableau. 

 Flexible to work during non-business hours in some exceptional cases (for a few days) required to meet the client time zones. 

Experience on Tools and Technologies preferred: 

ETL Tools: Talend or Informatica ,Abinitio,Datastage 

BI Tools: Tableau or Jaspersoft or Pentaho or Qlikview experience 

Database: Experience in Oracle or SS 

Methodology: Experience in SDLC and/or Agile Methodology

Qualifications & Skills

• Proven track record in delivering Data Governance Solutions to a large enterprise
• Knowledge experience in data governance frameworks, formulating data governance policy, standards and processes
• Experience in program management and managing cross functional stakeholders from senior leadership to project manager level
• Experience in leading a team of data governance business analysts
• Experience in data governance tools like Informatica Data Quality, Enterprise Data Catalog, Axon, Collibra
• Experience in metadata management, master and reference data management, data quality and data governance

• EDW/BI experience of 15+ years with at least 2-3 end to end EDW implementation experience as Solution or Technical program manager
• Must have at least ONE Azure Data Platform implementation experience as Solution or Technical Project manager (Azure, Databricks, ADF, PySpark)
• Must have technology experience in any of the ETL tools like Informatica, Datastage and etc.
• Excellent communication and presentation skills
• Should be well versed with project estimation, project planning, execution, tracking & monitoring
• Should be well versed with delivery metrics in Waterfall and/or Agile delivery models, scrum management
• Preferred to have technology experience of any of the BI tools like MicroStrategy, Tableau, Power BI and etc.

Responsibilities

• Installing and configuring Informatica components, including high availability; managing server activations and de-activations for all environments; ensuring that all systems and procedures adhere to organizational best practices
• Day to day administration of the Informatica Suite of services (PowerCenter, IDS, Metadata, Glossary and Analyst).
• Informatica capacity planning and on-going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as needed.
• Manage backup and security of Data Integration Infrastructure.
• Design, develop, and maintain all data warehouse, data marts, and ETL functions for the organization as a part of an infrastructure team.
• Consult with users, management, vendors, and technicians to assess computing needs and system requirements.
• Develop and interpret organizational goals, policies, and procedures.
• Evaluate the organization's technology use and needs and recommend improvements, such as software upgrades.
• Prepare and review operational reports or project progress reports.
• Assist in the daily operations of the Architecture Team , analyzing workflow, establishing priorities, developing standards, and setting deadlines.
• Work with vendors to manage support SLA’s and influence vendor product roadmap
• Provide leadership and guidance in technical meetings, define standards and assist/provide status updates
• Work with cross functional operations teams such as systems, storage and network to design technology stacks.

Preferred Qualifications

• Minimum 6+ years’ experience as Informatica Engineer and Developer role
• Minimum of 5+ years’ experience in an ETL environment as a developer.
• Minimum of 5+ years of experience in SQL coding and understanding of databases
• Proficiency in Python
• Proficiency in command line troubleshooting
• Proficiency in writing code in Perl/Shell scripting languages
• Understanding of Java and concepts of Object-oriented programming
• Good understanding of systems, networking, and storage
• Strong knowledge of scalability and high availability

• Looking only for immediate to 15 days candidate.
• Looking for an experienced Integration specialist with a good expertise in ETL Informatica and a strong Application integration background
• Minimum of 3+ years relevant experience in Informatica MDM required. Powercenter is a core skill set.
• Having experience in a broader Informatica toolset is strongly preferred
• Should prove a very strong implementation experience in Application integration, should demonstrate expertise/presentation with multiple use cases
• Passionate coders with a strong Application development background, years of experience could range from 5+ to 15+
• Should have application development experience outside of ETL, (just learning ETL as a tool is not enough), experience in writing application outside of ETL will bring in more value
• Strong database skills with a strong understanding of data, data quality, data governance, understanding and developing standalone and integrated database layers (sql, packages, functions, performance tuning ), i.e. Expert with a strong integration background who has more application integration background than just an ETL Informatica tool
• Experience in integration with XML/JSON based and heavily involve JMS MQ (read/write)
• Experience in SOAP and REST based API's exchanging both XML and JSON files used for request and response
• Experience with Salesforce.com Integration using Informatica power exchange module is a plus but not needed
• Experience with Informatica MDM as a technology stack that is used for integration of senior market members with Salesforce.com is a plus but not needed,
• Very strong scripting background (C/bourne shell/Perl/Java)
• Should be able to understand JAVA, we do have development around JAVA, i.e ability to work around a solution in programming language like Java when implementation is not possible through ETL
• Ability to communicate effectively via multiple channels (verbal, written, etc.) with technical and non-technical staff.

Job Title: Senior Software Engineer - Mulesoft / Informatica

Job Description:

• Senior integration developer who is having experience in any two of the integrations tools, Dell Boomi, MuleSoft, Informatica.
• Understand, gather and document requirements
• Analyze and design the solution, if needed help PM/Architect to decide the architecture
• Develop the solution and guide the team to develop the solution
• Follow coding guidelines
• Test the developed solution
• Follow the organizational / project processes
• Provide necessary support with right attitude to the project manager and the project team

Job Responsibilities:

• Gather requirements, analyze, document the design approach, develop and produce quality output
• Follow the project processes
• Mentor junior resources
• Impart training where necessary
• Be open to learn other integration tools

Primary Skills Required: Dell Boomi, Mulesoft, Informatica

Secondary Skills Required: Java, Salesforce

Technical Skills Required:

Experience in any one of the Integration tool, Dell Boomi, Mulesoft and Informatica.
Required at least one Certification on any Integration Tool

Experience: 5 years to 10 years

Job Description:

• Integration developer who is having experience in any one of the integrations tools Dell Boomi, MuleSoft, Informatica.
• Understand requirements and participate in designing the solution
• Develop the solution as per the design by following coding guidelines.
• Test the developed solution.
• Work on defect fixes
• Follow project processes
• Provide accurate status report on a daily basis

Job Responsibilities:

• Participate in Design and develop as per the design and requirements
• Follow coding guidelines and produce quality output
• Follow the project processes and completed the development within the set target
• Analyze the defects to identify root cause and fix the defects.
• Be Open to learn other integration tools.

Primary Skills Required: Dell Boomi, Mulesoft, Informatica

Secondary Skills Required: Java, Salesforce

Technical Skills Required:

Experience in any one of the Integration tool, Dell Boomi, Mulesoft and Informatica.
Required at least one Certification on any Integration Tool