Job Description

By clicking the Apply button, I understand that my employment application process with Takeda will commence and that the information I provide in my application will be processed in line with Takedas and . I further attest that all information I submit in my employment application is true to the best of my knowledge.The Future Begins HereAt Takeda, we are leading digital evolution and global transformation. By building innovative solutions and future-ready capabilities, we are meeting the need of patients, our people, and the planet.Bengaluru, the city, which is Indias epicenter of Innovation, has been selected to be home to Takedas recently launched Innovation Capability Center. We invite you to join our digital transformation journey. In this role, you will have the opportunity to boost your skills and become the heart of an innovative engine that is contributing to global impact and improvement.At Takedas ICC we Unite in DiversityTakeda is committed to creating an inclusive and collaborative workplace, where individuals are recognized for their backgrounds and abilities they bring to our company. We are continuously improving our collaborators journey in Takeda, and we welcome applications from all qualified candidates. Here, you will feel welcomed, respected, and valued as an important contributor to our diverse team.OBJECTIVES:Develops, maintains, and integrates processes which extract data from standardized or varied data sources; transforms data for storing in proper formats and structures for querying and analysis; loads data into target data structures in the Enterprise Data BackboneParticipates on a project / product team working closely with business analysts and other team members to ensure that the end to end designs meet the business and data requirements; responsible for unit testing, implementation of solution, and providing KT to the run organization for maintenance and support of existing solutions.Work with the Enterprise teams / COEs and understand the standards that needs to be adopted, the patterns that need to be used to develop the ETL routines and share it with the Junior ETL DevelopersACCOUNTABILITIES:Develops processes to be applied to extracted source data to move to target state; Writes data cleansing functions to get data to proper prunes data set to include only fields needed; translates source code values to target value.Develops processes which load the transformed data into end target systems (database, file, application, etc.); may apply different techniques based on business needs including inserting new data into target; Overwrite existing data with cumulative information; Updates existing data at some frequency; Creates data validation steps in this layer to ensure loaded dataBuild repeatable automated and sustainable Extract, Transform and Load (ETL) processes leveraging Enterprise platforms in the Organization such as IISCS and Informatica BDMSolid understanding and exposure on Data warehousing concepts. Should have worked on at least 1 large Data project in the past.Standardizes free form values to codes; Derives new values through calculations on existing fields; Merges data from multiple in order to generate on consolidated source for the targetExercises independent decision making to creates processes which initiate the ETL or Batch cycle; develops processes for extracted data loading to destination databasePerforms data profiling of source data in order to identify data quality issues and anomalies, business knowledge embedded in data; natural keys, and meta data informationEnsures proper configuration management and change controls are implemented; Provides technical assistance and cross training to other team members; Creates data validation rules on source data to confirm the data has correct and/or expected values.Sorts and Aggregates records into rollup where multiple records are represented; Creates surrogate key values to use in place of multiple natural keys; Turns multiple columns into multiple rows or vice- versa (Transposing or Pivoting); Splits multi-valued column data into multiple columns; Disaggregates repeating columns into separate detail table(s); Creates lookup tables; Looks up and validates reference information as part of data validationParticipates in the ceremonies associated with the project / product development working with the BU leads , business and data analysts, and team members in order to analyze and clarify business requirements;Maintain the required Technical documents and ad-here to the processes and best practices put in place for Informatica DevelopmentCOMPETENCIES, EDUCATIONAL AND SKILLSRequired:Bachelors Degree in Computer Science or equivalent3+ years experience or relevant project / courseworkExperience with SQL, Relational Databases, or NoSQL data stores (Postgres, Oracle, Redshift, Cassandra, MongoDB, Neo4J, )Experience in ELT/ETL (Glue, Informatica, or Databricks)Experience in Data Lake or Data Warehouse, Datamart environmentsAbility to write and speak in the English languagesAbility to work in an agile and rapid changing environment with high quality deliverables.Nice to Have:Additional Languages: PythonExperience in Cloud environments, especially AWS (S3, EC2, EMR, Athena)Experience in Spark or HadoopExperience with CI/CD, DevOps (Github)WHAT TAKEDA CAN OFFER YOU:Takeda is certified as a Top Employer, not only in India, but also globally. No investment we make pays greater dividends than taking good care of our people.At Takeda, you take the lead on building and shaping your own career.Joining the ICC in Bengaluru will give you access to high-end technology, continuous training and a diverse and inclusive network of colleagues who will support your career growth.BENEFITS:It is our priority to provide competitive compensation and a benefit package that bridges your personal life with your professional career. Amongst our benefits are:Competitive Salary + Performance Annual BonusFlexible work environment, including hybrid workingComprehensive Healthcare Insurance Plans for self, spouse, and childrenGroup Term Life Insurance and Group Accident Insurance programsHealth & Wellness programs including annual health screening, weekly health sessions for employees.Employee Assistance Program5 days of leave every year for Voluntary Service in additional to Humanitarian LeavesBroad Variety of learning platformsDiversity, Equity, and Inclusion ProgramsNo Meeting DaysReimbursements - Home Internet & Mobile PhoneEmployee Referral ProgramLeaves - Paternity Leave (4 Weeks) , Maternity Leave (up to 26 weeks), Bereavement Leave (5 calendar days)LocationsIND - BengaluruWorker TypeEmployeeWorker Sub-TypeRegularTime TypeFull time

Takeda