Job DescriptionInformatica and SQL Developer In this role, you will be responsible for working as Informatica and responsible for running ETL projects. To support Engineer using Agile Methodology and should have an end to end understanding of business use cases, to transform them into an effective and strategic solution. Work with business people to have a real time understanding of business problem and, craft the solution which really fits into customer needs. Responsibilities Engage with Client to participate in requirement gathering, Status update on work, UAT and be the key partner in the overall engagement. Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications. Builds ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter Write complex SQL queries with performance tuning and optimization. Handle task independently and own the team Installing, upgrading, configuring Informatica PowerCenter in Linux OS Identifying in the eliminating spool spaces, skewness issues along with Understanding various indexes and using appropriately in the queries. Develop, implement and optimize stored procedures and functions using SQL Analyze existing SQL queries for performance improvements & suggest new queries Minimum qualifications BE/B Tech/MCA Proficient with crafting Informatica mappings, sessions, workflows, mapplets Worked with large data sets and proficient using of Analytical functions Experienced in running an ETL project interacting with users globally Should be able to understand requirements analysis then, build and deliver the solution Experience in developing complex ETL solution Preferred qualifications Worked on Informatica, DB Perform development role in Informatica, DB DW/BI experience with implementation of ETL solutions using Informatica and Oracle Must have experience in writing SQL in Oracle. Confident to write and understand queries We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com. Follow us on Twitter, Facebook, LinkedIn, and YouTube. Employement Category:Employement Type: Full timeIndustry: IT – Software Role Category: General / Other Software Functional Area: Not ApplicableRole/Responsibilies: Consultant – Informatica & SQL developerContact Details:Company: Genpact IndiaLocation(s): Bengaluru
Keyskills:
sql
sql server
ssis
ssrs
database administration
use cases
sql queries
customer focus
agile methodology
stored procedures
performance tuning