Consultant - Informatica developer
- Genpact India
- 5 to 10 Yrs
- Hyderabad
- 4 years ago
- Email to a friend
- Report this job
Job Description
Informatica Developer, DE
In this role, you will be responsible for Informatica implementation for one of GENPACT customer.
You should be able to have:
- Good Knowledge / Experience on Informatica Power Center in Development and Support projects
- Proficiency in writing optimized custom SQL queries
- Experience with Informatica 10.x/SQL
- Experience on Informatica Suite
- Good expertise in Designing Informatica Mappings, Mapplets, sessions and Workflows
- Domain Knowledge in Pharma and its related Datasets is a major plus
- Debugging / Trouble shooting of Informatica Jobs
- Database (At least one RDBMS) Good SQL & PLSQL
- Good Knowledge in Migration (between versions and other tools)
- Strong Data Warehousing Concepts & Architecture
- Good Knowledge on Data warehousing Design approach
- Good Knowledge in ETL Testing Methodologies
- Very good Communication and experienced in Development / Support projects
- Demonstrated experience leading Informatica product suite, ETL and Business Intelligence products.
- Experience in code Debug, code review and other artifacts.
- Demonstrated understandings of database architecture design patterns, and complete application development lifecycle.
- Experience in Application Performance tuning
- Strong analytical, problem solving and strategic thinking skills to understand and anticipate the impact and opportunities across multiple projects.
- Ensures adherence to standards for all developed components
- Demonstrated experience ETL and Business Intelligence products from vendors such as Informatica.
- Expert in designing ETL jobs using Informatica for loading data warehouses, data marts.
- Expert in using different transformations available in Informatica and must be able to work with custom transformations.
- Ability to fine tune existing Informatica jobs.
- Thorough understanding of Data Warehousing architectures, techniques, and methodologies; including Star Schemas, Snowflake Schemas, Slowly Changing Dimensions, and Aggregation Techniques
- Must have implemented min. 2-3 projects using Informatica.
- Working knowledge in handling large data volumes (multi-TB) using Informatica.
- Having knowledge in Big Data, IICS (Informatica Cloud) will be advantageous
- Knowledge of other ETL tools like SSIS
- Strong SQL skills to perform data analysis
- Be able to provide the technical guidance and lead the offshore teams.
Responsibilities
- Define data relationship model to support data migration from source systems to target data warehousing environments.
- ETL solutions should follow database normalization standards and best
practices. - Design and develop Informatica mapping and transformation rules to support new data warehouse architecture model
- Understand Change control Management and drive changes by performing Impact Analysis
- Working with dependent teams such as DBA, Admin etc for tasks that require other team s assistance
- Identify, design, and write technical specifications and champion re-usable
software and frameworks and common objects using ETL and Business Intelligence technology. - Define database architecture development principles, standards, and best
practices. - Preparing test/quality strategies, plans for meeting the CTQs of the project
- Research current trends and emerging technologies and provide input on how they may positively or negatively impact the enterprise.
- Qualifications
Minimum qualifications
- BE/B.Tech
- Informatica & Oracle SQL Experience.
- Informatica Certified
Employement Category:
Employement Type: Full timeIndustry: IT - SoftwareRole Category: General / Other SoftwareFunctional Area: Not ApplicableRole/Responsibilies: Consultant - Informatica developerContact Details:
Company: Genpact IndiaLocation(s): Hyderabad+ View Contact
Fraud Alert to job seekers!
₹ 3.0 - 7 Lakh/Yr
Similar positions
Genpact India
Genpact (NYSE: G) is a global professional services firm focused on delivering digital transformation for our clients, putting digital and data to work to create competitive advantage. We do this by integrating lean principles, design thinking, analytics and digital technologies with our domain and ...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in