Tech Analyst ETL
Budget: $8 – $15 USD
Job Title: Technical Analyst- ETL Dev
Experience : 3 to 8 Yrs
Relevant Experience:
Tech Analyst ETL - Overall experience of 3 to 5 Yrs and 3+ Yrs into Informatica Power Center and experience into IICS will be plus.
Sr.Tech Analyst ETL - Overall experience of 7+ Yrs and 4+ Yrs into Informatica Power Center and 1+ Years of experience into IICS
Notice Period: Immediate or Max 15 days
Job Location: Bangalore
Shift Time: 1 PM to 10 PM
Experience and Mandatory Skills:
ETL development using Informatica Power Center.
3+ years of experience in developing SQL code in Snowflake/Oracle/MS SQL.
Good knowledge about Business Intelligence, Data warehousing concepts and methodologies and Reporting tools
Experience designing complex ETLs extracting data through RDBMS, Flat file, XML files, Json sources
Should be able to analyse poorly performing queries/ETL mappings and provide suggestions to tune them.
Essential Duties and Responsibilities:
Ability to gather and develop ETL pipelines in and out of data warehouse objects (type-2 dimensions, aggregations, star schema, etc.) using combination of Powercenter/IICS and Snowflake
Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 9.5 and higher
Ability to write SQL queries against Snowflake/Oracle/MS SQL.
Ability to develop scripts (Java, Python etc.) to do Extract, Load and Transform data
Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc.
Ability to understand data transformation and translation requirements and which tools to leverage to get the job done
Ability to understand data pipelines and modern ways of automating data pipeline using cloud based and on-premises technologies
Providing technical support and troubleshooting issues as needed.
Performs other duties and responsibilities as assigned.
Additional Preferences or certifications
Experience with cloud technologies
Able to work on own initiative and as a team player
Experience with CI/CD pipeline tools like Jenkins
Experience working with MS Office tools.
Soft skills required
Good communication skills, client facing experience, strong analytical and problem-solving skills.
Experience : 3 to 8 Yrs
Relevant Experience:
Tech Analyst ETL - Overall experience of 3 to 5 Yrs and 3+ Yrs into Informatica Power Center and experience into IICS will be plus.
Sr.Tech Analyst ETL - Overall experience of 7+ Yrs and 4+ Yrs into Informatica Power Center and 1+ Years of experience into IICS
Notice Period: Immediate or Max 15 days
Job Location: Bangalore
Shift Time: 1 PM to 10 PM
Experience and Mandatory Skills:
ETL development using Informatica Power Center.
3+ years of experience in developing SQL code in Snowflake/Oracle/MS SQL.
Good knowledge about Business Intelligence, Data warehousing concepts and methodologies and Reporting tools
Experience designing complex ETLs extracting data through RDBMS, Flat file, XML files, Json sources
Should be able to analyse poorly performing queries/ETL mappings and provide suggestions to tune them.
Essential Duties and Responsibilities:
Ability to gather and develop ETL pipelines in and out of data warehouse objects (type-2 dimensions, aggregations, star schema, etc.) using combination of Powercenter/IICS and Snowflake
Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 9.5 and higher
Ability to write SQL queries against Snowflake/Oracle/MS SQL.
Ability to develop scripts (Java, Python etc.) to do Extract, Load and Transform data
Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc.
Ability to understand data transformation and translation requirements and which tools to leverage to get the job done
Ability to understand data pipelines and modern ways of automating data pipeline using cloud based and on-premises technologies
Providing technical support and troubleshooting issues as needed.
Performs other duties and responsibilities as assigned.
Additional Preferences or certifications
Experience with cloud technologies
Able to work on own initiative and as a team player
Experience with CI/CD pipeline tools like Jenkins
Experience working with MS Office tools.
Soft skills required
Good communication skills, client facing experience, strong analytical and problem-solving skills.