IDMC ETL Developer

Post Date

Nov 04, 2024

Location

Columbus,
Ohio

ZIP/Postal Code

43085
US
Jan 31, 2025 Insight Global

Job Type

Contract

Category

Programmer / Developer

Req #

COL-743938

Pay Rate

$44 - $55 (hourly estimate)

Job Description

Design, develop, and implement data integration solutions using Informatica Intelligent Data Management Cloud (IDMC) and Power Center.
Ability to work with toolsets like Data Integration, Data Profiling, Data Quality, Data Governance & Catalog in IDMC.
Ability to work with Relational Databases, APIs, and other data source to pull the data using IDMC toolsets.
Collaborate with business analysts and stakeholders to understand data requirements and translate them into technical specifications.
Develop and maintain ETL/ELT processes to ensure data accuracy, integrity, and availability.
Optimize and troubleshoot data workflows and performance issues.
Implement data quality and data governance best practices.
Perform data migration and integration tasks across various platforms and environments.
Monitor and manage data pipelines, ensuring timely and accurate data delivery.
Provide technical support and guidance to junior developers and team members.
Stay updated with the latest trends and advancements in data integration and cloud technologies.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected].

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

Bachelors degree in Computer Science, Information Technology, or a related field.
2+ Years of Proven experience in Informatica IDMC (IICS) toolsets.
5+ Years of Proven experience in Informatica Power Center.
Proven experience in pulling the data from Oracle Fusion Cloud data Sources using IDMC tool sets.
Proven records of delivering data integration solutions using APIs, Databases and other data sources in IDMC.
Strong understanding of data integration, ETL/ELT processes, and data warehousing concepts.
7+ Years Proficiency in SQL and database management systems Oracle, SQL Server and so on.
Experience with cloud platforms such as OCI, AWS, and Azure
Knowledge of data quality and data governance principles.
Excellent problem-solving skills and attention to detail.
Strong communication and interpersonal skills.
Ability to work independently and as part of a team.

Nice to Have Skills & Experience

Experience with other data integration tools and technologies.
Familiarity with big data technologies such as Hadoop, Spark, or Kafka.
Experience with Agile development methodologies.
Experience with Oracle databases such as EBS and Fusion Cloud

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.