56 Etl Informatica Jobs

Role & responsibilities Collaborate with ZS internal teams and client teams to shape and implement high quality technology solutions that address critical business problems Understand and analyze business problems thoroughly, and translate them into technical designs effectively Design and implement technical features using best practices for the specific technology stack being used Assist in the development phase of implementing technology solutions for client engagements, ensuring effective problem-solving Apply appropriate development methodologies (e.g., agile, waterfall, system integrated testing, mid-development client reviews, embedded QA procedures, unit testing) to ensure successful and timely completion of projects Provide guidance and support to team members in creating comprehensive project implementation plans Work closely with a development team to accurately interpret and implement business requirements Preferred candidate profile Bachelor's or Master's degree in Business Analytics, Computer Science, MIS or related field with academic excellence Proficiency in RDBMS concepts, SQL, and programming languages such as Python Strong analytical and problem-solving skills to convert intricate business requirements into technology solutions Knowledge of algorithms and data structures Additional Skills: 1-3+ years of relevant professional experience in delivering small/medium-scale technology solutions Strong verbal and written communication skills to effectively convey results and issues to internal and client teams Familiarity with Big Data Concepts and Cloud Platforms like AWS, Azure, and Google Cloud Platform Understanding of productivity tools such as co-pilot and SQL generation Travel to other offices as required to collaborate with clients or internal project teams Perks and benefits ZS offers a comprehensive total rewards package including health and well-being, financial planning, annual leave, personal growth and professional development. Our robust skills development programs, multiple career progression options and internal mobility paths and collaborative culture empowers you to thrive as an individual and global team member. We are committed to giving our employees a flexible and connected way of working. A flexible and connected ZS allows us to combine work from home and on-site presence at clients/ZS offices for the majority of our week. The magic of ZS culture and innovation thrives in both planned and spontaneous face-to-face connections.

ETL Developer Informatica BDM/DEI Experience: 5+ years Industry Preference: Telecom (Telco) knowledge must. Key Skills: Informatica BDM/DEI, ETL development, data integration, Hive/Spark, SQL, performance optimization Responsibilities: Design and develop scalable ETL pipelines using Informatica BDM/DEI; integrate data from diverse sources including big data platforms; optimize mappings and workflows for performance and reliability; collaborate with data architects and analysts on mapping specifications.

ETL Developer Informatica BDM/DEI Experience: 5+ years Industry Preference: Telecom (Telco) knowledge must. Key Skills: Informatica BDM/DEI, ETL development, data integration, Hive/Spark, SQL, performance optimization Responsibilities: Design and develop scalable ETL pipelines using Informatica BDM/DEI; integrate data from diverse sources including big data platforms; optimize mappings and workflows for performance and reliability; collaborate with data architects and analysts on mapping specifications.

Critical Skills to Possess: 5+ years of experience in data engineering or ETL development. 5+ years of hands-on experience with Informatica. Experience in production support , handling tickets, and monitoring ETL systems. Strong SQL skills with experience in querying large datasets. Familiarity with data warehousing concepts and design (e.g., star schema, snowflake schema). Experience with relational databases such as Oracle, SQL Server, or PostgreSQL. Knowledge of cloud platforms such as AWS, Azure, or GCP is a plus. Preferred Qualifications: BS degree in Computer Science or Engineering or equivalent experience Roles and Responsibilities Roles and Responsibilities: Design, develop, and maintain robust ETL pipelines using Informatica . Work with data architects and business stakeholders to understand data requirements and translate them into technical solutions. Integrate data from various sources including relational databases, flat files, APIs, and cloud-based systems. Optimize and troubleshoot existing Informatica workflows for performance and reliability. Monitor ETL workflows and proactively address failures, performance issues, and data anomalies. Respond to and resolve support tickets related to data loads, ETL job failures, and data discrepancies. Provide support for production data pipelines and jobs Ensure data quality and consistency across different systems and pipelines. Implement data validation, error handling, and auditing mechanisms within ETL processes. Collaborate with data analysts, data scientists, and other engineers to ensure a consistent and accurate data platform. Maintain documentation of ETL processes, data flows, and technical designs. Monitor daily data loads and resolve any ETL failures or data quality issues.

About The Role : Job TitleSenior Engineer LocationBangalore, India Corporate TitleAssistant Vice President Role Description The Channels Global Applications Team within DWS Asset Management Technology is aiming to recruit a Senior Engineer . This role is ideal for an experienced Software Developer who is seeking a challenging and rewarding engagement, with the potential to grow both their career and their understanding of many applications and technologies. In DWS Asset Management, many applications are used to support the Sales and Marketing divisions. Each application must comply with Asset Management application governance, policy, and procedures. At DWS, were capturing the opportunities of tomorrow. You can be part of a leading, client-committed, global Asset Manager, making an impact on individuals, communities, and the world. Join us on our journey, and you can shape our transformation by working side by side with industry thought-leaders and gaining new and diverse perspectives. You can share ideas and be yourself, whilst driving innovative and sustainable solutions that influence markets and behaviors for the better. Every day brings the opportunity to discover a new now, and here at DWS, youll be supported as you overcome challenges and reach your ambitions. This is your chance to lead an extraordinary career and invest in your future. What well offer you 100% reimbursement under childcare assistance benefit (gender neutral) Sponsorship for Industry relevant certifications and education Accident and Term life Insurance Your key responsibilities This specific role is to act as a Senior Engineer reporting to the Global Applications Product Manager. The main objective of the Senior Engineer is to support the DWS Sales and Marketing divisions in building a holistic Sales Data Warehouse function, including the management of related controls as well as other infrastructure artifacts. You will be asked to develop and enhance batch processes to take in various data feeds to apply updates to the Sales Data Warehouse. This will involve extensive knowledge and experience with Control-M batch scheduling, UNIX batch scripting, Informatica ETL development, MSSQL stored procedure development, MSSQL database management, DOS batch scripting, and ASP.NET development . As a Senior Engineer you will: Support the development, implementation, maintenance and continuous improvement of the DWS Global Applications framework, in particular the approach to fulfil regulatory requirements and define process criticality. Identification of process weaknesses and process improvements aimed to address such weaknesses, test the hypothesis on a selected range of processes Detail requirements for the design and implementation of the application framework to ensure consistency with process management activities. Prepare insights for the organization (divisional COOs, Executive and Supervisory Board) on potential for improvement and improvement initiatives to launch. Your skills and experience University degree ideally in Computer Science, Software Engineering, or equivalent At least 5 years experience in banking and/or asset management, preferrable in Software Development, System Architecture, System Analysis, and Production Support related activities Solid domain knowledge in the Asset Management / Banking industry, with respect to regulatory frameworks and industry standards Excellent communication skills to effectively communicate with internal and external stakeholders (to Senior Management / Regulators) Process modeling experience or other BPM / Operational excellence certification are considered a plus. Direct and/or indirect experience in operational risk management or controls management in either 1st or 2nd Line of Defense are considered a plus Proficient in MS PowerPoint, Excel, and Word, experience with a Business Process Management Tool is considered a plus Strong written and verbal communication skills in English Working knowledge of JIRA and Confluence tools MSSQL creating SQL scripts and stored procedures Wintel - DOS scripting, SFTP connectivity concepts, and PuTTY Unix - scripting, SFTP connectivity concepts, account/group setup/permissions concepts, file system concepts Informatica / ETL tools Control-M job scheduling ASP.NET framework/core knowledge Networking Basic Networking knowledgeIP addresses, IP subnets, NATing How well support you About us and our teams Please visit our company website for further information: https://www.db.com/company/company.htm We at DWS are committed to creating a diverse and inclusive workplace, one that embraces dialogue and diverse views, and treats everyone fairly to drive a high-performance culture. The value we create for our clients and investors is based on our ability to bring together various perspectives from all over the world and from different backgrounds. It is our experience that teams perform better and deliver improved outcomes when they are able to incorporate a wide range of perspectives. We call this #ConnectingTheDots.

Gyansys is looking for resource with informatica CDGC Opportunity with one of our direct customer. Role & responsibilities 5+ years of experience of informatica and Good hands on experience in CDGC.

Objectives aligned to this role: One place to manage all Informatica related development jobs along with the setup support. What would you do: Analyse Database models and Requirements: - Informatica developers analyse a business's database storage and warehousing capabilities and assess the company's data requirements.They review data storage and access procedures and use Informatica tools to update, test, and provide solutions for data issues Develop Technical documents for informatica systems: - Informatica developers maintainup-to-date documentation of implementation, troubleshooting, and ETL processes related to Informatica systems. They also keep documents pertaining to specific issues and how they were resolved, including coding information and extraction and transformation processes. Integrate Informatica Systems: - One of the main roles of an Informatica developer is to develop Target systems using Informatica software tools. These developers must integrate this system with a company's existing systems, troubleshoot any issues, and smoothly implement the Informatica cloud data management product. Develop informatica Workflows: - The developers core job is by following the technical documentation develop informatica ETL workflow to pull data from source transform and then load into the target system. Conduct data quality test: - It is up to Informatica developers to regularly check the quality of stored data. They oversee mappings and workflows, check data integrity and accuracy, and perform data cleansing procedures as needed. Whom we are looking for: In addition to the expected technical skills required to be an Informatica developer, these professionals should be team leaders with strong analytical, creative, and time management skills. After examining several job postings, we found that employers tend to favor candidates who display the following abilities. 2 to 5 years of overall experience doing development job in Informatica ETL. Computer skills - a thorough knowledge of computer programming, coding, and various operating and database systems is a must for Informatica developers. Time management - Informatica developers should have the ability to quickly develop data warehousing systems and solve any issues to ensure the continued accuracy of business data. Creativity - the ability to create mappings from scratch often calls for strong creative skills on the part of an Informatica developer. Analytical thinking - Informatica developers should be able to analyse data needs and options and understand the needs of various clients. Troubleshooting - when data warehousing systems are down, it falls to Informatica developers to quickly assess the problem and provide a solution. Team collaboration - Informatica developers rarely work alone; they typically interact closely with database managers and other IT specialists when maintaining, storing, and retrieving data. Technical skills: Required: Informatica PowerCenter tools (workflow manager, workflow monitor, designer) Programming languages (SQL, XTML) Data platforms (Oracle, Teradata, Hadoop) IMMEDIATE JOINERS ONLY (15 DAYS OR LESS)

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Tagetik Planning Budgeting and Forecasting Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will design, build, and configure applications to meet business process and application requirements. A typical day involves collaborating with various teams to understand their needs, developing solutions that align with business objectives, and ensuring that applications are optimized for performance and usability. You will also engage in problem-solving activities, providing support and enhancements to existing applications while staying updated on industry trends and best practices. Roles & Responsibilities:- Expected to be an SME.- Collaborate and manage the team to perform.- Responsible for team decisions.- Engage with multiple teams and contribute on key decisions.- Provide solutions to problems for their immediate team and across multiple teams.- Facilitate knowledge sharing sessions to enhance team capabilities.- Monitor project progress and ensure timely delivery of application features. Professional & Technical Skills: - Must To Have Skills: Proficiency in Tagetik Planning Budgeting and Forecasting.- Strong analytical skills to interpret complex data and provide actionable insights.- Experience in application development methodologies and best practices.- Familiarity with integration techniques and tools to connect various applications.- Ability to troubleshoot and resolve application issues efficiently. Additional Information:- The candidate should have minimum 5 years of experience in Tagetik Planning Budgeting and Forecasting.- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education

Responsibilities Design, develop, test, and maintain ETL pipelines to ingest data from various sources (databases, flat files, APIs) Reddit+15Toptal+15DevsData+15 Collaborate with business analysts, data architects, and stakeholders to gather requirements and translate them into technical design Perform data profiling, cleansing, transformation, validation, and mapping based on business rules Optimize ETL jobs for performance, scalability, and reliability; tune SQL queries and pipelines HRBlade+12Airbyte+12Expertia+12 Monitor pipeline execution, handle errors, implement alerting, and troubleshoot failures Document ETL workflows, data lineage, dependencies, and technical specifications Wipro Careers+6Airbyte+6Expertia+6 Maintain data quality checks, implement data governance standards, and support compliance Indeed India+15Airbyte+15HRBlade+15 Provide guidance to junior developers, participate in code reviews, and share best practices Required Skills & Experience SQL expertise : Writing efficient queries, performance tuning, indexing Reddit+4Toptal+4Airbyte+4 ETL tools : Hands-on with SSIS, Informatica, Talend, Apache NiFi, AWS Glue, or similar Reddit+13Qureos+13DevsData+13 Programming/Scripting : Python, Java, C#, Shell scripting, PySpark Data modeling & warehousing : Experience with star/snowflake schemas, MPP databases (Redshift, Snowflake, BigQuery) Indeed India+1Indeed+1 Databases : Proficiency with SQL (e.g., Oracle, SQL Server, PostgreSQL) and NoSQL systems Reddit+8DevsData+8Reddit+8 Data quality & validation : Experience in defining and enforcing data cleansing and validation rules Workflow orchestration : Familiarity with Airflow or similar orchestration tools Indeed+15Wipro Careers+15Toptal+15

We are looking for ETL Developers for our US-based Insurance customer project. Required Skills: Having a minimum of 3 - 8 years of experience in SSIS. Insurance Domain is Plus Secondary Skills: Oralce Database experience Optional: Attitude to take challenging tasks and risk mitigation planning Good Logical and Analytical skills, Ability to think out-of-the-box, Strong Technical Skills Good communication skills. Other tech Stacks: Informatica Data Integration ETL process Workflow Automation Graphical Tools knowledge Microsoft SQK Server Oracle Database - 12C / 18c Framework designing Interested applicant, pls respond with your resume to mohanaprasath.ponnusamy@kumaran.com

Required Skills: Having a minimum of 9+ years of experience in SSIS Architecting, Framework designing experience . Secondary Skills: Oralce Database experience Optional: Attitude to take challenging tasks and risk mitigation planning Good Logical and Analytical skills, Ability to think out-of-the-box, Strong Technical Skills Good communication skills. Other tech Stacks: Informatica Data Integration ETL process Workflow Automation Graphical Tools knowledge Microsoft SQK Server Oracle Database - 12C / 18c Framework designing

Experience: 8+ Years. Location: Hyderabad, Bangalore , Chennai. 8+ Years of strong experience in Informatica Exp in Transformations, Mapping Configuration Task, Task Flows and Parameterized Templates Experience in Informatica Power Center and Designer Good knowledge in Oracle, SQL,PL/SQL Should have experience in scheduling the Informatica cloud ETL mappings Experience in Integration of Informatica cloud with SFDC, SAP etc. as sources Experience in Business Objects and other business intelligence platforms is an advantage Should be good in understanding of functional requirements and Business Process Candidate must have good communication and facilitation skills

We are looking for ETL Developers for our US-based Insurance customer project. Required Skills: Having a minimum of 3 - 8 years of experience in Informatica / SSIS. Insurance Domain is Plus Secondary Skills: Oralce Database experience Optional: Attitude to take challenging tasks and risk mitigation planning Good Logical and Analytical skills, Ability to think out-of-the-box, Strong Technical Skills Good communication skills. Other tech Stacks: Informatica Data Integration ETL process Workflow Automation Graphical Tools knowledge Microsoft SQK Server Oracle Database - 12C / 18c Framework designing Interested applicant, pls respond with your resume to mohanaprasath.ponnusamy@kumaran.com

Required Skills: Having a minimum of 9+ years of experience in Informatica / SSIS Architecting, Framework designing experience . Secondary Skills: Oralce Database experience Optional: Attitude to take challenging tasks and risk mitigation planning Good Logical and Analytical skills, Ability to think out-of-the-box, Strong Technical Skills Good communication skills. Other tech Stacks: Informatica Data Integration ETL process Workflow Automation Graphical Tools knowledge Microsoft SQK Server Oracle Database - 12C / 18c Framework designing

Must have skills: We are seeking a highly motivated and experienced Technical Manager to lead and support a cross-functional team. This role is evenly split between technical contribution and people management. The ideal candidate will have a strong background in data engineering, analytics, and software development life cycles, combined with proven leadership in Agile environments. He will manage a team of 13 people. This role is 50% technical and 50% people management 5+ years experience in solution delivery leveraging software development life cycles (e.g., SDLC). Provide hands-on technical guidance in solution architecture, ETL development, data modeling, and analytics Three (3) years experience developing or configuring business intelligence/analytics software Strong financial acumen and understanding of business value delivery Help Coordinate and support team members, with the ability to step in and contribute to technical tasks as needed 2+ years experience in a technical leadership role 2+ years experience in systems analysis and high-level technical design for complex systems 2+ years experience writing technical documentation in a software development environment. Proficient in JIRA and Agile project tracking tools Experience in prioritizing work with Product Owners and managing product backlogs Scrum master experience preferred Good to have skills: Healthcare domain preferred

Job Description : We are expanding our team. We are currently building humongous DataLakes for world-renowned corporations. As an Informatica developer, your role involves designing, developing, and maintaining data integration solutions using Informatica's suite of products. Data Integration and ETL: You will be responsible for extracting data from various sources, transforming it to meet business requirements, and loading it into the target systems, such as Snowflake or Redshift. Proficiency in using Informatica PowerCenter, the primary tool for data integration, is crucial. Understanding data models and database structures is essential for efficient data movement and storage. Strong SQL and Pl/SQL skills are required to query and manipulate data in relational databases and perform data validations. Identifying and resolving issues related to data integration and ETL processes. Tuning Informatica workflows and transformations for optimal performance and resource utilization. Integration with Other Systems: Integrating Informatica with other systems and applications to support data exchange and interoperability. Data Security: Understanding data security and implementing measures to protect sensitive data. Working closely with a global team of business analysts, data architects, and other stakeholders to gather requirements and deliver solutions that meet business needs. Experience with other ETL tools can be beneficial.

Hiring Now: Data Engineer / ETL Developer (Talend + Power BI) Location : Bengaluru | Experience : 13 Years | Immediate Joiners Preferred (15 days) About the Role We are looking for a Data Engineer / ETL Developer passionate about designing and developing robust ETL pipelines and data models using Talend Enterprise and delivering insights through Power BI . Key Responsibilities Analyze and understand business requirements to provide end-to-end BI solutions. Design and implement scalable ETL pipelines using Talend / Informatica . Integrate data from Oracle, MSSQL, file systems, FTP, REST APIs, and more. Develop data models, document solutions, and build data catalogs. Optimize ETL processes, troubleshoot issues, and lead team deliverables. Drive data-driven decision-making via reporting & analysis. Must-Have Skills 1+ years in Talend Enterprise/Open Studio , incl. tools like TAC, TMC, Talend API. Strong SQL, ETL pipeline development. Experience with Java or Python . Solid understanding of data modeling and database design . Good-to-Have Skills Experience with Power BI (dashboards, DAX, visuals). Exposure to Talend Data Catalog is a plus. Soft Skills Analytical thinker with strong communication skills. Self-motivated and result-driven. Comfortable working in cross-functional, multicultural teams.

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Tagetik Planning Budgeting and Forecasting Good to have skills : NA Educational Qualification : 15 years full time education is required Summary :As an Application Developer, you will engage in the design, construction, and configuration of applications tailored to fulfill specific business processes and application requirements. Your typical day will involve collaborating with team members to understand project needs, developing innovative solutions, and ensuring that applications function seamlessly to support organizational goals. You will also participate in testing and troubleshooting to enhance application performance and user experience, contributing to the overall success of the projects you are involved in. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work related problems.- Assist in the documentation of application processes and workflows.- Engage in continuous learning to stay updated with industry trends and technologies. Professional & Technical Skills: - Must To Have Skills: Proficiency in Tagetik Planning Budgeting and Forecasting.- Strong analytical skills to interpret data and provide actionable insights.- Experience in application development methodologies and best practices.- Ability to work collaboratively in a team-oriented environment.- Familiarity with project management tools and techniques. Additional Information:- The candidate should have minimum 3 years of experience in Tagetik Planning Budgeting and Forecasting.- This position is based at our Bengaluru office.- A 15 years full time education is required. Qualification 15 years full time education is required

Required Skills : Bachelors degree in Computer Science or similar field or equivalent work experience. 3 to 7 years of experience with Informatica Power Center , IDMC on Data Warehousing or Data Integration projects. Expert with data warehousing standards, strategies and tools. Expert with SDLC processes. Experience in Informatica Power exchange for Mainframe, Salesforce and other new age data sources. Experience in Informatica Webservices, XML, Java Transformations etc. Strong knowledge of relational database preferably ORACLE and SQL Server. Good knowledge of UNIX/LINUX shell scripting. Strong SQL background. Strong problem-solving, multi-tasking and organizational skills. Good written and verbal communication skills. Experience working with US or other international customers. Demonstrated experience of leading a team spread across multiple locations.

Business Informatica Consultant Seeking highly experienced Business Informatica Consultants to join our data team in India. The ideal candidates will have 3-7 years of experience in delivering data solutions to clients in the areas of data quality, data profiling, and data integration using Informatica Data Quality (IDQ) in an AWS environment. The candidates must possess strong AWS technical skills and a deep understanding of Informatica Data Quality and Informatica PowerCenter products, and hands-on experience in designing, implementing, and supporting these tools in AWS environment. Key Responsibilities: Engage with client stakeholders to understand the requirements and own the end-to-end solution and delivery. Design, develop, deploy, and support end-to-end Informatica IDQ solutions to support enterprise-level data quality initiatives. Integrate IDQ with Informatica PowerCenter, MDM, and other ETL/BI tools as needed. Create and maintain technical documentation, including design specifications and test plans. Lead performance tuning and troubleshoot complex issues in IDQ workflows and mappings. Ensure compliance with enterprise architecture standards, policies, and best practices. Required Skills & Qualifications: 3-7 years of IT experience with at least 3+ years in Informatica IDQ. Experience in cloud-based data platforms (AWS). Experience integrating IDQ with Informatica PowerCenter or MDM is a plus. Strong analytical and problem-solving skills. Experience working in Agile/Scrum environments. Excellent communication and interpersonal skills. Preferred Qualifications: Informatica certifications (IDQ/PowerCenter). Exposure to data governance frameworks and tools

Role & responsibilities 6+ years of total experience and at least 5+ years of experience in Informatica applications implementation and support of data management and integration system infrastructures and technologies. Participate in the evaluation and recommendation of new products and technologies, maintain knowledge of emerging technologies for application to the enterprise. Design and developing Automation/Scripting (shell, Perl, PowerShell, Python, Java) Informatica PowerCenter Informatica PWX Informatica DQ Preferred candidate profile Take ownership for the deliverables from the entire team Strong collaboration with leadership groups Learn new technologies based on demand Coach other team members and bring them up to speed Track project status working with team members and report to leadership Participate in cross-departmental efforts Leads initiatives within the community of practice Willing to work in rotational shifts Good Communication skill with the ability to communicate clearly and effectively

Job Title: Senior Informatica Developer (with OBIEE Expertise) Location: Gurugram Experience: 5+ Years Job Type: Full-Time Project: HMSI Enterprise Data Warehouse work location - Gurugram About the Role We are seeking a seasoned Senior Informatica Developer with a robust background in enterprise-level data integration, data warehousing, and reporting solutions. This role demands deep technical proficiency in Informatica PowerCenter, PL/SQL, Unix Shell Scripting, and ETL job scheduling tools, along with mandatory hands-on experience in OBIEE (Oracle Business Intelligence Enterprise Edition) and OBIEE RPD development. The ideal candidate will play a critical role in designing scalable ETL solutions, enhancing data reporting capabilities, and ensuring end-to-end data pipeline reliability in a fast-paced environment. Key Responsibilities ETL Development: Design, build, and maintain complex ETL workflows and mappings using Informatica PowerCenter for high-volume data integration. Troubleshooting & Optimization: Perform detailed analysis, root cause identification, and resolution of ETL failures. Tune performance of mappings, sessions, and workflows using advanced techniques. SQL/PLSQL Programming: Develop optimized SQL and PL/SQL scripts including procedures, triggers, and functions to support transformation logic and data validations. Unix Shell Scripting: Create and manage shell scripts for job automation, file handling, and system monitoring. Job Scheduling: Integrate Informatica jobs with scheduling tools (e.g., Autosys, Control-M, Tidal), handling job dependencies, retries, and recovery mechanisms. OBIEE Development: Develop and maintain OBIEE reports, dashboards, and answers for business reporting needs. Manage and enhance OBIEE RPD (Repository) including physical, business model, and presentation layers. Implement security policies, logical table sources, and aggregation rules within OBIEE RPD. Collaboration & Documentation: Work with business analysts, data modelers, QA, and support teams to deliver well-documented, high-quality solutions. Data Warehousing: Apply best practices for DW concepts such as star and snowflake schemas, surrogate key handling, slowly changing dimensions, and large data volume processing. Required Skills & Expertise Informatica PowerCenter: 5+ years of strong hands-on development experience. OBIEE: Mandatory experience with OBIEE 11g/12c report development and RPD modeling. SQL & PL/SQL: Proficient in writing complex queries, stored procedures, functions, and performance tuning. Unix/Linux Scripting: Skilled in developing shell scripts for automation and batch processing. Scheduling Tools: Experience integrating ETL workflows with Autosys, Control-M, or similar tools. Performance Tuning Techniques: Pushdown optimization Lookup and cache tuning Dynamic/static partitioning Parameterization and reusable objects Data Warehousing: Sound understanding of DW concepts, fact/dimension modeling, and ETL loading strategies. Problem Solving: Excellent analytical skills with ability to work independently and resolve complex technical issues. Nice to Have (Optional but Beneficial) Experience with cloud-based ETL tools or data platforms (e.g., AWS Redshift, Snowflake, Azure Data Factory). Familiarity with DevOps practices and version control tools like Git. Exposure to Agile or Scrum development environments.

5+ Years of strong experience in Informatica CloudExp in Informatica Cloud Designer & Informatica Cloud Portal Exp in Transformations, Mapping Configuration Task, Task Flows and Parameterized Templates Experience in Informatica Power Center and DesignerGood knowledge in Oracle, SQL,PL/SQL Should have experience in scheduling the Informatica cloud ETL mappings Experience in Integration of Informatica cloud with SFDC, SAP etc. as sources Experience in Business Objects and other business intelligence platforms is an advantage Should be good in understanding of functional requirements and Business

Key responsibilities: An expert in solution design with the ability to see the big picture across the portfolio; providing guidance and governance for the analysis, solution design, development and implementation of projects A strategic thinker who will be responsible for the technical strategy within the portfolio; ensuring it aligns with the overall architecture roadmap and business strategy. An effective communicator who will utilize their technical/business knowledge to lead technical discussions with project teams, business sponsors, and external technical partners in a manner that ensures understanding of risks, options, and overall solutions. An individual with the ability to effectively consult/support technical discussions with Account Delivery and Business Sponsors ensuring alignment to both technology and business visions. Collaborate with Designers, Business System Analysts, Application Analysts and Testing specialists to deliver high quality solutions Able to prepare high-level and detailed-level designs based on technical/business requirements and defined architectures and maintain documentation Have been instrumental in platform migration work and technical migration work in the past and understands the involved intricacies. Analyze, define and document requirements for data, workflow, logical processes, interface design, internal and external checks, controls, and outputs Ensure information security standards and requirements are incorporated into all solutions Stay current with trends in emerging technologies and how they could apply to Sun Life. Key experience: A Bachelors or master’s degree in Computer Science or related field 8 -11 years of progressive information technology experience with full application development life cycle. Domain knowledge of Insurance and Retail Wealth Management. Experience in Informatica Powercenter / IDMC Development. Experience of applying various informatica transformations and different type of sources. Ability to write complex T-SQL and stored procedures, views. Experience in SQL Server 2014 and above. Exposure to DevOps and API architecture Should have experience leading small teams (5-8 developers). Good knowledge and experience of Java1.8 or above. Experience in PostGRE SQL and No-SQL DB like MongoDB etc. Good knowledge of coding best practices and should be able to do code review of peer. Produce clean, efficient code based on specifications and troubleshoot, debug and upgrade existing software.

Hi, We are looking for Informatica Developer. 5+ years of hands-on experience with Informatica PowerCenter in a development role. Strong proficiency in SQL and experience with at least one RDBMS (e.g., Oracle, SQL Server, DB2). Solid understanding of data warehousing concepts, dimensional modeling, and ETL best practices. Experience with performance tuning of Informatica mappings and sessions. Knowledge of job scheduling tools (e.g., UC4, Autosys, Control-M) is a plus. Familiarity with version control tools (e.g., Git, SVN).