ETL Developer

About Us:

LTIMindtree 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 700+ 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.

Job Title: ETL Developer

Work Location: Tricity or Warsaw (only hybrid setup is considered (1-2 days from Office, 3-4 days Home Office)

Type of Hiring: B2B

Job Description:

Daily tasks:

• Writing SQLs which will transform data from multiple tables and schemas and compare the output to development results.
• Cooperate with developers, analysts and business to understand the proper transformation process to be able to create testing SQLs.
• Manage Test environment which include recreating database from GIT repository, putting proper scripts on UNIX server, running DataStage jobs to run migration process.
• Committing test cases changes into GIT repository and managing them in Qtest.
• Reporting bugs in JIRA and taking ownership of delivering proper solution for it. 

Description of knowledge and experience

Required:

• 3+ years of SQL / Oracle knowledge in writing queries which transform data from multiple tables and schemas
• 4+ years of Testing knowledge
• 3+ Experienced with Extract-Transform-Load (ETL) process and tools
• Experience in Agile ways of working and JIRA
• Qtest, JIRA and GIT repository
• Proactiveness and team collaboration
• Ability to work effectively in a team environment, sharing knowledge and skills and developing productive working relationships
• Fluent English

Additional:

•  Knowledge of IBM DataStage or other similar tool (e.g. Informatica),
•  Programming skillset,
•  Database. data modelling & data warehousing background,