Job Description:
The ideal candidate for this position should possess a good understanding of enterprise-class ETL technology and demonstrate solid skills in around business processes. This individual must have excellent communication skills, both verbal and written, and demonstrate a team-oriented, goal and results-driven work ethic. The role requires working collaboratively with the business community and other IT team members within a dynamic and high-profile environment.
Qualifications:
Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education
At least 7 years of experience with Information Technology
U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Responsibilities:
Develop and deploy ETL pipelines for various source systems to Enterprise Data Warehouse, Data lake etc.
Designs and develops software solutions to meet business requirements. Manages full software development life cycle including testing, implementation, and auditing. Performs solution design, bug verification, and beta support, which may require research and analysis.
Design, develop and document specifications throughout the project life cycle. Coding, developing, and documenting software specifications throughout the project life cycle.
Supports solution architects in problem analysis and design, advising teams on appropriate Azure services selection
Exposure to CICD Azure pipelines
Work on multiple DevOps environments
Mentoring development teams on Azure best practices
Manage the implementation of the cloud to ensure a successful deployment
Skillset
6+ Hands On experience on ETL looks like Informatica, SSIS etc.
3+ Relevant experience in space of Azure Data Factory
Develop and migrate to Azure leveraging Azure Data Lake, Azure SQL Pools, Apache Spark, Synapse, Azure Data Factory/Synapse pipelines Azure Storage Explorer
Sound skills and hands on experience width Azure Data Lake, Azure Data Factory, Data Warehousing , Azure Blob, ADLS Gen2, Databricks/scala/pyspark .
Develop and migrate to Azure leveraging Azure Data Lake, Azure SQL Pools, Apache Spark, Synapse, Azure Data Factory/Synapse pipelines
Carry out monitoring, tuning ,Query performance optimizations and database performance analysis
Azure Synapse Experts who knows differences at data type level from DB2 to Azure SQL Dedicated Pool
Proficient in creating Data Factory pipelines using ADF , copy activity, custom Azure development etc.
Expert in DB2 SQL queries writing.
Expert in writing T-SQL Synapse SQL Queries
Expert in PL/SQL , Triggers Views , Indexes
Expert in DB Model Schema like Star Schema , Snowflake Schema etc.
Writing Polybase scripts for movement of Data from Data Lake to the staging area of the Azure Synapse (SQL Pools)
Have done at least 3 Projects in Azure Synapse and Sql Server Analytics
Excellent communication skills.
Perform the design and extension of data marts, meta data, and data models.
About Us
Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.
To learn more about Infosys and see our ideas in action please visit us at www.Infosys.com
EOE/Minority/Female/Veteran/Disabled/Sexual Orientation/Gender Identity/National Origin