Consultant – Informatica And Sql Developer

Job details

---

Job description

---

With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. Now, we’re calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us. Are you the one we are looking for? Inviting applications for the role of Informatica 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. Job Principal Consultant Primary Location India-Hyderabad Other Locations India-Bangalore, India-Pune Education Level Bachelor's / Graduation / Equivalent Job Posting Sep 2, 2021, 7:17:43 PM Unposting Date Nov 1, 2021, 11:59:00 PM Master Skills List Corporate Job Category Full Time