lohasports.blogg.se - Azure data studio oracle

#Azure data studio oracle code

Debuggingthe scripts which were developed by teh other team mates.Gathering requirements from teh client managers and implementing them as tasks as per requirements.MovingCSV files from Azure blob to on-prem server(Linux).Provide support of production applications by trouble - shooting issues, and developing, testing and migration of Data Bases.Created stored procedures usingCommon Table Expression (CTE).Trouble shoot any kind of data issues or validation issues.Performance tuningof SQL queries and stored procedures usingSQL Profiler and Index Tuning Wizard.Transforming data in Azure Data Factory with theADF Transformations.Scheduling Pipelinesand monitoring teh data movement from source to destinations.Creating PipelineswithGUIin Azure Data Factory.Migrating teh data from different sources to teh destination with teh halp of ADF.Pumping data betweenSQL DB andADLS usingFlows.Createdautomated workflowswith teh halp oftriggers.Moving data fromHIVEto Azure SQL DB with teh halp ofpipeline and data flows.Successfully creating theLinked Serviceson teh source and as well for teh destination servers.Monitoring Produced and Consumed Data Setsof ADF.Creating Stored ProcedureandScheduledthem inAzure Environment.Worked on creating dependenciesofactivities in Azure Data factory.Building teh pipelines to copythe data from source to destination inAzure Data Factory.Experience in creating Tivoli webform to schedule teh jobs in IBM TWS scheduling tool.ĮTL Tools: Informatica, Azure Data Factory, Informatica Power Exchange, Mainframeĭatabases: SQL Server, Oracle 8i/9i/10g/11g, Exadata, HIVEĭatabase Tools: Azure data studio, Zeppelin tool.

#Azure data studio oracle code

Experience in creating deployment group and deploying teh informatica ETL code from One environment to another environment.

Good experience in agile and Waterfall methodology.

Experience inPerformance Tuning and Query Optimization.

Good experience in datamap creation using Informatica Power Exchange.

Good experience in Informatica Power Exchange and IBM Mainframe.

Good experience in create Sessions, Reusable worklets and workflow in Workflow Manager and scheduled teh workflow at specified frequency.

Good noledge of understanding teh Abinitio graphs and components.

10 years of strong experience in teh IT industry as a Informatica Developer and Azure Data factory include experience in design, development, and implementation with various business domains like Insurance and Health Care.