- Upgrade & maintenance of ETL server/client/jobs
- Knowledge of Agile Methodology/ SAFe Practices
- Establish, maintain and enforce ETL design principles, techniques, standards, and best practices.
- Exp working with & able to demonstrate knowledge of complex Informatica transformations.
- Exp working with very large data sets in ETL projects.
- Exp working on UNIX platforms - AiX.
- Exp in ETL performance tuning /optimization;
- Exp with the Informatica command line utilities;
- Exp drafting ETL specifications;
- Exp developing complex ETL mappings;
- Exp developing & deploying SSIS packages in an Enterprise environmentAbility to understand the domain and communicate with client/business
- Strong knowledge of data analysis, data transformation, conceptual data modeling, data transformation &metadata management.
- Strong knowledge of Unix & Unix Shell scripting
- Experience with Enterprise Scheduling tools such as Control-M is a plus.
- Tools, Concepts and Methodologies of BI/DWH.
- Excellent Customer Relations forms productive relationships with customers & development teams.
- Excellent writing & communication skills.
- Excellent analytical skills.
- Review and assess existing ETL applications, to support new features, performance improvements, upgrades, and ongoing sustainment
- Support on-going ETL environment and support during maintenance or failure
- Work closely with ETL migration/ network teams and DBA’s on operational failures and triage issues.
- Good understanding of various data models, both relational and dimensional and their associated principles.
- 3-4 years’ experience in performance tuning of report under high data volumes.
Technology:
Informatica , SQL Server, Shell Scripting, Control-M Preferably Hive/Pyspark/Bigdata