Direct message the job poster from LTIMindtreeLTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 750 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTIMindtree — a Larsen & Toubro Group company — combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit www.ltimindtree.com.LTI Mindtree’s data testing engineering solutions help to implement end-to-end testing services for enterprise-level data transformations, which enables our customers to achieve better decision-making processes and provide a faster time-to-market. We assure data transformations by conducting extensive and expertise testing across the data platform covering EDW/ETL, data migrations, data, business rules transformations, and data visualization with advanced analytics testing solutions on cloud platforms.We are seeking highly skilled and talented ETL Developers to drive data migration initiatives and deliver robust, efficient solutions. You will be performing data migration activities using ETL/R tools, participate in multiple workshops to understand data structures, and analyze new system data requirements.Positional Overview -Work closely with our customers' Data, Business, and Technology teams to design, implement, test, refine, and support integration workflows and mappings using IICS/IDMC. This includes, but is not limited to, the use of mapplets, rule specifications, joins, task flows, and parameters within Data Quality, and ETL/R frameworks.Understand source and target applications and how the migration will fit into the new system and identify challenges of the program.Develop a deep understanding of business products, their processes, and their data sources.Document all mappings, mapplets, and rules in detail.Build reusable Informatica assets, transformations, and data flows.Analyze source systems for Data Quality issues across different data quality dimensions, report and communicate issues, and recommend remediation options to data owners.Analyze target systems' data requirements to inform source to target mapping requirements.Document source to target data mapping requirements.Implement and educate Informatica best practices to other developers.Collaborate with data architects and analysts to understand data requirements and objectives.Ensure data accuracy, integrity, and security in all data integration activities.Perform performance tuning and optimization of ETL/R processes.Write SQL queries and scripts for data transformation and validation.Develop shell scripts for automation and orchestration.Document data integration processes and workflows.What you need?Experience in large data migration programs - including archive and purge programs.Excellent written and verbal communication skills are essential, as you will work closely with the business to understand their needs and communicate actionable insights and results effectively.Ability to work and support existing framework environments.Excellent problem-solving and troubleshooting skills.Ability to work collaboratively, and independently, with various teams in a dynamic development environment and determine solutions that meet business, technology, and data requirements.2+ years of experience with ETL/R Tools like Informatica cloud, IICS & Informatica PowerCenter.Strong understanding of ETL/R concepts and methodologies.Experience with performance tuning and optimization of ETL/R processes.Proficient with tools like Excel, Outlook, Teams, Confluence, BitBucket/GIT, SharePoint.Experience with UNIX environments, SSH file transfer, basic scripting and navigation commands.Preferably with previous experience in retail and business banking product data, and data models.Proficient in SQL for data manipulation and validation.Strong SQL Skills and performance tuning capabilities.Strong functional understanding of RDBMS DWH-BI conceptual knowledge.Experience using, configuring, and scheduling ControlM jobs.LTI Mindtree Minds Enjoy:Work-Life Balance: Enjoy a flexible schedule that allows you to balance work with personal life, reducing stress and improving overall well-being.Innovative Environment: Thrive in a creative and dynamic workspace that encourages experimentation and new ideas, keeping work engaging and exciting.Collaborative Culture: Be part of a supportive team where open communication, idea-sharing, and collaboration are at the forefront of the company’s success.Opportunities for Growth: A fun and flexible company often provides ample learning and career advancement opportunities, helping you stay ahead in the fast-evolving tech industry.LTIMindtree is proud to be an equal opportunity employer. We are committed to equal employment opportunity regardless of race, ethnicity, nationality, gender, gender-identity, gender expression, language, age, sexual orientation, religion, marital status, veteran status, socio-economic status, disability, or any other characteristic protected by applicable law.LTI Mindtree minds thrive on innovation, constantly driving the digital future forward with bold ideas and cutting-edge solutions!Seniority levelMid-Senior levelEmployment typeFull-timeJob functionEngineering and Information TechnologyIndustriesIT Services and IT Consulting
#J-18808-Ljbffr