Architect (ATC)

Architect (ATC)

Category:

Architect (ATC)

Location: Bangalore, Karnataka, IN

Job Category:  Technology

Qualifications:
Experience in Informatica Power Center 9.x (ETL) (Designer, Repository Manager, Workflow Manager Job Schedulers)
Must has experience in Installation, Configuration and Administration of Informatica Power Center
Strong on DW Fundamentals and various relational database design concepts
Must have experience in building complex SQL queries and Shell scripting
Strong experience in Data Migration and Data Quality initiatives
Extensive experience in Data Modeling Architecture
Hands on experience with Azure Data Factory relevant to ADF task flows, integration with web services, Security, templates, deployments and Subversion is a must
Should be able to troubleshoot API integration code and implement custom transformations
Experience in managing BI App Support Maintenance projects is an added advantage
Job responsibilities:
Troubleshoot and resolve data load issues including: bad data, file mapping, performance issues for SSIS packages and reviewing stored procedures
Document data flows, ETL processes, logic as flowcharts/ process diagrams
Error handling and Performance Improvements
Conduct and participate in design and code walkthroughs
Troubleshoot, perform improvements and upgrades to existing applications
Participate in requirement gathering sessions with stakeholders
Communicates effectively with business partners to identify needs and evaluate options
Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems

New Search