11/24/2023 updated
DK
100 % available
ETL Developer/Support, ETL Developer/Support
EAST SINGHBHUM, India
Only remote
Computer ScienceJava (Programming Language)Atlassian ConfluenceAtlassian JiraUnit TestingCA Workload Automation AeUnixCloud ComputingCollaborative SoftwaresDatabasesData CleansingExtract Transform Load (ETL)Data WarehousingRelational DatabasesDebuggingFile Transfer
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
Experience
Professional experience0 - 5 years
Freelancer since2023
Languages
EnglishGood
Project history
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.
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.
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.