Overview
On Site
$40+
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 18 Month(s)
100% Travel
Able to Provide Sponsorship
Skills
etl
Agile
Analytical Skill
Cloud Computing
Data Modeling
SQL
Oracle
PL/SQL
Microsoft SQL Server
Unix
Linux
Informatica PowerCenter
Database Administration
Data Migration
Data Extraction
Database
Data Warehouse
Data Quality
Job Details
Job Title: Informatica Developer Oracle & SQL Server Migration
Location: Dallas, onsite
Experience Level: Mid to Senior Level
Job Summary:
We are seeking a skilled Informatica Developer with strong expertise in Oracle database development and data migration from SQL Server to Oracle. The ideal candidate will be responsible for designing, developing, and implementing ETL solutions using Informatica PowerCenter, ensuring efficient and accurate data migration, transformation, and integration across systems.
Key Responsibilities:
- Design and develop ETL processes using Informatica PowerCenter for data extraction, transformation, and loading.
- Lead and execute data migration projects from SQL Server to Oracle databases.
- Collaborate with data architects, business analysts, and other stakeholders to gather requirements and translate them into technical specifications.
- Optimize ETL jobs for performance, reliability, and scalability.
- Develop and maintain technical documentation related to ETL processes and data mappings.
- Perform data profiling and quality checks to ensure the interity and consistency of data.
- Troubleshoot and resolve ETL and database-related issues in a timely manner.
- Work with DBA teams to manage data loads and schedule ETL workflows.
Required Qualifications:
- 5+ years of experience with Informatica PowerCenter development.
- Strong hands-on experience with Oracle PL/SQL development.
- Proven experience with data migration from SQL Server to Oracle (schemas, stored procedures, triggers, etc.).
- Solid understanding of relational databases, data modeling concepts, and data warehousing best practices.
- Experience with performance tuning of SQL queries and ETL jobs.
- Familiarity with version control systems and CI/CD processes.
- Strong problem-solving and analytical skills.
- Excellent communication and documentation skills.
Preferred Qualifications:
- Experience with Informatica Cloud / IICS.
- Exposure to data governance and data quality tools.
- Familiarity with Agile methodologies and working in a cross-functional team environment.
- Experience with Unix/Linux scripting.
Education:
Bachelor's degree in computer science, Information Systems, or a related field. Equivalent work experience may be considered.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.