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.
[login to view URL] 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.
Hi,
I'm interested in this project, I have good experience in ETL(Infromatica, Azure Data factory) and good SQL knowledge. I do alsoe knowledge in some of python models(Numpy, pandas etc...)
Thanks,
Aravind
Hi ,
I have around 10 year of experience on the informatica development and support. I lead team of 7 members with same set of skills.
I handle the new projects and even do PROD support activities.
Thanks,
Rakesh CR
I have abundant experience in Informatica Power center, SQL and unix servers. I've worked on complex transformations and also done performance tuning. Have handson experience on IICS too.
With over six years of background in Data Engineering, I am involved in ETL development for different projects. I find this field very interesting since it is responsible for making raw data beneficial to the enterprise. On the other hand, it is also challenging since it requires a broad set of technical skills and ability to communicate across departments to understand what the business wants to gain from its large data sets.
I have experienced initializing and managing ETL pipelines using Informatica PWC. I have exposure to building codes based on business requirements and project standards. I helped design and implement integration solutions and data storage in data warehouses and data lakes. I am also involved in performing regular maintenance checks to keep the system running smoothly.
I am familiar with ETL technologies such as Informatica and Talend. For development methodology, I used to work in Waterfall and Agile environments. I have basic knowledge of database technologies such as Oracle, Postgres, Hadoop, and Spark.
Given the opportunity, I am confident that the experience and skills I developed over the years have prepared me for this role with your firm. I believe that capability makes me an excellent fit for the position you are looking for at your company.
Summary of qualifications:
- 8+ years providing IT solutions for Multinational Companies in several sectors of the industry like banking, insurance, telecommunications, retail, investment and education.
- 8+ years of experience on Data Integrations and ETL tools using Informatica PowerCenter (8.6v to 10.2)
- 8+ years of experience on Databases and PL-SQL Development including MS-SQL Server, Oracle, Teradata, MySQL & Neo4j.
- 6+ years of experience using workload automation solutions including Control-M, Swap & One Automation (Automic).
- 4+ years of experience on Unix Shell Scripting.