Job ID :
35294
Company :
Internal Postings
Location :
Columbus, IN
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
14 Jan 2022
Job Seekers, Please send resumes to resumes@hireitpeople.com
Must Have Skills:
  • ETL
  • ADF
  • PowerBI
Detailed Job Description:
  • Seeking an ETL engineer with Azure experience.
  • The position will primarily be responsible for developing Azure Data Factory requirements and delivering it with the onshore – offshore model of Power BI developers and Architects.
  • The selected candidate be able to Troubleshoot the issues and provide solutions/directions to the projects. Candidate should be able to understand the business requirements, convert to technical solution and able to explain to Business (Client) through workshops and Technical (Development team) audience.
Required Qualifications:
  • Bachelor’s Degree or foreign equivalent, will consider work experience in lieu of a degree
  • 10+ years of Information Technology experience
  • 5 + years experience on Azure and related tools stack
  • Certified on Azure - Certification: AZ 900, PL 900, DP 900
  • Detail design of the data extraction, Transformation and Modeling
  • Provide Inputs to the Data Extraction, Processing strategy and Technical feasibility
  • Lead the teams for Design, Develop and test the data pipelines to acquire data into cloud hosted EDM platform covering Data Ingestion, Processing and Transformations, and Model the data for reporting.
  • Technical Guidance and deliverables review of the team members. Guide the offshore team as required, delegation and taking stock of the work output
  • Work on Azure Platform for Data Preparation, Data Sets Creation, Data Pipeline
  • Design, Develop and test the data pipelines to acquire data into platform covering Data Ingestion, Processing and Transformations, and Model the data for reporting.
  • Workflow setup and Job Scheduling for automation of data pipelines
  • Key skill set are Azure Data Factory, Azure Blob, Azure Storage Explorer, Azure Data Lake Store, Azure Databricks, Data Warehousing, and Power BI (including DAX),
  • SSIS tools, SSAS tools – Data Analysis and reporting, ETL and reporting.
  • Extensive hands on - Creating Views, Constraints, Triggers, Joins, Stored Procedure for data migration, data cleansing process and data validation processes
  • Have performed data mapping and ETL development
  • Manufacturing domain background and knowledge of the processes.
Preferred Qualifications:
  • Extensive experience in writing Oracle, PL/SQL, Stored Procedures/Functions/Cursors/Packages & triggers
  • Experience with Lean / Agile development methodologies
  • Experience with Data Migration from On Prem to Cloud
  • Able to manage client stakeholders across multiple geographies in Asia, Europe and US.
  • Excellent verbal and written communication skills
  • Experience and desire to work in a Global delivery environment

Minimum years of experience: 8-10 years

Certifications Needed: No

Top 3 responsibilities you would expect the Subcon to shoulder and execute:

  1. Developing Azure Data Factory requirements and delivering it with the onshore offshore model of Power BI developers and Architects.
  2. Troubleshoot the issues and provide solutionsdirections to the projects.
  3. Understand the business requirements, convert to technical solution and able to explain to Business Client through workshops and Technical

Interview Process (Is face to face required?): No

Does this position require Visa independent candidates only? No