Scalence L.L.C. · 3 weeks ago
Informatica IDMC Developer
Plano, TX
Full-time
Onsite
Mid LevelScalence L.L.C. 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 to implement effective data strategies.
Information Technology & Services
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
Scalence L.L.C.
In today’s dynamic and competitive market, success hinges on mastering three key areas: Data Intelligence, Business Resilience, and Digital Experience.
501-1000 employees
Funding
Current Stage
Late StageCompany data provided by crunchbase