Responsible for the ETL data integration process using TimeXTender Discovery Hub, SSIS, Informatica
Perform data object analysis by defining, analyzing, and validating data objects and relationships using TimeXTender Discovery Hub, SSIS, Informatica
Run manage and support Production Support ETL processes.
Modify and maintain ETL data integration process with the Business Intelligence and IT team.
Maintain data management standards and conventions, data dictionaries, data element naming standards, and data dictionary metadata standards
Implement data objects and integrate data shared across multiple sources and target systems.
Validates ETL by developing and executing test plans and scenarios including data design and data quality.
Works with Business Analysts to come up with a solution to implement business requirements.
Perform other duties as assigned.
Requirements:
Must have a minimum of 5years of experience with designing and developing ETL solutions using TimeXTender Discovery Hub, SSIS, Informatica
Minimum 8 years experience in ETL development using TimeXTender Discovery Hub, SSIS, Informatica
Highly knowledgeable in all aspects of enterprise OLTP and data warehouse concepts, design, implementation, deployment, and maintenance, both in theory and practice
Expertise in performance tuning and optimization of ETL processes in TimeXTender Discovery Hub, SSIS, Informatica
Proven, in-depth, enterprise-level data architecture skills (logical & physical, dimensional, and entity-relationship models)
Experience working with Mainframe as a data source/target
Must have working experience on database concepts including Oracle, MS-SQL Server etc.
Must have working experience on Window & Unix Operating System
Must have working experience on API - Mulesoft, Boomi, Zapier, Informatica Cloud
Must have working experience on Job Scheduling - Cybermation, Autosys, Control M
Must have skills like Team Player, Proactive, Problem Solving, Positive Attitude towards resolution.
Nice to have working experience on RPA - Uipath, BluePrism, Automation Anywhere
Nice to have working experience on Reporting - Qlik, Cognos, SAP BO, Tableau, MicroStrategy
Nice to have working experience on Scripting - Powershell, Batch, VB script, Shell script
Nice to have working experience on tools like Toad, SQL Developer, SQL Server Mgmt Studio, Microsoft Office suite, Putty, Winscp
Nice to have working experience on Service Now, JIRA, Remedy, Salesforce Service Cloud
Nice to have skills like ITIL concepts, Support documentation.