Informatica Developer
Apply NowCompany: Sarian, Inc.
Location: Charlotte, NC 28269
Description:
Job Title: Sr. Informatica Developer
Location: Charlotte, NC
Duration: Full-Time
Job Description:
Job Requirements:
Looking forward to hear & work with you soon.
Location: Charlotte, NC
Duration: Full-Time
Job Description:
- This position is responsible for providing Informatica Developer, with strong hands on development of Informatica and should have the ability to lead application development, support and guidance to the other associates should they run into any process, or technical challenge.
- Extensive experience with ETL development using Informatica Power Center (Version 10 (Preferred)) design, development, application troubleshooting, workload management and performance tuning.
- Must have ability to develop complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, XML, Oracle, SQL Server and Web services.
- Expertise with complex transformations like Normalizer, XML Generator, XML parser to transform XML files.
- Expertise in developing and implementing best practices in ETL specifics to process control, exception management in a data warehouse environment.
- Build, maintain, and enhance all objects packages/functions in PL/SQL to support application process.
- Perform functions including SQL tuning, database application design, and developer support
- Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
- Write clear, concise, well organized technical documentation to maintain standards and procedures
- Understand the requirement and analyze on a technical feasibility and design.
- Coding the requirement and proper Check in / Checkout in Version control.
- Unit Test Cases Preparation and Execution
- Code Review and Checklist document preparation.
- QA, UAT and PROD Release Scripts/Package Preparation and Validation.
- Knowledge in multiple software development lifecycle phases, including design, construction, and testing
- Be a key contributor to initiatives that require technical expertise.
- Communicate with technical partners and come up with solutions.
- Collaborate with the team to coordinate delivery of software application.
- Strong problem solving, analytical and interpersonal skills.
- Experience in Autosys Scheduling tool
- Work in a fast paced environment, under minimal supervision providing technical guidance to the team members.
Job Requirements:
- 7+ years of Application Programming experience
- 7+ years - Expert knowledge in Informatica (Power Center)
- 5+ years - Expert knowledge of Oracle, Knowledge of Exadata is an advantage.
- 5+ years - Database design, Data analysis for root cause
- Experience with the development of complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, XML, Oracle, SQL Server and Web services
- Performance Tuning of SQLs and experience handling Extra Large databases
- Knowledge of Oracle Internals and be able to advice team members of best practices and recommend solutions for performance issues.
- Experience as a DBA is an advantage (Not necessary)
- Unit testing skills, Proficient in problem root cause analysis and Analytical thinking
- Experience with the development models and software development lifecycle
- Experience working in full iterative/Agile development environment
- Relational database experience and demonstrated abilities in SQL and data modeling is required
Looking forward to hear & work with you soon.