Informatica Developer Etl

.

Dacula, Georgia ***** 470-***-**** ************@*****.***

.

JUBEY JOSSY

SUMMARY ● 4+ years of experience in the IT industry with a strong background in Database, Data Warehousing, Business Intelligence and ETL process using Informatica Cloud, Datastage, Informatica Power Center and a bit of Pentaho.

● Data integration with SFDC, Databases/DataLakes, Amazon S3, SFTP/FTP using Informatica cloud(IICS).

● Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings, Mapping tasks, and Taskflow), and fine-tuned transformations to make them more efficient in terms of performance.

● Database experience using Oracle, SQL Server, Teradata, and MS Access.

● Experience using SQL, PL/SQL Procedures/Functions, Triggers, and Packages.

● Experience with data mapping, modeling,lineage, governance and management.

● Maintenance of History retention tables using Slowly Changing Dimensions.

● Experience in UNIX Operating System and Shell scripting.

● Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.

● Working knowledge of data warehouse techniques and practices, experience including ETL processes and dimensional data modeling (Star Schema, SnowFlake Schema, FACT & Dimension Tables).

● Experience in writing SQL queries and PL/SQL to implement business rules and validation.

● Experience using database tools such as SQL Server Management Studio, MySQL Workbench, and TOAD.

● Working knowledge of BI tools - Power BI and OBIEE.

● Effective working relationships with the team to understand support requirements, and effectively manage requirements.

● Excellent communication, and presentation, a very good team player with the ability to work independently and as part of a team.

ACCOMPLISHMENTS

Valedictorian, Master’s Degree, Class of 2017

.

.

TECHNICAL

SKILLS

Operating Systems: ios, Windows XP/Vista/7, UNIX, MS-DOS, and Linux Databases: Oracle, MySQL, MS SQL Server, Teradata, Netezza, MS Access Languages: SQL, PL/SQL, C, C++, Java, Unix Shell Script, Batch Scripts ETL Tools: Informatica Cloud(IICS), Datastage, Teradata, Pentaho, Informatica PowerCenter Other Tools: Informatica Cloud(IICS), Informatica Power Center, Datastage, SQL plus, Toad, Pentaho, Git, SPLUNK 6.2, CA Service Desk Manager (CA SDM),Postman,SoapUI WORK HISTORY ETL INFORMATICA DEVELOPER 05/2018 to 03/2022 RigStreet, Kerala, India

Works as an Interface Developer in the Business Intelligence team. Responsible for developing, testing, and deployment of ETLs in mainly Informatica Intelligent Cloud Services

(IICS).

● Designed and developed multiple ETL Integrations using Informatica Cloud

● Extracted data from multiple sources including Workday, Salesforce, Databases, flat files, file lists, and XML.

● Experience in data transformation and data loading to various target systems.

● Experience in SFTP/FTP file transfer, file copy, and file encryption/decryption in Informatica Cloud.

● Migrated ETL processes from IBM Datastage to Informatica Cloud

● Migrated ETL processes from Informatica Power Center to Informatica Cloud.

● Managed ETL migrations on various environments - Dev, Test, Prod.

● Developed APIs using Data Integration to enable a third party to trigger an ETL process.

● Developed Data Integration Processes to call third-party REST APIs to load data.

● Created swagger file using Informatica cloud.

● Developed Data Integration Processes to call Workday custom report APIs and built-in SOAP APIs and get the data.

● Developed APIs using Application Integration to process JSON/XML payloads.

● Tested the APIS using Postman and SoapUI.

● Supported existing ETL processes in Datastage and Informatica Power Center.

● Performed Unit testing by executing the SQL scripts and comparing the source with target data and resolving issues if any.

● Created and documented ETL test cases and validations.

● Develop reusable integration components and transformation.

● Modified existing mappings for enhancements of new business requirements.

● Created Pre/Post SQL, Pre/Post process commands, and batch scripts in mappings and mapping tasks.

.

.

EDUCATION Marian College, Kerala,India

Master of Science, Computer Application, 03/2017

Assumption College, Kerala,India

Bachelor of Science, Computer Applications, 03/2015 PROJECTS

Air-Freight Cargo Service System

Technologies used: Front End - PHP, Back End - SQL Server 2008 Duration: 6 Months

Description: This project involved developing a software solution for an air freight cargo service. The system enhanced the speed and efficiency of cargo operations by incorporating AJAX for faster interoperability. In addition, it provided an online cargo status reporting feature for customers, leveraging the domain knowledge of cargo airlines and ERP experience. Hospital Management Portal

Project Name: MedSys - Integrated Hospital Management Solution Technologies used: Front End - Java, Back End - Oracle Duration: 4 Months

Description: This project entailed developing an integrated hospital management portal that effectively managed patient, hospital, and doctor information. MedSys streamlined the process of retrieving data by implementing a secure login portal, which allowed patients, doctors, and hospital administrators to access relevant information based on their respective roles. AUTHORIZATION Green Card

.

Contact this candidate