Talend Developer - R01543230
Job Summary
Job Description
Brillio is looking for a Talend Developer to join our team. You will be responsible for designing and developing Business Intelligence solutions in Data Warehousing using ETL Tools. You will also be responsible for extracting data from multiple operational sources and implementing SCDs (Type 1/Type 2/ Type 3) using Talend. The ideal candidate will have experience working with Talend open source, Talend Enterprise and Talend cloud. They will also have experience working with Agile methodology and experienced in creating user stories in JIRA, participated in daily standups and sprint retrospective and sprint planning. You will also be responsible for creating Generic schemas and creating Context Groups and Variables to run jobs against different environments like Dev, Test and Prod. In addition to the above, you will be responsible for creating AMC tables and customized logging tables for Error Handling and Logging of Talend Jobs. You will also be responsible for working with multiple databases like Oracle, MongoDB, SQL server. You will also be responsible for creating and implementing execution plans in TAC for scheduling jobs. You will also be responsible for creating and implementing Stored Procedures using Talend components like tMysqlSP. You will be responsible for writing complex queries using JOINS, Subqueries, Correlated Subqueries, PL/SQL procedures, functions, and triggers. You will also be responsible for creating Indexes, Partitions & Materialized views to improve query performance. You will also be responsible for leading a team and mentoring with technical solutions.
Must have:
- Bachelor’s degree in computer science / information technology or its equivalent discipline
- Exposure to healthcare domain (Medicaid, Medicare, marketplace)
- Strong experience in designing and developing Business Intelligence solutions in Data Warehousing using ETL Tools
- Good understanding of Data Migration process from Teradata to MongoDB using Talend Realtime Big Data 7.3.1
- Hands-on experience with complex mappings in Talend 7.1.1 using tMap, tJoin, tReplicate, tParallelize, tJava, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.
- Experience in working with Talend open source, Talend Enterprise and Talend cloud
- Extracted data from multiple operational sources and implemented SCDs (Type 1/Type 2/ Type 3) using Talend
- Experience in working with Agile methodology and experienced in creating user stories in JIRA, participated in daily standups and sprint retrospective and sprint planning
- Involved in extracting user's data from various data sources into Distributed File Systems
- Experienced in creating Generic schemas and creating Context Groups and Variables to run jobs against different environments like Dev, Test and Prod.
- Extensively worked on Talend Bulk components like tMySqlBulkExec, tMysqlOutputBulk, tOracleBulkExec, tOracleOutputBulkExec for multiple data bases
- Worked on creating AMC tables and customized logging tables for Error Handling and Logging of Talend Jobs
- Experience in Working with multiple databases like Oracle, MongoDB, SQL server
- Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data profiling and other database related activities
- Experience in Data warehouse design using Star and Snowflake dimensional models
- Experienced in creating and implementing execution plans in TAC for scheduling jobs also experienced in working with other scheduling tools like Autosys
- Extensive work on creating and implementing Stored Procedures using Talend components like tMysqlSP
- Well versed in writing complex queries using JOINS, Subqueries, Correlated Subqueries, PL/SQL procedures, functions, and triggers
- Experience in creating Indexes, Partitions & Materialized views to improve query performance
- Experience in Leading a team and mentoring with technical solutions
Good to have:
- Understanding of DataStage Jobs and need to build Talend Jobs accordingly
- Knowledge on OOPS programming (e.g., Java) – Existing teams are writing Talend jobs using Java.
- Experience on Test data management project, at the least 1 project on TDM – understanding the data requirements from teams (Dev, Test) and designing a Golden set of Records.
- Experience in testing Front-End applications.
- Experienced in ETL migration projects converting the Code from one ETL tool to another involving DWH migration at the same point.
- Ability to work independently- in tight schedule & be detail oriented.
- Excellent communication & interpersonal skills.
- Experiences and knowledge in Tools: Jira/Confluence.
- Willingness to flex daily work schedule to allow for time-zone differences for global team communications
10 skills required
Job Details
About Brillio:
Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.
Talend Developer
Location: Remote
Job Description
• A Bachelor’s degree in computer science / information technology or its equivalent discipline
• Exposure to healthcare domain (Medicaid, Medicare, marketplace)
• Strong experience in designing and developing Business Intelligence solutions in Data Warehousing using ETL Tools.
• Good understanding of Data Migration process from Teradata to MongoDB using Talend Realtime Big Data 7.3.1
• Hands-on experience with complex mappings in Talend 7.1.1 using tMap, tJoin, tReplicate, tParallelize, tJava, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc.
• Experience in working with Talend open source, Talend Enterprise and Talend cloud.
• Extracted data from multiple operational sources and implemented SCDs (Type 1/Type 2/ Type 3) using Talend.
• Experience in working with Agile methodology and experienced in creating user stories in JIRA, participated in daily standups and sprint retrospective and sprint planning.
• Involved in extracting user's data from various data sources into Distributed File Systems
• Experienced in creating Generic schemas and creating Context Groups and Variables to run jobs against different environments like Dev, Test and Prod.
• Extensively worked on Talend Bulk components like tMySqlBulkExec, tMysqlOutputBulk, tOracleBulkExec, tOracleOutputBulkExec for multiple data bases.
• Worked on creating AMC tables and customized logging tables for Error Handling and Logging of Talend Jobs.
• Experience in Working with multiple databases like Oracle, MongoDB, SQL server
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data profiling and other database related activities.
• Experience in Data warehouse design using Star and Snowflake dimensional models.
• Experienced in creating and implementing execution plans in TAC for scheduling jobs also experienced in working with other scheduling tools like Autosys.
• Extensive work on creating and implementing Stored Procedures using Talend components like tMysqlSP.
• Well versed in writing complex queries using JOINS, Subqueries, Correlated Subqueries, PL/SQL procedures, functions, and triggers. ¬¬¬
• Experience in creating Indexes, Partitions & Materialized views to improve query performance.
• Experience in Leading a team and mentoring with technical solutions.
Good To Have
• Understanding of DataStage Jobs and need to build Talend Jobs accordingly
• Knowledge on OOPS programming (e.g., Java) – Existing teams are writing Talend jobs using Java.
• Experience on Test data management project, at the least 1 project on TDM – understanding the data requirements from teams (Dev, Test) and designing a Golden set of Records.
• Experience in testing Front-End applications.
• Experienced in ETL migration projects converting the Code from one ETL tool to another involving DWH migration at the same point.
• Ability to work independently- in tight schedule & be detail oriented.
• Excellent communication & interpersonal skills.
• Experiences and knowledge in Tools: Jira/Confluence.
• Willingness to flex daily work schedule to allow for time-zone differences for global team communications
Know more about:
Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/
Equal Employment Opportunity Declaration
Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
· #LI-CH1
$65 - $70 an hour
Know what it’s like to work and grow at Brillio: Click here
Know what it’s like to work and grow at Brillio: Click here
Similar Jobs
New York, New York, United States (On-Site)
• 3 Months ago
Nielsen
Bengaluru, Karnataka, India (Hybrid)
• 4 Months ago
Stonewain Systems — An EquiLend Company
Chandigarh, Chandigarh, India (Hybrid)
• 5 Months ago
Buckman
Chennai, Tamil Nadu, India (On-Site)
• 4 Months ago
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
Mojang Studios
Stockholm, Stockholm County, Sweden (Hybrid)
• 6 Months ago
Nagarro
Riyadh, Riyadh Province, Saudi Arabia (On-Site)
• 3 Months ago
Hypixel Studios
Seattle, Washington, United States (Remote)
• 5 Months ago
PwC
Kolkata, West Bengal, India (On-Site)
• 4 Months ago
Get notifed when new similar jobs are uploaded
Jobs in St. Louis, Missouri, United States
The Walt Disney Company
Kissimmee, Florida, United States (On-Site)
• 3 Months ago
Atlanta, Georgia, United States (On-Site)
• 3 Months ago
Sunnyvale, California, United States (On-Site)
• 3 Months ago
ByteDance
Seattle, Washington, United States (On-Site)
• 3 Months ago
Arlington, Texas, United States (On-Site)
• 4 Months ago
Fabric
Austin, Texas, United States (Remote)
• 4 Months ago
Get notifed when new similar jobs are uploaded
Similar Category Jobs
The Walt Disney Company
San Francisco, California, United States (On-Site)
• 3 Months ago
PwC
Brno, South Moravian Region, Czechia (On-Site)
• 4 Months ago
Get notifed when new similar jobs are uploaded
