Informatica,SQL, PL/SQL, Unix, Basic Java, Python Developer
Location: Columbus, OH (Onsite) Duration: W2 / C2C Contract Experience: 10+ Years
Job Description
:
Strong knowledge on the Callidus ODI and stage hook concepts. (For loading the data by using various true comp tables).
Experience in Callidus Cloud automation for triggering batch imports/pipelines/reports generation without manual efforts.
Experience in IICS ETL, for constructing data integration processes by developing mappings, tasks, task flows, schedules, and parameter files.
Strong knowledge in Informatica, SQL, PL/SQL and Data Integration Concepts.
Perform the data quality Checks while loading the data using Data integration tools. If any validation fails in Extracts/integrate/transform operation based on requirement will send an error report to the Source team (Rejection reports).
Expertise in SQL, Java, Unix, PL/SQL and Python languages and ability work on GitGood knowledge on Callidus tool for importing the Batches by selecting different data options.
Data transformation using informatica tool.
Designing and implementing data Integration from multiple sources.
Developing scalable and re-usable frameworks for future requirements.
Writing proper ETL Scripts.
Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
Working experience in ETL testing including Master Data Management, Data Completeness Data Cataloging, Data Leverage, and Data Quality for various data feeds coming from the source
Should have experience working on complex data architecture
On-call support
Experience working in Agile/ Scrum methodology.
Strong communication and documentation skills
Informatica Powercentre, SAP Crystal Reports