Hi
Job Title : Informatica Developer
Location : Remote
Job Type : Fulltime / Contract
Job Description:
Seeking for the position of Onsite Informatica resource with 7+ years experience in Power center, Data exchange (DX), Data transformation (DT).
Position is responsible for Development of Data Warehouse, Business intelligence applications such as
Informatica with strong business understanding knowledge of Financial and Retail Services Domains. Designing and developing automated processes to extract, transform, and load data and metadata so they can be loaded into the data warehouse using a mixture of MS SQL Server Integration Services, Python, ArcGIS, SAS, and SQL scripts
Technical Skills:
- Techie with experience in Informatica PowerCenter 10.1.1/9.5.0
- Data exchange (DX)
- Data transformation (DT)
- Excellent hands on PL/ SQL programming and SQL scripts.
- Knowledge about Data warehousing Architecture and Concepts will be a plus
- Technical hands-on expertise in Data Loading Tools like Informatica (designer, Workflow Manager, Workflow Monitor) and data bases like Oracle.
- Query analysis and optimization
- Resolving queries and ensure delivery on-time.
- Exposure to Info work..
Process Skills:
- Hands on Data exchange, Data transformation, Power Center
- Creating of sessions & workflows by using Workflow manager to load the data into the target database
- According to the business requirements applying of Source Qualifier, Filter, Joiner, Expression, Aggregation, and Updated Strategy transformations extensively.
- Involved in unit testing on the developed mappings.
- Scheduling and monitoring the jobs.
- Resolving queries and ensure delivery on-time
- Interacting with source application team for data.
- Understanding the functionality of application and providing technical suggestions.
- Working on audit validations and production support activities.
- Resolving queries and ensure delivery on-time.
- Understanding of system analysis, business analysis, and requirements development and able to utilize such information in analyzing and solving complex problems.
- Familiar with Agile processes.
- Ability to work successfully in a team environment and possess the flexibility and adaptability to changing requirements is required.
- Seven or more years of Informatica experience with at least five years Integration service experience.
- Good Communication Skill and Analytical skills
- Ability to translate needs analysis results into functional designs and to develop and learn new technical skills quickly.
- Ability to analyze technical and functional aspects of a program and troubleshoot complex issues, take corrective actions, and implement improvements.
- Presentation skills, Sprint Demo etc.
- Senior level resource who can come and drive the work,
Experience and Education Required
- Bachelor's Degree and 7 years of related Informatica experience
- Senior level resource who can come and drive the work,
- 12+ years of IT experience