Informatica Technical Project Manager

• Expert knowledge of Amazon Web Services (AWS) and Redshift in an enterprise environment.
• Strong experience in data mining and the development of ETL processes using SQL or tool like Informatica, Matillion, Talend, etc.
• Excellent knowledge and expertise with SQL, T-SQL, Postgress and Relational & Multi-dimensional Databases.
• Discerning appreciation of best practices in designing data lakes.
• Strong understanding of data warehousing concepts.
• Duration: 6 months

Technical project manager with 10-14 years Good Knowledge on DWH concepts Involved in creating the mappings in order to extract the data from source to target using Informatica designer.
Evaluate all functional requirements and map documents and perform troubleshoot on all development processes Documents all technical specifications and associate project deliverables.
Design all test cases to provide support to all systems and perform unit tests. Should analysis the data and develop understand the ETL specifications. Develop mappings if required Involved in building Tidal.
Involved in creating the sessions, command-tasks, workflows using the workflow designer. Good at working with transformations including complex transformations Familiar with Stored Procedures and implementing them in the ETL jobs of Informatica.
Worked on the HLD and LLD document.
Very good at UNIX and LINUX shell scripting Strong Database Experience with strong knowledge of writing complex SQL scripts as well as SQL tuning.
Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks. Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills. Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
Comprehensive technical, oral, written and communication skills Has lead 15 offshore team from on-site