Informatica Consultant

Role: Informatica Consultant ( Informatica PowerCenter (or Informatica Intelligent Cloud Services) Location: Dallas, TX (5 days Onsite) Duration: 6+ MonthsOnly W2Required Skills & QualificationsTechnical Skills: 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. Education: Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field. Soft Skills: Excellent problem-solving and analytical abilities. Comfortable working independently and in team environments. Strong written and verbal communication skills. Preferred Qualifications 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. Qualification:Design and Development: 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. Data Integration: 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. Testing & Optimization: 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. Documentation & Maintenance: Produce thorough technical documentation for code, data flows, and process architecture. Maintain existing ETL jobs, support data migration and ongoing enhancement activities. Collaboration: 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.

Created: 2026-03-04