ETL IICS Developer
Innominds Software Pvt Ltd; Deloitte
Keywords
Extract Transform Load (ETL)
Unix Shell
Unix
Data Warehousing
Java (Programming Language)
Confluence
JIRA
Unit Testing
CA Workload Automation Ae
Cloud Computing
Skills
batch Scripting, Autosys, Cloud, Cloud Services, Collaboration Tools, Confluence, data cleansing, Data Warehousing, Data Warehouse system, Databases, ETL, ETL Tools, File Transfer, Informatica cloud, Informatica PowerCenter, Computer Science, JIRA, Java, Windows, router, Oracle, Oracle SQL, performance tuning, Putty, Python, RDBMS, SQL, ServiceNow, Debugger, SDLC, Text Files, unit testing, Unix, Unix Scripting, Unix shell scripting, Shell, UNIX shell scripts
Project history
08/2023
-
10/2023
Domain: Retail
Duration: 7th Aug 2023 - 20th Oct 2023
Technologies: Informatica Intelligent Cloud Services (IICS), Informatica PC 10.x, Oracle SQL, Windows/Unix
Responsibilities:
* Gathering requirements and creating technical specifications based on client functional specifications
Experience with high volume datasets from various sources like Oracle, Text Files.
* Involved in the designing of mappings by translating the business requirements.
* Document all ETL related work per company's methodology.
* Assisted with the development of complex business requirements documents, process diagrams and
flow charts.
Duration: 7th Aug 2023 - 20th Oct 2023
Technologies: Informatica Intelligent Cloud Services (IICS), Informatica PC 10.x, Oracle SQL, Windows/Unix
Responsibilities:
* Gathering requirements and creating technical specifications based on client functional specifications
Experience with high volume datasets from various sources like Oracle, Text Files.
* Involved in the designing of mappings by translating the business requirements.
* Document all ETL related work per company's methodology.
* Assisted with the development of complex business requirements documents, process diagrams and
flow charts.
08/2022
-
04/2023
ETL Developer/Support
Cognizant Technology Solutions
Project/client: Research-based biopharmaceutical (US client)
Role: ETL Developer/Support
Domain: Retail
Duration: 10th Aug 2022 - 14th Apr 2023
Technologies: Informatica PC 10.4, IICS, Oracle SQL, Unix, Unix Scripting, CDI, CAI
Responsibilities:
* Created task flows and mapping task and worked on the PROCESS to call up the task flows.
* Analyze enhancement mappings and modify those mappings.
* Used tasks like Session, Email, and Command etc.
* Used IICS (Informatica cloud Service) software to create new Cloud tasks to replicate data into Oracle.
* Involved in Preparing the High-Level Design (HLD), and Low-Level Design (LLD), Unite Testing
Documents (UTD) documents for ETL Informatica process.
* Automated UNIX shell scripts to handle exceptions to trigger alert email to support & Business team.
Role: ETL Developer/Support
Domain: Retail
Duration: 10th Aug 2022 - 14th Apr 2023
Technologies: Informatica PC 10.4, IICS, Oracle SQL, Unix, Unix Scripting, CDI, CAI
Responsibilities:
* Created task flows and mapping task and worked on the PROCESS to call up the task flows.
* Analyze enhancement mappings and modify those mappings.
* Used tasks like Session, Email, and Command etc.
* Used IICS (Informatica cloud Service) software to create new Cloud tasks to replicate data into Oracle.
* Involved in Preparing the High-Level Design (HLD), and Low-Level Design (LLD), Unite Testing
Documents (UTD) documents for ETL Informatica process.
* Automated UNIX shell scripts to handle exceptions to trigger alert email to support & Business team.
07/2018
-
08/2022
ETL Developer/Support
Accenture Services Pvt Ltd
Project/client: Jewellery Store Retailer (US client)
Role: ETL Developer/Support
Domain: Retail
Duration: 2th Sep 2018 - 5th Aug 2022
Technologies: Informatica PC 10.4, PC 10.2, IICS, Oracle SQL, SQL developer, Unix, Unix Shell Scripting,
Autosys, MFT (Managed File Transfer)
Responsibilities:
* Analyzing and understood project functional requirements from business and technical perspective.
* Worked with Session Logs, Informatica Debugger, and Performance Logs for error handling the
workflows and session failures.
* Actively involved in Data Warehouse system design discussions.
* Designed the customer order and purchase order flow based on fulfillment flow.
* Involved in the designing of mappings by translating the business requirements.
* Involved in system end to end testing as part of the SDLC process and done performance tuning at the
mapping level, session level, source level, and the target level.
* Optimized the mappings by changing the logic to reduce run time.
* Created test cases for unit testing and functional testing.
* Utilized Autosys to design, develop, and maintain jobs for daily/weekly scheduled loads.
* Used advanced transformations like Joiner, Router, Aggregator, Normalizer, Update Strategy, and
Sequence Generator for data cleansing.
* Parameterized the connections in the session & workflows and used scripts for pre and post session
tasks.
Role: ETL Developer/Support
Domain: Retail
Duration: 2th Sep 2018 - 5th Aug 2022
Technologies: Informatica PC 10.4, PC 10.2, IICS, Oracle SQL, SQL developer, Unix, Unix Shell Scripting,
Autosys, MFT (Managed File Transfer)
Responsibilities:
* Analyzing and understood project functional requirements from business and technical perspective.
* Worked with Session Logs, Informatica Debugger, and Performance Logs for error handling the
workflows and session failures.
* Actively involved in Data Warehouse system design discussions.
* Designed the customer order and purchase order flow based on fulfillment flow.
* Involved in the designing of mappings by translating the business requirements.
* Involved in system end to end testing as part of the SDLC process and done performance tuning at the
mapping level, session level, source level, and the target level.
* Optimized the mappings by changing the logic to reduce run time.
* Created test cases for unit testing and functional testing.
* Utilized Autosys to design, develop, and maintain jobs for daily/weekly scheduled loads.
* Used advanced transformations like Joiner, Router, Aggregator, Normalizer, Update Strategy, and
Sequence Generator for data cleansing.
* Parameterized the connections in the session & workflows and used scripts for pre and post session
tasks.
Local Availability
Only available for remote work
