Minimum 2 years of IT experience as an ETL developer using Informatica 9.x or above.
Knowledge of data warehousing concepts, star and snowflake schema methodologies.
Experience with SQL and PLSQL programming.
Strong communication skills and ability to work independently.
Requirements:
Develop and implement Informatica-based ETL solutions for data migration and integration.
Create database objects like views, materialized views, triggers, and stored procedures to support ETL processes.
Assist in impact analysis and support testing, debugging, and optimization of ETL and reporting systems.
Collaborate with team members and clients to develop specifications and resolve issues.
Job description
Greetings from Coders Brain Technology Pvt. Ltd.
Let this Diwali burn all your bad times and enter you in good times with new job
Coders Brain is a global leader in its services, digital, and business solutions that partners with its clients to simplify, strengthen, and transform their businesses. We ensure the highest levels of certainty and satisfaction through a deepset commitment to our clients, comprehensive industry expertise, and a global network of innovation and delivery centers.
Location: REMOTE
Position: Permanent with Coders Brain Technology Pvt. Ltd.
Experience: 215 Years
Notice Period: Immediate
JOB DESCRIPTION:
Requirements:
● Minimum 2 years of IT experience as in ETL developer using Informatica 9.x or above
● Any reporting tool (e.g. OBIEE, Qlikview etc.) knowledge is a plus.
● Well versed with Data warehousing Concepts and its design by using Star and Snowflake
Schema methodologies.
● Knowledge of working with Terradata
● Should be strong in writing complex SQL queries and PLSQL programs.
● Strong verbal and written communication skills. Be able to manage time efficiently and work
with little supervision
Responsibilities:
● Follow specifications provided by the Data Architect for development of Informatica based
solutions for migratingintegrating data in both OLTP and Data Warehouse environments.
● Develop views, MVs, triggers, functions, stored procedures to support the ETL process.
● Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting
systems.
● Assist with design, testing, support, and debugging of new and existing ETL and reporting
processes.
● Work with other developers, data architects, DBAs, project managers, and client business
users to develop specifications and resolve client questions around problems and