Hyderabad, Telangana
Job Summary
The Technical Lead will be responsible for leading and overseeing the implementation, development, and maintenance of projects related to Informatica Intelligent Cloud Services, SQL, Oracle PL/SQL, and Unix Shell Scripting. The role involves ensuring the seamless integration of these technologies to meet business requirements effectively.
Key Responsibilities
1. Lead a team of developers and provide technical guidance and expertise in utilizing informatica intelligent cloud services, sql, oracle pl/sql, and unix shell scripting technologies.
2. Design, develop, test, and deploy etl processes using informatica intelligent cloud services.
3. Create and optimize sql queries, procedures, and functions in oracle pl/sql for data manipulation and reporting.
4. Develop and maintain unix shell scripts for automation, monitoring, and data processing tasks.
5. Collaborate with stakeholders to understand project requirements and ensure technical solutions align with business objectives.
6. Troubleshoot and resolve technical issues in the applications or databases related to the supported technologies.
7. Ensure adherence to coding standards, best practices, and documentation practices.
8. Stay updated with the latest industry trends and technologies in data integration and cloud services.
Skill Requirements
1. Proficiency in informatica intelligent cloud services for etl processes.
2. Strong sql skills with the ability to write complex queries for data manipulation and reporting.
3. Experience in developing and optimizing procedures and functions in oracle pl/sql.
4. Proficient in unix shell scripting for automation, monitoring, and data processing tasks.
5. Strong analytical and problem-solving skills.
6. Excellent communication and leadership abilities to effectively lead a technical team.
7. Ability to work collaboratively with cross functional teams and stakeholders.
8. Attention to detail and ability to prioritize and manage multiple tasks effectively.
Other Requirements
- 3 to 7 years of experience with IT / Azure, Python, SQL, Kafka, NoSQL, .NET C#, Snowflake, IICS
- Bachelor’s degree in computer science, Information Technology, or related STEM fields, or equivalent experience.
- Good understanding Massively parallel processing (MPP) systems, experience building Datawarehouse/DataMart on Azure Synapse SQL pools (SQL DW)
- Strong SQL skills and experience writing complex yet efficient SPROCs/Functions/Views using T-SQL
- Solid understand of spark architecture and experience with performance tuning big data workloads in spark
- Building complex data transformations on both structure and semi-structured data (XML/JSON) using Pyspark & SQL, refactoring tradition ML model to run on spark framework
- Familiarity with Cognitive Search/Elastic search and its use cases & building integrations to load data to Search services
- Familiarity with Azure Databricks environment and deploying spark code in databricks cluster
- Good understanding of No SQL and its use case, Modelling No SQL schemas & containers, building integration to read/write to cosmos
- Good understanding on distributed systems and experience building real-time integrations with Kafka
- Good understanding of Azure cloud ecosystem; Azure data certification of DP-200/201/203 will be an advantage
- Proficient with Visual Studio 19+, IntelliJ/eclipse and source control using GIT
- Good understanding of Agile, DevOps and CI-CD automated deployment (e.g. Azure DevOps, Jenkins)
- Good knowledge on Microservices architecture and any experience in building microservices with .NET Core WebAPI will be an advantage
- Any experience building rest-full services using Python FAST API will be an advantage
- Experience with Snowflake data platform, including data loading, transformation, and query optimization
- Experience with Informatica Intelligent Cloud Services (IICS), including cloud data integration, ETL/ELT pipeline design, and connector configuration
#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-
