• Candidate will work with global teams spread across Mumbai and New York.
• Develop new streams, enhance existing streams and work on critical data sourcing aspect of the project.
• Responsible for the design, coding, testing, tuning and maintenance of DB2 datamarts and Informatica code
• Work directly with Modelers/Architects/DBA on data modeling, logical/physical schema design, SQL query tuning; and the application of data-related business rules while assisting in troubleshooting, debugging, and issue resolution
• Communicate effectively with end users, peers, and management regarding assignments, and must have a can-do attitude and a desire to provide solutions
• Provide support for the resolution of all reporting issues escalated by the Support Operations Team post-implementation.
Industry: IT-Software / Software Services
Experience: 3 – 8 Years
Interested candidates can walkin on 4th June 2016 from 10 am with updated resume
* 2-5 years of development experience in Informatica
* Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
* Experience in integration of various data sources like DB2, SQL Server, and Flat Files into the staging area
* Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing stages. Good experience with ETL tools: Informatica or SSIS/Data Stage
* Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
* Expert knowledge of DB2, SQL Stored Procedures, Triggers, and data querying optimization
* Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player
Trigent Software, a Microsoft Gold certified partner was established in 1995. We are a CMM Level 4 software Development Company headquartered in Boston (USA) with a development center in Bangalore.
Recruiter Name: Judy