Alpha Consulting Corp. · 3 weeks ago
Informatica IDMC Developer
Plano, TX
Full-time
Onsite
Mid LevelAlpha Consulting Corp. is seeking a talented and experienced professional to design, develop, and maintain data integration solutions using Informatica Intelligent Data Management Cloud. The role involves building robust data integration workflows and collaborating with DBAs and Data Architects for effective data management.
ConsultingPharmaceuticalStaffing Agency
Responsibilities
Design and build integrations supporting standard data warehousing objects
Perform source system analysis as required
Collaborate with DBAs and Data Architects to plan and implement appropriate data partitioning strategy
Implement versioning of the ETL repository and supporting code as necessary
Develop stored procedures, database triggers, and SQL queries where needed
Implement best practices and tune SQL/queries for optimization
Load and transform data from various external sources to Relational databases using Informatica
Qualification
Required
Experience in building and maintaining data integration workflows using Informatica IDMC services (Cloud Data Integration, Cloud Application Integration, Data Quality)
Proven experience in developing mappings, tasks, and pipelines for ETL/ELT processes
Hands-on experience with Informatica PowerCenter to IDMC migration
Familiarity with standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.)
Strong SQL/PLSQL skills and experience with Oracle databases (11g/12c/19c)
Preferred
Experience with complex transformations such as XML, XML parser, Java, and HTTP transformation
Familiarity with Autosys for job scheduling
Experience working with Informatica Data Quality tools (Analyst and Developer)
Benefits
Inclusive and diverse workplace culture.
Opportunities for professional growth and development.
Comprehensive benefits package.
Company
Alpha Consulting Corp.
Alpha Consulting Corp. has been exceeding expectations in the IT, pharmaceutical, and clinical staffing business since 1994.
Founded in 1994
201-500 employees
H1B Sponsorship
Alpha Consulting Corp. 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 (2)
2024 (4)
2023 (3)
2021 (4)
2020 (6)
Funding
Current Stage
Growth StageCompany data provided by crunchbase