13+ Informatica PowerCenter Jobs in India

Position Description

We are looking for a highly motivated, hands-on Sr. Database/Data Warehouse Data Analytics developer to work at our Bangalore, India location. Ideal candidate will have solid software technology background with capability in the making and supporting of robust, secure, and multi-platform financial applications to contribute to Fully Paid Lending (FPL) project. The successful candidate will be a proficient and productive developer, a team leader, have good communication skills, and demonstrate ownership.

Responsibilities

• Produce service metrics, analyze trends, and identify opportunities to improve the level of service and reduce cost as appropriate.
• Responsible for design, development and maintenance of database schema and objects throughout the lifecycle of the applications.
• Supporting implemented solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, and communicating functional and technical issues.
• Helping the team by taking care of production releases.
• Troubleshoot data issues and work with data providers for resolution.
• Closely work with business and applications teams in implementing the right design and solution for the business applications.
• Build reporting solutions for WM Risk Applications.
• Work as part of a banking Agile Squad / Fleet.
• Perform proof of concepts in new areas of development.
• Support continuous improvement of automated systems.
• Participate in all aspects of SDLC (analysis, design, coding, testing and implementation).

Required Skill

• 5 to 7 Years of strong database (SQL) Knowledge, ETL (Informatica PowerCenter), Unix Shell Scripting.
• Database (preferably Teradata) knowledge, database design, performance tuning, writing complex DB programs etc.
• Demonstrate proficient skills in analysis and resolution of application performance problems.
• Database fundamentals; relational and Datawarehouse concepts.
• Should be able to lead a team of 2-3 members and guide them in their day to work technically and functionally.
• Ensure designs, code and processes are optimized for performance, scalability, security, reliability, and maintainability.
• Understanding of requirements of large enterprise applications (security, entitlements, etc.)
• Provide technical leadership throughout the design process and guidance with regards to practices, procedures, and techniques. Serve as a guide and mentor for junior level Software Development Engineers
• Exposure to JIRA or other ALM tools to create a productive, high-quality development environment.
• Proven experience in working within an Agile framework.
• Strong problem-solving skills and the ability to produce high quality work independently and work well in a team.
• Excellent communication skills (written, interpersonal, presentation), with the ability to easily and effectively interact and negotiate with business stakeholders.
• Ability and strong desire to learn new languages, frameworks, tools, and platforms quickly.
• Growth mindset, personal excellence, collaborative spirit
• 
  

Good to have skills.

• Prior work experience with Azure or other cloud platforms such as Google Cloud, AWS, etc.
• Exposure to programming languages python/R/ java and experience with implementing Data analytics projects.
• Experience in Git and development workflows.
• Prior experience in Banking and Financial domain.
• Exposure to security-based lending is a plus.
• Experience with Reporting/BI Tools is a plus.

Key Responsibilities:

·      Solution Design: Collaborate with clients to understand their business requirements and design comprehensive Informatica MDM solutions tailored to their needs.

·      Implementation: Lead the implementation of Informatica MDM solutions, including configuration, customization, and integration with existing systems.

·      Data Modelling: Design and implement data models to support MDM initiatives, ensuring data integrity, accuracy, and consistency across systems.

·      Data Quality Management: Implement Informatica Data Quality (IDQ) processes and workflows to improve data quality and ensure compliance with organizational standards.

·      Integration: Integrate Informatica MDM solutions with other enterprise systems, such as CRM, ERP, and BI platforms, to facilitate seamless data exchange and interoperability.

·      Customization: Develop custom components, workflows, and extensions to extend the functionality of Informatica MDM and meet specific business requirements.

·      Data Governance: Establish data governance policies, standards, and best practices to govern the use, management, and quality of master data within the organization.

·      Documentation: Prepare comprehensive documentation, including solution designs, technical specifications, user guides, and training materials, to support the implementation and maintenance of Informatica MDM solutions.

·      Testing and Quality Assurance: Conduct thorough testing and quality assurance activities to ensure the reliability, scalability, and performance of Informatica MDM solutions.

·      Training and Support: Provide training and support to end-users, administrators, and stakeholders to ensure successful adoption and utilization of Informatica MDM solutions.

What you’ll bring

• Bachelor's degree in Computer Science, Information Systems, or related field; Master's degree preferred.
• Minimum of 4 years of experience in implementing and configuring Informatica MDM solutions.
• Proficiency in Informatica MDM Hub, Informatica Data Director, Informatica Data Quality (IDQ), and related Informatica tools and technologies.
• Strong understanding of data modelling principles, data integration concepts, and master data management best practices.
• Hands-on experience with data profiling, cleansing, and transformation using Informatica IDQ.
• Experience with data governance frameworks, data stewardship workflows, and data quality metrics.
• Excellent communication skills and the ability to effectively collaborate with cross-functional teams and stakeholders.
• Proven ability to work independently, manage multiple priorities, and deliver high-quality results within tight deadlines.
• Informatica certification(s) in MDM and/or IDQ is a plus.

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.

Pingahla is recruiting business intelligence Consultants/Senior consultants who can help us with Information Management projects (domestic, onshore and offshore) as developers and team leads. The candidates are expected to have 3-6 years of experience with Informatica Power Center/Talend DI/Informatica Cloud and must be very proficient with Business Intelligence in general. The job is based out of our Pune office.

Responsibilities:

• Manage the customer relationship by serving as the single point of contact before, during and after engagements.
• Architect data management solutions.
• Provide technical leadership to other consultants and/or customer/partner resources.
• Design, develop, test and deploy data integration solutions in accordance with customer’s schedule.
• Supervise and mentor all intermediate and junior level team members.
• Provide regular reports to communicate status both internally and externally.
• Qualifications:
• A typical profile that would suit this position would be if the following background:
• A graduate from a reputed engineering college 
• An excellent I.Q and analytical skills and should be able to grasp new concepts and learn new technologies.
• A willingness to work with a small team in a fast-growing environment.
• A good knowledge of Business Intelligence concepts

Mandatory Requirements:

• Knowledge of Business Intelligence
• Good knowledge of at least one of the following data integration tools - Informatica Powercenter, Talend DI, Informatica Cloud
• Knowledge of SQL
• Excellent English and communication skills
• Intelligent, quick to learn new technologies
• Track record of accomplishment and effectiveness with handling customers and managing complex data management needs
   

• Must have 4 to 7 years of experience in ETL Design and Development using Informatica Components.
• Should have extensive knowledge in Unix shell scripting.
• Understanding of DW principles (Fact, Dimension tables, Dimensional Modelling and Data warehousing concepts).
• Research, development, document and modification of ETL processes as per data architecture and modeling requirements.
• Ensure appropriate documentation for all new development and modifications of the ETL processes and jobs.
• Should be good in writing complex SQL queries.

• • Selected candidates will be provided training opportunities on one or more of following: Google Cloud, AWS, DevOps Tools, Big Data technologies like Hadoop, Pig, Hive, Spark, Sqoop, Flume and
• Kafka would get chance to be part of the enterprise-grade implementation of Cloud and Big Data systems
• Will play an active role in setting up the Modern data platform based on Cloud and Big Data
• Would be part of teams with rich experience in various aspects of distributed systems and computing.

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.

•   Minimum of 12 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

• 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.

• 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
• 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.

If you are an outstanding ETL Developer with a passion for technology and looking forward to being part of a great development organization, we would love to hear from you. We are offering technology consultancy services to our Fortune 500 customers with a primary focus on digital technologies. Our customers are looking for top-tier talents in the industry and willing to compensate based on your skill and expertise. The nature of our engagement is Contract in most cases. If you are looking for the next big step in your career, we are glad to partner with you. 

Below is the job description for your review.

Extensive hands- on experience in designing and developing ETL packages using SSIS

Extensive experience in performance tuning of SSIS packages

In- depth knowledge of data warehousing concepts and ETL systems, relational databases like SQL Server 2012/ 2014.