informatica developer

TAWANTECH

<div>Job Summary
We are seeking an ETL Developer to design, develop, and maintain enterprise data integration solutions supporting banking operations, reporting, analytics, and regulatory requirements.
Key Responsibilities
Develop and maintain ETL workflows using Informatica PowerCenter and/or IBM DataStage.
Extract, transform, and load data from multiple banking systems.
Support Data Warehouse and Data Lake initiatives.
Optimize ETL performance and ensure data quality.
Troubleshoot and resolve data integration issues.
Collaborate with business and data teams to define data requirements.
Support regulatory and management reporting processes. 
Requirements 
4+ years of ETL development experience.
Strong experience with Informatica PowerCenter and/or IBM DataStage.
Strong SQL and database skills.
Experience with Data Warehousing concepts.
Knowledge of data quality and data governance practices.
Experience working with Oracle, SQL Server, or other enterprise databases.
Preferred Qualifications
Banking domain experience.
Experience supporting regulatory reporting environments.
Knowledge of Data Lakes and Big Data technologies</div>

ETL Developer (Informatica / DataStage)

Valleysoft | Center of Excellence

<div>
 Valleysoft, a reputable IT services company, is seeking a skilled Data Engineer to join our dynamic team. The successful candidate will be responsible for designing, developing, and maintaining scalable data solutions to support business analytics and decision-making processes.
 
 
 Key Responsibilities:
 
 
 <ul>
 <li>
 Design, build, and optimize data pipelines and ETL processes for collecting, transforming, and storing data across multiple sources
 </li>
 <li>
 Develop and maintain data warehouses, data marts, and data lakes to enable efficient data access and analysis
 </li>
 <li>
 Collaborate with data scientists, analysts, and business stakeholders to understand data requirements and deliver relevant solutions
 </li>
 <li>
 Ensure data quality, consistency, and security throughout the data lifecycle
 </li>
 <li>
 Monitor and troubleshoot data pipeline performance and implement improvements
 </li>
 <li>
 Keep up-to-date with emerging data engineering technologies and best practices
 
 
 </li>
 </ul>
 
 Requirements
 
 
 
 <ul>
 <li>
 Build and maintain data warehouse and data marts, including ODS and internal departmental marts
 </li>
 <li>
 Gather, process, maintain, and analyze large datasets, ensuring data accuracy and quality
 </li>
 <li>
 Design, automate, and support ETL pipelines and data flows across multiple applications
 </li>
 <li>
 Create logical and physical data flow models and mapping designs for ETL processes
 </li>
 <li>
 Strong SQL skills (performance tuning, index management) and solid understanding of database structures
 </li>
 <li>
 Strong understanding of data modeling concepts
 </li>
 <li>
 Familiarity with SQL and NoSQL storage, and Big Data technologies (Hive, Impala, YARN, Kafka, etc.)
 
 
 </li>
 </ul>
 Informatica-specific requirements:
 
 
 <ul>
 <li>
 Hands-on experience with Informatica PowerCenter development (mappings, sessions, workflows)
 </li>
 <li>
 Strong knowledge of Informatica transformations (e.g., Lookup, Joiner, Aggregator, Expression, Router, Sorter) and performance tuning
 </li>
 <li>
 Experience with Informatica Developer
 </li>
 <li>
 Experience with Informatica B2B is a plus
 </li>
 <li>
 Ability to design, automate, monitor, and troubleshoot ETL jobs, including scheduling
 
 
 </li>
 </ul>
 Banking sector requirements (preferred):
 
 
 <ul>
 <li>
 Previous experience in the banking sector, preferably business banking, including working with banking datasets
 </li>
 <li>
 Strong understanding of data quality and reconciliation expectations in banking environments
 </li>
 <li>
 Experience working under regulated environments and change control practices is a strong plus
 
 
 </li>
 </ul>
 
 Benefits
 
 
 
 <ul>
 <li>
 Private Health Insurance
 </li>
 <li>
 Training &amp; Development
 </li>
 </ul>
</div>

Data Engineer (+3 Years Experience)

Confidential

<div>
 
 Overview
 
 
 
 
 
 We are seeking a Senior ETL Designer &amp; Developer to design, build, and support enterprise-scale data integration and analytics solutions across Informatica PowerCenter, Teradata EDW, and Google Cloud Platform (GCP). The role involves developing scalable ETL pipelines, enabling telecom data processing, supporting enterprise reporting (including ad-hoc analytics), and optimizing large-scale EDW environments.
 
 
 
 
 
 Key Responsibilities
 
 
 
 
 
 ETL &amp; Data Engineering
 
 <ul>
 <li>
 Design, develop, and maintain ETL/ELT workflows using Informatica PowerCenter
 </li>
 <li>
 Build scalable batch and near real-time data pipelines
 </li>
 <li>
 Develop reusable mappings, workflows, and transformation logic
 </li>
 <li>
 Automate ETL processes using Unix shell scripting
 </li>
 </ul>
 
 Data Warehouse (Teradata)
 
 <ul>
 <li>
 Work extensively with Teradata Enterprise Data Warehouse environments
 </li>
 <li>
 Strong experience with Teradata CLDM (Common Logical Data Model)
 </li>
 <li>
 Design and manage EDW layered architecture (Staging, ODS, EDW, Data Marts)
 </li>
 <li>
 Extensive expertise in Teradata performance optimization techniques including: Explain plan analysis, Partitioning strategies, Join/index optimization (PI, NUSI, etc.), Query tuning and workload management
 </li>
 <li>
 Strong Teradata SQL coding expertise for complex transformations and large datasets
 </li>
 <li>
 Design and optimize dimensional models (star/snowflake schemas)
 </li>
 </ul>
 
 Cloud Data Engineering
 
 <ul>
 <li>
 Develop solutions on Google Cloud Platform (BigQuery, Dataflow, Cloud Storage, Pub/Sub)
 </li>
 <li>
 Implement and support hybrid data architectures integrating on-prem EDW with cloud systems
 </li>
 </ul>
 
 BI, Reporting &amp; Data Virtualization
 
 <ul>
 <li>
 Support enterprise BI tools: SAP BusinessObjects, Qlik Sense, Looker
 </li>
 <li>
 Support ad-hoc reporting requirements from business users using EDW and BI layers
 </li>
 <li>
 Work with Denodo Platform for federated data access, performance optimization, and logical data modeling
 </li>
 </ul>
 
 Telecom Domain Experience
 
 <ul>
 <li>
 Strong experience in telecom OSS/BSS data environments
 </li>
 <li>
 Hands-on knowledge of: CDR/IPDR data processing; Billing, CRM, and subscriber lifecycle data; Network performance, fault, and mediation systems
 </li>
 <li>
 Understanding of telecom KPIs (ARPU, churn, usage patterns, QoS metrics)
 </li>
 <li>
 Experience handling high-volume, complex telecom datasets
 </li>
 </ul>
 
 Scripting &amp; Performance Optimization
 
 <ul>
 <li>
 Strong expertise in Unix shell scripting for automation, scheduling, and monitoring
 </li>
 <li>
 Advanced Teradata performance tuning and optimization for large-scale workloads
 </li>
 <li>
 Optimize ETL jobs, SQL queries, and EDW processes for scalability and efficiency
 </li>
 <li>
 Troubleshoot pipeline failures and ensure system reliability
 </li>
 </ul>
 
 Required Skills
 
 <ul>
 <li>
 7+ years of experience in ETL development and data warehousing
 </li>
 <li>
 Strong hands-on experience with Informatica PowerCenter
 </li>
 <li>
 Deep expertise in Teradata EDW, including CLDM and optimization techniques
 </li>
 <li>
 Strong Teradata SQL coding and performance tuning skills
 </li>
 <li>
 Experience with EDW architecture (Staging, ODS, EDW, Data Marts)
 </li>
 <li>
 Advanced SQL and data modeling (Kimball/Inmon)
 </li>
 <li>
 Experience with Google Cloud Platform data services
 </li>
 <li>
 Unix shell scripting for automation
 </li>
 <li>
 Telecom domain experience (preferred/required based on role level)
 </li>
 </ul>
 
 Preferred Skills
 
 <ul>
 <li>
 Cloud migration experience (on-prem EDW to GCP)
 </li>
 <li>
 Python or additional scripting/automation skills
 </li>
 <li>
 CI/CD pipelines for data engineering workflows
 </li>
 <li>
 Experience with BI semantic layers and enterprise reporting frameworks
 </li>
 <li>
 Experience supporting ad-hoc business reporting in enterprise environments
 </li>
 </ul>
 
 Soft Skills
 
 <ul>
 <li>
 Strong communication and stakeholder management skills
 </li>
 <li>
 Analytical thinking and strong problem-solving ability
 </li>
 <li>
 Ability to work in agile, fast-paced environments
 </li>
 <li>
 Strong ownership mindset with focus on data quality and delivery
 </li>
 </ul>
</div>

Senior ETL Designer & Developer

<div><div>Responsibilities: 
<ul><li>Design, implement, and optimize data pipelines for batch and real-time data processing using Cloudera (Hadoop, Hive, Spark, Impala) and Informatica (PowerCenter, Cloud Data Integration)</li><li>Build data extraction, transformation, and loading (ETL) workflows using Informatica PowerCenter for large-scale data integration from source systems (e.g., relational databases, flat files, APIs) into Cloudera Data Lake or data warehouse environments.</li><li>Implement Spark jobs on Cloudera for distributed data processing and optimization of data workflows.</li><li>Leverage Informatica for orchestrating ETL workflows, including data extraction, cleansing, transformation, and loading into data repositories (HDFS, Hive, SQL databases, etc.).</li><li>Optimize the Informatica workflows to minimize runtime, ensure smooth data integration, and maintain high data quality.</li><li>Utilize Hadoop and Spark on Cloudera to process large datasets and implement data transformations using MapReduce, Spark SQL, and PySpark.</li><li>Leverage Impala for low-latency SQL queries on Hadoop, ensuring real-time access to processed data.</li><li>Implement partitioning, bucketing, and indexing strategies in Hive and HBase to improve query performance on large datasets.</li><li>Implement and enforce data quality rules within Informatica workflows, ensuring that all transformations meet the required standards for completeness, consistency, and accuracy.</li><li>Ensure compliance with data governance and security protocols (e.g., encryption, masking, access control) in accordance with industry best practices.</li><li>Automation and Scheduling: Automate ETL workflows using Informatica Server, integrating with Airflow, Nifi or other workflow orchestration tools for scheduling and monitoring jobs.</li><li>Utilize Cloudera Navigator for monitoring and auditing data processes within the Hadoop ecosystem.</li><li>Perform regular tuning of the ETL pipelines, data flows, and SQL queries to ensure optimal performance.
</li></ul></div><div>Qualifications: 
<ul><li>Bachelor&rsquo;s degree in Computer Science, Engineering, or related field.</li><li>6+ years of experience in the same field.</li><li>Proven experience with the Cloudera Distribution of Hadoop (CDH), including expertise in HDFS, Hive, Impala, Spark, and HBase.</li><li>Strong hands-on experience with Informatica PowerCenter (ETL), EDC, IDQ, B2B, and Axon.</li><li>Deep understanding of ETL best practices, data pipelines, and distributed computing technologies such as Spark, MapReduce, PySpark, and Hadoop ecosystem components.</li><li>Advanced SQL skills for data manipulation, aggregation, optimization, and reporting across relational and non-relational data stores (e.g., SQL Server, MySQL, PostgreSQL, Hive, Impala).</li><li>Experience in Python and SQL.</li><li>Strong background in data warehousing principles and data modeling, including dimensional modeling (star schema, snowflake schema) and OLAP/OLTP considerations.</li></ul></div></div>

Senior Big Data Engineer

Unisys

<div>
 <ul>
 <li>
 We are hiring a Data Analyst / Developer to join our team. Your main tasks will include Troubleshooting data variances and failures to identify the root cause of issues using the available documentation (STTM). Providing solutions to resolve the issue.
 </li>
 </ul>
 
 
 
 
 Role Requirements for Data Analyst Position: Provided a comprehensive overview of the data analyst role, emphasizing the need for candidates with strong data analysis skills, hands-on Informatica experience, and the ability to interact with internal stakeholders.
 
 <ul>
 <li>
 Core Skill Set: Explained that the ideal candidate should possess strong data analysis abilities, be able to read and troubleshoot Informatica code, and effectively communicate with business users to resolve issues and clarify misunderstandings.
 </li>
 <li>
 Technical and Interpersonal Balance: Highlighted the challenge of finding candidates who are both technically proficient in Informatica and comfortable engaging with stakeholders, noting that many candidates are either strong in coding but reluctant to interact with people, or vice versa.
 </li>
 <li>
 Production Support Focus: Clarified that the role is primarily focused on supporting existing production code rather than developing new functionality, with responsibilities including identifying and implementing minor code changes and troubleshooting issues as they arise.
 </li>
 <li>
 Testing Responsibilities: Stated that there is no dedicated test organization, so the candidate is expected to test their own work and understand functionality deeply enough to validate and troubleshoot solutions.
 </li>
 <li>
 Stakeholder Interaction: Confirmed that all stakeholders are internal, and the candidate will need to communicate directly with business users to understand and resolve data-related issues.
 </li>
 </ul>
 
 
 
 
 Desired Experience and Technical Environment: Detailed the technical environment (Informatica on AWS S3) and clarified expectations regarding the recency and depth of Informatica experience required for the role.
 
 <ul>
 <li>
 Development vs. Analysis Split: Specified that the role is weighted towards Analysis (approximately 65-70%) with the remaining 30-35% involving Informatica Development or Code tweaking, emphasizing the need for candidates who can navigate and modify Informatica code as needed.
 </li>
 <li>
 Cloud and AWS Experience: Explained that while the data resides on AWS S3 and the infrastructure is cloud-based, the core requirement is proficiency in Informatica, with AWS familiarity considered beneficial but not essential.
 </li>
 <li>
 Recency and Hands-On Informatica Experience: Clarified that candidates must have recent, hands-on Informatica experience, as the role requires immediate ability to read, troubleshoot, and explain Informatica code without significant ramp-up time.
 </li>
 </ul>
 
 
 
 
 Team Structure and Supervision: Clarified the reporting structure in response to questions, explaining that the candidate will work under a product owner who manages day-to-day activities.
 
 <ul>
 <li>
 Supervision and Oversight: Stated that the product owner is responsible for daily supervision and team management, while Richard's involvement is limited to administrative tasks such as signing time sheets.
 </li>
 </ul>
 
 
 
 
 Data Analyst Responsibilities:
 
 <ul>
 <li>
 Analyze complex requirements by reading STTMs and apply the knowledge to troubleshoot failures in a production environment.
 </li>
 <li>
 Propose solutions to resolve the analyzed problem/issue.
 </li>
 <li>
 Write scripts to correct data (data corrections) and coordinate with the technical team members to ensure the change is delivered to production.
 </li>
 <li>
 Verify changes and certify the data after the data correction is implemented.
 </li>
 <li>
 Articulate technology solutions, in consultations with the Systems Analyst or Tech Lead and requirements to diverse internal/external stakeholders, integrating process, business rules, and data to meet business needs.
 </li>
 <li>
 Data-driven, results-oriented with the ability to quickly analyze data and make decisions that drive performance.
 </li>
 <li>
 Understanding of Data Lineage, source to target mapping, documenting the data elements accurately is strongly needed.
 </li>
 <li>
 Conducting meetings and presentations to share ideas and findings.
 </li>
 <li>
 Documenting and communicating the results of data and business requirements.
 </li>
 <li>
 Effectively communicating your insights and plans to cross-functional team members and management.
 </li>
 <li>
 Managing competing resources and priorities.
 </li>
 <li>
 Should be able to complete task with minimum supervision.
 </li>
 </ul>
 
 
 
 
 Business / Data Analyst / Developer Requirements:
 
 <ul>
 <li>
 8+ years of Business/ Data Analysis experience.
 </li>
 <li>
 A bachelor&rsquo;s degree Is required.
 </li>
 <li>
 Must have Advanced SQL, excel skills (SQL on Oracle database preferred).
 </li>
 <li>
 Strong knowledge of Data Warehouse / Mart concepts.
 </li>
 <li>
 Experience using Toad and comparing data from various data sources.
 </li>
 <li>
 Competency in Microsoft applications including Word, and Outlook.
 </li>
 <li>
 Must have experience using JIRA, Confluence.
 </li>
 <li>
 Strong working knowledge of agile methodology.
 </li>
 <li>
 Exhibit strong written and verbal communication skills.
 </li>
 <li>
 Extremely organized with strong time-management skills.
 </li>
 <li>
 Demonstrated ability to work with multiple stakeholders on a high visibility project.
 </li>
 <li>
 Multifamily or Single-Family mortgage experience is preferred.
 </li>
 </ul>
 
 
 
 
 Top Skills:
 
 <ul>
 <li>
 Data Analysis
 </li>
 <li>
 Informatica code
 </li>
 <li>
 SQL
 </li>
 <li>
 AWS
 </li>
 <li>
 Python is nice to have
 </li>
 <li>
 Analytic skills
 </li>
 <li>
 Agile experience
 </li>
 <li>
 Problem solving ability
 </li>
 </ul>
 
 
 
 
 #LI-CGTS
 
 
 #TS-3142
 
</div>

Data Analyst

Dautom

<div>
 
 
 We are seeking an experienced Data Engineer to join our Data &amp; AI team and deliver core data platform capabilities. This hands-on role focuses on building robust Python-based data pipelines, ETL processes, and data models across a modern data lake/lakehouse environment. Strong Python and SQL skills are essential, along with a solid understanding of data lake architecture. Experience with data quality tooling (Informatica, Purview, Great Expectations, or similar) is a strong advantage.
 
 
 
 
 Key Responsibilities
 
 
 <ol>
 <li>
 Design and maintain end-to-end Python-based data pipelines for ingestion, transformation, and delivery.
 </li>
 <li>
 Build and optimise ETL/ELT workflows across Bronze, Silver, and Gold layers using Medallion architecture.
 </li>
 <li>
 Write clean, modular, production-grade Python code for data processing and automation.
 </li>
 <li>
 Support data model, schema, and storage design for analytics and reporting.
 </li>
 <li>
 Develop SQL transformations, stored procedures, and views for validation and reconciliation.
 </li>
 <li>
 Build ingestion frameworks for files, APIs, databases, and streaming sources.
 </li>
 <li>
 Implement data quality checks across completeness, validity, consistency, uniqueness, accuracy, and timeliness.
 </li>
 <li>
 Monitor pipeline health, implement alerting, and troubleshoot production issues.
 </li>
 <li>
 Contribute to CI/CD pipelines, automated testing, and version control.
 </li>
 <li>
 Produce clear documentation for pipelines, models, and runbooks.
 </li>
 </ol>
 
 
 Required Skills
 
 
 <ul>
 <li>
 Strong Python development (pandas, PySpark, etc.) and production pipeline experience.
 </li>
 <li>
 Solid SQL for complex transformations and performance tuning.
 </li>
 <li>
 Hands-on ETL/ELT design and implementation.
 </li>
 <li>
 Understanding of Medallion architecture and modern data lake/lakehouse patterns.
 </li>
 <li>
 Experience with orchestration tools.
 </li>
 <li>
 Working knowledge of cloud platforms (Azure, AWS, or GCP).
 </li>
 <li>
 Familiarity with relational and NoSQL databases.
 </li>
 <li>
 Strong debugging and problem‑solving skills.
 </li>
 </ul>
 
 
 Desirable Skills
 
 
 <ul>
 <li>
 Experience with data quality tools (Informatica IDQ, Purview, Great Expectations, custom DQ frameworks).
 </li>
 <li>
 Knowledge of data cataloguing/lineage tools (Informatica EDC, Purview).
 </li>
 <li>
 Familiarity with data governance platforms (Axon, Purview).
 </li>
 <li>
 Exposure to BI tools such as Power BI.
 </li>
 </ul>
 
 
 
</div>

Data Engineer

<div>
 
 Introduction
 
 
 
 A career in IBM Consulting is built on long-term client relationships and close collaboration worldwide. You&rsquo;ll work with leading companies across industries, helping them shape their hybrid cloud and AI journeys. With support from our strategic partners, robust IBM technology, and Red Hat, you&rsquo;ll have the tools to drive meaningful change and accelerate client impact. At IBM Consulting, curiosity fuels success. You&rsquo;ll be encouraged to challenge the norm, explore new ideas, and create innovative solutions that deliver real results. Our culture of growth and empathy focuses on your long-term career development while valuing your unique skills and experiences.
 
 
 
 Your Role And Responsibilities
 
 
 
 As a seasoned Data Engineer specializing in Data Integration, you will design and build solutions to transfer data from operational and external environments to the business intelligence environment. Your expertise will ensure the seamless flow of data throughout the business intelligence solution's lifecycle. Your primary responsibilities will include:
 
 
 <ul>
 <li>
 Design Data Integration Solutions: Create and implement Extract, Transform, and Load (ETL) processes to facilitate data transfer between environments, utilizing tools such as Informatica, Ab Initio software, and DataStage.
 </li>
 <li>
 Develop ETL Processes: Build and maintain efficient ETL processes to ensure accurate and timely data flow, adhering to best practices and industry standards.
 </li>
 <li>
 Implement Data Integration Tools: Utilize IBM's WebSphere Data Integration Suite to integrate data from various sources, ensuring data consistency and integrity.
 </li>
 <li>
 Ensure Seamless Data Flow: Monitor and troubleshoot data integration issues, collaborating with stakeholders to resolve problems and optimize data flow.
 </li>
 <li>
 Optimize Data Integration Solutions: Continuously evaluate and improve data integration solutions, identifying opportunities for process improvements and efficiency gains.
 
 
 </li>
 </ul>
 
 Required Technical And Professional Expertise
 
 
 
 <ul>
 <li>
 Data Integration Solution Design: Experience with designing and building solutions to transfer data from operational and external environments to the business intelligence environment, utilizing tools such as Informatica, Ab Initio software, and DataStage.
 </li>
 <li>
 ETL Process Development: Experience in creating and implementing Extract, Transform, and Load (ETL) processes to facilitate data transfer between environments, adhering to best practices and industry standards.
 </li>
 <li>
 Data Integration Tool Implementation: Experience with utilizing IBM's WebSphere Data Integration Suite to integrate data from various sources, ensuring data consistency and integrity.
 </li>
 <li>
 Data Flow Optimization: Experience in monitoring and troubleshooting data integration issues, collaborating with stakeholders to resolve problems and optimize data flow.
 </li>
 <li>
 Data Integration Solution Evaluation: Experience in continuously evaluating and improving data integration solutions, identifying opportunities for process improvements and efficiency gains.
 
 
 </li>
 </ul>
 
 Preferred Technical And Professional Experience
 
 
 
 <ul>
 <li>
 Data Integration Tool Expertise: Experience with utilizing IBM's WebSphere Data Integration Suite, Informatica, Ab Initio software, and DataStage to integrate data from various sources, ensuring data consistency and integrity.
 </li>
 <li>
 ETL Process Optimization: Experience in optimizing ETL processes to ensure accurate and timely data flow, adhering to best practices and industry standards.
 </li>
 <li>
 Data Flow Troubleshooting: Experience in monitoring and troubleshooting data integration issues, collaborating with stakeholders to resolve problems and optimize data flow.
 </li>
 </ul>
</div>

Senior Data Engineer - Data Integration

Search 326+ Informatica developer jobs near you this June. New roles added regularly across leading industries. Apply today.