Job Seekers, Please send resumes to resumes@hireitpeople.com
Job Duties:
- Develop and maintain ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8+ to extract the data from multiple source systems that comprise databases like Oracle, SQL Server, flat files to the Staging area and then to the Data Marts.Â
- Create mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache.Â
- Perform impact analysis of the changes done to the existing mappings and SQL and provide understandable feedback.Â
- Create mappings using reusable components like worklets, mapplets using other reusable transformations.Â
- Document code.Â
- Demonstrate a strong understanding and coding ability in SQL.Â
- Work together on regular releases to push workgroups/Informatica code and SQL to production; need to be able to understand typical deployment concepts and processes (i.e. change control).Â
- Possess strong analytical and communication skills with a knack for learning and understanding business scenarios.Â
- Have the ability to work both as a team player and individually.Â
- Participate in providing the project estimates for development efforts.Â
- Demonstrate a solid work ethic with accountability and awareness to deliver on time and accurate; yet still be able to enjoy time spent on the job.Â
Education: The minimum qualification required for the performance of the above occupation duties is a bachelor’s degree or equivalent in MIS, IT, Computer Science or equivalent in a related field or a foreign equivalent is required closely related field with relevant experience.