Data Integration Lead

Skills & Experience 

The candidate would be a self-starter and capable of working independently to high standards of quality.    

·         5+ years of relevant experience in Informatica and 3 years’ experience in Oracle or any relational databases. 

·         Design, test, and implement data mapping and workflows to extract, transform and load data into the target environments (batch files, databases) 

·         Expert SQL query skill in Oracle and SQL Server for any analysis and high-volume relational databases. 

·         Ability to handle large datasets and different data types (XML, JSON, csv). 

·         Analyze new data sources and integration of data into readily available formats while maintaining existing structures and govern their use according to business requirements. 

·         Cross-platform development expertise, including consuming APIs. 

·         UNIX shell scripting experience 

·         Create new mappings, transition of PL/SQL ETLs to new mappings, or modification of existing mappings. 

·         Create or Maintain Technical design documents and develop test plans for ETL unit testing and integration testing. 

·         Analyze existing mappings and batch jobs. 

·         Assist with troubleshooting ETL batch jobs, session failure, tunning mappings and more across environments. 

·         Provide technical guidance and business process expertise on special projects or system issues. 

·         Transfer knowledge and transition work to the team. 

·         Manage daily technical challenges and communicate with management if there are any risks or issues. 

·         Interact with the Enterprise Architecture and Application Security teams to ensure that solutions are built in adherence with the defined enterprise standards. 

Collaborate with cross-functional teams to deliver high-quality solutions