| IICS Developer at Remote, Remote, USA |
| Email: [email protected] |
|
From: Abhishek Singh, KK Associates [email protected] Reply to: [email protected] Bachelors/Masters degree in computer science, information technology, or engineering with 10+ years of IT experience At least 5+ years of experience working with IICS Strong expertise in Data Ingestion using IICS Must have experience in building ETL code on IICS Strong expertise in SQL, Data Warehousing concepts, BI concepts, ETL concepts etc. Create IICS mappings with PL/SQL store procedures/functions to incorporate critical business functionality to load data. Used connected, unconnect lookup, static and dynamic cache to implement business logic and improve the performance. Develop procedures and functions using PL/SQL and develop critical reports. Develop PL/SQL functions/procedures/cursors/packages/database triggers to implement business logic. Work with relational databases like DB2. Detail table design and index selection in for TeraData databases using SQL. Develop mappings with XML as target and formatting the target data according to the requirement. Work with logical, physical, conceptual, star, snow flake schema data models. Extract data from flat files, DB2 and to load the data into the SalesForce database. Create and used debugger sessions to debug sessions and create breakpoints for better analysis of mappings. Work with various data sources--relational, flat file (fix width, delimitate) and XML. Involve in all phases of SDLC from requirements gathering, architecture design, development, testing, and data migration. Involve in writing PERL scripts for file transfers, file renaming and few other database scripts to be execute from UNIX. Create various active and passive transformations to support voluminous loading of data target table using Informatica PowerCenter. Provide documented operation and user procedures, when require, and perform supporting training for respective users. Involve in working with the strong AIX operating systems. Excellent communication skills Experience in Agile/DevOps Project Coordination Working with senior leadership team Regards, Abhishek Singh| KK Associates LLC. 8751 Collin McKinney Pkwy, # 1302, McKinney, TX 75070 555 Metro Place North, Suite # 100, Dublin, OH 43017 Contact :- +1 925-409-3082 Email : [email protected] |
| [email protected] View All |
| 08:40 PM 24-Oct-22 |