Principal Consultant, ETL

*

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose the relentless pursuit of a world that works better for people we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.

Inviting applications for the role of Principal Consultant, ETL
In this role, you will be responsible for coding, testing, and delivering high quality deliverables, and should be willing to learn new technologies.

Responsibilities
Design stable, scalable application database/data warehouse.
Identify potential improvements to the current design/processes.
Plan and coordinate the data/process migration across databases.
Follow and promote Agile methodologies.
Participate in multiple project discussions as a senior member of the team.
Serve as a coach/mentor for junior developers.

Qualifications we seek in you
Minimum Qualifications
BE/B Tech/MCA
Excellent written and verbal communication skills

Preferred Qualifications/ Skills
Experience in handling data projects using database on prem and cloud, ETL technologies.
Solid Experience and understanding of implementing largescale Data Warehousing Programs and E2E Data integration solutions on Snowflake Cloud Informatica Power center integrated with Multiple relational Databases like Teradata, DB2, SQL Server.
Hands-on experience working with various Teradata Utilities and tools, including Bteq, Fastload, Multiload, Procedures, and Macro s. Also, should be proficient in performance turning.
Hands-on experience in building ETL applications using Informatica PowerCenter in an enterprise data warehouse environment.
Strong SQL and database programming skills including creating views, stored procedures, triggers, implementing referential integrity, as well as designing and coding for performance.
Competency with Unix/Linux programming (Shell and/or Python).
Good working knowledge in Python will be an added advantage.
Understanding of requirements of large enterprise applications (security, entitlements, etc.)
Exposure to DevOps processes and tools (e.g., Jenkins, TeamCity, etc.).
Experience on container-based deployments using Docker, Working with Docker Images etc..
Experience with working in an Agile squad/chapter setup and exposure to JIRA or other ALM tools to create a productive, high quality development environment.
Good communication and leadership skills.
Promote Development Standards, Best Practices, Solution Accelerators and Re-usable components for design and delivery assurance.
Organization, discipline, detail-orientation, self-motivation, and focused on delivery.
Prior experience in the Financial Industry.
Experience in building applications using Teardata Informatca.
Shell Scripting knowledge.
Understanding of real-time streaming and microservices architecture.
Hadoop eco system (e.g., Hive, Pyspark) knowledge is an added advantage.

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.
Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit, paying to apply, or purchasing equipment or training.