Informatica ETL/Data Engineer


ArnAmy, Inc.
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- ELT
- Communication
- Cost-benefit Analysis
- Data Engineering
- Data Integration
- Change Management
- Cloud Computing
- Data Flow
- BMC Control-M
- Business Objects
- CA Workload Automation AE
- Universe Designer
- Software Development Methodology
- Scheduling
- Snow Flake Schema
- Performance Tuning
- Production Support
- Relational Databases
- Mainframe
- Mapping
- Oracle
- Orchestration
- Informatica
- Informatica PowerCenter
- Job Scheduling
- Exceed
- Extract, Transform, Load
- Flat File
- Forms
- Analytical Skill
- Data Loading
- Data Quality
- Database
- PL/SQL
- Stored Procedures
- Workflow
Summary
Informatica ETL/Data Engineer
Introduction:
We are seeking an experienced Informatica ETL/Data Engineer to join our team. The ideal candidate will have 8+ years of experience in designing, developing, and supporting enterprise data integration solutions. This role will involve working with Informatica PowerCenter, Oracle SQL/PLSQL, ETL workflows, data ingestion from diverse source systems, and providing production support.
Responsibilities:
- Design, develop, and maintain ETL workflows using Informatica PowerCenter
- Ingest data from multiple heterogeneous source systems into Oracle databases
- Work with Snowflake for data loading, schema design, and query performance optimization
- Collaborate with business and technical stakeholders to gather data requirements and perform source-to-target mapping
- Troubleshoot and resolve data quality issues, job failures, and performance bottlenecks in production ETL pipelines
- Utilize job scheduling/orchestration tools to support batch data loads
Requirements:
| Years | Required/Preferred | Experience |
|---|---|---|
| 8 | Required | Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment |
| 8 | Required | Hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter |
| 8 | Required | Experience ingesting data from multiple heterogeneous source systems into Oracle databases |
| 8 | Required | Strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning |
| 8 | Required | Experience with Snowflake, Informatica Power center, and Informatica Cloud Data Integration |
| 8 | Required | Experience with data flow design, troubleshooting data quality issues, and job failures |
| 8 | Required | Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) |
| 3 | Preferred | Experience with SAP Business Objects Universe design and/or maintenance |
| 3 | Preferred | Experience working in a state government or large enterprise IT environment |
- Dice Id: 10376147
- Position Id: A202609010
- Posted 1 day ago
Company Info
ArnAmy, Inc. is an Information Technology consulting and Software Development firm headquartered in Tallahassee, FL. We are IT professionals, driven by passion rather than revenue goals. We are the result of a sincere desire to provide exceptional service in the Information Technology (IT) industry. At ArnAmy, we understand that your business dictates your technology needs, not vice versa. With our proven track record, we have demonstrated our ability to create customer centric IT solutions. We are your go-to vendor partner for expert IT consultation.
We are a full service IT company. Our formidable reputation is built on the caliber of our highly qualified people who thrive on meeting challenges. Our service offerings cover the whole gamut of modern IT services:
-Application Lifecycle Management (ALM)
-Application Performance Engineering
-Strategic IT Consulting
Mission Statement:
At ArnAmy, Inc. we are on a mission to provide Efficient, Effective, and Economic solutions while creating a Win-Win-Win situation for our Customers, Consultants, and Company
The relentless pursuit of excellence in all that we do, leaves no room for mediocrity in ArnAmy.
Vision Statement:
To be viewed as a respected IT consulting and software engineering firm, providing high quality design and development services to our clients with honesty, integrity, and passion.
Core Values
Team ArnAmy is passionate about delivering dependable, scalable, and maintainable solutions to enhance our customer's business growth and development. We are guided by these principles in carrying out our duties:
Honesty
Honesty is indeed the best principle! You will experience complete transparency in all our dealings.
Integrity
We serve as trusted collaborators to guide you with customized solutions, pointing you always in the right direction.
Passion
We are completely committed and passionate about our clients. Our ability to create a long term meaningful relationship with our clients is testimony to this fact.
Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs