Job Information
Takeda Pharmaceuticals ETL Developer in Bengaluru, India
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 Takeda’s Privacy Notice and Terms of Use . I further attest that all information I submit in my employment application is true to the best of my knowledge.
Job Description
The Future Begins Here
At 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 India’s epicenter of Innovation, has been selected to be home to Takeda’s 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 Takeda’s ICC we Unite in Diversity
Takeda 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.
The Opportunity
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 Backbone
Participates 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 Developers
*ACCOUNTABILITIES: *
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 data
Build repeatable automated and sustainable Extract, Transform and Load (ETL) processes leveraging Enterprise platforms in the Organization such as IISCS and Informatica BDM
Solid understanding and exposure on Datawarehousing 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 target
Exercises independent decision making to creates processes which initiate the ETL or Batch cycle; develops processes for extracted data loading to destination database
Performs data profiling of source data in order toidentify data quality issues and anomalies, business knowledge embedded in data; natural keys, and meta data information
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 validation
Participates 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 Development
COMPETENCIES, EDUCATIONAL AND SKILLS
Required:
Bachelor’s Degree in Computer Science or equivalent
3+ years’ experience or relevant project / coursework
Experience 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 environments
Ability to write and speak in the English languages
Ability to work in an agile and rapid changing environment with high quality deliverables.
Nice to Have:
Additional Languages: Python
Experience in Cloud environments, especially AWS (S3, EC2, EMR, Athena)
Experience in Spark or Hadoop
Experience 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 Bonus
Flexible work environment, including hybrid working
Comprehensive Healthcare Insurance Plans for self, spouse, and children
Group Term Life Insurance and Group Accident Insurance programs
Health & Wellness programs including annual health screening, weekly health sessions for employees.
Employee Assistance Program
5 days of leave every year for Voluntary Service in additional to Humanitarian Leaves
Broad Variety of learning platforms
Diversity, Equity, and Inclusion Programs
No Meeting Days
Reimbursements – Home Internet & Mobile Phone
Employee Referral Program
Leaves – Paternity Leave (4 Weeks) , Maternity Leave (up to 26 weeks), Bereavement Leave (5 calendar days)
Locations
IND - Bengaluru
Worker Type
Employee
Worker Sub-Type
Regular
Time Type
Full time