96 Iics Jobs

Key responsibilities: Understand the programs service catalog and document the list of tasks which has to be performed for each Lead the design, development, and maintenance of ETL processes to extract, transform, and load data from various sources into our data warehouse Implement best practices for data loading, ensuring optimal performance and data quality Utilize your expertise in IDMC to establish and maintain data governance, data quality, and metadata management processes Implement data controls to ensure compliance with data standards, security policies, and regulatory requirements Collaborate with data architects to design and implement scalable and efficient data architectures that support business intelligence and analytics requirements Work on data modeling and schema design to optimize database structures for ETL processes Identify and implement performance optimization strategies for ETL processes, ensuring timely and efficient data loading Troubleshoot and resolve issues related to data integration and performance bottlenecks Collaborate with cross-functional teams, including data scientists, business analysts, and other engineering teams, to understand data requirements and deliver effective solutions Provide guidance and mentorship to junior members of the data engineering team Create and maintain comprehensive documentation for ETL processes, data models, and data flows Ensure that documentation is kept up-to-date with any changes to data architecture or ETL workflows Use Jira for task tracking and project management Implement data quality checks and validation processes to ensure data integrity and reliability Maintain detailed documentation of data engineering processes and solutions Required Skills: Bachelor's degree in Computer Science, Engineering, or a related field Proven experience as a Senior ETL Data Engineer, with a focus on IDMC / IICS Strong proficiency in ETL tools and frameworks (e g , Informatica Cloud, Talend, Apache NiFi) Expertise in IDMC principles, including data governance, data quality, and metadata management Solid understanding of data warehousing concepts and practices Strong SQL skills and experience working with relational databases Excellent problem-solving and analytical skills Qualified candidates should APPLY NOW for immediate consideration! Please hit APPLY to provide the required information, and we will be back in touch as soon as possible Thank you! ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields Recent Recognitions: One of Largest IT Consulting Staffing firms in the USA Recognized as #4 by Staffing Industry Analysts (SIA 2022) ClearlyRated Client Diamond Award Winner (2020) One of the Largest Certified MBE Companies in the NMSDC Network (2022) Advanced Tier Services partner with AWS and Gold with MS

Job Responsibilities Technology Leadership Independently he/she should be able to design, implement deliver complex Data Warehousing/Data Lake, Cloud Data Management and Data Integration project assignments. Technical Design and Development Expertise in any of the following skills. Any of the ETL tools (Informatica, IICS, Matillion, Data Stage), and hosting technologies like the AWS stack (Redshift, EC2) is mandatory. Any of the BI tools among Tablau, Qlik & Power BI and MSTR. Informatica MDM, Customer Data Management. Expert knowledge of SQL with the capability to performance tune complex SQL queries in tradition and distributed RDDMS systems is must. Experience across Python, PySpark and Unix/Linux Shell Scripting. Project Management is must to have. Should be able create simple to complex project plans in Microsoft Project Plan and think in advance about potential risks and mitigation plans as per project plan. Task Management Should be able to onboard team on the project plan and delegate tasks to accomplish milestones as per plan. Should be comfortable in discussing and prioritizing work items with team members in an onshore-offshore model. Handle Client Relationship Manage client communication and client expectations independently or with support of reporting manager. Should be able to deliver results back to the Client as per plan. EducationBachelor Equivalent - OtherPG Diploma in Management

Required Skills: Need experienced Informatica MDM Engineers with strong ETL and data integration expertise to design, develop 5+ years of hands-on experience with Informatica PowerCenter or IICS. Exposure to data quality tools, MDM, or real-time data integration. Strong experience with ETL design and performance tuning. Proficiency in writing complex SQL queries and working with relational databases (Oracle, SQL Server, etc.). Solid understanding of data warehousing concepts, data modeling, and architecture. Familiarity with job scheduling tools and version control systems.

Job Track Description: The ETL Data Architect would be responsible for driving data migration strategy and execution within complex Enterprise landscape. This role will be responsible to bring in the best practices of data migration and integrations with Salesforce. Bring in best practices for Salesforce data migration integration. Create Data migration strategy for Salesforce implementations. Define template/uniform file format for migrating data into Salesforce. Must Skill: Data Architect with 8-10 years of ETL experience and 5+ years of Informatica Cloud (IICS, ICRT) experience. 5+ years of experience on Salesforce systems. Develop comprehensive data mapping and transformation plans to align data with Salesforce data model and software solution. Good understanding of Salesforce data model and schema builder. Excellent understanding of relational database concepts and how to best implement database objects in the Salesforce. Experience integrating large sets of data into Salesforce from multiple data sources. Experience with EDI transactions. Experience in Design and Development of ETL/Data Pipelines. Excellent understanding of SOSL and SOQL and the Salesforce Security model. Full understanding of project life cycle and development methodologies. Ability to interact with technical and functional teams. Excellent oral, written communication and presentation skills. Should be able to work in offshore / onsite model. Experience: Expert in ETL development with Informatica cloud using various connectors. Experience with Real Time integrations and Batch scripting. Expert in implementing the business rules by creating various transformations, working with multiple data sources like flat files, relational and cloud database, etc. and developing mappings. Experience in using ICS workflow tasksSession, Control Task, Command tasks, Decision tasks, Event wait, Email tasks, Pre-sessions, Post-session, and Pre/Post commands. Ability to migrate objects in all phases (DEV, QA/UAT and PRD) following standard defined processes. Performance analysis with large data sets Experience in writing technical specifications based on conceptual design and stated business requirements. Experience in designing and maintaining logical and physical data models and communicates to peers and junior associates using flowcharts, unified data language, Data flow Diagram. Good Knowledge of SQL, PL/SQL and Data Warehousing Concepts. Experience in using Salesforce SOQL is a plus. Responsibilities: Excellent troubleshooting and debugging skills in Informatica Cloud. Significant knowledge of PL/ SQL including tuning, triggers, ad hoc queries, and stored procedures. Strong analytical skills. Works under minimal supervision with some latitude for independent judgement. Prepare and package scripts and code across development, test, and QA environments. Participate in change control planning for production deployments. Conducts tasks and assignments as directed.

Hello everyone! PwC India is inviting applicants for the role below, kindly apply if found suitable! JD ETL Developer Work Location: Mumbai Years of experience: Around 5 to 10 years Level: Senior Assocaite , Tech leads , Mangers . Work Model - Work from office Mandatory Skill Set-ETL Informatica IICS or Power center Job Description: Location: Mumbai Full job description Skill: Informatica PowerCenter or IICS or ODI or Talend - 5 - 10 years of professional experience with working knowledge in a Data and Analytics role with a Global organization -Mandatory Hands-on Development Experience in ETL tool : Informatica Power center OR IICS or ODI or Talend -Should have implemented end to end ETL life cycle, preparing ETL design frameworks and execution -Must have rich experience building Operational Data stores, Data marts and Enterprise Data warehouse -Must have very good SQL skills ( Specifically in Oracle, MySQL, Postgre) -Should be able to create and execute ETL designs, and test cases should be able to write complex SQL queries for testing/analysis depending upon the functional/technical requirement. -Should have worked on performance optimization, error handling, writing stored procedures, etc. -Demonstrate ability to communicate effectively with both Technical & Business stakeholders - Should have good knowledge of SCD Type 1, SCD Type 2 concepts. -Should have Understanding of data modelling, Data warehousing concepts Pease lfill the application form below. https://lnkd.in/gVTyzjmu

Job Description Template Job title Senior Data Engineer (or equivalent) Position Description At MassMutual, were passionate about helping millions of people find financial freedom and this passion has driven our approach to developing highly interactive digital experiences for our customers To help us achieve our mission, we are looking to hire senior data engineer for our Data Platform Data Engineering team What Great Looks Like In This Role Our ideal Senior Data Engineer is someone who is passionate about data You enjoy building data projects from the ground up and are equally comfortable working with business partners to understand requirements as you are developing and delivering robust solutions that meet the highest standards Learning new technologies and working in the cloud excite you You are team oriented and a strong communicator Provide a description of what the position does within your group/department Department name Data Platform Supervisor Location Hyderabad Key Responsibilities And Accountabilities Design, build and maintain complex ELT/ETL jobs that deliver business value transform and load data from various sources including databases, APIs, and flat files using IICS or Python/SQL Translate high-level business requirements into technical specs Conduct unit testing, integration testing, and system testing of data integration solutions to ensure accuracy and quality Ingest data from disparate sources into the data lake and data warehouse Cleanse and enrich data and apply adequate data quality controls Provide technical expertise and guidance to team members on Informatica IICS/IDMC and data engineering best practices to guide the future development of MassMutuals Data Platform Develop re-usable tools to help streamline the delivery of new projects Knowledge, Skills And Abilities Please refer ?Education and Experience Education And Experience Bachelors degree in computer science, engineering, or a related field Masters degree preferred Data: 5+ years of experience with data analytics and data warehousing Sound knowledge of data warehousing concepts SQL: 5+ years of hands-on experience on SQL and query optimization for data pipelines ELT/ETL: 5+ years of experience in Informatica/ 3+ years of experience in IICS/IDMC Migration Experience: Experience Informatica on prem to IICS/IDMC migration Cloud: 5+ yearsexperience working in AWS cloud environment Python: 5+ years of hands-on experience of development with Python Workflow: 4+ years of experience in orchestration and scheduling tools (e g- Apache Airflow) Advanced Data Processing: Experience using data processing technologies such as Apache Spark or Kafka Troubleshooting: Experience with troubleshooting and root cause analysis to determine and remediate potential issues Communication: Excellent communication, problem-solving and organizational and analytical skills Able to work independently and to provide leadership to small teams of developers Reporting: Experience with data reporting (e g- MicroStrategy, Tableau, Looker) and data cataloging tools (e g- Alation) Experience in Design and Implementation of ETL solutions with effective design and optimized performance, ETL Development with industry standard recommendations for jobs recovery, fail over, logging, alerting mechanisms Specify the minimum acceptable level of education, experience, certifications necessary for the role Application Requirements No special requirements Support Hours India GCC US (EST) hours overlap for 2-3 hours Show more Show less

Informatica TDM 1. Data Discovery, Data Subset and Data Masking 2. Data generation 3. Complex masking and genration rule creation 4. Performance tunning for Inoformatica Mapping 5. Debugging with Informatica power center 6. Data Migration Skills and Knowledge 1. Informatica TDM development experiance in Data masking, discovery, Data subsetting and Data Generation is must 2. Should have experiance in working with flat file, MS SQL, Oracle and Snowflake 3. Debugging using Inofmratica Power center 4. Experiance in Tableau will be added advantage 5. Should have basic knowledge about IICS" 6. Must have and Good to have skills Informatica TDM, SQL, Informatica Powercenter, GDPR

Minimum 7+ years of working experience in Informatica Cloud IICS components - application integration, data integration, Informatica data quality, and Informatica power center. Strong functional understanding of RDBMS DWH-BI conceptual knowledge. Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy, ETL Error Handling, Error logging mechanism, standards, and best practices. Ability to gather requirements, solutioning, design and implementation of Informatica pipelines and performance tuning. Proficiency in SQL and experience with various sources and databases like Oracle, SQL Server, MySQL, SAP HANA, and flat files Excellent problem-solving and analytical skills, Strong SQL Skills, and performance tuning capabilities. Effective communication and teamwork skills. Knowledge of SAP Implementation, SAP HANA experience is a plus. Ability to lead a team and manage the deliverables.

Requirement : Data Architect & Business Intelligence Experience: 9+ Years Location: Gurgaon (Remote) Preferred: Immediate Joiners Job Summary: We are looking for a Data Architect & Business Intelligence Expert who will be responsible for designing and implementing enterprise-level data architecture solutions. The ideal candidate will have extensive experience in data warehousing, data modeling, and BI frameworks , with a strong focus on Salesforce, Informatica, DBT, IICS, and Snowflake . Key Responsibilities: Design and implement scalable and efficient data architecture solutions for enterprise applications. Develop and maintain robust data models that support business intelligence and analytics. Build data warehouses to support structured and unstructured data storage needs. Optimize data pipelines, ETL processes, and real-time data processing. Work with business stakeholders to define data strategies that support analytics and reporting. Ensure seamless integration of Salesforce, Informatica, DBT, IICS, and Snowflake into the data ecosystem. Establish and enforce data governance, security policies, and best practices . Conduct performance tuning and optimization for large-scale databases and data processing systems. Provide technical leadership and mentorship to development teams. Key Skills & Requirements: Strong experience in data architecture, data warehousing, and data modeling . Hands-on expertise with Salesforce, Informatica, DBT, IICS, and Snowflake . Deep understanding of ETL pipelines, real-time data streaming, and cloud-based data solutions . Experience in designing scalable, high-performance, and secure data environments . Ability to work with big data frameworks and BI tools for reporting and visualization. Strong analytical, problem-solving, and communication skills.

Requirement : Senior Business Analyst (Data Application & Integration)Experience: 10+ Years Location: Gurgaon (Hybrid) Budget Max:35 LPA Preferred: Immediate Joiners Job Summary: We are seeking an experienced Senior Business Analyst (Data Application & Integration) to drive key data and integration initiatives. The ideal candidate will have a strong business analysis background and a deep understanding of data applications, API integrations, and cloud-based platforms like Salesforce, Informatica, DBT, IICS, and Snowflake . Key Responsibilities: Gather, document, and analyze business requirements for data application and integration projects. Work closely with business stakeholders to translate business needs into technical solutions. Design and oversee API integrations to ensure seamless data flow across platforms. Collaborate with cross-functional teams including developers, data engineers, and architects. Define and maintain data integration strategies, ensuring high availability and security. Work on Salesforce, Informatica, and Snowflake to streamline data management and analytics. Develop use cases, process flows, and documentation to support business and technical teams. Ensure compliance with data governance and security best practices. Act as a liaison between business teams and technical teams, providing insights and recommendations. Key Skills & Requirements: Strong expertise in business analysis methodologies and data-driven decision-making. Hands-on experience with API integration and data application management. Proficiency in Salesforce, Informatica, DBT, IICS, and Snowflake . Strong analytical and problem-solving skills. Ability to work in an Agile environment and collaborate with multi-functional teams. Excellent communication and stakeholder management skills

Job Information Job Opening ID ZR_1661_JOB Date Opened 17/12/2022 Industry Technology Job Type Work Experience 6-10 years Job Title Informatica TDM Developer City Pune Province Maharashtra Country India Postal Code 411001 Number of Positions 4 LocationPune, Bangalore, Hyderabad Informatica TDM 1. Data Discovery, Data Subset and Data Masking 2. Data generation 3. Complex masking and genration rule creation 4. Performance tunning for Inoformatica Mapping 5. Debugging with Informatica power center 6. Data Migration Skills and Knowledge 1. Informatica TDM development experiance in Data masking, discovery, Data subsetting and Data Generation is must 2. Should have experiance in working with flat file, MS SQL, Oracle and Snowflake 3. Debugging using Inofmratica Power center 4. Experiance in Tableau will be added advantage 5. Should have basic knowledge about IICS" 6. Must have and Good to have skills Informatica TDM, SQL, Informatica Powercenter, GDPR check(event) ; career-website-detail-template-2 => apply(record.id,meta)" mousedown="lyte-button => check(event)" final-style="background-color:#2B39C2;border-color:#2B39C2;color:white;" final-class="lyte-button lyteBackgroundColorBtn lyteSuccess" lyte-rendered=""> I'm interested

Responsibilities: * Design, develop, test & maintain Informatica CDQ solutions using IICS. * Collaborate with cross-functional teams on project delivery. * Ensure data quality through monitoring & optimization. Annual bonus Health insurance Provident fund

Position : IICS Developer Experience : 6 + Years Location : Bangalore Notice Period : Immediate to 15 Days Primary Skill : IICS Developer, IICS, Informatica Intelligent Cloud Services, Informatica, ETL Best Regards, Shaheen J shaheen.jameelahmed@buzzworks.in

Job Summary: We are seeking an experienced Informatica Developer with a strong background in data integration, cloud data platforms, and modern ETL tools. The ideal candidate will have hands-on expertise in Informatica Intelligent Cloud Services (IICS/CDI/IDMC) , Snowflake , and cloud storage platforms such as AWS S3. You will be responsible for building scalable data pipelines, designing integration solutions, and resolving complex data issues across cloud and on-premises environments. Key Responsibilities: Design, develop, and maintain robust data integration pipelines using Informatica PowerCenter and Informatica CDI/IDMC . Create and optimize mappings and workflows to load data into Snowflake , ensuring performance and accuracy. Develop and manage shell scripts to automate data processing and integration workflows. Implement data exchange processes between Snowflake and external systems, including AWS S3 . Write complex SQL and SnowSQL queries for data validation, transformation, and reporting. Collaborate with business and technical teams to gather requirements and deliver integration solutions. Troubleshoot and resolve performance, data quality, and integration issues in a timely manner. Work on integrations with third-party applications like Salesforce and NetSuite (preferred). Required Skills and Qualifications: 5+ years of hands-on experience in Informatica PowerCenter and Informatica CDI / IDMC . Minimum 3 - 4 years of experience with Snowflake database and SnowSQL commands. Strong SQL development skills. Solid experience with AWS S3 and understanding of cloud data integration architecture. Proficiency in Unix/Linux Shell Scripting . Ability to independently design and implement end-to-end ETL workflows. Strong problem-solving skills and attention to detail. Experience working in Agile/Scrum environments. Preferred Qualifications (Nice to Have): Experience integrating with Salesforce and/or NetSuite using Informatica. Knowledge of cloud platforms like AWS , Azure , or GCP . Informatica certification(s) or Snowflake certifications.

Minimum 7+ years of working experience in Informatica Cloud IICS components - application integration, data integration, Informatica data quality, and Informatica power center.] Strong functional understanding of RDBMS DWH-BI conceptual knowledge. Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy, ETL Error Handling, Error logging mechanism, standards, and best practices. Ability to gather requirements, solutioning, design and implementation of Informatica pipelines and performance tuning. Proficiency in SQL and experience with various sources and databases like Oracle, SQL Server, MySQL, SAP HANA, and flat files Excellent problem-solving and analytical skills, Strong SQL Skills, and performance tuning capabilities. Effective communication and teamwork skills. Knowledge of SAP Implementation, SAP HANA experience is a plus. Ability to lead a team and manage the deliverables. Job Location: Bengaluru, Hyderabad, Pune, kolkata, Chennai, Gurgaon

Who we are: Founded in 2015, Fresh Gravity helps businesses make data-driven decisions. We are driven by data and its potential as an asset to drive business growth and efficiency. Our consultants are passionate innovators who solve clients business problems by applying best-in-class data and analytics solutions. We provide a range of consulting and systems integration services and solutions to our clients in the areas of Data Management, Analytics and Machine Learning, and Artificial Intelligence. In the last 10 years, we have put together an exceptional team and have delivered 200+ projects for over 80 clients ranging from startups to several fortune 500 companies. We are on a mission to solve some of the most complex business problems for our clients using some of the most exciting new technologies, providing the best of learning opportunities for our team. We are focused and intentional about building a strong corporate culture in which individuals feel valued, supported, and cared for. We foster an environment where creativity thrives, paving the way for groundbreaking solutions and personal growth. Our open, collaborative, and empowering work culture is the main reason for our growth and success. To know more about our culture and employee benefits, visit our website https://www.freshgravity.com/employee- benefits/. We promise rich opportunities for you to succeed, to shine, to exceed even your own expectations. We are data driven. We are passionate. We are innovators. We are Fresh Gravity. What You'll Do: Configure the data model, hierarchies, and other relationships. Troubleshoot technical issues conflict resolution and demonstrate problem-solving skills. Monitor, analyze, and participate in business requirement review, data loading, data modeling, etc. Strong background in API Development, preferably within the Informatica ecosystem Utilize CDI (Cloud Data Integration) tools for effective data integration within the cloud environment. Implement CAI (Cloud Application Integration) for seamless connectivity across applications. Deploy DQ (Data Quality) tools and methodologies to ensure high-quality data across systems. Design and implement efficient APIs for diverse integration requirements. Involved in requirement gatherings and analyzing Business Requirement Documents and worked with system analysts to create source-to-target documents. Analyse data in source databases before loading it into the data warehouse and create technical documents according to BRD. What Were Looking For: Hands-on experience in client projects Hands-on experience in Informatica MDM which includes, but is not limited to, advanced match/merge configuration, AVOS, SIF, E360, IDD, etc. OR Hands-on experience as an Informatica IDMC SaaS developer (Informatica Intelligent Cloud Services (IICS) and Intelligent Data Management Cloud (IDMC). Experience with Java enterprise. Nice to have experience in AWS services like S3, SQS etc. Why us: In addition to a competitive package, we promise rich opportunities for you to succeed, to shine, to exceed even your own expectations. In keeping with Fresh Gravity’s challenger ethos, we have developed the 5Dimensions (5D) benefits program. This program recognizes the multiple dimensions within each of us and seek to provide opportunities for deep development across these dimensions. Enrich Myself; Enhance My Client; Build my Company, Nurture My Family; and Better Humanity.

Design, develop, deploy ETL workflows mappings using Informatica PowerCenter Extract data from various source systems transform/load into target systems Troubleshoot ETL job failures resolve data issues promptly. Optimize and tune complex SQL queries Required Candidate profile Maintain detailed documentation of ETL design, mapping logic, and processes. Ensure data quality and integrity through validation and testing. Exp with Informatica PowerCenter Strong SQL knowledge Perks and benefits Perks and Benefits

Seeking ETL Developer with expertise in Informatica IICS/PowerCenter, strong SQL skills, Snowflake integration, and cloud apps. Design high-quality ETL pipelines, ensure performance, mentor juniors, and collaborate across teams.

Job Summary NetApp is in search of a qualified professional to become a member of their IT Data Analytics Support team. The selected candidate will undertake IT support responsibilities, including incident management, ensuring data load completions in accordance with service level agreements (SLAs), and leading data quality initiatives. This individual is expected to proactively assess our environments for potential risks related to stability, performance, capacity, and security, while also providing strategic recommendations to accommodate both current and future growth. The ideal candidate must thrive in a fast-paced, high-demand environment and possess a strong team-oriented mindset. Job Requirements Proven experience in ETL processing of enterprise data, transofrming data from source systems to target environments such as an Enterprise Data Warehouse. Expertise in SQL scripting tailored for data warehouses and ETL processes is essential. Practical knowledge of data reconciliation techniques is highly desirable. A robust functional understanding in key areas such as Sales, Finance, Master Data Management, and Data Analytics systems is required. Mandatory Skills: Informatica IICS, Snowflake. Preferred Skills: Azure ADLS. Additional Skills: HVR for data replication. Education B-Tech in computer science, engineering or relevant field

5+ yrs experience in IICS, ETL methodology, Informatica Cloud & Power Centre. Hands-on with Informatica Intelligent Cloud Services. Strong DB skills (Oracle, SQL). Business analysis, data modeling, complex SQL. Nice to have: Snowflake, AI/ML

Description - External Job Summary We are seeking a highly skilled Technical Lead with 10 to 12 years of experience in Informatica SaaS CDI IICS Informatica SaaS CDQ Informatica AXON and Informatica EDC. The ideal candidate will work from our office during day shifts contributing to our data integration and quality initiatives. Responsibilities Lead the design and implementation of data integration solutions using Informatica SaaS CDI and IICSOversee the development and deployment of data quality solutions with Informatica SaaS CDQProvide technical expertise in the use of Informatica AXON for data governance and metadata managementEnsure the effective use of Informatica EDC for enterprise data cataloging and lineage trackingCollaborate with cross-functional teams to understand data requirements and deliver solutions that meet business needsDevelop and maintain best practices for data integration quality and governanceMonitor and optimize the performance of data integration and quality processesTroubleshoot and resolve issues related to data integration and qualityProvide guidance and mentorship to junior team members on Informatica tools and best practicesConduct regular reviews of data integration and quality processes to ensure compliance with industry standardsStay updated with the latest trends and advancements in Informatica tools and technologiesContribute to the continuous improvement of data management practices within the organizationCommunicate effectively with stakeholders to ensure alignment on data initiatives Qualifications Possess extensive experience in Informatica SaaS CDI and IICSDemonstrate strong expertise in Informatica SaaS CDQ for data quality managementHave in-depth knowledge of Informatica AXON for data governanceShow proficiency in using Informatica EDC for data cataloging and lineageExhibit excellent problem-solving and troubleshooting skillsDisplay strong communication and collaboration abilitiesHave a proven track record of leading data integration and quality projects successfullyMaintain a commitment to staying current with industry trends and best practicesDemonstrate the ability to mentor and guide junior team members effectivelyPossess a strong understanding of data management principles and practicesShow a proactive approach to identifying and addressing data-related challengesExhibit a strong attention to detail and commitment to qualityHave a passion for leveraging data to drive business outcomes. Certifications Required Informatica Certified Professional Informatica Data Quality Certification

Synechron is seeking a skilled Oracle/SQL Developer with expertise in Informatica Intelligent Cloud Services (IICS) to join our data engineering team. The successful candidate will be responsible for designing, developing, and maintaining robust database solutions and ETL workflows that support business intelligence and data integration initiatives. This role is vital in enabling data-driven decision-making by ensuring high-quality, reliable, and efficient data processing across the organization. Software Requirements Required: Oracle SQL (latest stable versions or as specified by project) Informatica Intelligent Cloud Services (IICS) for data integration and ETL processes SQL development tools (e.g., SQL Developer, TOAD, or similar) Version control systems (e.g., Git) Data modeling and diagramming tools (e.g., ERwin, Visio) Preferred: Data warehousing tools and technologies Cloud platforms (AWS, Azure, GCP) familiarity for deployment considerations Data governance and data quality tools Overall Responsibilities Design, develop, and optimize database structures using Oracle SQL to ensure maximum performance and reliability Develop, modify, and troubleshoot ETL workflows using IICS to extract, transform, and load data from various sources Collaborate with business analysts, data architects, and stakeholders to interpret requirements into technical specifications and data models Monitor, troubleshoot, and refine ETL processes to ensure data accuracy, integrity, and timeliness Document database schemas, ETL workflows, and data integration processes for operational clarity and future reference Conduct code reviews and promote best practices in data development and implementation Stay current with emerging data management tools, techniques, and industry standards to continuously improve data solutions Support data governance and quality initiatives, ensuring compliance with organizational standards Performance outcomes: Reliable and high-performance database solutions ensuring rapid data retrieval and processing Effective ETL workflows with minimal downtime and data inconsistencies Clear documentation and adherence to best practices facilitating easy knowledge transfer and maintenance Positive stakeholder feedback on data accuracy and timeliness Technical Skills (By Category) Programming Languages: Mandatory: SQL, PL/SQL (Oracle) Preferred: Data scripting languages such as Python, Shell scripting for automation Databases/Data Management: Oracle Database (latest versions preferred), data modeling, indexing, and performance optimization Understanding of data warehousing concepts, star schema, data mart design Cloud Technologies: Cloud data integration and deployment experience (AWS, Azure, GCP) is a plus Frameworks and Libraries: Familiarity with ETL frameworks, especially Informatica IICS platform, and related tools Development Tools & Methodologies: SQL development environments (e.g., Oracle SQL Developer, TOAD) Version control: Git, GitHub, or equivalent Agile and scrum methodologies for project management and delivery Security Protocols: Basic understanding of data security, encryption, and governance strategies Experience Requirements Minimum of 4+ years experience in Oracle SQL development and database administration Proven experience with ETL design, development, and management using Informatica Intelligent Cloud Services (IICS) Familiarity with data warehousing concepts, including data modeling and data quality standards Experience with data integration involving multiple data sources and complex workflows Knowledge of Agile project environments is a plus Alternative pathways: Candidates with extensive hands-on experience with Oracle databases and ETL development using other tools, who are willing to adapt to IICS, may also be considered. Day-to-Day Activities Develop and optimize SQL and PL/SQL scripts for data extraction, transformation, and loading Design and implement scalable ETL workflows within IICS, monitoring their performance and integrity Collaborate with analysts and stakeholders to gather and refine data requirements Troubleshoot issues within database schemas and ETL processes, providing timely resolutions Participate in code reviews, ensuring adherence to coding standards and best practices Maintain detailed documentation for all data schemas, workflows, and procedures Conduct regular reviews of data quality and implement enhancements as needed Stay informed with industry best practices and advances in database and data integration technologies Qualifications Bachelors degree in Computer Science, Information Technology, or related field Hands-on experience with Informatica Intelligent Cloud Services (IICS) and ETL development Certifications such as Oracle OCA/OCP or Informatica IICS certifications are a plus Knowledge of data warehousing, data modeling, and data governance best practices Continuous learning mindset and ability to adapt to evolving technology landscapes Professional Competencies Strong analytical and problem-solving skills, with attention to detail Effective communication skills for collaborating with technical and non-technical stakeholders Ability to work independently and as part of a team to meet deadlines and project goals Adaptability to rapidly changing environments and new tools or methodologies Commitment to high-quality work and process improvement Strong organizational skills for managing multiple tasks concurrently

Overall Experience : 5+ years of experience in IICS and Snowflake Proven experience in implementing ETL solutions with a focus on IICS and Snowflake. Strong hands-on development experience in IICS, including CDI, CAI, and Mass Ingestion. Proficiency in using various connectors for different source/file formats and databases. Knowledge of web services and their integration into ETL processes. Administration skills related to IICS, ensuring a smooth operational environment. Proven experience as a Snowflake Developer with a strong focus on data warehousing. Hands-on experience in designing and implementing data models within the Snowflake environment. Proficient in developing ETL processes using Snowflake features and SQL. Knowledge of security best practices and access control within Snowflake. Familiarity with data integration and data warehouse concepts. Experience with data migration to Snowflake from other platforms is a plus. Excellent problem-solving skills with the ability to analyze and resolve critical issues. Strong organizational and project management skills. Effective communication skills for customer interactions and status updates. Ability to thrive in a fast-paced, dynamic, client-facing role where delivering solid work products to exceed high expectations is a measure of success. Eager to contribute to a team-oriented environment. Strong prioritization and multi-tasking skills with a track record of meeting deadlines. Ability to be creative and analytical in a problem-solving environment. Effective verbal and written communication skills. Adaptable to new environments, people, technologies, and processes Ability to manage ambiguity and solve undefined problems.

Project Description min 50 words Informatica Power Centre 8-10+ years of experience Informatica Intelligent Cloud Services (IICS) Minimum 4+ years of experience Good hands-on experience along with IICS and Informatica on below mentioned topics, Creation of Complex Mappings/Mapplet/Workflow/Applications Exception handling Use of different reference tables Performance tuning Database – Hands on experience of writing complex SQLs using Oracle or Azure SQL(SQL Server) Unix – Basic scripting skills Scheduling tool – Ctrl-m/Autosys etc

Role- Data Engineer Experience- 8+ Years Mandatory skiils- SQL, ETL Tools, Data Modeling, IICS and Snowflake Location- Remote Job description: -Experience in Data/SQL -Experience in Data Vault Modelling and DBT -Good hold on Python -Experience in ETL Tools -Should be able to design and build data programs in SQL, ETL Tools -Good Experience with Data combination of: Solution/Design with modeling experience -Experience in Cloud (Preferably GCP) and Azure -Experience in Database migration and Cloud migration