Informatica Consultant jobs in United States
info-icon
This job has closed.
company-logo

Apolis ยท 1 day ago

Informatica Consultant

positionDallas, TX
timeFull-time
remoteOnsite
senioritySenior Level
money$50/hr - $55/hr
date5+ years exp

Apolis is a company seeking an Informatica Consultant to join their team in Dallas, TX. The role involves designing and implementing ETL processes using Informatica PowerCenter, integrating data from various sources, and optimizing performance of ETL jobs.

ConsultingEnterprise ApplicationsEnterprise Resource Planning (ERP)Information TechnologyIT InfrastructureIT ManagementMobileSoftwareWeb Hosting
check
Growth OpportunitiesbadNo H1Bnote

Responsibilities

Architect, develop, and implement ETL processes and mappings using Informatica PowerCenter
Collaborate with business analysts and data architects to understand requirements and translate them into technical designs
Integrate data from multiple on-premise and cloud sources (e.g., databases, flat files, APIs) while ensuring data quality, integrity, and consistency
Create reusable components and frameworks to streamline ETL development and support scaling
Develop and execute unit, integration, and system test cases for ETL processes
Optimize performance of ETL jobs, troubleshoot failures, and resolve data-related issues efficiently
Produce thorough technical documentation for code, data flows, and process architecture
Maintain existing ETL jobs, support data migration and ongoing enhancement activities
Work closely with database administrators, QA testers, and business partners for successful project delivery
Participate in code reviews and provide feedback to improve code quality and consistency

Qualification

Informatica PowerCenterSQLETL performance tuningData warehousing conceptsCloud migrationInformatica certificationUnix/Linux scriptingProblem-solvingTeam collaborationCommunication skills

Required

5+ years of hands-on experience with Informatica PowerCenter (or Informatica Intelligent Cloud Services)
Strong expertise in SQL and relational databases (e.g., Oracle, SQL Server, MySQL)
Experience with performance tuning of ETL processes and jobs
Familiarity with data warehousing concepts, dimensional modeling, and data governance best practices
Understanding of scheduling/orchestration tools (e.g., Control-M, Autosys) and basic knowledge of Unix/Linux scripting
Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field
Excellent problem-solving and analytical abilities
Comfortable working independently and in team environments
Strong written and verbal communication skills

Preferred

Experience with cloud migration or integration (e.g., AWS, Azure, GCP)
Exposure to big data technologies (Hadoop, Spark) or other ETL tools
Informatica certification(s) or relevant training
Experience in Agile/Scrum environments

Company

Apolis

twittertwittertwitter
Glassdoor4.2
company-logo
Apolis is a IT consultancy that offers provides ERP solutions, hosting, assessment, web and mobile, IT staffing and IT workforce solutions.
dateFounded in 1996
location
El Segundo, California, USA
people-size501-1000 employees
web-link
https://apolisrises.com/

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Amar Shokeen
President/ CEO
linkedin
leader-logo
Rita Shokeen
COO
linkedin
Company data provided by crunchbase