Principal Consultant, DB ETL Developer
Principal Consultant, DB ETL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125000 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 DB ETL Developer
In this role you will be responsible for coding testing and delivering high quality deliverables and should be willing to learn new technologies.
Responsibilities
Will be responsible for design code & maintain databases and ensuring their stability reliability and performance.
Research and suggest new database products services and protocols.
Ensure all database programs meet company and performance requirements.
Collaborate with other database teams and owners of different applications.
Modify databases according to requests and perform tests.
Maintain and own database in all environments
Qualifications we seek in you!
Minimum Qualifications
BE/B Tech/MCA
Excellent written and verbal communication skills
Preferred Qualifications/ Skills
A bachelors degree in Computer Science or a related field.
Hands-on developer in Sybase DB2 ETL technologies.
Worked extensively on data integration designing and developing reusable interfaces/
Advanced experience in Sybase shell scripting Unix database design and modelling and ETL technologies Informatica
Hands-on experience with Snowflake OR Informatica with below details:-
o Demonstrate expertise in Snowflake data modelling and ELT using Snowflake SQL implementing complex stored procedures and best practices with data warehouse and ETL concepts.
o Designing implementing and testing cloud computing solutions using Snowflake technology
o Expertise in Snowflake advanced concepts like setting up resource monitors RBAC controls virtual warehouse sizing query performance tuning zero copy clone time travel and understand how to use these features.
o Creating monitoring and optimization of ETL/ELT processes (Talend Informatica) migrating solutions from on-premises to public cloud platforms.
Expert level understanding of data warehouse core database concepts and relational database design
Skilled at writing editing large complicated SQL statements
Experience in writing stored procedures optimization and performance tuning
Strong Technology acumen and a deep strategic mindset
Proven track record of delivering results
Proven analytical skills and experience making decisions based on hard and soft data
A desire and openness to learning and continuous improvement both of yourself and your team members
Exposure to SDLC tools such as: JIRA Confluence SVN TeamCity Jenkins Nolio and Crucible.
Experience on DevOps CI/CD and Agile methodology.
Good to have experience with Business Intelligence tools
Familiarity with Postgres and Python is a plus
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 respect and integrity customer focus and innovation. For more information visit . 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.
Required Experience:
Staff IC
Employment Type
Full-Time
