3 months ago
Bengaluru, IndiaSenior
Responsibilities
- Design, develop, and maintain ETL/ELT pipelines using Informatica Intelligent Cloud Services.
- Implement IICS Cloud Data Integration workflows with error handling, scheduling, and parameterization.
- Develop mappings, mapping tasks, taskflows, and reusable data integration components.
- Build and maintain Snowflake data warehouse objects including databases, schemas, tables, views, and stages.
- Write and optimize advanced SQL queries and Snowflake stored procedures.
- Implement incremental and full data loads, Change Data Capture, and Slowly Changing Dimensions Type 1/Type 2.
- Perform data transformation, cleansing, validation, and reconciliation to maintain data quality and integrity.
- Troubleshoot ETL failures, data issues, and performance bottlenecks.
- Collaborate with business analysts, data architects, QA, and technical teams on end-to-end data solutions and production deployments.
Requirements
- At least 5 years of experience designing, developing, and maintaining data integration and data warehouse solutions, with the stated range extending to 8 years.
- Hands-on experience with Informatica Intelligent Cloud Services and Cloud Data Integration.
- Expertise in Snowflake architecture and features including warehouses, stages, streams, tasks, Time Travel, and zero-copy cloning.
- Advanced SQL development and query optimization skills.
- Proficiency in ETL/ELT development and data warehousing concepts.
- Experience developing IICS mappings, mapping tasks, and taskflows.
- Experience implementing ETL pipeline parameterization, error handling, scheduling, and automation.
- Experience designing and managing incremental and full data loads, CDC, and SCD patterns.
- Preferred experience with AWS or Azure cloud services, AWS S3 or Azure Blob Storage, Python or scripting, CI/CD and DevOps practices, Git, Jenkins, or Azure DevOps.
- Preferred experience in the Life Sciences or Pharmaceutical industry.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline.
- Snowflake, Informatica Cloud Data Integration, AWS, or Azure certifications are preferred.
About Brillio
Brillio is a privately held digital engineering and enterprise AI services firm that helps Fortune 1000 companies modernize products, data, and infrastructure. It combines consulting and managed services with an accelerator platform (ADAM) across cloud, AI, data engineering, customer experience, and infrastructure workstreams. Founded in 2014 and headquartered in Dallas, it operates delivery centers across North America, Europe, and Asia, with focus areas that include healthcare and life sciences.