Job Title: ETL Developer

Location: Carlisle, PA

Duration: long term

Job ID: 4CI –7126

Required Qualifications:

• Design, develop, and maintain ETL processes using Informatica PowerCenter and IDMC.
• Analyze source systems and technical specifications to implement transformation logic.
• Develop and support mappings, workflows, sessions, and parameter files.
• Implement data validation, transformation rules, and data quality checks.
• Load and maintain fact and dimension tables, including surrogate keys and historical data.
• Perform unit testing, defect resolution, and production support.
• Support deployments across DEV, TEST, UAT, and PROD environments.
• Tune ETL jobs for performance (SQL optimization, partitioning, workflow tuning).
• Maintain ETL design documentation and operational runbooks.

Qualifications:

Bachelor s degree or foreign equivalent in Computer Engineering, or Computer Science and Engineering or STEM related courses.

40 hours per week. M-F. Must be authorized to work in the United States. Email resumes to jobs@fourci.com or mail to Attn: HR, 4Consulting, Inc., 6850 TPC Drive Suite 208 McKinney, TX 75070.

Disclaimer

• 4 Consulting Inc. offers a comprehensive compensation and benefits package. 4Ci is an affirmative action-equal opportunity employer. 4Ci complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified candidates are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable federal, state or local laws.