Informatica Developer
Software Specialists, Inc.
Strongsville, United States of America
12 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Strongsville, United States of America
Tech stack
COBOL
Data Validation
Data Integration
ETL
Data Transformation
IBM DB2
Relational Databases
Oracle Applications
Performance Tuning
SQL Databases
Virtual Storage Access Methods
Data Processing
Sql Optimization
Informatica Powercenter
Data Pipelines
Job description
Job Summary: We are seeking dedicated professionals to join our team in supporting large-scale data integration initiatives within a leading technology-driven environment. Our team focuses on enterprise-level ETL development and data pipeline support essential for critical business functions., * Design, develop, and maintain ETL workflows and mappings for enterprise data integration projects.
- Build and support data pipelines using Informatica PowerCenter, extracting and processing data from mainframe and other sources.
- Write and optimize SQL queries for data validation, reconciliation, and performance tuning, ensuring robust system performance.
- Create and maintain technical documentation, collaborating closely with Business Analysts, QA, and application teams to clarify data requirements and ensure data quality.
Requirements
- Hands-on experience in ETL development using Informatica PowerCenter, including design and support of enterprise-scale data pipelines.
- Proven ability to work with relational databases such as Oracle and manage data integration from mainframe sources like VSAM, flat files, COBOL copybooks, and DB2.
- Advanced SQL skills for data validation, reconciliation, and performance tuning, alongside experience implementing complex data transformations and quality checks.
- Strong background in ETL job monitoring, troubleshooting, and production support, with demonstrable experience in creating technical documentation and maintaining enterprise data systems.