Job Location: Bengaluru, Karnataka, India
Role: ETL Lead
Experience: 5-7 Years
Location: Bangalore
Notice Period: 15-20 days
Work From Home for Initial months
Candidate with immediate joining will be preferred
Required Skills
- Analyzing and evaluating data sources, data volume, and business rules.
- Automation, job scheduling, dependencies, monitoring.
- Extraction, transformation and load of data using the ETL tools.
- Configure/Script Business rules and transformation rules in Informatica.
- Sound Knowledge in Core SQL concepts
- Ability to perform Query optimization based on SQL best practices
- Hands-on in Microsoft SQL Server with good SQL coding knowledge
- Knowledge and understanding in Data Warehousing concepts such as Facts & Dimensions, OLTP, OLAP, Star & Snowflake Schema
- Familiar with Slowly Changing Dimension Types and its implementation based on use cases
- Ability to understand requirements and provide best optimal solution based on Industry standards
Roles And Responsibilities
- Implement Informatica Cloud Data Integration (CDI), Cloud Application Integration (CAI) use cases using mappings, mapping tasks, task flows, processes, process objects, service connector, app connection, guides, synchronous, replication tasks etc. Handle IICS administrative tasks such as creating and managing user and user groups, creating schedules, creating connections etc., check and verify subscriptions, licensing, metering etc. Monitor jobs and processes etc.
- Work on SQL databases objects like write stored procedures, views, functions, complex SQL queries considering performance and help in other performance improvement activities from IICS and from database standpoint.
- Participate in any kind of PoC’s (proof of concepts) based on database and Informatica Cloud as per business requirement, work on research & development work viz., IICS assets management source control, deployment automation which is in pipeline.
- Prepare technical designs.
About Company
The company exists to build a better working world, helping create long-term value for clients, people, and society and build trust in the capital markets. Enabled by data and technology, diverse company teams in over 150 countries provide trust through assurance and help clients grow, transform and operate. Working across assurance, consulting, law, strategy, tax, and transactions, the company teams ask better questions to find new answers for the complex issues facing our world today.
About CIEL HR
Ciel HR marks the return of HR visionaries to the HR Services industry, powered by technology and analytics. The Founders of Ma Foi, the pioneer of the HR services sector in India, along with some of the finest brains in the HR Services Industry have envisioned and built the firm, CielHR, to deliver the full range of Recruiting services from Executive Search, Recruitment Process Outsourcing and Staffing Permanent as well as Temporary roles through its offices in India and the Middle East.
Website: https://www.cielhr.com
Submit CV To All Data Science Job Consultants Across Bharat For Free

