Largeton Group ยท 3 days ago
Data Consultant- Informatica Power centre
Dallas, TX
Full-time
Onsite
Mid Level
3+ years expLargeton Group is seeking a Data Consultant specializing in Informatica PowerCenter. The role involves designing and implementing ETL processes, integrating data from various sources, and collaborating with team members to ensure successful project delivery.
ConsultingInformation TechnologyTraining
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
Required
Bachelor's degree in computer science, Information Systems, Engineering, or a related field
3+ 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
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
Largeton Group
At Largeton Group, we're passionate about empowering businesses to reach new heights through innovative staffing solutions and cutting-edge technology.
51-200 employees
H1B Sponsorship
Largeton Group has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (10)
2023 (8)
2022 (6)
2021 (7)
2020 (11)
Funding
Current Stage
Growth StageLeadership Team
Ashutosh Tripathi
Managing Partner
Saurabh Prakash
Client Partnership Manager.
Company data provided by crunchbase